PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 04/02/2013 10:46 AM by  Greg Moeller
Lawson Integration
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Elam
Architect
Axway
New Member
(8 points)
New Member
Posts:4


Send Message:

--
03/04/2013 11:39 AM

    I would like to integrate Lawson System Foundation 9.0.1.8 and Lawson Application 9.0.1.6 to push the Contract file, Item Master file, Vendor Catalog file into Lawson system and retrieve Item Master, Invoice History, PO History, Vendor Master from Lawson System. Gurus please let me what is best way to develop a solution?

    Milo Tsukroff
    Private
    Private
    Veteran Member
    (117 points)
    Veteran Member
    Posts:43


    Send Message:

    --
    04/01/2013 11:17 AM
    Elam:

    I do not know if this is the "best way" but one solution is to write scripts that call the "importdb" and "rngdbdump" utilities.

    "importdb" moves data into Lawson tables, provided that the import files are properly set up, properly scrubbed to prevent bad data from entering, and, will not screw up relationships to other tables. I can't tell you off the top of my head what issues would come up, that will take you some study. Use the utility "dbdoc" to dump the table ("file") definitions for the various files, and check on the relationships.

    "rngdbdump" can dump a Lawson file in various ways to output csv files. Check on its functionality. Using indexes, it can dump specific ranges of data, and it can dump only specified fields if you want it to.

    I have written interfaces which work both ways, using those utilities. A more elegant method is to "importdb" into a specific import table, then finish the import by running the import program. Again, off the top of my head I don't know if there are such import pathways for Contract, Item Master, or Vendor Catalog. If there are, they should be used instead of a direct "importdb" into the actual tables used. One the other hand, "rngdbdump" has no impact on any working files, since it's essentially read-only.
    Greg Moeller
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    04/02/2013 10:46 AM
    For the Item Master export FROM Lawson, I can help. IC52x are some jobs that you should look at. Here we use a modified IC527 feed from Lawson out to Cerner's Surginet piece. If you'd like, I could share scripts.
    https://www.lawsonguru.com/forums/i...icity-dms/
    You are not authorized to post a reply.