Lawson Integration

Sort:
You are not authorized to post a reply.
Author
Messages
Elam
New Member
Posts: 4
New Member

    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
    Veteran Member
    Posts: 47
    Veteran Member
      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
      Veteran Member
      Posts: 1498
      Veteran Member
        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.co...h-ge-centricity-dms/
        You are not authorized to post a reply.