AutoLISP and ERP software, specifically Syteline

[Bhull1985]

Hello.

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.

 

 

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 very much!

[BIGAL]

What is syteline can you provide more info, you can write a bubble sort routine say using VBA via excel or Autocad the code is readily available I did one in lisp. 80,000 items maybe throw into Access it can handle this type of number then sort.

 

You have only really given half the question need detail on data set.

[Bhull1985]

Thanks BIGAL for the reply.

I hope you're doing well.

 

 

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 copy straight out of syteline.

 

 

Each manufacturing plant and headquarters has their own database. This has created some problems- mainly overlapping ones. 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.

 

 

Yes, 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.

 

 

Thanks again