Excel round trip
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2016-07-13 05:19 PM
2016-07-13
05:19 PM
Everything is exported as text, including numbers. True/false properties are exported as 1's and 0's, and those too are text. URLs are not links (though links work in a saved PDF). Most concerning, option sets are not exported, so the Excel user can't pick from the list. And if that user enters a value not on the list, the entire column must be excluded from re-import to Archicad.
In Excel, you can't tell properties from parameters. The Excel user can edit parameter values, but they will be skipped on re-import, and the user doesn't know that.
You can convert the text numbers to number format, and Archicad does not object to this for re-import. It will also accept formula results in number fields, that's good.
I haven't explored adding the option sets to Excel as lists, or T/F fields as checkboxes.
As it stands the Excel user needs to be well-informed and careful in order to hand back useful data. I hope this feature continues to develop – everything in properties and schedules can be done in Excel, but the connection needs to be stronger.
Labels:
- Labels:
-
Data management
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2016-10-31 03:04 PM
2016-10-31
03:04 PM
Agreed. Fantastic feature, but needs a little help. I just set up a bunch of properties with "option sets". I'll have to change them all to "general" to use this feature.
Many Thanks, JP
John Peterson, AIA
Dalgliesh Gilpin Paxton Architects
Archicad 7-21 US
PC and iMac
John Peterson, AIA
Dalgliesh Gilpin Paxton Architects
Archicad 7-21 US
PC and iMac