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.
Access Database
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 so, replace POS on this article with your database name 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
Give the backup a filename. For format, select Custom or Plain –
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 will now continue with step 6.
6. From the list of tables, select one at a time by double-clicking. This will bring all the table fields onto 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 menu on the 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.