All data from the database in POSI can be exported easily.

To do this, click the "Export Data" button on the main window.  The "Export Data" window appears.  Now you need to create a text file listing out the fields in the source table.  To facilitate this, on the right corner of the window you can see a list of the existing tables in POSI database.

To see the field names of a table, highlight it and hit the "Show Column Names of" button.

For instance if you have highlighted the "Stocks" table and then press the "Show Column Names of" button, a page showing the field names of the Stocks table will be generated in your web browser as shown in the illustration below.

Now copy only those required field names from your web browser and paste into Notepad. Save this file as Stocks.txt, reflecting the table name.

 

Now to export data from the Members table you will click the "Browse for source table file" button and look for the "Stocks.txt" that you have just saved.  Next select the "From" and "To" dates and hit the "Export Data Now" button.

The required Stocks table data is exported as a .csv file named ~export.csv located in POSI directory.  If you have selected "Open csv file in Notepad upon generation" option button, then the said csv file will be opened in Notepad. This is illustrated in the screenshot below:

When exporting from the 'Stocks' table in csv format, and the 'Amount' and/or 'SalesTaxPaid' fields are required, the system can - by prompting you - add an extra row showing the grand totals of Amount & SalesTaxPaid of the targeted period. The Amount grand total, after deducting the cost of good sold as reported by the Reports window, is the value of your existing inventory. This information is useful for accounting purpose.

If you wish to export data with field names that are the same as those of target table of the third party database, you will need to create another text file listing out those field names.

For example you need to export data for use in an accounting software. The fields names in the accounting software are different.  No problem. You simply create a text file of field names corresponding to those in POSI Stocks table.

The following image shows the fields as laid out in the 2 text files. "Stocks.txt" lists the fields in POSI Stocks table. "Stocks 2.txt" shows the field names in the accounting software.

When these 2 text files are loaded into the Export Data window (using the button "Browse for ..." ) the fields names will appear as shown in the next illustration below.  Now the exporting is ready to begin.

Set the required period and hit the "Export Data Now" button and the exported data will open up in the MsExcel program. This of course assumes that you have MsExcel installed in your computer.  With this exported Excel file it should be easier to import the data into your accounting software.  How this may be done would be beyond the scope of this help file as that would be discussion about third party software with differing capabilities.

It should also be noted that there exists specialised software in the market that facilitates the transfer of data between databases.