Automating parts, where to start?
Automating parts, where to start?
(OP)
Alright, I am looking for answers at the 30,000 feet level (aka no lines of code!).
Here is what I am trying to do. We have a basic part, different styles of window grids. Each style of grid fits in infinite different sized windows. The goal is to be able to take customer data on the window size and their requested grid style and give them a visual on what the combination will look like (either a print or a web based viewer). Each grid style has a master part file (made up mostly of weldments) and master print. The data can be taken directly out of our order entry system (stored in a database).
I am an engineer, only basic knowledge of programming. I have access to a programmer, but he does not know much about SW.
My question is where to start, Macro's, API, VB, Design Tables, etc? What should I focus on to get this job done? Anyone have similar examples that don't involve 30,000 part assemblies (God bless you guys...)?
It seems so simple, but I am kind of stuck on where to go now that I have the models done.
Thanks!
Joe
Here is what I am trying to do. We have a basic part, different styles of window grids. Each style of grid fits in infinite different sized windows. The goal is to be able to take customer data on the window size and their requested grid style and give them a visual on what the combination will look like (either a print or a web based viewer). Each grid style has a master part file (made up mostly of weldments) and master print. The data can be taken directly out of our order entry system (stored in a database).
I am an engineer, only basic knowledge of programming. I have access to a programmer, but he does not know much about SW.
My question is where to start, Macro's, API, VB, Design Tables, etc? What should I focus on to get this job done? Anyone have similar examples that don't involve 30,000 part assemblies (God bless you guys...)?
It seems so simple, but I am kind of stuck on where to go now that I have the models done.
Thanks!
Joe






RE: Automating parts, where to start?
Chris
Systems Analyst, I.S.
SolidWorks/PDMWorks 05
AutoCAD 06
ctopher's home site (updated 06-21-05)
FAQ559-1100
FAQ559-716
RE: Automating parts, where to start?
So we just need to input window size data and use the style number to call up the appropriate template. At that point the model should update to the new data (window size and custom grid locations if applicable), and create a print. I would assume that I would also save both files (part and drawing) to a unigue file name (order number or something like that.
Does that help?
Thanks
joe
RE: Automating parts, where to start?
I would use config's and DT's. Create basic model templates for each style and DT's to change the # of grids and sizes.
Chris
Systems Analyst, I.S.
SolidWorks/PDMWorks 05
AutoCAD 06
ctopher's home site (updated 06-21-05)
FAQ559-1100
FAQ559-716
RE: Automating parts, where to start?
Joe
RE: Automating parts, where to start?
I would create a macro to auto save to eDrawings and send. There may be a macro already created to download.
Chris
Systems Analyst, I.S.
SolidWorks/PDMWorks 05
AutoCAD 06
ctopher's home site (updated 06-21-05)
FAQ559-1100
FAQ559-716
RE: Automating parts, where to start?
Helpful SW websites FAQ559-520
How to get answers to your SW questions FAQ559-1091
RE: Automating parts, where to start?
http:/
Helpful SW websites FAQ559-520
How to get answers to your SW questions FAQ559-1091
RE: Automating parts, where to start?
I like the macro to save the edrawing, that is the kind of stuff I am looking for.
Thanks,
Joe
RE: Automating parts, where to start?
It might be a bit overkill for what we are doing. I think what I am trying to do is pretty simple, I just need the right direction.
thanks
Joe
RE: Automating parts, where to start?
Rob Rodriguez CSWP
President: Northern
Vermont SolidWorks User Group
www.robrodriguez.com (updated 2/22/06)
SW 2006 SP 3.0
RE: Automating parts, where to start?
Rob, If I use a macro to prompt the input, I will need a seat of SW for each of my customer service people, correct? (or at least a shared seat)
I think I am looking to take the data from the existing database and build the models and save off the prints. I will work on a user interface later. Would this just require a VB program to go out and grab the data out of the database and dump it into a design table? At that point fire a macro that will save the edrawing under a specific name?
It all seems so simple until I try to do it!
Thanks
Joe
RE: Automating parts, where to start?
Chris
Systems Analyst, I.S.
SolidWorks/PDMWorks 05
AutoCAD 06
ctopher's home site (updated 06-21-05)
FAQ559-1100
FAQ559-716
RE: Automating parts, where to start?
At this point, yes you are correct. I would like to do a web based project down the road, but at this point I just want to take existing data and create a picture.
Thanks for simplifying it!
Joe
RE: Automating parts, where to start?
Your design table will be set up in Excel (I assume) so all you really need is some sort of programming to extract the data and populate the correct design table cells. ThenSW will do the rest of the work for you as far as creating configurations. Yo umay have to creat the drawings manually?? Not sure. it may also be possibel to do this and the e-drawings with a macro. SolidWorks Task Scheduler might be able to help you here.
I'm not sure I can give you the exact steps to achieve your goal but I see no reason why you couldn't make this work.
Rob Rodriguez CSWP
President: Northern
Vermont SolidWorks User Group
www.robrodriguez.com (updated 2/22/06)
SW 2006 SP 3.0
RE: Automating parts, where to start?
Why not use the SQL query to populate the DT? It was pretty simple idea at the start. The grid formula is in the DT and the query would trigger the VB parser to sort units by grid code them open ech different grid part then create the units,as configurations, for that pattern. It would next trigger the SW macro to open drawing, print, and pdf the unit then after all configs are processed exit the part and move on to the next. This way the query results for each schedule can be archived as a text file and the DT or drive works database wont end up with 1,000,000 entries after 4 months. This is simply create a list sorting be pattern then populating a few DT Rows. For the instances you do not use custom locations or where VP1 = 0 ir is blank just point to you standard calucaltions row i.e. =d:5