Data Import Tools
Last updated
Last updated
Data Import Tool Data Import tool is the easy way to upload and edit bulk data. Home > Settings > Report and Masters > Data > Import data or Type 'New Data Import' in search bar
1.How to insert new records in ActiveBooks? Follow the below given step by step process to import data. For example we will see, how to import 'item list' to the system.
1.Click 'Stocks' 2.Select 'Item' 3.Click on 'Menu' 4.Select 'Import' 5.Select Import Type as Insert New Records 6.Click on 'Download Template' While inserting new records, the template should be blank. If you have a few items in your system, you can select Export Type as "5 Records" to see the format in which you have to enter the data in the template 7.Select the File Type of the export template (CSV or Excel) 8.Click on Export
1.1 Enter the Data in the Template Your downloaded template will look like this:
When you import this template, each row will make a Customer record in the system.
1.2 Import the Template Follow the step by step process given below:
After updating your template file, go back to the Data Import form and attach the file by clicking on the Attach button.
Select the template file and click on Upload.
After the upload is successful, click on Start Import.
Click Reload
Do you know? System will show warnings, if there any errors in your template. Errors will be categorized as rows and columns with their numbers. Therefore ActiveBooks makes it easy to track and resolve the issues. You must resolve all the warnings before you can import the data.
2. How to update existing records in ActiveBooks? Let's say you want to update Customer data in bulk in your system. The first step is to download the template with the data.
Follow the below steps:
2.1 Download the Template
Go to Customer List, click on Menu > Import. Click on New.
Select Import Type as Update Existing Records
Click on Save.
Now, click on Download Template.
While updating existing records, you must export the records from the system with the ID field and the fields that you want to update. You can choose All Records or Filtered Records depending on your case.
Select the fields that you want to update for the Customer records.
Click on Export.
2.2 Update Data in the Template
Important Reminder: While exporting records for updating them, ensure that the ID column is exported and is untouched. The values in the ID column are used to identify the records in the system.
2.3 Start Importing the Updated Template
3. How to import child records? - In ActiveBooks data is stored as in tables like a spreadsheet with columns and rows. - Each form likes Sales Order has multiple fields like Customer, Company, etc. - In Data Import, the set of fields in the Sales Order are treated as the main table and the rows inside the child table (item table) are treated as the child table for data import. - For example, an Item can have multiple prices, a Sales Invoice has multiple Items, Taxes, and so on.
4. What are the Import options You have in ActiveBooks?
4.1 Import from Google Sheets You can also import data from Google Sheets.
4.2 Submit After Import In ActiveBooks document types are mainly of two types: 1. Transactions - Records like Sales Orders, Purchase Invoices are submittable documents and can be submitted. 2. Masters - Records like Customer and Task which can only be saved not submitted. Note: When you select a submittable document type for Import, you can tick Submit After Import. It will be automatically submitted after import.
4.3 Don't Send Emails - Let's say you have created a notification in your system and whenever a Lead is created an email is sent. - if you are bulk importing Leads then a lot of emails will be sent, which may not be desired. - You can disable this option to avoid sending emails.
