I have problems to import and link csv file cost schedule. An error is generated. Is there another template for csv file. Using ver 0.8.4 alpha 251117
Thanks
@Amerigo
please make sure you have the column headers like Index, Identification, Name, Quantity, Unit,[cost columns], Property,Query, RateSchedule,RateID
with Index as tree level value, 1 for summary items (parent), 2 for immediate nested ones (child), and so on
there was a change some time ago that replaced hierarchy header
in [cost columns] you can have something like Contract Rate, Plant Rate, Material Rate,Labor Rate,Subtotal
they are not mandatory, or at least they do not trigger an error if missing
@steverugi said: @Amerigo
please make sure you have the column headers like Index, Identification, Name, Quantity, Unit,[cost columns], Property,Query, RateSchedule,RateID
with Index as tree level value, 1 for summary items (parent), 2 for immediate nested ones (child), and so on
Where I can insert unit price?
Some problem anyway ...
In detail, I would have a BoQ (UnPricedBillofQuantities) to be compiled into ifc model and a SoR with unit prices to be applied, in Ifc model, on BoQ items to have finally a PricedBillofQuantities
schedule of rates name = "SoR" (one cost item example)
where you have a cost item with ID BLN100 and a rate value of 60
csv to create bill of quantities
I hid the cost columns, that are empty, note the RateSchedule = "SoR" and RateID = "BLN100"
the Property column indicates the type of quantity to use (from Qto_SlabBaseQuantities) and
the Query select all IfcSlab elements with type = "S-B-BLN-100" matching "M_F1" location (spatial container)
BoQ:
don't forget to run "Perform Quantity Take-off" first (as I often do)
@Amerigo
It looks like exporting to xlsx needs "xlswriter" module.
The export to csv too is what it is, hopefully with time (and some donations) it can be improved, in the meantime you can export it to .ods and import it back in Excel.
ideally:
1. the first 4 columns are not needed
2. a list of quantities from Qto_*BaseQuantities might be not something of immediate use in a cost schedule export (IMHO it should report the same info shown in Bonsai's panel)
3. values are exported as text, and yes columns TotalPrice and General Cost are seemingly confusing
do you have further comments? We can organize a little bounty to have it fixed
ping @Massimo
Grazie
@Amerigo not in scripting, they are just some .csv file example that can be imported in bonsai...so you can look at the columns name in order to understand how to structure your csv file
I've tried ... but still missing partial cost of each item, only report sum in TotalPrice column where ItemIsASum is set to true (Ex4 - BoQ with description.csv)
Comments
@Amerigo
please make sure you have the column headers like
Index,Identification,Name,Quantity,Unit,[cost columns],Property,Query,RateSchedule,RateIDwith Index as tree level value, 1 for summary items (parent), 2 for immediate nested ones (child), and so on
there was a change some time ago that replaced hierarchy header
in [cost columns] you can have something like
Contract Rate,Plant Rate,Material Rate,Labor Rate,Subtotalthey are not mandatory, or at least they do not trigger an error if missing
Thank you Steve, I really appreciate your availability...I'll try
Where I can insert unit price?
Some problem anyway ...
In detail, I would have a BoQ (UnPricedBillofQuantities) to be compiled into ifc model and a SoR with unit prices to be applied, in Ifc model, on BoQ items to have finally a PricedBillofQuantities
@Amerigo
schedule of rates name = "SoR" (one cost item example)
where you have a cost item with ID
BLN100and a rate value of 60csv to create bill of quantities
I hid the cost columns, that are empty, note the RateSchedule = "SoR" and RateID = "BLN100"
the Property column indicates the type of quantity to use (from Qto_SlabBaseQuantities) and
the Query select all IfcSlab elements with type = "S-B-BLN-100" matching "M_F1" location (spatial container)
BoQ:
don't forget to run "Perform Quantity Take-off" first (as I often do)
Many Thanks Stefano. I'll try
Such a strange thing...in exported csv disappear total cost for each item.
Regarding export, couldn't it be exported directly in xls format?
@Amerigo
It looks like exporting to xlsx needs "xlswriter" module.
The export to csv too is what it is, hopefully with time (and some donations) it can be improved, in the meantime you can export it to .ods and import it back in Excel.
ideally:
1. the first 4 columns are not needed
2. a list of quantities from Qto_*BaseQuantities might be not something of immediate use in a cost schedule export (IMHO it should report the same info shown in Bonsai's panel)
3. values are exported as text, and yes columns TotalPrice and General Cost are seemingly confusing
do you have further comments? We can organize a little bounty to have it fixed
ping @Massimo
Grazie
Thanks for now, have a nice day
Well, the error can be reported as issue :-)
For the other aspects, they can be added to the (already long) list :-)
Just added a few simple csv file examples in ifc5d folder, let me know if it useful...i hope it helps! Cheers!
Where I can retrieve them?
Thanks
@Amerigo here https://github.com/IfcOpenShell/IfcOpenShell/tree/v0.8.0/src/ifc5d
Grazie. Saluti
Excuse me , how can I use them ...in scripting I suppose (I'm not so practical!)
@Amerigo not in scripting, they are just some .csv file example that can be imported in bonsai...so you can look at the columns name in order to understand how to structure your csv file
I've tried ... but still missing partial cost of each item, only report sum in TotalPrice column where ItemIsASum is set to true (Ex4 - BoQ with description.csv)
@Amerigo are you talking about the export? If so nothing changed afaik so the behavior is the same...
@Massimo Many thanks
Yes...Thank you for your availability