Creating CSV files when printing Invoices in IFSAPP8
Hi IFS Community,
Can anyone help me out with a little job I have, please?
I need to create a CSV file on printing a certain type of invoice within IFS. I have seen that there are various places where files can be created and placed on the appropriate DB server. These seem to be scheduled Data Migration jobs but I want to do something based on the printing of the invoice. How can I do this? Maybe using Routing Rules might be an answer?
I’m sure that there must be a simple approach to solving this but I don’t know it, yet .
Can anyone point me in the right direction, please?
Cheers,
Neil.
Page 1 / 1
Hi @Neil Guild,
You can use the CSV report plug-in for this. You just need to create a layout for the report using the CSV plug-in. You can find instructions on how to do this in Foundation1 documentation.
The first link I have mentioned below has links to all the other resources you need. Just putting the rest of the links for your convenience.
Edit: Just realized you are on IFSAPP8. What you need to do is pretty similar, but it would be better to look up the equivalent documentation for IFSAPP8 in your Foundation1 documentation. For instance, the plug-in name and some other parameters could be a little different.
Hope this helps!
Thanks for your suggestion @Charith Epitawatta :-).
I haven't had time to test anything out yet, having been diverted onto a different LIVE problem!
Cheers,
Neil.
Hi @Neil Guild@Charith Epitawatta
Here’s the path in Apps8 F1doc for report plugin development
Another way to achieve your requirement is using IFS Connect. In order for report to route to IFS Connect, you need to use IFS predefined logical printer SEND_XML_TO_CONNECT or SEND_FULL_XML_TO_CONNECT when printing the report.
This will send the report XML to IFS Connect framework which then can send to a desired destination using outbound routing rules and routing address.
For creating the CSV: You can create a java transformer which could convert the report XML into a CSV output.