Exporting Data From Artisan 4.0 Database
This article explains how to obtain data that resides in the Artisan POS 4.0 version directly from the database with all information stored in their specific tables.
NOTE: The tool we are using to accomplish the export must be used with care as it could render all data unusable if instructions are not followed. This is only for advanced users and do not perform tasks NOT related to the exporting, unless you know what you’re doing.
CerTek Software Designs, Inc. is not responsible for any data damage or loss. Use this tool at your own risk. Make backups before any changes.
We will use pgAdmin to access the database. This program should already be installed on your main Artisan POS computer.
1. Open pgAdmin on your MAIN Artisan POS computer.
- Click on the Windows Start Menu and on the Search field type “pgadmin”
2. Once pgAdmin opens, right-click on PostgreSQL with the red X and select “Connect“
- It will ask for a password. Try your store’s name or Ask CerTek for it.
3. Expand “Databases” and click on “POS” without opening it.
- Note: your database name may be different from POS, if it so, replace POS on this article with it from now on.
IMPORTANT: Before proceeding, let’s make a backup of the database.
Make a backup
Just right-click the name of the database and select backup
Then just choose a directory to save it at and click “Backup”. Then continue with the steps below.
4. Now click on the “SQL” button on top.
5. A new window will open call the Query window.
- Select “Graphical Query Builder”
- Expand “Schemas”
- Expand “pos”
Select Tables to Export Data
We now continue as step 6.
6. From the list of tables, select one at the time by double-clicking. This will bring all the table fields on to the right panel where specific fields could be selected for the export or simply leave all unchecked to export all information.
- Once the table is selected click on the on the menu top to run the query which will return all the data requested on the table selected.
- All the data returned will be shown on the inferior panel.
7. After the data has been reviewed on the lower panel and it has been decided to export it. Click file on the top menu => Export
- A new window will open asking for the criteria for the file that will be generated.
- Be sure to select the same options as the image below, except the directory or path or you will save your files at.
- Select the path where you will like to place the file at (It has to be selected every time you export a file)
- Select “OK” to export.
8. When data saves to the file, a success message will be shown.
Now go to step 6, select another table and repeat the steps to export it.
The most useful tables may be: category, item, customer, user, vendors. But, all tables could be exported if needed.
All files will be exported as .CSV (Comma Separated Values) and these could be edited in Microsoft Excel for customization.