A good CSV editor

This is the location for all mods to collaborate. Anyone making or planning their own mod should post help requests, screen shots and news here.

Moderators: Omega, tillias, Mod Contributor

Post Reply
ezee
Intrepid Venturer
Intrepid Venturer
Posts: 703
Joined: Tue Feb 11, 2014 12:47 am
Location: FRANCE
Contact:

A good CSV editor

Post by ezee »

If you plan to mod vegastrike , you'll need one day to look inside some .csv files and perhaps tweak it .
I've found a free editor for windows that is neat , with numerous options , import , export
to xml , etc ...
The link to the app page : http://csved.sjfrancke.nl/

ANd for everyone , there is an online .csv to xml converter:
http://www.creativyst.com/Doc/Articles/ ... m#ProcForm

Code: Select all

 if (!track.HasWeapons())
            {
                // So what are you going to threaten me with? Exhaustion gas?
                return ThreatLevel::None;
            }
Vegastrike evolved
DEV YOUTUBE CHANNEL
Vegastrike evolved wiki
ezee
Intrepid Venturer
Intrepid Venturer
Posts: 703
Joined: Tue Feb 11, 2014 12:47 am
Location: FRANCE
Contact:

Re: A good CSV editor

Post by ezee »

I have tried CSVed to convert the master-part-list.csv into xml .
That works perfect .
<?xml version="1.0" encoding="ISO-8859-1" standalone="yes"?>
<!-- Source File: D:\program\VSMARKET\Vegastrike_Market\data\master_part_list.csv -->
<!-- Number of Records: 606 -->
<!-- Created with: CSVed 2.3.2, at: 01/06/2015 23:24:26 -->
<!-- Start of the body -->

<Document source="D:\program\VSMARKET\Vegastrike_Market\data\master_part_list.csv">
<Row>
<Column0>file</Column0>
<Column1>categoryname</Column1>
<Column2>price</Column2>
<Column3>mass</Column3>
<Column4>volume</Column4>
<Column5>description</Column5>
</Row>

<Row>
<Column0>Admonisher.stock</Column0>
<Column1>starships/Confed/Heavy</Column1>
<Column2>3000001</Column2>
<Column3>275</Column3>
<Column4>5600</Column4>
<Column5>A Purist crafted light assault vessel, the Admonisher is often used for internal policing duties by Homeland Security and others within the Confederation. As might be expected from a vessel used for such purposes, it excels at neutralizing both small craft and their support vessels, a valuable asset in the suppression of Pirates and the dangerous ideologies of the Luddites and ISO.</Column5>
</Row>

<Row>
<Column0>Admonisher.HSspec</Column0>
<Column1>starships/Homeland-Security/Milspec</Column1>
<Column2>3000000</Column2>
<Column3>275</Column3>
<Column4>5600</Column4>
<Column5>A Purist crafted light assault vessel, the Admonisher is often used for internal policing duties by Homeland Security and others within the Confederation. As might be expected from a vessel used for such purposes, it excels at neutralizing both small craft and their support vessels, a valuable asset in the suppression of Pirates and the dangerous ideologies of the Luddites and ISO.</Column5>
</Row>

...
...
...
That make a huge page , but it's easy to edit and change values with a text editor only.
I use notepad++ , it's beautiful ^^ .
It is also possible to split the .csv file , thing that i will try .
Last edited by ezee on Mon Jun 01, 2015 11:12 pm, edited 1 time in total.

Code: Select all

 if (!track.HasWeapons())
            {
                // So what are you going to threaten me with? Exhaustion gas?
                return ThreatLevel::None;
            }
Vegastrike evolved
DEV YOUTUBE CHANNEL
Vegastrike evolved wiki
loki1950
The Shepherd
Posts: 5841
Joined: Fri May 13, 2005 8:37 pm
Location: Ottawa
Contact:

Re: A good CSV editor

Post by loki1950 »

BTW the current code does use split .csv files so they can be a bit more human readable.

Enjoy the Choice :)
my box::HP Envy i5-6400 @2Q70GHzx4 8 Gb ram/1 Tb(Win10 64)/3 Tb Mint 19.2/GTX745 4Gb acer S243HL K222HQL
Q8200/Asus P5QDLX/8 Gb ram/WD 2Tb 2-500 G HD/GF GT640 2Gb Mint 17.3 64 bit Win 10 32 bit acer and Lenovo ideapad 320-15ARB Win 10/Mint 19.2
ezee
Intrepid Venturer
Intrepid Venturer
Posts: 703
Joined: Tue Feb 11, 2014 12:47 am
Location: FRANCE
Contact:

Re: A good CSV editor

Post by ezee »

I have found now an online tool that will turn the .xml file you just edited
into a new master-part-list.csv :
http://www.luxonsoftware.com/converter/xmltocsv

There is a downloadable free version that manage large files :
http://xmltocsv.codeplex.com/

Code: Select all

 if (!track.HasWeapons())
            {
                // So what are you going to threaten me with? Exhaustion gas?
                return ThreatLevel::None;
            }
Vegastrike evolved
DEV YOUTUBE CHANNEL
Vegastrike evolved wiki
Post Reply