Sajit re-sent me the file, so if anyone is interested in looking at it,
let me know.
Paul
Paul,
I wonder if you have had a look at the piping MTO database that I sent you? Please do when you have the time.
This is a system that I had done to use with the Shell MESC and the newer SAP material numbering. It can enter MTO, line wise and Isometric wise. Assemblies can also be entered. Which is exploded to its components. Report Summaries can be made line wise and Isometric wise. The isometric wise MTO can be exported to excel for placing on a manual CAD isometric.
I would like you to post this on the Pipingdesign.com as a downloadable. The internal logics are simple enough for someone with an understanding of a relational database. They can use it as a freeware and develop or modify it further to put additional features.
I am currently using the Intergraph Marian material management system. This one is based on the lines of the SAP system. It does material descriptions on a rule based method, Piping classes, material requistions, construction fabrication spooling, NDE tracking inventory management etc. It is also for the material take off and management for other disciplines.
This probably must be the reason that data is contained in about 1000 or more tables. So much so that the system is so complicated that the bugs and the other fixes that need to be done, Intergraph is reluctant to take up. There are various silly restrictions such as the number of characters that one enter for the description of an item.
In real terms if the task of doing the MTO and the material requisition and others were done manually. it is a simple enough to understand. Not so much complicated logics as this system would make it appear.
Sajit Viswan
Sr. Piping Engineer
Technip Paris
Received on Sun Nov 20 03:15:00 2005
This archive was generated by hypermail 2.1.8 : Tue Mar 04 2008 - 11:40:45 EST