How to Add a New CSV, TXT, or XYZ file Field Order for Importing
Posted: Tue Dec 01, 2020 11:02 am
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
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