TimeTonic now offers you the possibility to import your data yourself.
To do this, click on the option in the table
A first screen appears:
Follow the instructions in the previous image, a new window appears, it's the mapping of the data from the CSV file and the table fields in TimeTonic.
You will find various useful information :
Selected table : indicates on which table the data will be imported, here it is the "Worksites" table.
Selected file : indicates which CSV file will be used for the import, here "CUSTOMER BASE including VAT WAVE 16 BIS.csv".
CSV Column : indicates the columns present in your CSV file.
First lines of the CSV : indicates an overview of the data in the CSV column in question
TimeTonic fields : drop-down menu with all the fields available in the selected table.
Unique key : check box to define this data as the value on which your import is based. If the data you import from your CSV file already exists in TimeTonic, the line will be updated, if it doesn't exist, the line will be created.
Then it's up to you to make the link between the CSV columns and the TimeTonic fields :
For example here, your column "refclient" in the CSV file corresponds to the field "#" which is of type autonumber. My data in the "refclient" column and my "#" being unique data, I can use it as an import key.
Then assign the other columns of the CSV file to the columns of the TimeTonic table and click "OK" at the end of the page.
A new page appears:
Click on "Start import" when you want. You can stop the import at any time by clicking on "Pause Import" and decide to resume the import with the "Resume Import" button.
Please sign in to leave a comment.