How to Add a New CSV, TXT, or XYZ file Field Order for Importing

Tutorials and 'How To' information.
Post Reply
User avatar
jovivier
Site Admin
Posts: 919
Joined: Thu Mar 12, 2009 2:57 pm
Company: Lincoln Agritech Ltd, IRRICAD Software
City / Town: Lincoln
Location: Canterbury, New Zealand
Contact:

How to Add a New CSV, TXT, or XYZ file Field Order for Importing

Post by jovivier »

When importing CSV, TXT, or XYZ files you need to select the field order that matches the file. Open the file in Excel or Notepad to view it.
Each entry requires its own column or be separated by a comma.
If the order in the file does not match a default order you can add this to the "a2ccmds.ini" file.

For example, we have a csv file that has the column order Desc, X, Y, Z.
To add this:
1. Browse to the installed Irricad folder, commonly located at C:\Program Files\Irricad\Irricad Link for IRRICAD Link or C:\Program Files (x86)\Irricad\Irricad Pro for Standalone, and open the “a2ccmds.ini” file in Notepad.

2. Note the number of options there and start a new entry with the next number, e.g., [Option9]

3. Looking at the existing format, create the field order that you require. You can base this on the closest one, which in this case is option 5 E.g.,
DESC= Desc, X, Y, Z,
CSV=/T=0 /DX=1 /DY=2 /E=3
GEO=false


Note that:
/DX is X
/DY is Y
/E is Z
/T is Desc.
(/DID= is ID which is not used in this case).
The numbers represent their position (column number), where the first column is 0.

Your entry should look like:
[Option9]
DESC= Desc, X, Y, Z,
CSV=/T=0 /DX=1 /DY=2 /E=3
GEO=false

4. Save the file and now import the csv file using the new "Field Order" option.


The IRRICAD Team
Post Reply