Solved

Creating CSV files when printing Invoices in IFSAPP8

  • 30 November 2021
  • 3 replies
  • 211 views

Userlevel 2
Badge +7

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.

 

icon

Best answer by dsj 6 December 2021, 15:01

View original

3 replies

Userlevel 7
Badge +31

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.

Introduction to Report Plugins:

https://docs.ifs.com/techdocs/foundation1/010_overview/250_operational_reporting/210_report_plugins/default.htm

Development of Report Plugins:

http://ifstechdocs10.azurewebsites.net/foundation1/050_development/025_operational_reporting/190_using_report_plugins/

How to use the CSV Plugin:

http://ifstechdocs10.azurewebsites.net/foundation1/050_development/025_operational_reporting/190_using_report_plugins/010_csv_plugin/

Manage Plugin Reports:

http://ifstechdocs10.azurewebsites.net/foundation1/050_development/025_operational_reporting/190_using_report_plugins/005_manage_plugin/default.htm

 

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!

Userlevel 2
Badge +7

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.

Userlevel 7
Badge +20

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.

 

Hope it will be useful!

Damith

 

 

Reply