Solved

Can you create an Output channel in IFS that will open File Explorer, and allow you to save a file without having to open it in an application (like Excel) first?

  • 9 January 2020
  • 5 replies
  • 1354 views
Joy
Rank
Userlevel 3
Badge +8
  • Joy
  • Sidekick (Customer)
  • 31 replies

I have a user that is trying to export query data from IFS, a large amount of query data, and he just needs the flat file (.csv). His Output channel is exporting the .csv file to Excel and trying to auto-open, and the export is taking a very long time - due to the many rows of data being downloaded to Excel. The user does not need to view this info in Excel, so is there a way to create an Output channel where it will just allow you to save the flat file to a local file folder without having to open in an application first?

icon

Best answer by Rusiru Dharmadasa 13 January 2020, 12:40

View original

5 replies

Joy
Rank
Userlevel 3
Badge +8

I believe I just answered my own question - and it is easy, and I can’t believe I overlooked it… 

 

If you select “save as” in the Output window, it will open the file explorer, where you can choose the file type and save to a local destination, 

 

I will have my user try this and see if it speeds up the process. 

Rusiru Dharmadasa
Rank
Userlevel 7
Badge +19

Hi Joy,

 

Output channel’s export to excel functionality is not expected to use when there are large amount of rows. It can take hours to complete. A better option would be to write a new SQL quick report for your query and then use the RMB → Export to excel. 

 

 

This will not have an option to “save as”. It will directly open the excel file. But excel can open huge files without taking much time as in your case. So its better to give it a try.

Rusiru
Joy
Rank
Userlevel 3
Badge +8

Rusiru, 

Thank you for your response! Yes, we ultimately ended up creating a Quick Report, which reduced the export drastically. The “Save -As” from the output area did not speed up the export, even though it was not trying to provide a view copy on screen in Excel. 

The Quick Report opened/exported in a matter of just a couple minutes, rather than hours.

R
Rank
Userlevel 2
Badge +6

if its a regular report, you could schedule the report, this will give you the option of running the report possibly out of hours if its resource intensive.

Under the settings there is the option to either email the the report or create a document in document management, this file can then just be opened instantly like any normal docman attachment.

 

 

https://www.linkedin.com/in/erppm/
Joy
Rank
Userlevel 3
Badge +8

Thank you, @richardwoods !

Reply


Terms & ConditionsCookie settings