How to start the CSV Exporter

 

File menu > Export.

...OR

Tools menu > Apps, or Add-Ons menu > CSV Exporter

 

 

 

Introduction


A video covering the CSV Exporter is available below.




 

The CSV Exporter will allow you to produce "comma separated values" files (CSV) which can be imported into many accounts packages, as well as opened for viewing in many apps such as Microsoft Excel or OpenOffice Calc.

 

A CSV file is a standard way of transferring data from one program to another, and stores specific data in a simple, unformatted and readable format. The destination program (such as Xero Accounts) expects to see the information in a particular sequence, and will only be expecting to see pre-determined items of data, so the CSV Exporter needs to create the file using a template provided by the destination program. These templates are available online and can be downloaded directly within the CSV Exporter. Once downloaded, a template is stored on your LabManager computer and you can then access that template without having to download it every time.

 

(Note, if you open a CSV file in your spreadsheet program, and then make changes and save, the new file may not be compatible with your accounts package any more! If you need to open the file in your spreadsheet program you should work with a copy of the original CSV file)

 

Occasionally we may release new templates, such as when new accounts packages become available. You can download these online when we release them.

 

If we need to make any changes to existing templates, you can download the updated template online too, using the "Automatically check for new versions online" checkbox on the Browse page.

 


 

 

 

 

Using the CSV Exporter

 

Within the CSV Exporter, click the Browse button to pick an export template to use.

If this is the first time you've used the CSV Exporter, or you want to find new templates to use, you should now click "Get more templates online".

From the list that appears, select an export template to download to your PC then click "Download this template".

Close the dialog then click Browse again

Select a template from the list, then click "Use this template".

Depending on the template you chose, you may be required to enter parameters such as a start and end date, or other criteria

When you're done entering parameters, click "Export to CSV File" and choose where to save the file on your computer

 

The resulting CSV file can be imported into the appropriate accounts package or opened in Excel/OpenOffice Calc as a comma separated CSV file.

 

 

Note that once you've exported accounting data, the Lock Date can be set within LabManager, and you will be prompted if you wish to do this. If you choose to lock your data you can no longer make changes to those invoices that were included in the export. This is to ensure consistency between your account package and LabManager. If you wish to unlock your data again you can just visit the Accounting Rules page of Control Centre > Advanced within LabManager, and change the Lock Date.

 

Further details of each screen are given below.

 

 

 

 

Browse for a template

 

add ons - csv exporter browse

 

You can reach this page by clicking "Browse" from the main page of the CSV Exporter.

 

The large left panel lists all the templates you have previously downloaded to your computer. You can select any one of these to see a short description of that template on the right panel.

 

A template contains the instructions required to export data from LabManager in the format required for importing into the selected application. Every accounts package will have its own requirements for importing from a CSV file, so you will need to ensure you select the template that is appropriate for the accounts package that you use.

 

You can get more templates from our online library, by clicking the button "Get more templates online".

 


Once you have selected the template you wish to use, click the button "Use this template". You will be returned to the first screen and your template will be loaded and ready to use. If you need to enter parameters (such as start and end dates for your export) you will be prompted to enter these. Click "Export to CSV file" to choose an output file and begin the export.

 


Occasionally it may be necessary for us to release a new version of an existing template, such as to include additional data or work around a problem. If the box "Automatically check for updated versions online" is ticked, then whenever you select a template in the list, if a newer version is available you will be notified and given the option to download the updated version.

 

add ons - csv exporter browse - update available

 

 

 

Download new templates to your computer

 

You can reach this page by clicking "Get more templates online" from the Browse page of the CSV Exporter

 

The large left panel lists all the templates available online that you don't already have. You can select any one of these to see a short description of that template on the right panel.

 

A template contains the instructions required to export data from LabManager in the format required for importing into the selected application. Every accounts package will have its own requirements for importing from a CSV file, so you will need to ensure you use the template that is appropriate for the accounts package that you use.

 


To download a template, select it, then click the button "Download this template". The template will be downloaded into your library and you can find it using the Browse button from the main page.

 

add ons - csv exporter download new