The ‘Company Import’ feature will allow you to import company and employee details in to the software.
This is done using a CSV(Comma Separated Value) format file. This type of file can be created/edited using Microsoft Excel or any Notepad/Plain Text document.
We advise you to take a backup before importing any data into the payroll.
Creating your Import files
To access this section in the software select ‘Admin’ > ‘Data Conversion’ > ‘Company Import’
- You must first have import files, populated with data, before you can import using the ‘Company Import’ option.
- QTAC can generate these import files, but first it is best to create the company within the payroll under ‘Company’ > ‘Company Maintenance’ by clicking the ‘Add New’ button – simply enter the company name and then save and close to create the company – other company details can be entered when importing the file (see the steps in the ‘Importing your Import files’ below).
- You can then go into ‘Admin’ > ‘Data Conversion’ > ‘Company CSV Export’ – select the location you want to save the files by clicking the ‘..’ button and then click ‘Export’.
- When you have created the import files in the steps above, you can then open these import files (Browse to the location you saved the files in the exporting steps above) and enter any data needed into the necessary import files.
- If creating a company, then you can enter in the company details under the ‘Company.csv’ file. If creating employee data as well as company data then you can enter employee details into the ‘Employee.csv’ file
- After you have entered in details into the import files, you can go into ‘Admin’ > ‘Data Conversion’ > ‘Company Import’ – click the ‘Browse’ button to select the location of the import files you have created. You will need to select the folder where the import file
folders are held and not the import file folder itself and then click the ‘Ok’ button. - Click on the ‘Prepare’ button on the main company import screen, this should give you the companies/name with import data in. Select the company/name down the left hand side and select ‘Migrate’ – you will need to be logged out of the database before import.
- After clicking ‘Migrate’, the data should start being imported, giving you details of companies/employees imported
- Any issues or problems will be reported on in an ‘Anomaly Report’.
