I discovered this forum a couple of weeks ago and it already helped me with two issues that I had, just by browsing and searching the threads. Now however I am stumped so here is my issue:
We are using wMDeveloper 6.1 and IS 6.1 on a Windows 2000 server in conjunction with EnterpriseOne E8.12 and Web Services Gateway WSG from JDEdwards (Peoplesoft/Oracle) on an IBM i-series As400.
My current project involves taking all records of a table from E8.12 and importing the data using Developer so that soem of the records of the table can be sent to each of ten different locations whereby each location gets a different set of records. The value of the CustSearchType variable within the records dteremines whether the record gets sent to a location or not.
I have been testing this with six records right now.
I created an adapter service to bring the records from the E812 tbale into WSG into an IS document based on a flatfile schema I created. The IS document has a datawithnorecordID label. After initial problems I was able to succesfully convert the records to a string and then ftp the data out to the receiving test server.
What I am struggling with right now are the flow steps to select/filter the necessary records based on the CustSearchType value for each of the locations.
I created a LOOP step over /Data/recordwithnoid so that the flow goes through the records of the IS document one by one. I then created a BRACN step on /Data/recordwithnoid/custsearchtype and then a MAP step with the Label C35 so that only records with CustSearchType C35 get mapped. I mapped the records from /Data into /DataGFS which was created in the pipeline as a document reference to /Data. I mapped the /Data/recordwithnoid to /DataGFS/recordwithnoid and if there is only one record it works fine but if there are more that fit the criteria then the second records overwrites the first one and so one leaving me in the end just with the last record. It looks like /DataGFS only accepts one record that way. Any idea how I can get the multilpe records into /DataGFS?
A Secondary question would be if I have a location that only needs either C17 or C35 records can I do that in one MAP step. What would be the proper synthax on the label: C17|C35 or C17||C35. I can’t test this of course until I get my other problem resolved.
Thank you for your time.