How to use IPA to importdb

You have to use a System Command node.

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

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.

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

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.

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.

 

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

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

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

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.

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.

 

useful links:

https://itlearnings.wordp...sformation-extender/

https://lawson-lsaprod.hm...L27051243607073.html

 

Here's a tutorial on WTX:

http://www.ibm.com/develo..._vila/0712_vila.html

 

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.

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.