.CSV files

Matrix Games Forums

Forums Register Login Photo Gallery Member List Search Calendars FAQ

My Profile Inbox Address Book My Subscription My Forums Log Out

.CSV files

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [New Releases from Matrix Games] >> Gary Grigsby's War in the West >> Scenario Design and Modding >> .CSV files

Page: [1]

Message

<< Older Topic Newer Topic >>

.CSV files - 2/25/2019 10:59:52 PM

lunca

Posts: 27
Joined: 2/8/2009
Status: offline

How to properly open, edit and save .csv file? Always when I did it I can no longer import it back. I got message: "error open..."

Post #: 1

RE: .CSV files - 2/26/2019 11:34:39 AM

lunca

Posts: 27
Joined: 2/8/2009
Status: offline

Please help me. I want to change something via Excell (export/import .csv file) but when I save as .csv something goes wrong. What is the right procedure to export .csv file to Excell and import back to the game?
Thank you.

< Message edited by lunca -- 2/26/2019 11:36:25 AM >

(in reply to lunca)

Post #: 2

RE: .CSV files - 2/26/2019 12:47:10 PM

Denniss

Posts: 7902
Joined: 1/10/2002
From: Germany, Hannover (region)
Status: offline

once opened in Excel the files are protected from access. you need to close the file in excel first

(in reply to lunca)

Post #: 3

RE: .CSV files - 2/26/2019 8:14:13 PM

lunca

Posts: 27
Joined: 2/8/2009
Status: offline

@Denniss
I tried all the ways, but it does not work. When I try to import, the game closes and I'm back on the desktop.

This is original .csv file after export. If this fail import right back without save_as in Excell, then the import is successful.

This is .csv file after save_as in Excell. A completely different form from original .csv file.

(in reply to Denniss)

Post #: 4

RE: .CSV files - 2/27/2019 11:07:49 AM

Denniss

Posts: 7902
Joined: 1/10/2002
From: Germany, Hannover (region)
Status: offline

you need to import it as comma-separated csv file, upon saving it should retain this separation.

(in reply to lunca)

Post #: 5

RE: .CSV files - 2/27/2019 7:59:39 PM

lunca

Posts: 27
Joined: 2/8/2009
Status: offline

quote:

ORIGINAL: Denniss

you need to import it as comma-separated csv file, upon saving it should retain this separation.

I'm doing exactly that but after save_as, file is different form than the original (see above). How to convert it save_as file back to the form the original had? Has anyone worked with export/import .csv file?

p.s.
Please try to export file to Excell and save it there, then try to import back to the game and tell me if it works.

< Message edited by lunca -- 2/27/2019 8:04:50 PM >

(in reply to Denniss)

Post #: 6

RE: .CSV files - 2/27/2019 8:24:35 PM

RedLancer

Posts: 4314
Joined: 11/16/2005
From: UK
Status: offline

I use CSV all the time. Just save the file that you have opened as a CSV as a CSV then close. Normally I don't change the save name as that means you'll have to change the name when you import it back in.

_____________________________

John
WitE2 Asst Producer
WitE & WitW Dev

(in reply to lunca)

Post #: 7

RE: .CSV files - 2/27/2019 8:29:05 PM

lunca

Posts: 27
Joined: 2/8/2009
Status: offline

I found a solution !!!
When I make save as a comma-separated csv in Excel, I get a file with ";" instead ",". I do not know why, but this was the reason that import file did not work.

The solution is:
I opened the existing file as Text document and replaced all ";" with ",". I can now import file back in the game without problem :)

(in reply to lunca)

Post #: 8