T
by towi on 28 Nov 2022
#
+3 votes
@brunopostle said:
@vbertran this looks like the file is written in utf-8 encoding, but excel hasn't recognised this and has assumed it is latin1.
I seem to remember that you can indicate the encoding when you open a CSV file in excel.
Yes, you can choose the right encoding if you instead of opening a CSV directly, go to the Data tab in the ribbon, then the import group and the import from text/csv. If you need to, you can also transform the data in Power Query.
Never open a CSV directly in Excel, as this quickly can lead to a corrupted CSV.
T
by TransportBIM on 6 Sep 2023, edited 6 Sep 2023
#
Hi, I'm a noobie to BlenderBIM and this forum and not entirely sure if this is the right place to post.
But, I'm having trouble exporting to csv, via the IFCCSV exporter, a few selected custom Property Set properties.
see screen shot attached of the error returned: "NameError: name 'args' is not defined"
Thanks in advance, any assistance is appreciated.
T
by theoryshaw on 6 Sep 2023
#
Can you show us a snapshot of this area?...
M
by Moult on 6 Sep 2023
#
@TransportBIM also make sure you have upgraded to the latest version, this has changed significantly recently.
T
by TransportBIM on 6 Sep 2023
#
@Moult I have updated to latest release, i.e. v0.0.230902.
I note that the menu has changed. Any hints on where I might find the IFCCSV import/export tool under this version?
T
by TransportBIM on 6 Sep 2023, edited 6 Sep 2023
#
I was able to find it under collaboration by typing CSV into the search bar.
However, the menu under Collaboration tab is greyed out. Is it recalling it from the previous version?
M
by Moult on 6 Sep 2023
#
+1 votes
@TransportBIM I'm not sure what you mean by the menu is greyed out - you should always be able to create schedules. I'm also happy to jump on a call with you to help figure it out.
T
by theoryshaw on 6 Sep 2023, edited 6 Sep 2023
#
+2 votes
does this help?
video:
It uses the new facet selector system to select stuff...
https://community.osarch.org/discussion/1580/
T
by TransportBIM on 6 Sep 2023
#
@Moult & @theoryshaw
thank-you for responding.
I have managed to get it exported, and it worked as expected.
My apologies, being new to the UI always a little challenging, but best way to learn also.
Thanks for the offer @Moult I still may take you up on that later, but for now I press-on.
@theoryshaw thank-you also for the links, I'll check them out soon too.
A
by Andrej730 on 6 Sep 2023
#
It's in Quality and Coordination:
However, the menu under Collaboration tab is greyed out. Is it recalling it from the previous version?
which one menu?
F
by fbosche on 6 Sep 2023
#
+2 votes
Just to say that I had the same problem as @TransportBIM with a version 0.0.2307xx of the BlenderBIM addon. After upgrading to 0.0.230902, the problem is sorted.
However, it takes some time to get used to the new "Spreadsheet Import/Export" because things have changed a fair bit. More functionality is offered, which is great, and the "Export CSV Settings" functionality has been updated accordingly, which is great.
For those who wonder, if you PSet name contains spaces, you need to put its name in quotation marks now. Also "type" doesn't exist anymore; it's now "class", etc. etc. :)
Anyways, this is such a great feature of BlenderBIM. Thank you.
T
by TransportBIM on 10 Sep 2023, edited 10 Sep 2023
#
Hi, following on from @fbosche comments above, with the new arrangement under 0.0.230902 UI.
My issue atm is indirectly related to IFCCSV export but might be more relevant to another topic.
That is, before exporting, I could not add a custom Property Set to objects in my ifc project. I have created a custom property set template under the Project Setup > Property Set Templates. See image :
But when I go over to "Object Information" to apply the custom property set, I'm unable to select it from the list under the 'Object Property Sets' see the two images below:
I feel as though I'm missing a step. Again, any assistance is greatly appreciated. Thanks
F
by fbosche on 10 Sep 2023
#
That's funny because I was investigating just that a couple of day ago and faced the same problem (I was going to investigate a bit more before posting). However, I think we should discuss this in a different thread. Could you maybe move this to another one?
M
by Moult on 10 Sep 2023
#
+1 votes
Make sure you save your changes back to your pset template file:
Note that there a number of quality of life issues like needing to also reload your model when creating a new pset template file. This didn't actually stop it from working if you know the steps, but it's really unintuitive and leads to a bad user experience. I've now removed the save button so hopefully this helps: https://github.com/IfcOpenShell/IfcOpenShell/commit/9be7d951c3f9f68b250d2daa00f197a0c49d5621
F
by fbosche on 10 Sep 2023, edited 11 Sep 2023
#
Thanks. I actually figured that one out just before you posted. It's good to have this recorded here, in case somebody else faces this issue.
T
by TransportBIM on 11 Sep 2023
#
@Moult, The latest release v0.0.230910 works well, thanks again.
V
by vinnividivicci on 24 Oct 2023
#
@fbosche said:
Just to say that I had the same problem as @TransportBIM with a version 0.0.2307xx of the BlenderBIM addon. After upgrading to 0.0.230902, the problem is sorted.
However, it takes some time to get used to the new "Spreadsheet Import/Export" because things have changed a fair bit. More functionality is offered, which is great, and the "Export CSV Settings" functionality has been updated accordingly, which is great.
For those who wonder, if you PSet name contains spaces, you need to put its name in quotation marks now. Also "type" doesn't exist anymore; it's now "class", etc. etc. :)
Anyways, this is such a great feature of BlenderBIM. Thank you.
Adding to this, the syntax for Psets that contain spaces would be: "Pset Name"."Property Name".
That works for me.
However, I've got a painful exception since the model comes from Revit and the parameter names contain apostrophes ('). Ex.: "Pset Name"."Object's property" gives "N/A" in the CSV. Any idea how to the the " 's " to not bug things out?