Sage 50 Delivery Address CSV Import Addon (£69+VAT)

Import, update and export Customer Delivery Addresses for Sage Line 50 / Sage 50 Accounts from a CSV file. Additionally in Sage 50 2009 (v15) it can also import Contacts. The CSV layout is easily configured to suit your requirements by using the Sage 50 field names as column headings.

• Can be used to import data into any field in the Sage 50 Customer Delivery Address file that is exposed by the Sage SDO.
• The column headings in first line of the CSV file are used to define the fields that the data should be imported into.
• The CSV file contents are displayed, along with any error messages, before the import takes place.
• Create new template CSV files by selecting fields from a list of available field names.
• Option to Export to a CSV file as well.
• Can be used to import Contacts into the Address File when used with Sage 50 2009.
• The program can be run from a button in the Sage 50 Customer Module (Accounts Pro and Financial Controller only).
• Licensed for use on as many of your company's computers as you like.
• Compatible with Sage Line 50 Accountant, Accountant Plus or Financial Controller versions 8 to 15 (2009).
• Only £69.00 + VAT for a company wide licence.
• Free 30 day trial

Works with:

• Sage Line 50 Accountant | Sage 50 Accounts
• Sage Line 50 Accountant Plus | Sage 50 Accounts Plus
• Sage Line 50 Financial Controller | Sage 50 Accounts Professional
• Sage Client Manager

Run the Sage 50 Address CSV Import program by:

• If you have Financial Controller you can run the program by clicking the button on the Sage Line 50 Customer module tool bar.
• Or by selecting “Adept Tools” and then “Address CSV Import ” from the Windows Start Button / Programs Menu.

Set the Sage 50 Address CSV Import Options:

Currently the program has two options and if in doubt you should leave both boxes unticked.

Unix Compatibility

CSV files created on a UNIX computer usually use a single Line Feed to terminate each record whereas Windows computers will terminate each record with a Carriage Return Line Feed combination. If you tick the "UNIX Compatibility" box the program will be able to read CSV files in either format. However the multi-line option for the v15 Notes field will be disabled because this feature relies on being able to use a single Line Feed (Excel Alt-Enter) to indicate the end of a line within a field.

Restrict Automatic Preview

When you select a CSV file the program will normally load it straight away. This can become tedious if you regularly import large CSV files. If you tick the "Restrict Automatic Preview to Header row only" box only the first row of the CSV file will be loaded until you explicitly press the Load button.

The Main Sage 50 Address CSV Import Program window

• The window can be resized by dragging the corners or edges.
• The status bar at the bottom of the window will display a progress bar when the program is busy.
• When the program is idle, the contents of the current CSV file will be displayed.

Company Box

The Company Name from your Sage 50 data files will be displayed here.

CSV File Box

• Enter the path and file name of the CSV file that contains the data that you want to import.
• Alternatively, click the Browse button to use the standard Windows file browser to help locate your CSV file.

Allow New Addresss to be Created Tick Box

• Tick this box if you want the program to create a new Address record when it encounters a Customer Address in the CSV file that does not exist in Sage 50.
• Untick the box if you will only be updating existing Addresss. The program will show an error message against any Addresses that do not already exist in Sage 50 as shown in the following screen image

Blank Fields are left Unchanged Tick Box

• If this box is ticked the program will leave the current contents of Address file fields untouched if the field is empty in the CSV file.
• Untick the box if you want the Address file field to be cleared when the CSV field is empty.

Menu Button Click this button to display the program's menu. Fields Export Options (discussed above) Sage Path (see Installation) User name (see Installation Licence About Help

Exit Button

Click this button to close the Sage 50 Delivery Address CSV Import program down.

Browse Button

Click this button to browse for the CSV file to be loaded.

Load Button

• Click this button to import the CSV file into Sage 50.
• The program will check the CSV file and if any errors are found appropriate error messages will be displayed in the Status column.
• If all is well, the following dialog will be displayed to allow you to confirm that you want to import the Addresses.

Clicking Yes on this dialog will import the Addresses and display an "Added OK" or "Updated Ok" message as appropriate in the Status column, as shown in the following screen image

Fields Menu Option Select this option to display information about the Address Field Names that are available to you in your version of Sage 50 To create a new template CSV file tick the boxes alongside the fields that you want to create columns for. When you close the Address Fields dialog you will be prompted to save your Template CSV file in a folder and with a name of your choice.

Simple and Straightforward

Installation of the Sage 50 Delivery Address CSV Import Addon is simple and straightforward and should take no more than a few minutes. Comprehensive step-by-step instructions are provided.

Prior to installation you will need to:

1. Ensure that you have installed all the appropriate patches and updates from the Sage update site for your version of Sage (comprehensive notes are provided with the download)
2. Obtain from Sage a Serial and Activation key to enable '3rd Party Integration'.
   Notes and telephone numbers are provided with the download but Sage will want to know the main serial number for your copy of Sage and the version number - found by going to Sage 50,'s HELP / ABOUT menu option.
   N.B. The same 3rd Party Integration keys can be used for all addons that require them

• A fully functional 30 day free trial of this Sage add-on is available.
• The trial can be unlocked by purchasing a full licence - you will not loose any settings
• Still got questions? Checkout the FAQ section

£69.00 (£79.35 inc VAT)	Sage 50 Delivery Address CSV Import Addon
Ref: S50-019

Home > Sage Add ons > Delivery / Contact Address CSV Import Addon for Sage 50

Sage 50 Addons Summary
Sage 50 Addons FAQ's
Sage 50 Addons Resellers

Addons that View Data ..

Sage 50 Company Viewer Lite
Sage 50 Product Viewer Mid
Sage 50 Order Viewer Pro

Addons that Manipulate Data ..

Sage 50 Back to Back Ordering
Sage 50 Credit Note Creator
Sage 50 Document Explosion
Sage 50 Multi Location Stock Tools
Sage 50 Payment Allocations
Sage 50 Product & Account Code Changer
Sage 50 Product Duplicator
Sage 50 Product Memos Backup Program
Sage 50 Sales Price Updater
Sage 50 Stock Adjustments In
Sage 50 Stock Split Program
Sage 50 Stock Transaction Editor
Sage 50 Subscriptions

Addons that Import Data ...

Sage 50 Address CSV Import
Sage 50 Customer CSV Import
Sage 50 Fixed Assets CSV Import
Sage 50 Invoice CSV Import
Sage 50 Price Lists CSV Import
Sage 50 Product CSV Import
Sage 50 Project Charge CSV Import
Sage 50 Purchase Order CSV Import
Sage 50 Sales Order CSV Import
Sage 50 Transaction CSV Import

Addons that also work with ..
Sage Instant* &/or Sage Instant Plus*

Sage 50 Company Viewer Lite
Sage 50 Customer CSV Importer
Sage 50 Product & Account Code Changer
Sage 50 Product CSV Import
Sage 50 Product Viewer Mid
Sage 50 Order Viewer Pro