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/28 10:52] – [Export settings section] 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> |
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. | 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. | ||
Line 11: | Line 11: | ||
Click on the **Export Settings** tab and you will see this window: | Click on the **Export Settings** tab and you will see this window: | ||
- | {{ : | + | {{ : |
+ | |||
==== Postgres server section ==== | ==== Postgres server section ==== | ||
Line 23: | Line 25: | ||
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. | 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. | + | 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 process can be edited to run at different intervals based on your needs. |
==== Export settings section ==== | ==== Export settings section ==== | ||
- | This section enables you to select exactly what data is exported | + | This section enables you to manually export |
- | + | ||
- | To perform an immediate (manual) export: | + | The time and date of the next scheduled |
- | + | By default, | |
- | * Check the boxes to choose | + | |
- | * Click the **Export** button | + | The **Run Next Scheduled Export Now** button gives you a way of exporting the data immediately, |
- | * Enter the authorisation code | + | |
- | * Click **OK** | + | The **Full export of Checked Tables** button gives you a way of re-exporting the specific table data from scratch |
- | + | 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/ | |
- | By default, | + | |
+ | When you click on either of them you must enter your authorisation code before the export will be carried out. | ||
+ | |||
+ | Click on the **OK** button to save your changes and the **Cancel** button to cancel any changes you have made. | ||
- | In order to force a //full// export of transactions and/or requisitions, | ||
\\ | \\ |