Project Detail

Description

Desription:

A Lookup utility that lookups translation codes from a file called mapping.csv and compares it against the tchadata.csv. Then produces a files called tchaoutput.csv with the format and formulas as described here below:

Needs to be able to run from the command line, as no buttons please as this needs to be binded into another script.


-

Name of data files: tchadata.csv
Name of mapping file: mapping.csv
Name of outpufile: tchaoutput.csv





Format and formulas for the output file:



If case = U then

Translation Question, Translation Question + INSTALL YEAR, Translation Question + REMAINING LIFE, Translation Question + QUANTITY, Translation Question + COMMENTS


If case =L then

Translation Question, Translation Question + Install year, Translation Question + Rem Life, Translation Question + Quantity, Translation Question + Comments



Output layout:


Property Ref = Ref (IBS OPEN)


Translation Question = Code Translation

Translation Question + Install year = WORKS LAST DONE
Translation Question + INSTALL YEAR = WORKS LAST DONE

Translation Question + REMAINING LIFE = Priority - 9
Translation Question + Rem Life = Priority - 9

Translation Question + QUANTITY = Quantity
Translation Question + Quantity - Quantity

Translation Question + COMMENTS = Comments
Translation Question + Comments = Comments









Additional files submitted:
lookupscript.zip