howtos:workwithdata:createreaddatafiles
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
howtos:workwithdata:createreaddatafiles [2010/08/03 15:34] shona.weldon |
howtos:workwithdata:createreaddatafiles [2011/05/13 12:30] (current) shona.weldon |
||
|---|---|---|---|
| Line 4: | Line 4: | ||
| Here's a tar file with several examples and data. | Here's a tar file with several examples and data. | ||
| - | * Download and un-tar it somewhere on your server where you have access to it with interactive tool, on any account. | + | * Download and un-zip it somewhere on your server where you have access to it with interactive tool, on any account. |
| - | * {{:howtos:workwithdata:createtest.tar.gz|createtest.tar.gz}} | + | * {{:howtos:workwithdata:create.zip|}} |
| * The best way to learn about the features is to work through the test.t script file in the above tar file looking at the results as you go. | * The best way to learn about the features is to work through the test.t script file in the above tar file looking at the results as you go. | ||
| ===== Important Parameters ===== | ===== Important Parameters ===== | ||
| - | **stopIfExtraOrMissData=on/off** - Always run without this first and check out any errors or warnings about your input data however if you determine there are just extra empty columns or missing columns that you don't mind padding with 0's then turn on this parameter. | + | **ignoreExtraCols=on/off** - Always run without this first and check out any errors or warnings about your input data however if you determine there are just extra empty columns |
| + | |||
| + | **ignoreMissingCols=on/off** - or missing columns that you don't mind padding with 0's then turn on this parameter. | ||
| **delimiter** - works for both coordinate and odometer format now | **delimiter** - works for both coordinate and odometer format now | ||
| - | **searchElemName1=** and **replaceElemName1=** - use this to search and replace pair to match up with the changes to element names you may have made when extracting the informant for this data. Must be used together | + | **searchElemName1** and **replaceElemName1** - use this to search and replace pair to match up with the changes to element names you may have made when extracting the informant for this data. Must be used together |
| **replaceWhiteSpaceInElemName** - replace any tab, space or other "white space" in the element names and should also be used to match up with the element name changes you may have made when extracting the informant set | **replaceWhiteSpaceInElemName** - replace any tab, space or other "white space" in the element names and should also be used to match up with the element name changes you may have made when extracting the informant set | ||
| - | **firstLine=** - this is the line the data starts on and is counted from the top of the file even if there are lines commented out with '!' | + | **firstLine** - this is the line the data starts on and is counted from the top of the file even if there are lines commented out with '!' |
| - | **firstCol=** - this is the first column to consider and is a 1 based value so the first column is 1 | + | **firstCol** - this is the first column to consider and is a 1 based value so the first column is 1 |
| * In coordinate format that means the first column that has coordinate element names in it. | * In coordinate format that means the first column that has coordinate element names in it. | ||
| * In odometer format that means the first column that has data in it, if this is used the **rowTitles** parameter is ignored | * In odometer format that means the first column that has data in it, if this is used the **rowTitles** parameter is ignored | ||
| - | **firstTabCol** - only here for backward compatibility, it is used in odometer format only and it means the first column where there is actually data and is a 0 based index (ie the first column is actually counted as 0). If the **rowTitles=on** is used it is the same as setting firstTabCol to 1 | + | |
| + | |||
| + | ===== Indexing ===== | ||
| + | When you have a non-numeric column and have an informant for these values you can take in the data as the indexed numeric value. Then later when writing it out you can index it back to this informant and write out the text. | ||
howtos/workwithdata/createreaddatafiles.1280849648.txt.gz · Last modified: 2010/08/03 15:34 by shona.weldon
Page Tools
