User avatar
Pocus
Posts: 24746
Joined: Wed Oct 19, 2005 7:37 am
Location: Lyon (France)

CW2 Excel Database

Fri Apr 11, 2014 1:57 pm

Hi gents,

Here is the current database, v1.06


http://ftp.ageod.com/pub/CW2/CW2_106DB_2015June.rar

Publication date: June 22nd 2015.
Link updated March 21st, 2016.
Image


Hofstadter's Law: "It always takes longer than you expect, even when you take into account Hofstadter's law."

User avatar
ArmChairGeneral
AGEod Grognard
Posts: 939
Joined: Thu Nov 21, 2013 9:00 am
Location: Austin, TX, USA

Sat Apr 12, 2014 1:22 am

Hooray! Thank you!

User avatar
tripax
AGEod Veteran
Posts: 777
Joined: Thu Aug 29, 2013 9:58 pm

Sat Apr 12, 2014 10:06 am

Yes, thank you very much! I didn't see a leaders file, although much of that is in the models/units files. I guess I already made excel files with much of this info in it for my project, but this definitely helps. If we want to add/change unit or model names, it looks like we could add them to the database in the appropriate spots and you/the development team can compile the game files from them?

User avatar
Eugene Carr
Colonel
Posts: 387
Joined: Wed Jun 20, 2007 6:58 pm
Location: Dundee, Scotland

Sat Apr 12, 2014 10:09 am

Great to see this, thanks a lot.

S!
[SIGPIC][/SIGPIC]

User avatar
tripax
AGEod Veteran
Posts: 777
Joined: Thu Aug 29, 2013 9:58 pm

Sat Apr 12, 2014 11:18 pm

For units/models, it seems like FamilyType might make sure names don't overlap between similar but different units. 10lb NC artillery are in the $famLightArty|1 but should be in $famMedArty|1 if it is to match other 10lbers.

User avatar
Pocus
Posts: 24746
Joined: Wed Oct 19, 2005 7:37 am
Location: Lyon (France)

Mon Apr 14, 2014 9:06 am

Post these remarks in Help Improve CW2, we can gather them all when the next patch will be near. :)
Image


Hofstadter's Law: "It always takes longer than you expect, even when you take into account Hofstadter's law."

User avatar
tripax
AGEod Veteran
Posts: 777
Joined: Thu Aug 29, 2013 9:58 pm

Wed Apr 16, 2014 4:20 am

I'm curious how exactly we should use the DB files. It seems like an excel version of the information in the game folders already. Will a tool be created to allow for creation of game files from a DB file we've modified?

User avatar
Ace
Posts: 3490
Joined: Mon Aug 30, 2010 4:33 pm
Location: Croatia

Wed Apr 16, 2014 7:02 am

Csv splitter is the tool to create game files out of excel files. Just enter proposed suggestion into excel files, and read few tutorial posts in the modding section of the forum that explain how to use csv splitter tool.

After a mod is made, if it is good enough, the devs may consider integrating it into official game files.

Welcome to modding, and

Good luck :)

User avatar
tripax
AGEod Veteran
Posts: 777
Joined: Thu Aug 29, 2013 9:58 pm

Wed Apr 16, 2014 3:48 pm

Wow, thank you very much! There is a nice introduction I used as you recommend (http://www.ageod-forum.com/showthread.php?34995-A-brief-introduction-to-modding-units).

I wanted to try the splitter utility, so I unzipped the Database, saved the model DB file, and saved it as a CSV. I clicked mdl then clicked convert. Instead of success, I get an error, "Exception in line 0,..." followed by info from the file. Here is a screen shot:

[ATTACH]27395[/ATTACH]

It worked fine for an Events DB file, but not for the Model DB or Unit DB file. Any ideas what is wrong?
Attachments
Untitled.png

User avatar
Pocus
Posts: 24746
Joined: Wed Oct 19, 2005 7:37 am
Location: Lyon (France)

Fri Apr 18, 2014 2:33 pm

I think I get it, it comes from the habit of the team to not fully flesh out some comments columns, the ones with § in their header. Remove them entirely with Excel before doing an export in CSV, it should work...
Image


Hofstadter's Law: "It always takes longer than you expect, even when you take into account Hofstadter's law."

User avatar
tripax
AGEod Veteran
Posts: 777
Joined: Thu Aug 29, 2013 9:58 pm

Fri Apr 18, 2014 5:16 pm

Hmm, still no luck for me. Does it work for anyone else? The error message for the units database isn't cut off, so I'm attaching it.

[ATTACH]27417[/ATTACH]
Attachments
Untitled.png

User avatar
Ace
Posts: 3490
Joined: Mon Aug 30, 2010 4:33 pm
Location: Croatia

Fri Apr 18, 2014 8:38 pm

I tried to export original file and it worked with no problems. Maybe your changes caused some errors. Try to use original file posted by Pocus, and change only 1 line in it. That is how you'll know you are doing it right.

User avatar
tripax
AGEod Veteran
Posts: 777
Joined: Thu Aug 29, 2013 9:58 pm

Fri Apr 18, 2014 9:08 pm

Ok, I have it now. Excel was exporting as comma delimited (you can see the commas in the error screen I posted). CSV splitter needs semicolon delimited.

I'm not sure the best way to save the file in semicolon delimited (for others who may have problems, my excel is the version that is a part of MS Office Pro Plus 2010 that I got in the US). The way I did it was to save as a tab delimited text file, then open it in notepad++, then search and replace tab (\t) to semicolon, then save as *.csv. Also, excel adds quotation marks (") to the beginning and end of some cells which need to be removed.

Anyway, it works great now. Thank you both for the help.

User avatar
Pocus
Posts: 24746
Joined: Wed Oct 19, 2005 7:37 am
Location: Lyon (France)

Tue Apr 22, 2014 10:08 am

This might be related to regional settings.
Image


Hofstadter's Law: "It always takes longer than you expect, even when you take into account Hofstadter's law."

User avatar
Captain_Orso
Posts: 5482
Joined: Tue Sep 01, 2009 5:02 pm
Location: Stuttgart, Germany

Sat May 10, 2014 11:58 pm

You know what's missing? The setup files for the scenario pack: 1862 Campaign, 1862 East Campaign, 1863 Campaign, 1863 Gettysburg, 1864 Atlanta and 1864 Campaign. Any chance of getting these?

User avatar
PhilThib
Posts: 13363
Joined: Tue Oct 18, 2005 5:21 pm
Location: Meylan (France)

Sun May 11, 2014 8:24 am

If you ask politely :mdr: .... send me a mail at pthibaut@ageod.net
Image

User avatar
Captain_Orso
Posts: 5482
Joined: Tue Sep 01, 2009 5:02 pm
Location: Stuttgart, Germany

Sun May 11, 2014 2:38 pm

Image

..with sugar on top :o




















Oh, the e-mail, on its way ;)

User avatar
Pocus
Posts: 24746
Joined: Wed Oct 19, 2005 7:37 am
Location: Lyon (France)

Mon Jul 28, 2014 9:36 am

First post updated to 1.04.

BRS scenarios missing on purpose, ask by PM if need be and depending of the result of several ordeals and testing, you might get it or not. ;)
Image


Hofstadter's Law: "It always takes longer than you expect, even when you take into account Hofstadter's law."

Santini
Conscript
Posts: 11
Joined: Tue Jul 15, 2014 11:44 am

Fri Aug 08, 2014 12:13 am

Where is the csv splitter for civil war 2?

Edit: In case anyone is as dumb as me, it is here: showthread.php?5358-Official-Files-for-modding

fogg
Conscript
Posts: 6
Joined: Sun Jun 03, 2007 9:05 am

Fri Aug 08, 2014 1:35 pm

Is it possible to add a structure into a Region/City? Which file have I to mod?

User avatar
bigus
General
Posts: 599
Joined: Wed Oct 24, 2007 11:43 pm

Sun Aug 10, 2014 4:05 am

Visa out and ready to purchase CW2.
Thanks folks.
Scenarios for AACW (1.15)[CENTER][/CENTER]

User avatar
BigDuke66
Brigadier General
Posts: 419
Joined: Fri Dec 11, 2009 2:06 pm

Thu Mar 05, 2015 7:33 pm

Link is not working, can someone please correct that?
"Spread word to every slave, that even the mighty republic bleeds when struck!"
Join the Napoleonic Wargame Club
Join the American Civil War Game Club
Join the The Blitz Wargaming Club

User avatar
Pocus
Posts: 24746
Joined: Wed Oct 19, 2005 7:37 am
Location: Lyon (France)

Fri Mar 06, 2015 9:26 am

Here are the latest files:

http://www.ageod-forum.com/downloads/AGE_DB_archives/CW2_105DB_2015March.rar

Updated first post too. 1.05 is not official but changes to the DB should be very minor by now.
Image


Hofstadter's Law: "It always takes longer than you expect, even when you take into account Hofstadter's law."

User avatar
Pocus
Posts: 24746
Joined: Wed Oct 19, 2005 7:37 am
Location: Lyon (France)

Mon Jun 22, 2015 10:23 am

Hi gents,

Here is the current database, v1.06

http://ovh.to/Ysr5pY

Publication date: June 22nd 2015.
Image


Hofstadter's Law: "It always takes longer than you expect, even when you take into account Hofstadter's law."

User avatar
tripax
AGEod Veteran
Posts: 777
Joined: Thu Aug 29, 2013 9:58 pm

Thu Jun 25, 2015 12:26 pm

Thanks! The link isn't working right now, I'll try again later but maybe it isn't just me.

User avatar
Pocus
Posts: 24746
Joined: Wed Oct 19, 2005 7:37 am
Location: Lyon (France)

Mon Jun 29, 2015 9:33 am

Here is a link valid for 10 days, we are working on a permanent solution:

http://we.tl/iVGa7thjot
Image


Hofstadter's Law: "It always takes longer than you expect, even when you take into account Hofstadter's law."

User avatar
tripax
AGEod Veteran
Posts: 777
Joined: Thu Aug 29, 2013 9:58 pm

Mon Jun 29, 2015 11:16 am

Great, I have it now.
Across the South, we have a deep appreciation of history -- we haven’t always had a deep appreciation of each other’s history. - Reverend Clementa Pinckney

User avatar
Keeler
Captain
Posts: 152
Joined: Fri Oct 29, 2010 10:51 pm

Sun Jul 19, 2015 8:04 pm

Pocus wrote:Here is a link valid for 10 days, we are working on a permanent solution:

http://we.tl/iVGa7thjot


Any progress? This link has expired.
"Thank God. I thought it was a New York Regiment."- Unknown Confederate major, upon learning he had surrendered to the 6th Wisconsin.

User avatar
PhilThib
Posts: 13363
Joined: Tue Oct 18, 2005 5:21 pm
Location: Meylan (France)

Mon Jul 20, 2015 7:45 am

Pocus is on holiday right now, will come back to you early August. I believe some permanent hosting solution was found for these, but I can't find the links in my usual desk mess, sorry
Image

User avatar
Keeler
Captain
Posts: 152
Joined: Fri Oct 29, 2010 10:51 pm

Mon Jul 20, 2015 4:51 pm

PhilThib wrote:Pocus is on holiday right now, will come back to you early August. I believe some permanent hosting solution was found for these, but I can't find the links in my usual desk mess, sorry


Yeah, after I posted I remembered that we're in the middle of European holidays.

No problem, I am looking through the old database for the time being.
"Thank God. I thought it was a New York Regiment."- Unknown Confederate major, upon learning he had surrendered to the 6th Wisconsin.

Return to “CW2 Mods”

Who is online

Users browsing this forum: No registered users and 1 guest