This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
howtos:workwithdata:createsetsfromdatafile [2011/05/06 20:58] shona.weldon |
howtos:workwithdata:createsetsfromdatafile [2011/05/13 12:37] shona.weldon |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Use create to make informants from data file ====== | ====== Use create to make informants from data file ====== | ||
- | Here's a tar file with several examples and data. | + | |
- | * Download and un-zip it somewhere on your server where you have access to it with interactive tool, on any account. | + | |
- | * {{: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. | + | |
===== Important parameters ===== | ===== Important parameters ===== | ||
==== General ==== | ==== General ==== | ||
Line 38: | Line 34: | ||
,,,,,,,,,,,,,, | ,,,,,,,,,,,,,, | ||
Greenhouse Gas Categories,,,,,Greenhouse Gases,,,,,,,,, | Greenhouse Gas Categories,,,,,Greenhouse Gases,,,,,,,,, | ||
- | ,,,,,CO2,CH4,CH4e,N2O,N2Oe, HFCs , PFCs ,SF6,TOTAL, | + | ,,,a,b,CO2,CH4,CH4e,N2O,N2Oe, HFCs , PFCs ,SF6,TOTAL, |
,,,,Global Warming Potential,,,21,,310,,,,, | ,,,,Global Warming Potential,,,21,,310,,,,, | ||
,,,,Unit,kt,kt,kt CO2 equivalent, kt ,kt CO2 equivalent,kt CO2 equivalent,kt CO2 equivalent,kt CO2 equivalent,kt CO2 equivalent, | ,,,,Unit,kt,kt,kt CO2 equivalent, kt ,kt CO2 equivalent,kt CO2 equivalent,kt CO2 equivalent,kt CO2 equivalent,kt CO2 equivalent, | ||
Line 72: | Line 68: | ||
export (ECemRowTitles[]; file=$importPath/ECemRowTitles.txt) | export (ECemRowTitles[]; file=$importPath/ECemRowTitles.txt) | ||
</code> | </code> | ||
+ | |||
+ | ==== Read from a line/row ==== | ||
+ | The following code reads the second column as | ||
+ | |||
+ | <code> | ||
+ | string $importPath, $fileName | ||
+ | buildstring ($importPath, $home, "/testScripts") | ||
+ | |||
+ | buildstring ($fileName, $importPath, "/emtestfile.csv") | ||
+ | localinformant GHGInvEmType[] = create (; object=set, delimiter=",", \ | ||
+ | allowDuplicate=on, \ | ||
+ | elemNamesFromLineNum=6, firstCol=4, \ | ||
+ | searchElemName1=",", replaceElemName1="-", \ | ||
+ | replaceWhiteSpaceInElemName="_" , \ | ||
+ | file=$fileName) | ||
+ | |||
+ | display (GHGInvEmType[]) | ||
+ | export (GHGInvEmType[]; file=$importPath/GHGInvEmType.txt) | ||
+ | </code> | ||
+ | |||
+ | ===== Example Test Load ===== | ||
+ | Once you have code for reading the sets it's often useful to do a quick test load of the data |