Keynote Database Structure Archicad 28

[tonyyy]

Hi everyone,

I’m trying to import a keynote database into Archicad 28 using an Excel file using CSI Masterformat. While the keynotes import successfully, they don’t seem to nest correctly under the folders as intended.

I’ve read through Graphisoft’s guide on keynotes, but I’m still unsure about the exact structure the database needs to follow for the hierarchy to work properly.

Should the folders and keynotes be set up with specific identifiers, columns, or formatting in Excel to ensure nesting? Is it based on the 'Path' relationship or 'Reference' relationship defined in the column?

I’d appreciate it if someone could share a working example or clarify the steps to get the folder structure right!

Thanks in advance for your help!

Operating system used: Mac Apple Silicon Sequoia 15

[Ricardo Lopez · Accepted solution]

Hi @tonyyy 

Try to create a simple structure of Folders and Keynotes with different levels in Archicad and export it to xlsx format. Then you can open it in Excel and you will see the order of the columns and the hierarchy of the keynotes scheme (Type> Key> Title> Description> Reference> Path).

If there are several sublevels they do not need a extra header in the Excel file.

Check for duplicates and correct logic.

See the example below and the attached .xlsx file for reference.

[tonyyy]

Brilliant. Thank you, @Ricardo Lopez !