+2In Apps 10 there was an option to export data, including the output of quick reports, in various different formats. By default this included .xlsx, .xml and .txt (which would be formatted as a CSV) as well as there being a setting to enable more possibilities.
Is there similar functionality available in IFS cloud? When pressing the export button it does not give a choice and always exports as a .xlsx.
+23Hi
try the option ‘Output’ in the status bar. Then add a new output type.
For example.
With RMB on ‘Output’ in your quick report you can export it.
+2Hi
try the option ‘Output’ in the status bar. Then add a new output type.
For example.
With RMB on ‘Output’ in your quick report you can export it.
Hi
Unfortunately I was asking how to do the same thing in IFS Cloud rather than Apps10.
When we asked Operational Success IFS to investigate the possibility, in our case, of exporting to CSV in IFS Cloud, we received the following response:
We have reviewed your request regarding the export options in IFS Cloud. Based on our analysis and experience, we are unable to proceed with this from the OS side, as the limitation is functional rather than technical.
In IFS APP10, users had the ability to export data in multiple formats (CSV, XML, TXT, HTML, XLSX). However, in IFS Cloud, the export functionality has been restricted to .xlsx only. This behavior is consistent with the core environment and is not considered a bug, but a functional design choice within the Cloud platform.
Therefore, this case should be forwarded to R&D for further evaluation, and a CRIM can be raised if support for additional export formats is required.
+4Hi
Hope that helps!
+2Hi
Hope that helps!
This doesn’t really help - the reason I asked was because the .xlsx files that get exported don’t fully work (I suspect they don’t completely follow the .xlsx spec). They can be opened in excel itself, but don’t work to be imported as data e.g. via Power Query or similar tools. If opened first in excel and then saved again then excel fixes the issue, but this is an extra step in the workflow that add a lot of time and opportunity for error.
I don’t know if the same problem would cause issues with an online conversion tool but it’s a big security risk to upload data to such tools that I’m not willing to test, it also wouldn’t help improve the workflow.
Fortunately I’m not using exports to access data anymore though, so don’t have to face this problem!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
