Language:


Introduction

You can export several different types of information from FirstOffice. You can incorporate the exported information in external programs such as spreadsheets, word processors etc. Apart from those created by the Back-up functions, all exports are output in simple text format, with fields separated by tabs.

To produce an export file, select the 'Exports' item on the File menu or click the [Exports] button in the Master Control panel.

The 'Exports' list window opens, showing the Exports that can be produced from FirstOffice.

Double-click the appropriate item. A specification window will then appear, where you can decide the contents of the export file. Click [Run] again and a 'Save File' dialogue box will appear, where you can name the file and determine where it is to be saved.

Be careful when opening a FirstOffice Export file with Microsoft Excel with the intention of editing it before importing it to a new database. Under certain circumstances, Excel will, when opening a text file, convert some variables that it interprets as dates into its own internal date format. Where you are expecting a date to appear in the spreadsheet you may see a number such as "35475". When you save the spreadsheet again as a text file these variables will not be converted back to date format. So, if you import this text file to FirstOffice, the dates will all be wrong. To avoid this problem, make sure you use the third step of Excel's Import Wizard to set all imported columns to 'text' format (highlight all the columns in the Data Preview area using the Shift key and select 'Text' as the Column Data Format).

You cannot open files created using the 'Database Text Backup' and 'Company Text Backup' functions in Excel as they are not text files.