Data extraction for use with Manufacturing

At the beginning of the year I am hoping to upgrade to Sage Manufactoring, JobOps, to help improve the efficiency of our end to end process as a metal job shop. Looking for options to extract data from thousands of cut files, as shown: material type, thickness, and bounding box size, to be printed on work tickets. Manually entering this information even one time into Sage for every part would be a massive undertaking. Any help getting this data extracted, consolidated and end goal of integrated with Sage???? Thanks!

SYMATRCAP1.pdf

SYMATRCAP2.pdf

  • 0

    I am currently using a demo of ReportMiner and it does exactly what I need as far as getting data from our parts files (had to make a txt format copy of some 28,000 part files. I have exhausted all options for software or trying to find someone to write a code to do this for us. Once it is set up the software will loop through an entire folder and export to excel. I am assuming that these steps are necessary to get the needed part information into Sage? I have two problems though. Firstly, the Enterprise version of ReportMiner is more annually than we would be looking to spend to own the software, making it not even a close possibility. Second, even if I can find different software or a programmer, how would I keep this data updated as new parts are added to the server?

  • 0 in reply to AlertMTL

    You need to determine whether or not you want each data element in its own UDFs or all of in concatenated into a Comment. A Comment would likely be easier up front since you wouldn't have to create a bunch of UDFs for the different data elements you have. If you only have a few data elements than it might not be too bad. 

    Since the data in the attached files look similar to XML, you could give either Crystal Reports or a recent version of Excel a shot. Both can read XML and depending on the structure, you might be able to easily get the data into a row and column format that you can import into Sage 100 via Visual Integrator.

    For Excel, use this option to get data then point it to your XML document.

    For Crystal Reports, which if you have Sage 100 installed, you have a license to use Crystal Reports Designer but you may need to install it on your workstation using the Sage 100 Installer for the server (not the workstation) component. Once you have it installed, start a new blank report, when prompted for a database connection, expand the ADO.NET tree under Create New Connection and then double click Make New Connection and point it to your XML document.