McFarland Chris

I do not autocreate the file.  The user just manually exports the result list to get the CSV.  Pretty manual, not very pretty in a lot of ways, but functional.  My handling is not an easy build, and next time I'm likely to check out Patrick's offering before i build another one of these myself.
 
 

That's great to know about the rhino docs integration.  I know Patrick pretty well.

In this case I built it myself.

The client provided a template CSV file and I built Autoindex routines to populate a dedicated file cabinet where I write the rows for the base invoice and the gl coding detail rows from the table field.

Then i use the sorting order for the result list to arrange and group the rows so that the CSV file that you get when you export the result list conforms to the provided sample.

Hello Everyone:

From my DocuWare Cloud V7.2  system I need to be able to, in whatever manner, get my AP Invoices pushed into Sage Timberline as a posted invoice.

While the Sage system will import flat flies that are properly constructed, my GL coding information will live in a table field so getting everything consolidated into a nice flat file seem like it would be quite a challenge.

Maybe a web service built into a workflow for this task to generate the flat file, but DocuWare claims a tight integration with Sage so I wonder if there's something slicker and maybe more modular that I could plug in.  I really can't find anything that gives specifics on what this tight integration is.

What do you think?

Thanks!

Chris McFarland