Jump to content

Import Text Database


Recommended Posts

Hi, you have a Callout tool and General Notes tool that uses text databases. So how do I get my existing text databases from other CAD programs into the Vectorworks databases to use? I haven't tried any way as I can't find any instructions on how to do that and what format it needs. Hence the question.

Link to comment

So I had a file of keynotes and everything in the file was previously separated by Tabs. 

Like so 

image.png.4c37f42c887cf9caaadb287e15da032f.png 

 

I created an excel by importing the file in as a tab delimited file to create this

image.png.8bb7254479e1374e55ac5fb87726a3a1.png

 

Then I added two columns in front of the text and copied the section header into column B like so.

image.thumb.png.831a9a42b1b87d1494e1696e65604a1e.png

 

We need to add a UUID to column A so I used a UUID generator site like https://www.uuidgenerator.net/version4

but it does not include the brackets, so I placed it in another excel file in the second column and added brackets to the first and third columns like so

image.png.c664496da15cd2b8de65ff57b9ef2783.png

Save that file as a tab delimited text file and delete all the tabs, then you can past it into column A of the other file like so. 

image.thumb.png.1ced9b9d5ff1e5ef0105235422f508cf.png

 

The rest of the steps are outlined in this video

 

 

  

Edited by The Hamma
  • Like 2
Link to comment

@The Hamma Thank you for the very clear explanation.

 

I would probably skip the Tab Delimited save step to get the brackets. I would probably add three column in the front and paste in the UUIDs to the first.

In the second I would put a formula of ="{"&A1&"}" replacing A1 with whatever cell has the UUID.

Select and Copy the concatenated formula and Paste Special, Paste Values. This could either be in a different column or directly on top of the data you just copied.

Delete the unneeded extra UUID columns and you are ready to export.

 

Or even easier, just create a custom format in Excel of {@} This will automatically put the brackets around whatever you put in the cell. Then you don't ever need any extra columns 🤦‍♂️

  • Like 2
Link to comment

So to be completely clear, the text file that is the database needs to include four columns.

 

Completely unique UUID surrounded by curly brackets/braces

Section

Description

Note Text

 

Does it also need the NotesManagerDataFile text at the top and the 0    End of Notes text at the bottom?  Does it need the list of sections manually entered at the bottom or will that be created when you open the text file in the Notes Manager?

Link to comment

@PatStanford The {@} custom format works great.  Thanks for the tip.  

 

I forgot to mention once the database is created it is much quicker (in relation to file saves) to edit in Vectorworks as an XML format so I would save as XML format from the callout dialog and disregard the TXT format if you only intend to edit and delete callouts from Vectorworks. 

Link to comment
5 minutes ago, Pat Stanford said:

Completely unique UUID surrounded by curly brackets/braces

Section

Description

Note Text

Yes it does need this exactly as described

 

5 minutes ago, Pat Stanford said:

Does it also need the NotesManagerDataFile text at the top and the 0    End of Notes text at the bottom?

Just tested it and all that is need is the "NotesManagerDataFile" text at the top

 

11 minutes ago, Pat Stanford said:

Does it need the list of sections manually entered at the bottom or will that be created when you open the text file in the Notes Manager?

This is created by Vectorworks if the file is edited. 

Link to comment
  • 1 month later...

I have tried this per the steps above with the suggestions from Pat Stanford above and the added information is visible in the Notes.txt file yet when I open it in VW the new section does not appear in the list? Any thoughts on what I'm doing wrong.

 

My working theory is that as I'm working on a Mac that the numbers formatting may be interfering with the successful integration.

Link to comment
  • 1 year later...

As of July 2023 (VW SP6)

I want to share my solution for a problem when Database General Notes.txt or XML can not be located such as in this screenshot

 

 

Screenshot2023-07-25at1_11_11PM.thumb.jpg.b87fdba5adb99de2e3ab5d3927f860c3.jpg

 

 

 

The solution I finally found was to use a command: Text / Reconcile Notes... and then choose the current Database with .xml extension in my user Folder.

 

Before getting my final answer I spent hours and days reading on VW forum.

Thanks to David Hamer who helped me with UUID, but the solution was just to Reconcile Notes.

 

 

  • Like 3
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...