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


About WEAP

Home
Why WEAP?
Features
What's New?
Sample Screens
Demonstration
Publications
History and Credits

Using WEAP
Download
Licensing
User Guide
Tutorial
Videos

User Forum
Discussions
Members List
Edit Profile

Additional Support
Training
University Courses
Collaboration

About Us
SEI-US Water Resources Program
Please Contact Us


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

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: 178 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: 120 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"