Skip to Content
0
Former Member
Mar 26, 2008 at 05:07 AM

xMII File I/O Importing .CSV file and mapping to columns for querie

297 Views

Hi,

I am new to xMII and my first assignment is to import a .CSV file using file I/O in the BLS editor and then use that transaction as a data source for a Xacute query. I am able to import the file using the "Get File List", "Text Loader and "Text Saver" functions. After that I parse the file using the "Flat File Parser" function.

At this point I get stuck as I am trying to map the respective fields on the flat file delimited by commas, to their respective columns as identified in the Illuminator Doc.

Please advise as to how I can assign the data delimited by commas to their respective columns. I tried a "Repeater" action block with a "Row" action block that reference the Illuminator Doc but get an invalid Assignment Target error.

Any help will be greatly appreciated

Thanks!