This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
howtos:workwithdata:import_quick_reference [2017/05/02 16:58] marcus.williams |
howtos:workwithdata:import_quick_reference [2017/05/18 14:51] (current) marcus.williams [advanced import examples] |
||
---|---|---|---|
Line 51: | Line 51: | ||
file=$importDir/zonesMask.csv) | file=$importDir/zonesMask.csv) | ||
</code> | </code> | ||
+ | |||
+ | ==== advanced import examples ==== | ||
+ | |||
+ | <code> | ||
+ | local occPrivDwellCustSC_1[pzans,dtd] = create (; \ | ||
+ | dim=PLUMzoneAllNS, dim=dwellType_data, \ | ||
+ | entityFrom=occPrivDwellCustSC[pzans,dt,byrs][$index], \ | ||
+ | dataFormat=coordinate, fileFormat=text, \ | ||
+ | allCoord=off, delimiter=",", firstLine=2, \ | ||
+ | searchElemName1=",", replaceElemName1="", \ | ||
+ | searchElemName2="/", replaceElemName2="_", \ | ||
+ | searchElemName3="-", replaceElemName3="_", \ | ||
+ | replaceWhiteSpaceInElemName="_", \ | ||
+ | stripLeadingWhiteSpace=off, \ | ||
+ | searchData=",", replaceData="" , \ | ||
+ | file=$importDir/dwellUnitsByType.csv) | ||
+ | </code> | ||
+ | ==== read localinformants ==== | ||
+ | |||
+ | Read informant definition from column: | ||
+ | |||
+ | <code> | ||
+ | localinformant age_0510002[] = create (; object=set, delimiter=",", \ | ||
+ | allowDuplicate=on, \ | ||
+ | elemNamesFromColNum=3, firstLine=2, \ | ||
+ | searchElemName1=",", replaceElemName1="", \ | ||
+ | searchElemName2="/", replaceElemName2="_", \ | ||
+ | searchElemName3="-", replaceElemName3="_", \ | ||
+ | replaceWhiteSpaceInElemName="_", \ | ||
+ | stripLeadingWhiteSpace=off, \ | ||
+ | file=$importDir/051-0002.csv) | ||
+ | </code> | ||
+ | |||
+ | Read informant definition from line: | ||
+ | |||
+ | <code> | ||
+ | localinformant date_0510002[] = create (; object=set, delimiter=",", \ | ||
+ | allowDuplicate=off, \ | ||
+ | elemNamesFromLineNum=1, firstCol=4, \ | ||
+ | searchElemName1=",", replaceElemName1="", \ | ||
+ | searchElemName2="/", replaceElemName2="_", \ | ||
+ | searchElemName3="-", replaceElemName3="_", \ | ||
+ | replaceWhiteSpaceInElemName="_", \ | ||
+ | stripLeadingWhiteSpace=off, \ | ||
+ | file=$importDir/051-0002.csv) | ||
+ | </code> | ||
+ | |||
===== tab delimited text odometer (block) format ===== | ===== tab delimited text odometer (block) format ===== |