Search the Knowledge Base Report a bug
Post new topic   Reply to topic   printer-friendly view   .    ArchiCAD-Talk Forum Index >>> BIM Managers >>> Attribute Management Goto page 1, 2  Next
View previous topic :: View next topic
Author Message
neil Kaiser
New member
New member

Joined: 04 May 2004
Posts: 11
Location: NewZealand

PostPosted: Tue Apr 07, 2009 11:52 pm    Post subject: Attribute Management Reply with quote

Does anyone know of a utility for managing software ID's within Archicad?

I have been grappling with project files which should have the same attributes but users have either added or removed some elements from various parts of the attributes set. In particular composites are an issue. If the software ID gets out of sync between two files, overwriting the attributes can cause all sorts of havoc and you don't know where it's going to occur. Even a utility that identifies software ID differences between files would be good as this would at least identify what I'd be looking for.

I know a project wide standard attribute set is ideal but invariably there are changes you don't expect people to do and you still have to deal with them. The attribute manager does show some of the ID's but I need to manage them between multiple files so a comparitive list or even an editor if there is one would make life more consistent.

Cheers

_________________
8 core Mac Pro
User from V4.5 to 12
Chowhill Architects
Auckland
New Zealand
Back to top
View user's profile Send private message Visit poster's website    
Karl Ottenstein
Moderator
Moderator

Joined: 28 Oct 2003
Posts: 7806
Location: Bozeman, Montana USA

PostPosted: Wed Apr 08, 2009 12:23 am    Post subject: Re: Attribute Management Reply with quote

neil Kaiser wrote:
Even a utility that identifies software ID differences between files would be good as this would at least identify what I'd be looking for.


This is relatively easy for Mac people (you) because of the Unix utilities available from Terminal. I'm not supposed to even be here right now (!) - so will try to remember to post the steps tomorrow. Basic idea is to export the attributes either from AM or SQL and do an sdiff in Terminal (or equivalent) to find the differences between files. Of course, the differences will be just by name/ID - if someone has the same content with a different name, you'll never know it.

Karl

_________________
AC 20 US, Artlantis 5, Adobe CS 6, Piranesi 6, Final Cut Pro X, etc.
8 Core 2.8 Mac Pro/12GB RAM, SSD, ATI 5770/1GB, 27" LED Cinema/Dell U2415: OS 10.11.6
Back to top
View user's profile Send private message    
Karl Ottenstein
Moderator
Moderator

Joined: 28 Oct 2003
Posts: 7806
Location: Bozeman, Montana USA

PostPosted: Wed Apr 08, 2009 7:11 pm    Post subject: Re: Attribute Management Reply with quote

You can export some or all attributes as a tab-delimited text file via the "Print to File" button in Attribute Manager (screenshot).

The saved files can then be compared using a file difference program. On Macs, diff and sdiff, for example, are built-in and available under Terminal. The tricky part is that the text "in use" preceded by a tab will appear for any attributes that are in use in the file from which you exported from AM ... and will cause otherwise matching attributes to look like they are not the same...



Save txt.png
 Description:
 Filesize:  71.36 KB
 Viewed:  748 Time(s)

Save txt.png



_________________
AC 20 US, Artlantis 5, Adobe CS 6, Piranesi 6, Final Cut Pro X, etc.
8 Core 2.8 Mac Pro/12GB RAM, SSD, ATI 5770/1GB, 27" LED Cinema/Dell U2415: OS 10.11.6
Back to top
View user's profile Send private message    
Karl Ottenstein
Moderator
Moderator

Joined: 28 Oct 2003
Posts: 7806
Location: Bozeman, Montana USA

PostPosted: Wed Apr 08, 2009 7:15 pm    Post subject: Re: Attribute Management Reply with quote

For example, I saved two files - materials1.txt and materials2.txt from two different templates. I opened Terminal into the folder containing the two files and typed: diff materials1.txt materials2.txt and obtained what follows here. Where a line begins with "<" it means that that line is uniquely in the first (left) file. Where "> the line is from the second (right) file.

The initial lines are in pairs - the materials are the same in both files - but in one or the other the material is "in use". So, we just need to strip off that text in order to find which materials actually differ between the two files...

12c12
< 9 07 | Asphalt Shingle 132 132 132 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Roof 12:Roof Tiles 12:Shingle Asphalt alpha.png
---
> 9 07 | Asphalt Shingle 132 132 132 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Roof 12:Roof Tiles 12:Shingle Asphalt alpha.png in use
33c33
< 30 32 | Grass Green 0 64 0 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Landscape 12:Grass 12:Grass Green alpha.png
---
> 30 32 | Grass Green 0 64 0 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Landscape 12:Grass 12:Grass Green alpha.png in use
36c36
< 33 32 | Earth 148 104 75 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Flooring 12:Hard Surfaces 12:Earth alpha.png
---
> 33 32 | Earth 148 104 75 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Flooring 12:Hard Surfaces 12:Earth alpha.png in use
53c53
< 50 00 | Default Walls-Ext 225 214 187
---
> 50 00 | Default Walls-Ext 225 214 187 in use
60,61c60,61
< 57 09 | W Boards Maple 03" Ureth 171 119 55 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Flooring 12:Parquet 12:Wood Flooring.png in use
< 58 09 | Paint-01 Ceiling White 255 255 255
---
> 57 09 | W Boards Maple 03" Ureth 171 119 55 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Flooring 12:Parquet 12:Wood Flooring.png
> 58 09 | Paint-01 Ceiling White 255 255 255 in use
71c71
< 68 00 | Default Walls-Int 248 243 235
---
> 68 00 | Default Walls-Int 248 243 235 in use
93c93
< 90 32 | Asphalt Dark 46 46 46 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Flooring 12:Hard Surfaces 12:Asphalt alpha 2.png
---
> 90 32 | Asphalt Dark 46 46 46 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Flooring 12:Hard Surfaces 12:Asphalt alpha 2.png in use
125,141d124
< 122 Corner Boards 145 107 70 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Wood 12:Mahogany.jpg
< 123 Driveway 192 192 192 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Wall Finishes 12:Concrete 12:Concrete.JPG
< 124 Floor Finish Int 227 142 91 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Flooring 12:Parquet 12:Floorboards 2.jpg in use
< 125 Lake Water 173 210 201 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Landscape 12:Water 12:Water4.png
< 126 Roof 168 147 96 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Roof 12:Roof Tiles 12:Terracotta shingle.png in use
< 127 Roof Fascia 132 98 60 in use
< 128 Roof Soffit 133 95 52 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Wood 12:Wood 3.jpg in use
< 129 Stone Veneer 128 128 128 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Cultured Stones 12:CStone 44.JPG in use
< 130 Walls Concrete 168 169 158 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Wall Finishes 12:Concrete 12:Poured concrete.jpg
< 131 Walls Ext Siding 243 240 226 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Wall Finishes 12:Siding 12:Light siding.jpg
< 132 32 | Better Grass Green 0 64 0 Macintosh HD:Users:karl:Documents:Archispectives:AC Projects:Office Lib 12:Textures:grass_big_03.jpg in use
< 133 Walls Exterior 254 248 226 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Wall Finishes 12:Render 12:Stucco.png in use
< 134 Walls Interior 255 255 255 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Wall Finishes 12:Render 12:Stucco.png in use
< 135 Window Trim 133 95 52 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Wood 12:Walnut.jpg
< 136 Beams 155 113 55 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Wood 12:Mahogany.jpg
< 137 09 | Wd-Pine 244 206 136 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Wood 12:Wood Grain pine alpha.png in use
< 138 32 | Earth scaleable 148 104 75 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Flooring 12:Hard Surfaces 12:Earth alpha.png in use

_________________
AC 20 US, Artlantis 5, Adobe CS 6, Piranesi 6, Final Cut Pro X, etc.
8 Core 2.8 Mac Pro/12GB RAM, SSD, ATI 5770/1GB, 27" LED Cinema/Dell U2415: OS 10.11.6
Back to top
View user's profile Send private message    
Karl Ottenstein
Moderator
Moderator

Joined: 28 Oct 2003
Posts: 7806
Location: Bozeman, Montana USA

PostPosted: Wed Apr 08, 2009 7:24 pm    Post subject: Re: Attribute Management Reply with quote

You could manually strip out the "[tab]in use" even in Word or Textedit, but if this is something you'll do all the time, it would be better to write (or if someone here donates) a script that strips that and does that comparison.

After stripping, for the example below, only the following lines show up via 'diff', showing the new materials assigned at ID's 122 and above in one of the two files.

Note that this method doesn't show any fill associated with the material, won't tell you if someone altered the LW settings, etc.

Cheers,
Karl

125,141d124
< 122 Corner Boards 145 107 70 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Wood 12:Mahogany.jpg
< 123 Driveway 192 192 192 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Wall Finishes 12:Concrete 12:Concrete.JPG
< 124 Floor Finish Int 227 142 91 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Flooring 12:Parquet 12:Floorboards 2.jpg
< 125 Lake Water 173 210 201 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Landscape 12:Water 12:Water4.png
< 126 Roof 168 147 96 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Roof 12:Roof Tiles 12:Terracotta shingle.png
< 127 Roof Fascia 132 98 60
< 128 Roof Soffit 133 95 52 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Wood 12:Wood 3.jpg
< 129 Stone Veneer 128 128 128 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Cultured Stones 12:CStone 44.JPG
< 130 Walls Concrete 168 169 158 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Wall Finishes 12:Concrete 12:Poured concrete.jpg
< 131 Walls Ext Siding 243 240 226 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Wall Finishes 12:Siding 12:Light siding.jpg
< 132 32 | Better Grass Green 0 64 0 Macintosh HD:Users:karl:Documents:Archispectives:AC Projects:Office Lib 12:Textures:grass_big_03.jpg
< 133 Walls Exterior 254 248 226 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Wall Finishes 12:Render 12:Stucco.png
< 134 Walls Interior 255 255 255 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Wall Finishes 12:Render 12:Stucco.png
< 135 Window Trim 133 95 52 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Wood 12:Walnut.jpg
< 136 Beams 155 113 55 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Wood 12:Mahogany.jpg
< 137 09 | Wd-Pine 244 206 136 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Wood 12:Wood Grain pine alpha.png
< 138 32 | Earth scaleable 148 104 75 Macintosh HD:Applications:Graphisoft:ArchiCAD 12:ArchiCAD Library 12:[TImg] Textures 12:Flooring 12:Hard Surfaces 12:Earth alpha.png

_________________
AC 20 US, Artlantis 5, Adobe CS 6, Piranesi 6, Final Cut Pro X, etc.
8 Core 2.8 Mac Pro/12GB RAM, SSD, ATI 5770/1GB, 27" LED Cinema/Dell U2415: OS 10.11.6
Back to top
View user's profile Send private message    
Karl Ottenstein
Moderator
Moderator

Joined: 28 Oct 2003
Posts: 7806
Location: Bozeman, Montana USA

PostPosted: Wed Apr 08, 2009 7:30 pm    Post subject: Re: Attribute Management Reply with quote

You get more information (at least for materials - did not check other attributes) by enabling the Calculate menu commands and opening the Query window and entering "select * from materials" as seen in the attached screenshot...


query.png
 Description:
 Filesize:  9.75 KB
 Viewed:  13282 Time(s)

query.png



_________________
AC 20 US, Artlantis 5, Adobe CS 6, Piranesi 6, Final Cut Pro X, etc.
8 Core 2.8 Mac Pro/12GB RAM, SSD, ATI 5770/1GB, 27" LED Cinema/Dell U2415: OS 10.11.6
Back to top
View user's profile Send private message    
Karl Ottenstein
Moderator
Moderator

Joined: 28 Oct 2003
Posts: 7806
Location: Bozeman, Montana USA

PostPosted: Wed Apr 08, 2009 7:36 pm    Post subject: Re: Attribute Management Reply with quote

The result will appear in your browser. Sample attached here to see the additional data fields that would be compared, letting you know if some standard material was modified when you do a comparision.

Coordinating attributes is a big issue, and there should be an easier way than just visually comparing in Attribute Manager, or going through the hoops that I've listed.

Cheers,
Karl



Result recordset of a SQL query executed on ACDB.zip
 Description:
An HTML file with the output of the query - forum doesn't allow posting of html files, so that's why it is zipped here.

Download
 Filename:  Result recordset of a SQL query executed on ACDB.zip
 Filesize:  6.28 KB
 Downloaded:  692 Time(s)


_________________
AC 20 US, Artlantis 5, Adobe CS 6, Piranesi 6, Final Cut Pro X, etc.
8 Core 2.8 Mac Pro/12GB RAM, SSD, ATI 5770/1GB, 27" LED Cinema/Dell U2415: OS 10.11.6
Back to top
View user's profile Send private message    
Karl Ottenstein
Moderator
Moderator

Joined: 28 Oct 2003
Posts: 7806
Location: Bozeman, Montana USA

PostPosted: Wed Apr 08, 2009 10:49 pm    Post subject: Re: Attribute Management Reply with quote

Took a break to do a search on MacUpdate and found this free visual diff utility:

http://www.macupdate.com/info.php/id/25426/diffmerge

Much more attractive than working in Terminal. (There are similar utilities for Windows users.)

Attached is a screenshot of comparing the files exported from Attribute Manager. I like that the " in use" bits are highlighted, making it easy to see that they don't matter without stripping them out.

Karl



DiffMerge.png
 Description:
 Filesize:  149.03 KB
 Viewed:  782 Time(s)

DiffMerge.png



_________________
AC 20 US, Artlantis 5, Adobe CS 6, Piranesi 6, Final Cut Pro X, etc.
8 Core 2.8 Mac Pro/12GB RAM, SSD, ATI 5770/1GB, 27" LED Cinema/Dell U2415: OS 10.11.6
Back to top
View user's profile Send private message    
Rob
Veteran member
Veteran member

Joined: 29 Oct 2003
Posts: 953
Location: London, UK

PostPosted: Thu Apr 09, 2009 2:25 am    Post subject: Re: Attribute Management Reply with quote

Karl,

Rolling Eyes OMG you went on a real nerdy rampage here Wink

_________________
Robert Kalocay

AC19 UKI
iMac 27"::i7Quad::20GB::OSX10.11
Back to top
View user's profile Send private message    
Karl Ottenstein
Moderator
Moderator

Joined: 28 Oct 2003
Posts: 7806
Location: Bozeman, Montana USA

PostPosted: Thu Apr 09, 2009 4:44 am    Post subject: Re: Attribute Management Reply with quote

Rob wrote:
Rolling Eyes OMG you went on a real nerdy rampage here Wink


Once a nerd, always a nerd. Rolling Eyes Laughing

_________________
AC 20 US, Artlantis 5, Adobe CS 6, Piranesi 6, Final Cut Pro X, etc.
8 Core 2.8 Mac Pro/12GB RAM, SSD, ATI 5770/1GB, 27" LED Cinema/Dell U2415: OS 10.11.6
Back to top
View user's profile Send private message    
Display posts from previous:   
View previous topic :: View next topic
Post new topic   Reply to topic   printer-friendly view       ArchiCAD-Talk Forum Index >>> BIM Managers >>> Attribute Management All times are GMT + 1 Hour
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB 2001, 2005 phpBB Group
Copyright 2012 - Graphisoft SE. All rights reserved worldwide. Terms of Use | Privacy Policy