Parsing through a CSV Collection
yliquor
December 10th, 2008
I am trying to parse through a csv file. I have tried inputing into a collection (using the Add Items To a Collection component and inside that using the Read CSV to Dynamic Data compoent) then using the for each element in collection to parse through them. But All I get are numbers, when my data contains no numbers, only text.
Anybody have an example of how to read through a csv and pull out the actual values? I have been able to get it to give the data names, but not the values.....
TIA
Filed under: Endpoint Management and Virtualization
This can be accomplished
This can be accomplished through the Separated Value Generator integration library.
1. Create your integration library. i ran through the wizard using a little CSV file on my hard drive (C:\blah.csv)
2. In a webforms project, drag out and hook together the following components: Start->Read File->Dynamic ClassRead->Form Builder->End. NOTE: the DynamicClassRead comp is the "read" component generated in the integration library in the previous step.
3. Hook up your Read File component to access the CSV file. This will put a File datatype out on the stream, pointing to your appropriate CSV, needed by the next component.
4. Hook up your DynamicClassRead comp. Have it read in the file variable output in the previous step.
5. Hook up your Form Builder. Drag a grid out, and make it's data type to read the "DynamicClass" generated from the integration library. check the "Grid Data Is Array", and select the grid data to be the output of the DynamicClassRead component.
6. Run your flow, and data should be displayed.
I can provide more detailed info if contacted. Hope this helps.
Thanks!
Not quite what I was looking for, but your clue got me through it.. It works like I want it to now. Thanks a bunch!
Would you like to reply?
Login or Register to post your comment.