Varformat errors when exporting data

Use this forum to post Vensim related questions.
Post Reply
Samsamsam
Junior Member
Posts: 6
Joined: Mon Jun 29, 2020 9:40 am
Vensim version: PRO

Varformat errors when exporting data

Post by Samsamsam »

After running my model for 10 scenarios, I ran into an issue when attempting to export the dataset to an Excel file.

Vensim would give me a Varformat error with a random number attached to it. Sometimes even multiple varformat errors, before eventually crashing and not creating any export file. After messing around with the export options and other data formats like CSV and .dat files, they all give the same varformat errors and subsequent crash.

I'm admittedly not very experienced with Vensim, and could not fix the issue myself. Previous forum posts also didn't help, they suggest it has something to do with subscripts but its beyond my comprehension.

Any ideas on how to fix this? I'm open to any suggestions.
(The MDL model file is attached.)
Attachments
Model 15.mdl
(17 KiB) Downloaded 181 times
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: Varformat errors when exporting data

Post by Administrator »

What version of Vensim are you using?

And can you upload your vensim ini file, you'll find it in %APPDATA%\vensim (it should be vensimdp.ini or vensim.ini).

I have no errors when exporting on my machine here.
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391

Units are important!
http://www.bbc.co.uk/news/magazine-27509559
Samsamsam
Junior Member
Posts: 6
Joined: Mon Jun 29, 2020 9:40 am
Vensim version: PRO

Re: Varformat errors when exporting data

Post by Samsamsam »

Version: Vensim Professional 8.0.9 (Double Precision) x64

Unfortunately I could not upload the .ini file because it's not supported file type. So I copy-pasted the contents into a Word document and uploaded that instead. If there is a better way around this please let me know.
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: Varformat errors when exporting data

Post by Administrator »

INI files should be allowed now.
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391

Units are important!
http://www.bbc.co.uk/news/magazine-27509559
Samsamsam
Junior Member
Posts: 6
Joined: Mon Jun 29, 2020 9:40 am
Vensim version: PRO

Re: Varformat errors when exporting data

Post by Samsamsam »

I'm still getting a "Invalid file extension: vensimdp.ini" error when uploading the .ini file.

So here is my second attempt at uploading the Word document, because apparently I did not attach it with my last message.
vensimdp.docx
(12.67 KiB) Downloaded 182 times
tomfid
Administrator
Posts: 3804
Joined: Wed May 24, 2006 4:54 am

Re: Varformat errors when exporting data

Post by tomfid »

Are you using a command script or the menu?
Samsamsam
Junior Member
Posts: 6
Joined: Mon Jun 29, 2020 9:40 am
Vensim version: PRO

Re: Varformat errors when exporting data

Post by Samsamsam »

I assume you are referring to how I attempt to export my data?

I use the Model > Export Dataset... dropdown menu.
Then I select the dataset I want to export, leave all settings untouched (except for the Export as option where I select the XLSX file).
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: Varformat errors when exporting data

Post by Administrator »

Can you update to Vensim 8.1.0? I'm not getting the error in the latest version of Vensim (but do in 8.0.9).
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391

Units are important!
http://www.bbc.co.uk/news/magazine-27509559
Samsamsam
Junior Member
Posts: 6
Joined: Mon Jun 29, 2020 9:40 am
Vensim version: PRO

Re: Varformat errors when exporting data

Post by Samsamsam »

This morning I installed Vensim pro 8.1.0. Unfortunately, when running it I get the error "The program can't start because api-ms-win-core-verison-l1-1-0.dll is missing from your computer".

After spending 3 hours trying various solutions found online, I could not fix it. I'm still using Windows 7 so that may be the issue. (My Vensim pro 8.0.9 still works fine).
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: Varformat errors when exporting data

Post by Administrator »

Windows 7 is no longer supported. There does not seem to be a solution for the missing DLL error.
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391

Units are important!
http://www.bbc.co.uk/news/magazine-27509559
Samsamsam
Junior Member
Posts: 6
Joined: Mon Jun 29, 2020 9:40 am
Vensim version: PRO

Re: Varformat errors when exporting data

Post by Samsamsam »

Thank you for the help! I will ask one of my peers running Windows 10 to export the datasets for me.

(It would be nice if the Vensim download center stated that only windows 10 is supported, it would have saved me a lot of time :) )
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: Varformat errors when exporting data

Post by Administrator »

Samsamsam wrote: Tue Jun 30, 2020 10:43 am(It would be nice if the Vensim download center stated that only windows 10 is supported, it would have saved me a lot of time :) )
We do list the hardware/software requirements on the FAQ at
http://vensim.com/faq/
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391

Units are important!
http://www.bbc.co.uk/news/magazine-27509559
tomfid
Administrator
Posts: 3804
Joined: Wed May 24, 2006 4:54 am

Re: Varformat errors when exporting data

Post by tomfid »

The only solution I've seen (but not tried) is to install the Win 8.1 SDK. So possibly a win7 sdk would also work. https://t.co/W0BrQzYQBw
Post Reply