The epowerhr esuite supports automated file uploads to import data from other systems. In most cases these files are delivered on the epowerhr SFTP server or retrieved from an external SFTP server provided by the customer.

The supported file types for these automated uploads are:

• CSV
• Excel
• XML

When providing files via the SFTP server, the filenames should always be the same.

CSV (comma-separated values)

For a CSV file, the following parameters should be chosen:

• Delimiter: which is the column separator
• Encoding: the encoding used to display special characters in the file (possible value: Default, UTF8, UTF32, Unicode, iso-8859-1)
• Text Qualifier: this is the character used to enclose text in

Excel

When making use of an Excel, it is possible to provide multiple data types in different sheets (e.g. employees, jobs, organizational units and cost centers).

Some attention points:

• The sheet names should always be the same;
• Excel allows you to use formulas, but they are not supported in the upload;
• The extension can be .xlsx or .xls;
• In Excel, you can easily add extra spaces after unique codes that are not immediately visible when performing a cross-check. However, a unique code with an extra space is considered as an extra unique code.

XML

There is also a possibility to use XML as input for the automatic uploads. There are however some limitations:

• In the upload, you can define the path to the XML node that contains the data that you are trying to upload. That specific node structure can't have child nodes.

In the example below, the path is "Employees/Employee". Within that node, there shouldn't be any child nodes.

• XPath Namespace Navigation is not supported

This means that the part in yellow should not be added.