Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML
<span data-swiftype-index="true">
HTML Wrap
classcol span_3_of_5

Need to import data into AccountRight but not sure where to start? The easiest solution way is to create an import template and populate it with your data, ready for importing.

UI Text Box
sizemedium
typenote

Importing can be a tricky thing – even using an import template. That's why it's important to create a backup before you import.

You can create the template by exporting the same type of information from AccountRight's sample company file. The export file becomes your template.

To use the template, open it in Microsoft Excel and replace its contents with the data you want to import. You can then import the file into your company file.

OK, let's step you through it.

 

UI Expand
title1. Create an import template

Create an import template 

  1. Open AccountRight.

  2. On the Welcome window, click Explore a sample company.

  3. Click the folder for your AccountRight version, such as 2018.3.
  4. Double-click to open a clearwater file. Open the one which matches your AccountRight product (Basics, Standard, Plus or Premier).
  5. Sign in as the Administrator user (leave the Password blank).
    Image Added
  6. Export the type of information you need for your template, such as customer cards.
    1. Go to the File menu and choose Import/Export Assistant.
    2. Select the Export data option then click Next.
    3. At the Data Type step, choose the type of data you want for your import template, then click Next.

      UI Text Box
      sizemedium
      typetip

      You can't export receive payment records, but you can import them. For a list of import fields for receive payment records and a sample import file, see Import and export fields.

    4. At the Format step, select the options Tabs and Include field headers in the file, then click Next.
    5. At the Select Fields step, select the fields you want to include in your import template. If unsure, just click Add all to export all fields.
    6. Click Export.
    7. Save the export file in an easy to find location, such as your Desktop.
      Image Added
UI Expand
title2. Use the import template

Use the import template

Now that you have a template, you can open it in Excel and replace the contents with your data - ready for importing.

Here's how:

  1. Open Microsoft Excel.
  2. Go to File > Open.
  3. For the type of file, select All Files(*.*). This ensures you'll be able to find your import template which is a text (.TXT) file.
  4. Locate and open your exported text file. The Text Import Wizard appears.
  5. In Step 1 of the Text Import Wizard, select the Delimited option, then click Next.
  6. In Step 2 of the Text Import Wizard, select the Tab option, then click Next.
  7. In Step 3 of the Text Import Wizard, click Next.
  8. Click Finish. The file contents of your template will be displayed. Notice in our example:

    • the first cell contains parentheses (brackets) - these need to remain, as they indicate that the import file is from the new AccountRight. If they're not present, AccountRight assumes the import file is from v19 AccountRight and this can cause fields to display incorrectly.

    • the second row (beneath the row with the brackets) is labeled so you can easily work out what type of information is displayed in each column.

  9. Delete the data from row 3 down. This is the data from the sample company file which you don't need. Remember to leave the brackets on the first row, and the headings on the second row.

  10. Enter your data in each applicable column. Remember - when viewing an import file in Excel:
    • each column in the import file represents a field in your company file.
    • each row in the import file represents a different record, e.g. a separate card, item, account, etc.
    • if importing transactions, leave a blank row between each transaction (so AccountRight knows where one transaction ends and the next begins)
    • for details about the required format for each field, see Import and export fields.
  11. When you're done, save the template as a text (.TXT) file. If you like, you can give the file a meaningful name, such as "Customer import" or similar.

    UI Text Box
    sizemedium
    typetip

    Save in the correct format

    The easiest way to ensure your template is saved in the right format, after making your changes to the file attempt to close Excel and you'll be prompted to save. Click Yes and accept the default file type Excel suggests. Here's an example:

    Image Added

Your template is now ready for importing as described below.

UI Expand
title3. Import the prepared template

Import the prepared template

Now that you've populated the template with your data, it's ready for importing. Before completing the import, you should When importing, it's important to create a backup when you're prompted to do so.

Let's do it!

  1. Open the AccountRight company file you want to import the data into.
  2. Go to the File menu and choose Import/Export Assistant.
  3. Select the Import data option then click Next.
  4. At the File Type step:
    1. Choose the type of data you're importing.
    2. Click Browse, select your import template then click Open.
    3. Click Next.
  5. At the Format step:
    1. Select the options Tabs and Headers or Labels.
    2. At the field If data you are importing already exists in this company file, choose Update existing data.
    3. Click Next.
  6. At the Match Fields step, click Auto Match. Providing you didn't change the column headings in the template, this will correctly match the import fields with the applicable AccountRight fields.
  7. Click Next.
  8. If you haven't already done so, click Click Back up to create a backup of your company file. This is a safeguard in case the import doesn't go as planned.
  9. When you're ready to import, click Import. The data in the template is imported into your company file.

The results of the import are shown at the Conclusion step. If there were any issues, view the Import error log for details.

If things didn't go to plan

Importing can be a tricky thing – even using an import template. That's why it's important to create a backup before you import. That way, if If the import failed, the first thing to do is check the the import log. This helps you troubleshoot the cause of the errors or warnings.

If you can't resolve your import issue using the import log, you can restore the backup. The restored company file will be just as it was before the import so you can investigate what went wrong and try again.

HTML
</span>
HTML Wrap
width15%
classcol span_1_of_5
        

 

      
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

Importing data

Import and export fields

Import error log