Hard Light Productions Forums

Hosted Projects - Non-FreeSpace => MechCommander OmniTech => Topic started by: Cipher on March 05, 2011, 07:32:38 pm

Title: Help with .csv editing
Post by: Cipher on March 05, 2011, 07:32:38 pm
well, i was editing the direwolf csv to add a favorite (canon) variant of mine, and after i finished and went to solo mission to make sure it works, this happened.
(http://img714.imageshack.us/img714/7113/oopsf.jpg)

so, now i'm looking through the csv to find what i did wrong, and because i'm not really experienced in this, i'm totally stumped

p.s. i edited it with ms excel 03, and i'll put it here to see if someone could try and help me

[attachment deleted by ninja]
Title: Re: Help with .csv editing
Post by: TheOldMan on March 06, 2011, 05:06:01 am
First mistake, using Excel or some  other DB type program to edit.  Made that one myself.     :confused:

Your best bet is to use NotePad.  You can change the values between the commas without losing any.

Just from looking at the first few lines I see missing commas at the end of the line.  The code expects them to be there, and if not, will throw off positions for other values in the data.

Go to my web site.   http://members.cox.net/morkover/ (http://members.cox.net/morkover/)

Download the CSV Weapons coding file, it's in Rich Text Format.  It explains how to make what changes you want.  Plus a little hysterical background on the files.  :nod:
Title: Re: Help with .csv editing
Post by: Starman01 on March 06, 2011, 05:44:27 am
There is also a tool available to edit csv files, but having the same good look as excel. It's called "CSVed". However, while it supports a good and organized view, I find it quite unhandy in editing. You can try, but your best bet is as TheOldman said, using notepad. In time you get used where each value is stored
Title: Re: Help with .csv editing
Post by: Droid803 on March 06, 2011, 01:12:43 pm
Isn't a csv just a file of Comma Separated Values?
Title: Re: Help with .csv editing
Post by: Starman01 on March 06, 2011, 01:15:22 pm
Yep.

But Excel is messing it up when you try to save it :(
Title: Re: Help with .csv editing
Post by: Cipher on March 06, 2011, 04:41:29 pm
i've done it before (2 other times), but for some reason it's always the direwolf that i mess up :lol:
Title: Re: Help with .csv editing
Post by: fgbrooks on May 28, 2011, 09:28:56 am
Hi "TheOldMan",

I went to your site to download the CSV Weapons Coding document and got a "File Not Found Message".  Please help.
Title: Re: Help with .csv editing
Post by: TheOldMan on May 29, 2011, 08:23:50 am
Can't upload .RTF as attachment.  So, I ZIPped it.

or

Try :http://cid-15efb07473c65248.office.live.com/self.aspx/.Documents/CSV%20Weapons%20Codng.rtf (http://cid-15efb07473c65248.office.live.com/self.aspx/.Documents/CSV%20Weapons%20Codng.rtf)

Name messed up on server.  Trying to update.   :banghead:


[attachment deleted by ninja]
Title: Re: Help with .csv editing
Post by: TheOldMan on May 29, 2011, 09:48:59 am
Web Site should be working now.  Damn server! :mad:
First it doesn't like spaces in file names, then it doesn't like Upper/Lower case mismatch.  :confused:
Now I can't even delete the file with spaces in the name!  :banghead:
It's now 9:45 am Sunday. I'm going to bed.  :mad:
Title: Re: Help with .csv editing
Post by: fgbrooks on May 29, 2011, 10:03:25 am
Thanks "OldMan"!!   Now my question to you is how did Wolfman, Magic et al manage to put an entirely NEW weapon into the game and have a description of it show up.  The reason I ask this is that the compbas.csv file that comes with the Omnitech download does not have the RAC2 or the RAC5.  When I took the data from Wolfman and tried to make an entry into the OT compbas.csv file, the gun shows up in the game, but the description is "undefined".  Your thoughts/comments??
Title: Re: Help with .csv editing
Post by: TheOldMan on May 29, 2011, 04:05:13 pm
Tried the same thing myself.  Just so I could use a Rail Gun.
I'm pretty sure, just like many other things in the game. that they are hard coded in the source somewhere.

It might take a while, but check out Wolfman's Forum and Dropship Command Forum.  I remember seeing a discussion thread somewhere that talks about Weapons Upgrades to the game, and compbas.csv.
Title: Re: Help with .csv editing
Post by: fgbrooks on May 29, 2011, 04:20:22 pm
Thanks "OM" for the quick follow-up.  Will do; will report back if I come up with anything.