Hi All,
Reposting here in hopes of more eyes taking a look.
Sorry if you've seen this over at cadtutor but here goes..
Has anyone seen any .lsp files that interact with an ERP software such as Syteline?
I know autolisp can interface with third party softwares but a quick google search of "autolisp syteline" provides no lisp files for my interrogation.
Apparently there is a rather large mess that I was hoping to be of some assistance in dealing with. There are 5 sites each containing a database of 80,000+ items. Pulling these into autocad and running a sorting function on them would certainly be more efficient than a human attempting to decipher through the large number of items.
Syteline is an ERP software that we use to track our part numbers. What is in stock, projected completion dates for projects already opened, it also is the main home for our BoM descriptions. It'd be what program we would open if given "Vanepack" by an engineer- we'd then find the part number and give it a more descriptive well, description that we could clipboard copy straight out of syteline and into our BoM. This is the main drafting/design usage of syteline but Project Management as well as the Schedulers also use this software so it needs some cleaning up.
Each manufacturing plant and headquarters has their own syteline database, accessed by anyone from any plant. This has created some problems- mainly overlapping/redundancy issues. Without a part number all that we'd have to go on is the given description. So, a human without explicit knowledge of how the item is called in syteline may search for 2" SEAMLESS (pipe) when the item is actually in the database as 2" SMLS. So they don't find it, and go and create a new part number in the database for the redundant pipe. That's why I am sure some sort of comparing and sorting is going to be required in this project.
Microsoft Access is the most logical software to use, for the boss here has an excel spreadsheet with all of the items from one site..and it's very slow to open or modify. Definitely access would be the way to go. I was hoping autoCAD could contain the data, use lisp to do all of the sorting, then push it all into access. I've a working acad->excel software and knowledge to modify it for most needs but I don't know how handy that would be for this particular task.
Good thing is, there's no rush. The lead engineer here wants to take some steps in 2015 to rectify the databases of their errors...so I'll be getting with him after the new year just hoping to have something tangible or at least a concrete idea that is in works by then.
I can delve into this a bit further but I wanted to get this up here in the hopes that someone already has a working lisp file for me to take a look at.
Thanks a bunch Swampers and happppppy new years!