The Hamma Posted September 1, 2020 Share Posted September 1, 2020 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? Quote Link to comment
Pat Stanford Posted September 2, 2020 Share Posted September 2, 2020 Unless this is time critical right now, you might want to put this on the back burner for a few weeks. Quote Link to comment
SamIWas Posted September 12, 2020 Share Posted September 12, 2020 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. Quote Link to comment
SamIWas Posted September 12, 2020 Share Posted September 12, 2020 (edited) 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 September 12, 2020 by SamIWas 1 Quote Link to comment
mjm Posted September 12, 2020 Share Posted September 12, 2020 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… Quote Link to comment
SamIWas Posted September 12, 2020 Share Posted September 12, 2020 1 hour ago, Hans-Olav said: I just want FileMaker connection. I don’t even have excel. Quote Link to comment
rDesign Posted September 13, 2020 Share Posted September 13, 2020 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. Quote Link to comment
SamIWas Posted September 13, 2020 Share Posted September 13, 2020 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. 3 Quote Link to comment
ernbod Posted October 8, 2020 Share Posted October 8, 2020 If Vw is using Filemaker for the Plant database model, why is it so difficult/Impossible to make it work for any other DATA? Quote Link to comment
Maury Jensen Posted Sunday at 06:08 PM Share Posted Sunday at 06:08 PM @The Hamma Did you ever get a solution for this? I'm needing to do the exact same thing you described in this post, but have not been able to find the right solution. Thanks. Quote Link to comment
The Hamma Posted Monday at 07:18 PM Author Share Posted Monday at 07:18 PM On 3/24/2024 at 1:08 PM, Maury Jensen said: Did you ever get a solution for this? I'm needing to do the exact same thing you described in this post, but have not been able to find the right solution. Sorry I gave up on this. Quote Link to comment
Recommended Posts
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.