Hi guys, thanks for al the support you give me enough input to start with my project. And yes Keans website "through the interface". is a very very good one. Thanks Kean and team.
Then about my graduation project.
My company builds electrical panels used to control Industrial production lines. For example production lines for building cars. My goal is to make a system in AutoCAD .NET to add article info to AutoCAD blocks from componenets which are mounted at the control panels.
A drawing in our company consist mainly out of 3 parts: Electrical scheme's, materiallist and panelview.
If you do a good job engineering the electrical scheme's it should be possible to generate the materiallists and panelview's and even generate orderlists.
I want to do this as follows.
We have an ERP-program in our company which uses a large database with article info. The fields from a record in this database are...Price info...article number, description, supplyer info etc. But none specific article info like size from the components, factoryname and types(specific engeering info). The ERP-program is build with FoxPro.
So at first I start with developing a windowsServer 2005 database. WindowsServer 2005 is lots faster then foxpro and foxpro isn't updated any more by Microsoft. In this database I copy the article-records from the ERP-database. Then it must be possible to add specific CAD-fields(like length, width and height, factoryname and type) from an article. Therefor I have to create a GUI in which a user can insert and update articles.. This is a none AutoCAD program and for this I use .NET 2005 and SQL-Server 2005.
If the database is ready I make an AutoCAD .NET C# application to add the info from the database to the blocks in the drawing. I want to do this with XRecords. I also want to create a dictionary in the NOD from AutoCAD in this dictionary I put data witch has a relatiion with the drawing in general. Like projectnumber and name.
As the this is done I want to make a GUI in which te user can select all the CAD-info from the block and then it must be possible to create a panellayout in AutoCAD a Materialllist exported to Excell and an orderlist ASCII for the ERP program to order the articles wich are neccesary fo build the panels.
I have already tested a lot of functions in AutoCAD and the connections with the databases thats work fine. But it is still a little exciting because like you programmers no you can never test everything and things always go wrong when and where you don't have expected this and there is a lot of time pressure at my graduation project.
Support and opinons are welcome.
Jobro
