Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
import_and_export:export_to_dashboard [2021/04/20 10:06] – [16.18. Exporting to the dashboard] Gary Willetts | import_and_export:export_to_dashboard [2023/04/07 09:38] (current) – Gary Willetts | ||
---|---|---|---|
Line 1: | Line 1: | ||
{{indexmenu_n> | {{indexmenu_n> | ||
- | ====== | + | ====== |
- | <wrap info> | + | <wrap info> |
- | To access Dashboard export settings (administrators only): | + | This information is for sending data from your mSupply database to the mSupply dashboard database. The dashboard has a separate Postgres database so that its use does not slow down or interfere with your use of mSupply. |
- | * Click the **Admin** tab | + | |
- | * Click the **Dashboard** button | + | |
- | * Click the **Export Settings** button | + | |
- | {{ :import_and_export: | + | To access Dashboard export settings (administrators only), click on the //Admin// tab of the Navigator and click on the **Dashboard** icon: |
- | Once Dashboard is enabled and the correct Postgres settings entered, there will be an automatic (scheduled) export every 24 hours. The next scheduled export is shown on the Export Settings tab (above). | + | {{ : |
- | To perform an immediate (manual) export: | + | Click on the **Export Settings** tab and you will see this window: |
- | * Check the boxes to choose the data you want to manually export to the dashboard (check the **All/ | + | {{ : |
- | * Click the **Export** button | + | |
- | * Enter the authorisation code | + | |
- | * Click **OK** | + | |
- | By default, **transaction** and **requisition** data is only exported incrementally — that is, only transactions and requisitions that are new or have been changed since the last export are exported, which saves a substantial amount of time in the export process. All other tables are re-exported from scratch each time. | ||
- | In order to force a //full// export | + | |
+ | ==== Postgres server section ==== | ||
+ | In here you enter the details of the dashboard database server: | ||
+ | * **Server:** the URL or IP address of the dashboard database server | ||
+ | * **Port:** the port on the server that the database is listening for connections | ||
+ | * **User:** The user name that mSupply will use to access the Postgres database | ||
+ | * **Password: | ||
+ | * **Database Name:** The name of the database that mSupply is to access | ||
+ | |||
+ | To make sure the details are correct and your copy of mSupply has access to the dashboard database, click on the **Test connection** button. A message will tell you whether the connection is successful or not. | ||
+ | |||
+ | Once the dashboard is enabled and the correct Postgres settings entered, there will be an automatic (scheduled) export every 24 hours. The next scheduled export is shown in the //Next scheduled export// field. This export | ||
+ | |||
+ | |||
+ | ==== Export settings section ==== | ||
+ | This section enables you to manually export data to the dashboard apart from the scheduled dashboard export. | ||
+ | |||
+ | The time and date of the next scheduled export to the dashboard database are shown in the **Next scheduled | ||
+ | By default, all table data is exported incrementally — that is, only records that are new or have been changed since the last export are exported, which saves a substantial amount of time in the export | ||
+ | |||
+ | The **Run Next Scheduled Export Now** button gives you a way of exporting the data immediately, | ||
+ | |||
+ | The **Full | ||
+ | The table contains a list of all the database tables in mSupply that can be exported to the dashboard. Simply check the checkbox in the Export column to set that table to be exported to the dashboard when you click on The **Full export of Checked Tables** button. The **All/None** checkbox is a quick way of toggling between all tables selected and non-tables selected. | ||
+ | |||
+ | When you click on either of them you must enter your authorisation code before | ||
+ | |||
+ | Click on the **OK** button to save your changes and the **Cancel** button to cancel any changes you have made. | ||
\\ | \\ |