Jump to content
The Hamma

Import spreadsheet data into vectorworks and assign to record format.

Recommended Posts

I have a spreadsheet with a list of equipment and each piece of equipment is identified with a unique id.  I also have symbols in the drawing with a record attached and a matching field for every column in the spread sheet.   I was able to create a report based on the record and I am able to copy cell by cell manually from the imported spread sheet to the record report worksheet.  My question is has anyone written a script that would search a worksheet for a matching id and copy all of the following cells in the row to the other worksheet?

Share this post


Link to post

Unless this is time critical right now, you might want to put this on the back burner for a few weeks.

Share this post


Link to post
On 9/1/2020 at 10:55 PM, Pat Stanford said:

Unless this is time critical right now, you might want to put this on the back burner for a few weeks.

 

Oh, well, that's just mean.  If there's some new great way of sending and receiving data from external sources (particularly Filemaker), I'm going to be quite a happy camper.

Share this post


Link to post
On 9/1/2020 at 5:54 PM, The Hamma said:

I have a spreadsheet with a list of equipment and each piece of equipment is identified with a unique id.  I also have symbols in the drawing with a record attached and a matching field for every column in the spread sheet.   I was able to create a report based on the record and I am able to copy cell by cell manually from the imported spread sheet to the record report worksheet.  My question is has anyone written a script that would search a worksheet for a matching id and copy all of the following cells in the row to the other worksheet?

 

Are you saying you have a spreadsheet outside of Vectorworks and want to import  that spreadsheet, match each line to a symbol, and apply the data from that spreadsheet to the symbols, filling the necessary record format(s)?  If so, yes.  I have dozens of scripts which do this.  Each symbol/lighting device/plug-in has a unique ID, and the script matches the data from each line to the symbol using that.

 

It's can get quite complicated.  The  basics are to use OPEN(filename) and then  create a loop to read each line and separate each cell into a variable. Find any symbol which matches the key variable, and SETRFIELD to apply the variables to the records fields.

Edited by SamIWas
  • Like 1

Share this post


Link to post
On 9/1/2020 at 9:03 PM, The Hamma said:

🤔😏

Well then, Not gonna say @Pat Stanford's reply is (maybe translucent?), but it does make me stop and think: 'hmmm, 2021 is just around the corner…

Share this post


Link to post
1 hour ago, Hans-Olav said:

 

I just want FileMaker connection. I don’t even have excel. 

Share this post


Link to post
1 hour ago, SamIWas said:

I just want FileMaker connection. I don’t even have excel. 


I believe that FileMaker can import from & export to Excel files, so presumably you could use this new 2021 Excel file functionality as the means to transfer data / records between Vw <—> FileMaker, without needing the MS Excel application itself. Just a hunch.

Share this post


Link to post
1 hour ago, rDesign said:


I believe that FileMaker can import from & export to Excel files, so presumably you could use this new 2021 Excel file functionality as the means to transfer data / records between Vw <—> FileMaker, without needing the MS Excel application itself. Just a hunch.

 

Yeah, I already do that via text files.  It's just an extra step in the process.   I know that a direct, immediate, and automatically updating connection is possible with Filemaker via ODBC.  I've gotten it working briefly on small projects, but it is mind bogglingly difficult.  I'm hoping for VW and FM to work together to make a solution with easy, automatic connection between the two.  FM Is so powerful when it comes to tracking and reporting data.

  • Like 3

Share this post


Link to post

If Vw is using Filemaker for the Plant database model, why is it so difficult/Impossible to make it work for any other DATA?

Share this post


Link to post

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.


 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×
×
  • Create New...