To load CSV file to landmark business class through IPA

Hi ,

I have following requirement . I need to create CSV file and store in a Business class. I have defined new field as Binary object. But i don know how to load the CSV file to the binary object field.

I tried this below,

1) Create CSV file with the data (test.csv)

2) Created reference file-HROrganization.csv for the business class HROrganization with the following data

HROrganization,Document
100,test.csv

3) I ran dbupdatelobs using system command node. - The node is not working..

Please let me know if you have any other options

Thanks

Find more posts tagged with

Process Automation (IPA) - General Discussions

Accepted answers

All comments

unknown

Have you tried using a Data Iterator node to read the CSV file and a Landmark Transaction node to update the business class?

unknown

Yes.. But the file created is text file . I need CSV as output file format.

john-miller

If you would like the actual .lpd file for this example, I can send it.
To upload a Local File to a Business Class, you will need to use the Landmark Transaction Node and the Following Fields need to be filled in as well as the Key Fields:

Attachment.File="file://C:Temp/HROrganization.csv" & Attachment.MimeType="text/csv" & Attachment.Title="HROrganization"

Attachment.File is the actual Binary Field

unknown

Thanks Miller, I tried this way.. But in the application, when I browse the field, file is opening as text file.. The file opened for you is Text or CSV.. Also it would be grateful if you send the .lpd file

john-miller

Technically speaking a .csv file is a text file, and should open in whatever application you have set as the default application for .csv type files. Post your email address and I'll send a .lpd with the upload.

unknown

lavanyamcet@gmail.com is the email I'd.. Thanks a lot.. I ll try with..

unknown

@john-miller , Can you please send the IPD file to mail id - lavanyamcet@gmail.com. . Thanks for your time

0811130630195911.xls

Copyright © 2025 Infor. All rights reserved.