• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Integration / Customization IPA/ProcessFlow

DataIterator login process

 6 Replies
 3 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
tambrosi
Veteran Member Send Private Message
Posts: 55
Veteran Member
2/11/2016 1:52 PM

Hi All,  hope somebody can help me out.   I am trying to under stand if we can use a generic login for use with the dataiterator.   We have a need to parse out a csv file that gets created from a Lawson job run.   

The file is sitting in the print directory on the LSF Server and the dataiterator needs to access it.  

The process is being run/tested on a work station in which the user is logged in with their own credentials, and they do not have access to the 

print directory on the LSF server.    They get a file not found error.   The file is there.  

I know I can ask our Windows security admin to grant access to the user(s), and that will work.   

But I am wondering if there a better way we should be going, using a generic login with using the dataiterator to access files.  

I looked around in the Info Rich admin area, but could not find a way to set a generic user/password.   Not sure we would use it that way, but I am trying to under stand how the process works.  

I hope I explained this clearly enough, we are new to the Lawson software and trying to get a good understanding of it. 

Thanks

Terry 

David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
2/11/2016 2:06 PM
The DataIterator would use the values in the main configuration - File Access setting - to read the files from LSF. As a best practice, however, you should use a FileAccess to read the file into IPA and then the Dataiterator to process the data from the FileAccess load.
David Williams
tambrosi
Veteran Member Send Private Message
Posts: 55
Veteran Member
2/11/2016 3:17 PM
Hi David, thanks for the info. That is what I thought it should be, but when I changed those params nothing really happened. When I use the syscommand 'whoami it returns user SYSTEM. I am wondering if this is todo with Server 2012 and how they do not use the RunAs as available in 2008.
If you do not mind, can I ask about the file access process, would you set that up in a For loop and process the records or am I missing something when you say the file into IPA, and then the Dataiterator to process the data from the FileAccess load.
Example, my file has about 1500 records on it and needs to be parsed out and then rewritten someplace adding some data.
I really appreciate the ideas and help.
Thanks
Terry
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
2/11/2016 3:46 PM
The idea otf using FileAccess to 'load' the file into IPA prevents multipe Open-Read-Close of a file that the DataItera performs when it processes a file. Load the file and then set the DataIterator to process the Data (instead of File) and set the source to be the FileAccess_outputData. So read the file into IPA and set the DI to process the data from that. It saves a lot of time.
David Williams
John Henley
Send Private Message
Posts: 3351
2/11/2016 3:51 PM
As David suggests, best practice is to use the FileAccess node to read a file into memory first, and then iterate over the variables created by the FileAccess node. This is especially important when reading files from LSF server and IPA is on a separate server. Otherwise, IPA will make a round-trip network access for each iteration.

As for defining the logins, you do that in Rich Client by defining them under 'File Access'. The default 'main' configuration will be used if one is not specified on the file access (and data iterator if using file data) unless one is specifically set on the node. I typically set up a configuration for both the Landmark and the LSF server in Rich Client and explicitly reference those configurations in the nodes.
Thanks for using the LawsonGuru.com forums!
John
tambrosi
Veteran Member Send Private Message
Posts: 55
Veteran Member
2/12/2016 11:03 AM
David and John, thanks for the info. I was very helpful and appreciated.!!!

Would you guys know if there are any good books about IPA that a person can use as a reference.

Thanks
Terry
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
2/12/2016 12:33 PM
As with most things Infor/Lawson, you have a user guide which can explain the basics but most knowledge comes from experience.
This forum is also the best I've seen on answering questions.
David Williams