I am needing a bit of guidance on getting the service connect workflow function to create a simple pipe delimited file that contains the header, invoice lines and a end terminator line. I seem to have been going around in circles.
I have tried using the csv2xml conversion as well as the csv append converter, but am only getting one line (the header) of data in the resultant file. I have tried various iterations of the xsd, but to no avail. I am assuming now that I need to build the file with multiple conversions for each part of the document instead of trying to map the schema from the EDI output file of the ARForm report.
I am interested in how others have done this with service connect or am I just wasting my time.
If anyone has any simple examples to point me in the right direction I would appreciate it.
I know I can create the file with a BPM straight up, (thanks @Randy) but I want to use the SFTP functionality in service connect to give a complete solution instead of having to use a SFTP client to send the files.
Basically we are trying to achieve EDI, but our requirements at this stage (one customer) do not call for the cost of Tie Kinetix.
It seems to me that I would have thought Service Connect to be the correct tool for this sort of thing, but as others have mentioned lack clear simple information is the bit that is missing from making it a really good tool.
Any assistance appreciated.