Difference between revisions of "5. Export to Reports"
From TrueERP wiki
Omer Farooq (Talk | contribs) (Created page with "= Overview = '''Export to Report DB''' '''Export to Reports - How do you use the 'Export to Report DB'?''' This function is under the '''Utilities''' module. '''Export to R...") |
Omer Farooq (Talk | contribs) (→Overview) |
||
| Line 10: | Line 10: | ||
- Select '''Utilities''' tab. | - Select '''Utilities''' tab. | ||
| + | |||
- '''Export to Report DB''' button. | - '''Export to Report DB''' button. | ||
| + | |||
- There will be a list of table that can be exported. | - There will be a list of table that can be exported. | ||
| + | |||
- Select by clicking in the box along side of the Table you require. | - Select by clicking in the box along side of the Table you require. | ||
| + | |||
- The button '''Select All''' automatically selects all of the tables. | - The button '''Select All''' automatically selects all of the tables. | ||
| + | |||
- The '''Unselect All''' clears the selection. | - The '''Unselect All''' clears the selection. | ||
| + | |||
- Click '''Export''' to export the selected table. | - Click '''Export''' to export the selected table. | ||
The Data will be exported to this location: '''C:\\Mysql_ERP\data\ERP_Export''' | The Data will be exported to this location: '''C:\\Mysql_ERP\data\ERP_Export''' | ||
This will be on the Server. | This will be on the Server. | ||
Latest revision as of 00:48, 28 August 2014
Overview
Export to Report DB
Export to Reports - How do you use the 'Export to Report DB'?
This function is under the Utilities module. Export to Reports is designed to make a copy of your data in tables that you can manipulate.
This enables you to copy the tables from ERP and export them in an ODBC (Open Data Base Connectivity)format to enable the tables to be used in any application that you want. For example; Excel, Access, Open Office.
- Select Utilities tab.
- Export to Report DB button.
- There will be a list of table that can be exported.
- Select by clicking in the box along side of the Table you require.
- The button Select All automatically selects all of the tables.
- The Unselect All clears the selection.
- Click Export to export the selected table.
The Data will be exported to this location: C:\\Mysql_ERP\data\ERP_Export This will be on the Server.
