Service Connect - Trying to process a file and only getting the

Yahoo Archive
1
You have to create two workflows. The first workflow simply loops thru your input file (e.g. ".csv" file), and sends one record at a time to a second workflow. This second workflow does your heavy lifting. When you create the input schema using the schema generator for the first workflow, be sure you have more than one record in your file. This will create a schema that recognizes multiple rows. The output schema of this main workflow will only be for a single record, and will be the same schema that starts off your sub-workflow. Simply configure your main workflow's call to loop thru the records.

Hope this helps.

Keith
2
Importing a file for customers. Inserts the first record, but how do I get the webservice to read multiple records. The file is all being brought into service connect, but I can not figure out how to get it to loop through the entire file. Any help on this simple task would be greatly appreciated.

Thanks.
3
You will need to use a sub-workflow to feed your current workflow one
line at a time.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of chagansonthelake
Sent: Wednesday, July 01, 2009 1:44 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Service Connect - Trying to process a file and only
getting the first record.








Importing a file for customers. Inserts the first record, but how do I
get the webservice to read multiple records. The file is all being
brought into service connect, but I can not figure out how to get it to
loop through the entire file. Any help on this simple task would be
greatly appreciated.

Thanks.





[Non-text portions of this message have been removed]
4
You need to pass the records into a subroutine and select cycling
execution in the properties.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of chagansonthelake
Sent: Wednesday, July 01, 2009 1:44 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Service Connect - Trying to process a file and only
getting the first record.





Importing a file for customers. Inserts the first record, but how do I
get the webservice to read multiple records. The file is all being
brought into service connect, but I can not figure out how to get it to
loop through the entire file. Any help on this simple task would be
greatly appreciated.

Thanks.





[Non-text portions of this message have been removed]