Final step is to actually upload the Excel file that is filled with data. Open the ‘Import jobs’ screen and click ‘Create import job’.
A window will be opened which is pre-filled with the data that has been entered on the ‘Default job settings’.
You can enter a name for this job and set the date to which actuals should be accounted for. By default this is the date of today, but you could set it to a specific date in the past in case you would only like to interface actuals to that date. All actuals after the set date will then be ignored in the interface.
When you’ve entered the name, set the date and checked the remaining options, you can click ‘Next’.
A new window shows up in which you can upload the Excel template that you’ve just filled with data from the external (administrative) system. By clicking on the ‘Select files…’ a file browser opens so you can look up the Excel template and select it. The file will then be uploaded.
A first check is performed to see whether the document is an .xlsx file. If it is a document of another type, the name of the file will be presented in red along with the text ‘File type not allowed’.
You are able to upload multiple files at once, for example if you have an excel file per project.
After uploading the file(s), you can save the wino. The application will now start validating the data in the uploaded files and check whether there are any anomalies in the data.
The grid on the ‘Import jobs’ screen shows you the jobs that are running and were ran in the past. The status column tracks the status of all import jobs. After completing the validation cycle, two possible outcomes can occur; completed or invalid.
If the status is ‘Invalid’, it means that the data of the import job is invalid. When you click on the respective import job in the grid, a slide-in opens with the details. It shows a validation log stating the issues that have been found in the data. The picture on the right shows that validation has failed due to an error in the project mapping ID. It appears that the external project ID 9989 has not been linked to any project in the application and therefore can’t be processed.
If the status is ‘Completed’, it means that the data of the import job is valid and has been imported successfully. You can also click on the completed import jobs to see the import log and job details.
The actuals have now been interfaced to the project. You can check the cashflows to see the result of the interfaced data!