Resources and Resource Sets are be imported from the same ASCII file.
Data is most conveniently edited in a Spreadsheet such as Microsoft Excel.
Each item must be on a separate line.
Each item’s fields are separated by the comma character (ASCII code 44).
It follows that commas in text fields will cause the separation between fields to become distorted. To avoid this occurrence, commas in text fields (e.g. the description) must be replaced by the "Pipe" character (Shift+\). Valesco will convert this character back to a comma when imported
For the same reason avoid comma separated thousands format in numeric values.
First line only
Resources, , , , , , , , , , , , , , , , , , , , , , , ,
Second Line
Cost Type Number,Cost Type,Short Description,Long Description,Unit,Base Rate,Factor 1,Factor 2,Factor 3,Factor 4,Factor 5,Factor 6,Factor 7,Factor 8,Factor 9,Selected Supplier,Supplier 1,Supplier 2,Supplier 3,Supplier 4,Supplier 5,Supplier 6,Supplier 7,Supplier 8,Supplier 9
For Each Resource:
Col Item Fields
A Cost Type Number
B Cost Type
C Short Description
D Long Description
E Unit * Ensure that time units are Minute, Hour, Day, Week, Month or Year
F Base Rate
G Factor 1
O Factor 9
P Selected Supplier
Q Supplier 1
Y Supplier 9
Resource Sets
To Follow the last Resource
First Line
Resource Sets,,,,,,Unit Rte,No Of,Prod,,,,,,,,,,,,,,,,,,,,,
Second Line
Set S/Descr,Set L/Descr,Set Unit,No of Res x (Res S/Descr,No Of, Prod...),,,,,,,,,,,,,,,,,,,,,,,,
Third line onwards
For Each Resource Set Group:
Col Fields
B Set Group
Optional
C <SET GROUP>
D Parent of Set Group
For Each Resource Set within the preceding Set Group
A Set Short Description
B Set Long Description
C Set Unit
(Optional) For Each Resource within the Set
Next Resource Short Description
Next Resource Number Of
Next Resource Production Rate
(Optional) For Each Cost Type with Added Money (Net Rates)
Next <ADDED>
Next Cost Type 1
Next Cost Type 1 Added Money (Net Rate)
Optional
Next <USER>
Next T1
Next User Text 1
Next T2
Next User Text 2
Next Tn (Maximum 30)
Next User Text n
Next D1
Next User Date 1
Next D2
Next User Date 2
Next Dn
Next User Date n (Maximum 10)
Next N1
Next User Number 1
Next N2
Next User Number 2
Next Nn
Next User Number n (Maximum 10)