#Insert rows in lightwrite software
#Insert rows in lightwrite code
#Insert rows in lightwrite trial

The production company PRG Hamburg got ODBC to work but only after scouring Europe. This has been the case with every program I have tried to hook up to Filemaker using ODBC. In fact getting ODBC to work is a hell of lot harder than scripting. This problem is unique and not appropriate to compare with plug-in object programming, such as the window object. The trick is constructing a user interface that will allow one to construct a custom connection with any other program that supports making such a connection. The window plug-in is part of Vectorworks and the orange in an apples to oranges comparison. That is what I like about this software, you can make it your own.

#Insert rows in lightwrite code

If that is not your thing, let someone else code it for you. Vectorscript or Python might be scary at first, but your investment of time will be earned back big time. It will cost you some time, but will save you much more in the end. People will help you if you end up stuck. Give it a go, you will find several resources on the web or on this forum to get you started. I spend a lot of time in getting an ODBC connection work once and have not touched it since. I don't think the instructions are hard, but the method is, certainly for people with less computer skills. While it is possible with Vectorworks, it's not easy to say the least.

#Insert rows in lightwrite software

I could give some examples, but I'm not here to advertise other software nor should we start such a discussion More easily than other CAD programs? I think so, but my familiarity is not that great. I would love to check out any examples you can point me to.Ĭurrently, VW seems to provide the most easily accessible tools for creating such a connection between CAD data and database data. I'm sure this is the future of personal computing, but I haven't seen it or heard of it. The 'this' being an easy way for an end user to set up a custom configured connection between two separately created and marketed programs to seemlessly share information. These are all using the same record format, but you could use any number and mixture of them. IF GetRField(h,'LED Ribbon','Position')='' THEN WRITE ('-') ELSE Write(GetRField(h,'LED Ribbon','Position')) Tab(1) IF GetRField(h,'LED Ribbon','Location')='' THEN WRITE ('-') ELSE Write(GetRField(h,'LED Ribbon','Location')) Tab(1) Write(GetRField(h,'LED Ribbon','ID')) Tab(1) They all use the calls Sam Jones specified above: I have a large number of scripts which import information out in tab-separated files for import into Filemaker. It amazes me how difficult it is to get that working.Īs for the OP, exporting all of your info should be a pretty simple script.

#Insert rows in lightwrite trial

I was successful like one time many years ago for a brief trial on one file. Not with Vectorscript, but just through their built-in options. I've been trying for more than a decade to get Vectorworks and Filemaker to talk using ODBC. You can also use ODBC to connect to databases either from VW directly or programmatically with vectorscript. I've also used C++ some 15 years ago, but hopefully would be able to get some c++ code working if I have the right entry points/examples.Ĭan anybody point me to a good example/starting point for this? I could sort out everything else on the server easily. If the files could be uploaded to the SQL-Server via FTP or maybe HTTP-POST or any other way, that would be even better. I can do the conversions I do manually (field names, factors.) by a little php script on the SQL-Server, but I need to automate the Vectorworks side. Ideally, I'd have eventually have a Button or menu option to click that exports all Objects from my drawings that have records attached including their layer and class information (ideally XYZ positions, too) and save them in one or more CSV files. This is too time-consuming and fault-likely and I'd like to automate at least most of the tasks involved. What I currently do is, that I manually create a bunch of worksheets (List 'objects with a record', but as the symbols have different records, I need to set up at least 6-8 sheets each time) and then export them as CSV files that I adjust manually and import them to our SQL database. I regularly need to make calculations based on symbol types and counts from VW drawings and import reports into a SQL database. Especially, I'm not sure if I need to dig into Vectorscript or if I'd have to use the SDK/C++ for this: I find it hard to figure out a starting point for a little tool I need.