User Tools

Site Tools


howtos:workwithdata:import_quick_reference

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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 =====
howtos/workwithdata/import_quick_reference.1493744322.txt.gz ยท Last modified: 2017/05/02 16:58 by marcus.williams