Tips and tricks on exporting data in EFS

Overview

This article provides tips and tricks for exporting data in EFS (Enterprise Financial System). It covers important aspects such as export duration, file handling, and character limitations in exports.

Information

This guide focuses on best practices for exporting data from EFS, with an emphasis on using CSV format for high-volume exports and efficient file management.

• Export Duration
• File Handling
• Character Limitations in Exports

Export Duration

When exporting data from EFS, it's important to note that the exported data is not created in advance. Instead, it is generated based on your settings at the moment you click the Export button. The duration of the export process can vary significantly depending on factors such as:

• The desired content
• Selected format (CSV is preferred for high-volume exports)
• Number of records

Due to these factors, some exports may take a considerable amount of time to complete.

File Handling

After initiating an export, you'll be presented with a dialog window offering options to save the file locally or open it directly. It is strongly recommended to always save the file to your local PC first.

Benefits of Saving Locally:

• Reduces server load by creating the file only once
• Avoids potential issues with browser file type recognition
• Ensures you have a local copy of the exported data

Character Limitations in Exports

To ensure effective exporting across various formats, some minor modifications are made to the result data:

• Backslashes are removed
• Special characters \n (Newline), \t (Horizontal tab), \r (Carriage return), and " (Double quote) are removed
• NULL values are replaced with an empty string

These modifications apply to all result data exports, including panel exports.

FAQ

Why is CSV export preferred over Excel for high-volume data?

CSV export is preferred for high-volume data exports because it offers better performance and faster processing times compared to Excel format, especially when dealing with large datasets.

Can I open the exported file directly in my browser?

While it's possible to open the file directly, it's not recommended. Saving the file locally first ensures proper file type recognition and avoids potential errors that may occur due to browser limitations in handling certain file types.

How do character limitations affect my exported data?

Character limitations ensure compatibility across different export formats. While some special characters are removed or modified, these changes are minimal and shouldn't significantly impact the integrity of your exported data.