• TurboCASH UK Website • Download TurboCASH FREE • Buy TurboCASH
taken from the Accounting Made Easy e-book








EXPORT DATA
EXPORT DATA FOR DOCUMENTS
  
This facility is in addition to the powerful Report Export facility, in which all reports in TurboCASH may be exported and saved in any available format on your system, such as Word Processing (Text), Spreadsheets, etc. Using this facility, you may also export certain data regarding documents in an open Set of Books to XML Database format or any available format on your system. You may then open the other applications to which the exported data is saved and work in the applications, such as OpenOffice.org Calc, Lotus 123, Microsoft Excel, etc.

To Export Documents Data:

 Click on Tools - Export menu option or press the and and keys on your keyboard. The Export Data to File (Documents tab) screen will be displayed. Select the Documents tab if not selected.

Title bar - double-click to display the screen in full size or to return to the normal size. Minimise - click to minimise this screen. Restore - button inactive Close - click to close or exit this screen. Select to export data for documents. Select to export data for stock items. Select to export data for debtors. Select to export data for Accounts. Select to export data for creditors. Select to export transaction data for posted batches. Click to generate the export file and save the data in the file name and selected directory. Close - click to close or exit this screen. Click to select a different folder on the Browse for Folder screen. Select XML Database, Comma Separated Value (CSV), Lotus 123 (WK1), MS Excel (XLS), TurboCASH Exchange File (TXF), SYLK (SLK) and OpenOffice Calc (SXC) file types. Enter a name to save the exported Header data. Enter a File Name for the Log File. Enter or select a valid date using the Date Picker. Export Documents Options
Select and enter the following for the options to create an export data file.

Option Description
Export to The installation directory in which TurboCASH is installed will be displayed. You may click on the Browse icon to select a folder on the Browse for Folder screen on which you may select any available folder or drive on your system into which you wish to export the documents to.

File Type You may select to export the file in the XML Database, Comma Delimited File, Lotus Spreadsheet File or any other format available on your system from the dropdown list.
Export File Name There are 3 files - the Header File, Lines File and Log File. Enter a name for the export file.
Log File Enter the Log File name.
Range From and To Select the dates on the Date Picker from which and until when you need to include documents. Any documents generated outside the selected dates will not be included in the export file.

Click on the button. TurboCASH will create the export file and save it in the specified directory.

The saved exported file formats or file types will be displayed as the following icons:

 - XML Database file

 - OpenOffice.org Spreadsheet

  - Lotus 123 Spreadsheet file

 - Microsoft Excel Workbook (Spreadsheet).

 - Comma Separated Value

GNU Free Documentation License 1.2 SourceForge
Content released by Digidan under the GNU Free Documentation License 1.2.