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
Last revision Both sides next revision
howtos:workwithdata:import_quick_reference [2017/05/02 16:58]
marcus.williams
howtos:workwithdata:import_quick_reference [2017/05/18 14:50]
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.txt ยท Last modified: 2017/05/18 14:51 by marcus.williams