PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 06/05/2017 5:20 PM by  mthedford
How to use IPA to importdb
 15 Replies
Sort:
You are not authorized to post a reply.
Author Messages
JasonP
Programmer Analyst
PennState Hershey Medical Center
Advanced Member
(59 points)
Advanced Member
Posts:27


Send Message:

--
04/13/2016 9:51 AM
    Any ideas on how to run importdb via IPA?
    John Henley
    Private
    Private
    Senior Member
    (9638 points)
    Senior Member
    Posts:3230


    Send Message:

    --
    04/13/2016 9:59 AM
    You have to use a System Command node.
    Thanks for using the LawsonGuru.com forums!
    John
    Woozy
    Private
    Private
    Veteran Member
    (3487 points)
    Veteran Member
    Posts:707


    Send Message:

    --
    04/13/2016 10:02 AM
    Hi JasonP,

    You'd need to use a System Activity node to call importdb. Depending on the complexity of the process, it may be best to build a script to do it and then call the script using the system node.

    It is certainly possible to do this with IPA, but it's kind of clumsy. What are you trying to do that causes you to want to use importdb rather than a regular transaction node?

    Good Luck!
    Kelly
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    JasonP
    Programmer Analyst
    PennState Hershey Medical Center
    Advanced Member
    (59 points)
    Advanced Member
    Posts:27


    Send Message:

    --
    04/13/2016 12:24 PM
    We have like an imagenow system with custom forms gathering enough information to code an invoice.  The invoice is being manually created in ap20.  We would like to apcinvoice /apcdistrib importdb ap520 the data from the imagenow like system.  We are open to other ideas.
    JasonP
    Programmer Analyst
    PennState Hershey Medical Center
    Advanced Member
    (59 points)
    Advanced Member
    Posts:27


    Send Message:

    --
    04/13/2016 12:27 PM

    Im putting in an Infor ticket for this but just curious have you seen in a lawsontransaction call , ags call, where your security doesn't show you the available methods such as add inquire change delete, but inside of the regular screens, I have no problem doing an inquire. I think something is missing in security maybe table level access or something?

     

    I attached an example

    Attachments
    Shane Jones
    Private
    Private
    Veteran Member
    (1246 points)
    Veteran Member
    Posts:460


    Send Message:

    --
    04/14/2016 7:56 AM
    If you have the data pulled out of your other system in a csv file you could use the data iterator and an ap20 transaction node. You mention ap520 - if you can get the file in the format ap520 needs you could just run that job.

    I like using data iterator because I can collect all of the results and send anan email showing what was changed.
    Shane Jones
    Tools: HR, Payroll, Benefits, PFI, Smart Office, BSI, Portal and Self-Service
    Systems: Lawson, Open Hire, Kronos, Crystal Reporting, SumTotal Learning
    ** Teach others to fish...
    JasonP
    Programmer Analyst
    PennState Hershey Medical Center
    Advanced Member
    (59 points)
    Advanced Member
    Posts:27


    Send Message:

    --
    01/03/2017 3:12 PM

    So im now working on importing in GLTRANSREL.  Would you suggest an IPA that

    1) ftps file to unix, then sys command to importdb

    or

    2)a simple GL65 add transaction? what node would I use to parse the csv file into columns

     

    I like the importdb because its familiar and fast and I worry that 600 GL65 adds might for some reason crash.

     

    Woozy
    Private
    Private
    Veteran Member
    (3487 points)
    Veteran Member
    Posts:707


    Send Message:

    --
    01/03/2017 3:36 PM
    Hi JasonP - either option is possible.

    Someone can correct me if I'm wrong, but it seems to me that the important thing is to determine is whether you are confident enough in the source data to use importdb, since I believe this will "force" the data into the table and basically bypass the GL65 edits. I don't have any experience with GL65, so I don't know if it does anything else in the background. I also don't know if there is a batch import program equivalent to GL65 (GL165???) that could take a csv file as input and include the edits.

    If you choose to use the GL65 via an add transaction, you can parse the csv file with a data iterator node - probably actually two nested data iterators, one to iterate by line and the other by delimiter.

    Good Luck
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    John Henley
    Private
    Private
    Senior Member
    (9638 points)
    Senior Member
    Posts:3230


    Send Message:

    --
    01/03/2017 3:44 PM
    You can use importdb into GLTRANSREL, and then run GL165 to do the edits/updates.
    GL65 via AGS for 600 records is not unreasonable, but importdb will get you there quicker
    Thanks for using the LawsonGuru.com forums!
    John
    steve finger
    ICS - Senior Consultant
    Infor
    Advanced Member
    (94 points)
    Advanced Member
    Posts:32


    Send Message:

    --
    01/03/2017 6:52 PM

    The importdb does some basic data edits such as string length, number of decimal digits, adds a leading zero to numbers between -1 and 1, etc.  The GL165 will then futher validate your data.  Since i usually prepare the data in the first place, i have a high degree of confidence in the data viability and use importdb often in IPA

    alexrs
    Lawson Developer
    Private
    Basic Member
    (46 points)
    Basic Member
    Posts:16


    Send Message:

    --
    01/06/2017 8:51 AM
    We are currently creating a Process Flow to import records into the GLTRANSREL table. We are using WTX to map the fields from the flat file into the table.
    JasonP
    Programmer Analyst
    PennState Hershey Medical Center
    Advanced Member
    (59 points)
    Advanced Member
    Posts:27


    Send Message:

    --
    01/06/2017 10:34 AM
    What is WTX? 

    I did a proof of concept with a sys command node and it also will correctly hit the error path when for example I try to import headers.  Ill probably stick with the sys command, i cant bring myself to using Adds on gl65.

    alexrs
    Lawson Developer
    Private
    Basic Member
    (46 points)
    Basic Member
    Posts:16


    Send Message:

    --
    01/06/2017 12:10 PM
    WTX- Webspere Transformation Extender

     

    useful links:

    https://itlearnings.wordpress.com/2011/04/23/lawson-processflow-and-ibm-transformation-extender/

    https://lawson-lsaprod.hmc.hurleymc.com/help/index.jsp?topic=%2Fcom.lawson.help.developer%2Fcom.lawson.help.lpdug-uw_10.1.x%2FL27051243607073.html

     

    alexrs
    Lawson Developer
    Private
    Basic Member
    (46 points)
    Basic Member
    Posts:16


    Send Message:

    --
    01/06/2017 12:16 PM
    alexrs
    Lawson Developer
    Private
    Basic Member
    (46 points)
    Basic Member
    Posts:16


    Send Message:

    --
    01/09/2017 10:02 AM
    Just to clarify why. I use the Data Transformation (WTX approach), instead of the SysCommand because the flat file we receive is not a csv, but a fixed-width file. Hence, the need for mapping the fields.
    mthedford
    Lawson Systems Administration
    Torchmark Corporation
    Basic Member
    (21 points)
    Basic Member
    Posts:7


    Send Message:

    --
    06/05/2017 5:20 PM
    Lawson put out a new Delivered JOB/Token for Portal users to run the Importdb utility, it is called IMDBB. It has input parameters, so any method in which you are comfortable to use in IPA to update input parameters for a job will work for this job. Check out this Token. Since it is a Token, you may need to be granted access to it thru Lawson Security like any other Token. We use this with all of our GL interfaces.
    You are not authorized to post a reply.