Help converting scenario to Excel

[Bradley7735]

I saw this in another thread and thought that someone might be able to help me.

"maybe you should give "witploadAE.exe" a try.
It is located in the "SCEN" folder and you have to run it in a cmd-window.
Witpload generates 9 .csv files which can be sorted and reorked with excel or
its open office pendant.
All data of airgroups, ships, ship-classes, base and more are included in these
files. "

Can anyone give me specific details on how to do this? I opened a dos prompt, changed the directory to the scen folder and typed in witploadAE.exe and it just says:

WITP AE data export/import utility - Version 7.9
Loading scenario number # 1
WITPdev001.csv: No such file or directory

I have also tried the path in the "Start---->Run" thingy with no luck. Something flashes on the screen and dissapears before I can see anything.

I am fairly competent with Excel and CSV files, but I lack a lot of competence trying to start the whole thing. I would also need instructions on how to import the CSV files once updated.

Thanks for any help you can give,
Brad

[steveh11Matrix]

Echo that request!

[JuanG]

Witploadae.exe requires additional commands to get it to do what you want.

The key ones are
/e is extract scenario -> csv (without this it is packaging from csv -> scenario)
/s## is scenario ID

As you are just typing witploadae.exe, it is assuming to be packaging scenario 1, which is why you get that error as there is no scenario 1 csv files.

So if you wanted to extract scenario 2 into csv, you would write witploadae.exe /e /s02

CSV files should open fine in excel, and unlike some other games, AEs csv files are well formatted and should read and save perfectly from excel.


Hope this helps, as its a very useful and powerful tool to use.

[Mistmatz]

For a start try "witploadae /help" in the command line. This gives you a list of all documented switches and their function.

[Bradley7735]

Thanks to both of you!!! I am now able to edit via excel.

thanks a million.

Brad