You can start the import via Settings -> Import. At least administrator rights are required for the import.
Import from DATEV Reisekosten classic
You can import employee data from DATEV Reisekosten classic via this import interface.
Procedure:
- Create an export of your employee data in DATEV Reisekosten classic according to these instructions: Exporting master data from Reisekosten classic for transfer to an external system
- Start the import wizard in Spesenfuchs and select the created export file.
- Select all employees you want to import. If you do not want to import an employee, deactivate the checkbox for this employee.
- If you want the employees to record their trips themselves, set the checkbox to Yes. After the import, these employees will then receive an invitation by email so that they can register in Spesenfuchs. If you want to send the invitations at a later date, leave the switch set to No and send the invitations via the user administration.
- The "i" at the end of a line may inform you why the data record cannot be imported. For example, in Spesenfuchs some fields must be present or must not be duplicated.
- If cost centres/cost units are stored for your employees, you can also create them in Spesenfuchs. If the cost centres/cost units are not to be imported, please deactivate the checkbox Import and assign new cost centres/cost units. Please note that once used, cost centres/cost units cannot be deleted in Spesenfuchs. Avoid importing outdated data at this point. However, it is possible to hide cost centres/cost units that are not required.
- When you have checked your data, start the import process with Import.
- The wizard checks whether there are enough free user licences available. If necessary, you can add more licences at this point. Without sufficient licences, the import cannot be continued.
- After the import, you will receive a summary of the imported data.
Notes:
- Individual km records of the employee are not imported. If you use individual rates for your employees, you must enter them for the employees under User administration -> Account assignment.
- The cost centres/cost units from DATEV travel expenses only have one number. In Spesenfuchs you can also store names for the cost centres/cost units after the import for easier identification.
Import from a CSV file
If you want to create several employees at once in Spesenfuchs, importing is more convenient than creating each user individually via the interface.
Procedure:
- Start the import from a CSV file.
- Download the template and open the file with e.g. Microsoft Excel.
- Do not change the headings in the file and do not add any headings. If you do not want to fill in certain columns, leave them blank.
- Fill in one row for each staff member.
- You must fill in the Name and Email fields, as these are mandatory fields in Spesenfuchs. All other fields are optional.
- Save the file again in CSV format (UTF-8).
- In Spesenfuchs, proceed to the second step of the import wizard. Click Select & Upload and select the file you just saved.
- Select all the employees you want to import. If you do not want to import a staff member, uncheck the box for that staff member.
- If you want the employees to record their trips themselves, set the checkbox to Yes. After the import, these employees will then receive an invitation by email so that they can register in Spesenfuchs. If you want to send the invitations at a later date, leave the switch set to No and send the invitations via the user administration.
- The "i" at the end of a line may inform you why the data record cannot be imported. For example, in Spesenfuchs some fields must be present or must not be duplicated.
- When you have checked your data, start the import process with Import.
- The wizard checks whether there are enough free user licences available. If necessary, you can add more licences at this point. Without sufficient licences, the import cannot be continued.
- After the import, you will receive a summary of the imported data.