Need to import your project expenses from your financial system? TimeLog Project now offers full import of .TXT and .CSV files.
Eliminate duplicate entries and save time
If you register your business expenses in a financial system such as e-conomic, C5, Navision, Axapta or the like, you can now eliminate duplicate entries by importing data on supplier invoices, employee and travel expenses, etc. from a comma-separated .TXT or .CSV file. This consolidates all internal and external project-related expenses. And if you invoice your customers using TimeLog Project, you’ll be able to include these expenses, too.
Importing the file
Go to the system’s main menu, then go to the Management Reports group, select Import and Export and then select Import of Expenses. Next, go to the Select File tab and select the import file. This shows the import file data in table format on the Select Expenses tab. Now mark the rows in the import file that you wish to import. Import the file by selecting Import in the Select action drop-down list, and click OK. This imports the file into TimeLog Project, showing the predefined fields.
Import file requirements
To read the comma-separated import file, each row must include 11 fields in a specific order. Also, the fields require specific formatting.
The names of the corresponding fields in your financial system don’t necessarily match those of the destination fields in TimeLog Project. Likewise, the fields may appear in a different order in TimeLog Project than they do in the import file.
Find out how to get started by reading these user guides:comments powered by Disqus