AIMMS Libraries

Dear,I am trying to use aimms.py in order to run a AIMMS model from python and parse and receive output. I created the following python script based on the package: aimmspy · PyPI. import osfrom aimmspy.project.project import Project, Modelfrom aimmspy.utils import find_aimms_path aimms_bin_path = r"C:\Users…..."project_file = r"C:\Users…..aimms"# input_file = r"C:\Users....txt"results_file = r"C:\Users....csv" project = Project(    # path to the AIMMS Bin folder (on linux the Lib folder)    aimms_path=aimms_bin_path,     aimms_project_file=project_file,    license_url=R"wss://licensing……..") my_aimms : Model = project.get_model(__file__) my_aimms.GuiReadData() After running the script (with proper paths and license), I get Unable to load IBM CPLEX library. Exiting.I tried to change the solver within AIMMS but still the same error occurs.  Is there anyone that encountered the same issue? I look forward to a reply.Kind regards,Jesper 

I have multiple math programs, each related to a different energy supply sector.. I want to keep their development and version control independent. Is making them into libraries a reasonable way to combine these otherwise independent math programs? 

Good morning all. I just brought out an old program I have written over a year ago to run it and it gave an error:‘The CONOPT 4.1 library has not been loaded because: Solver initialization failure.’Please, what can I do to remove the error. Thank you.

Hi communityWe use standard Excel functionality to download a file of the following format:Then we try to reupload this file after having made the following adjustment (we manually adjusted the columns A and B and copied the values in A2 and B2 from other Excel): However, this reupload resuts in 0 changes being made to the table in the WebUI. What could be the reason the reupload fails to read in the 1000?

I am running AIMMS 24.6.3.3 with an academic licence on a macbook air M2 through parallels.I would like to include AXLL in my project, but when opening the library manager and trying to access to the library repository, I get an error message that doesn’t provide any information on how to solve the problem: Unable to get the list of available libraries from repository. How can I possibly solve? Or alternatively, is there a way to use AXLL on my setup without accessing the repository?

Hello! I was writting to see if anyone would be able to help me; you see, when I start up my AIMMS project file I get an error (which can be seen on the shared screenshot) about missing some kind of element in my project library. This started happening after moving my AIMMS project files from one computer to another, so I suspect that some data might not have transfered properly. In any case, I was hoping someone would be able to help me, as this is kind of urgent to be honest. Thank you very much in advance! Pablo

Hello and greetings,I have a question regarding the AIMMS tool. Can I know, if I have many data that need to be inserted in AIMMS by ticking the table for parameters, is there any alternative to ticking the table automatically without ticking them one by one manually like I did (refer to the to the figure below)  

Dear all I was using a DataLink library to export to excel. However, I have installed the latest version and this library is not there. I need to use DEX Library.I created a table and a data mapping to export it to excel.Below is the code. How could I implement it using DEX?Thanks for helping.----------------------------------------------------------------------The code was this dl::DataTables += 'Result2';DataMap(dl::dt,dl::idn,dl::cn,dl::dn) := data {    ( 'Result2', 'Scenarios', 1, 1 ) : "Scenarios",    ( 'Result2', 'Port', 2, 2 ) : "Port",    ( 'Result2', 'Destination', 3, 3 ) : "Destination",       ( 'Result2', 'Bidder', 4, 4 ) : "Bidder",       ! from fourRows.csv, read in a data pDem from a 3rd csv data column named "demand". This is a data column    ( 'Result2', 'TransportMode', 5, 5 ) : "TransportMode",    ( 'Result2', 'Days', 6, 6 ) : "Days",    ( 'Result2', 'ScenarioAllocation', 7, 0 ) : "ScenarioAllocation",    ( 'Result2', 'ForecastAllocation', 8, 0 ) : "ForecastAllocation

I want to share an issue I recently had with using the DLS (ADLSG2) Library in case you come across it.To use this locally (developer mode) you need to generate a SAS Token.I did this but in a lazy way (I selected all permissions!).Then you try using to then use the functions to communicate with ADLS2, you will get an error regarding "Signature fields not well formed.". This is apparently (to be confirmed) caused by the token being either too big or maybe some conflict with permissions.In anyway, to resolve this, when generating your SAS Token be mindful and actual pick the ones you need - not simply all of them.

In the realm of data handling, creating large CSV files efficiently is crucial. This article explores four distinct methods to generate a CSV file with 10 million records, comparing their performance in terms of execution time and memory increment. FmtPut Method: Time: 44 seconds Memory Increase: 1276 Mb This traditional approach uses format-based output to write data to a CSV file. While reliable, it’s not the most efficient in terms of memory usage. See FormatString PurePut Method: Time: 36 seconds Memory Increase: 2533 Mb A method that writes data directly, PurePut is faster than FmtPut but requires significantly more memory, making it less ideal for memory-constrained environments. See PUT statement DexCSV Method: Time: 16 seconds Memory Increase: 253 Mb Using the AimmsDEX repository library to write CSV stands out as a high-performance method, striking a balance between speed and memory usage, making it a suitable choice for large-scale data processing. DexParquet Me