Welcome to WEAP's Website WEAP
WEAP is an initiative of the Stockholm Environment Institute.

About WEAP

What's New?
Sample Screens
History and Credits

Using WEAP
User Guide
Videos (YouTube)

User Forum
Members List
Edit Profile

Additional Support
University Courses

About Us
SEI-US Water Resources Program
Please Contact Us

Interested in Energy?
Read about LEAP: SEI's software for energy planning.

Link WEAP and LEAP for combined Water-Energy planning.
Watch a video demo!

User Forum

All Topics | Topic "problems with csv files"
Log in to post new messages or reply to existing messages.
Author Message
Ms. Marina Al Ali

Subject: problems with csv files   
Posted: 6/1/2018 Viewed: 8755 times
Hi,I have problems with CSV files when I move them from my laptop to my desktop computer. All columns disappear and merge into one column with all previously entered data.
How can I solve this problem?
Mr. Jack Sieber

Subject: Re: problems with csv files   
Posted: 6/16/2018 Viewed: 8692 times
It might be an issue with different Windows List Separator characters on the two computers. Because the list separator varies from country to country, it is a good practice to always include the $ListSeparator directive in the CSV file so that WEAP can read the file, regardless of the setting of the Windows List Separator character. This is helpful if the dataset is shared between users in different countries. If you will be editing your CSV file in Excel, you should enclose this entire directive in quotes so that Excel doesn't interpret the list separator character as an actual list separator, e.g., "$ListSeparator = ,"

See http://www.weap21.org/WebHelp/Read_From_File.htm for more information.
Topic "problems with csv files"