topic Re: Project Info import and export options in Project data & BIM

Project Info import and export options

Miha_M — Fri, 19 May 2023 23:03:30 GMT

Dear GS, I have one simple (?) wish. We work in a open BIM enabled environment and exchange data between different software. I would be very very happy if I could import some project info data from an external .xls or .xlsx source; now only a .xml data structure is available for import.

We use excel spreadsheets with many formulas and some databases for managing project data, from which we generate ISO 19650 conventions conform project data (naming rules, other in-house standardized data, etc.). If possible, I would like to export a sample data structure from Archicad to excel, upon which I would be able to build a dedicated speadsheet. From this spreadsheet, which pulls elsewhere generated data and structures it into an Archicad scheme, this data could be imported back to Archicad.

Additional, an import dialogue could allow users to see existing data vs. imported data, where an option to select or deselect data entries to be overwritten - maybe Project Info data could be accessible and editable through the Attribute Manager UI?

Re: Project Info import and export options

poco2013 — Thu, 26 Jan 2023 12:11:36 GMT

Sounds a lot like the Archicad export schedule to excel feature. What do you need to do differently??

Re: Project Info import and export options

Miha_M — Thu, 26 Jan 2023 13:10:29 GMT

Exactly. What is different is that the Project Info data export/import feature doesn't support the .xls Excel filetype.

Re: Project Info import and export options

poco2013 — Thu, 26 Jan 2023 21:38:06 GMT

Excel does accept XML files as a database file. But I expect the process is more trouble than worth.

i expect that it would be be more effective to skip the excel import and just use a xml editor, xmlspy is a popular one. You could export and duplicate a typical (template) file and just overwrite the entries as needed. Adding entries is tricky as Archicad uses a unusual protocol.

Re: Project Info import and export options

Miha_M — Fri, 27 Jan 2023 07:31:23 GMT

More trouble then worth, I tried it myself. Well, the workaround with an .xml editor is possible, but my main goal can't be reached this way. As I have written in my wish I would like to get outside of Archicad (excel worksheet based on internal database, rules and formulas) generated information imported back into Archicad Project Info. For me this would be one additional data transformation from excel to .xml and as you found out yourself the Archicad protocol is a bit unusual. I am nowhere near a capable data transformation expert and have limited knowledge about the xml structure, so this workaround route for me is out of reach.

As the Project Info has a simple table structure I believe it shouldn't be that difficult to implement an additional .xls or .xlsx translation process, as this functionality has already been implemented into schedules.

Re: Project Info import and export options

Francois Swanepoel — Wed, 29 Mar 2023 07:19:23 GMT

Great question @Miha_M thanks for posting it. I fully understand why you ask for this.

Some time ago I also posted a wish for the same aspect, but for a different (additional) reason.
Wishes - New Feature Request for BIMx (Project Info control)

What I suggest is better control of project info directly INSIDE Archicad, because we experience TOO MANY .xml file corruption errors exporting & importing Info sets. These persistent errors cause a lot of delays, especially during Publishing in extremely tight deadlines. The exporting & importing Info sets process is buggy and we can not trust it.

I am keen to see what comes out of this thread...

Re: Project Info import and export options

Erik Bjornhage — Mon, 26 Jun 2023 09:42:00 GMT

We have used XML Notepad which is easy enough and gives a reasonably simple way of handling ProjectInfo entries.

We think it works well and solves some of our problems.

Still, a better way of handling ProjectInfo - including the possibility to map in IFC as been discussed in other threads.

Re: Project Info import and export options

JeffH — Mon, 26 Jun 2023 21:36:14 GMT

I have a different end goal...but would also like the ability to adjust Project Info much more than currently allowed.

Currently, we are trying out having all of our typical Section notes already established, and then using basic autotext for Wall Sections & Details where we can't pull everything directly from the model (Building Materials or element ID's).

The massive benefit here is that we change a note in this single "Project Info" location, and all the autotexted labels will update for the entire project.

Unfortunately, I cant Create an additional header for each division, so "Building Details" ends up containing what will be a massive amount of typical pre-established notes.

Re: Project Info import and export options

Barry Kelly — Tue, 27 Jun 2023 01:20:58 GMT

I have not tried this, so can't say if it will work well or not.

Have you tried using Properties?

You can create groups of properties and you can even associate properties with particular classifications (or simply associate all of them).

Your properties can even be an option list where you can choose from pre-set options.

Properties can also be exported/imported between files (and of course set them up in your template).

Then label using the properties instead of the project info.

Barry.

Re: Project Info import and export options

Francois Swanepoel — Sat, 03 Feb 2024 08:10:39 GMT

Interesting indeed @JeffH
Note these suggested options with images (below) for expanding Project Info on my post: Wishes - New Feature Request for BIMx (Project Info control)

As we solve Property Compliance for owners, landlords & their tenants, we use BIMx as an easy to use, entry level platform to access their "Digital Twin" for various stakeholders that each need to have an applicable level of access to info in the model. I believe control of "Project Info" visibility is not that far removed from where Graphisoft is taking BIMx looking at the exciting roadmap & recent BIMx improvements. Properties does not work in this case. I remain hopeful... have not given up on my posted wish for improved Project Info.

Constantly importing / exporting various Project Info data is messy, time consuming and very open to software & operator error with varying Archicad proficiencies in a studio environment.

Re: Project Info import and export options

JeffH — Tue, 27 Jun 2023 12:07:43 GMT

Properties was my first attempt.

Sadly when it comes to most of our details (Plan Details and Section Details), a good chunk of the detail ends up being fills and lines, which you cant attach Classifications & Properties to.

Without that association, you can't pull the actual info from the properties manager, at least not that I was able to find. You are only able to pull the Property name. How we have things set up is using the CSI number which correlates back to our specification numbers...And I tried then listing all the notes as option sets. Without association, if my memory serves me correctly, The Text would simply come in as the overall property name rather then allowing selection of the various options.

If they were ever to allow us to attach Classifications and properties to absolutely everything in AC (Lines, Fills, Hotspots, etc.)...that would be exactly where all these notes would live.

Re: Project Info import and export options

Aurasphere — Tue, 27 Jun 2023 21:46:42 GMT

I agree Barry

More to the point that properties allow a custom hierarchy so that groupings and categories can be well navigated. Despite ProjectInfo using xml and tree schema, it relies directly on essentially GUID so that migration, where others users have tampered with the values can wreak havoc.

Properties satisfy this as a global project reference imvho

Re: Project Info import and export options

Aurasphere — Tue, 27 Jun 2023 21:48:56 GMT

Hi Francois

From what I understand of your needs...possibly an easy implement for some python and additions to the api (havent looked to see if projectinfo is exposed as yet)?

Cheers