少年辛苦终身事，莫向光阴惰寸功。这篇文章主要讲述Transfer data between DB and CDS on Power Apps相关的知识，希望能为你提供帮助。
- 鏍囩锛?a href='http://www.mamicode.com/so/1/win' title='win'>win
create
appear
earlier
base
one
instance
ssi
sof
Transfer data from Hospital to Regional SystemMicrosoft provides you the following solutions for emergency response:
- The
Hospital Emergency Response solution
enables you to collect data for situational awareness of available beds and supplies, COVID-19 related patients, staffing, and pending discharges at a
hospital level.
- The
Regional Government Emergency Response and Monitoring solution
enables you to collect data for situational awareness of available beds and supplies, COVID-19 related patients, staffing, and pending discharges at a
regional health organization level. Each hospital under the regional organization jurisdiction can submit their data by using the regional organization鈥榮 portal, which is also part of the
Regional Government Emergency Response and Monitoring solution.
The out-of-box solution uses the Secure File Transfer Protocol (SFTP) as the data transmission mechanism. Customers can use other ways to transfer data to/from these solutions such as importing and exporting data as CSV files and using web services to programmatically interact with data in Microsoft Dataverse, which is the underlying data store for these solutions.
This article provides information about how to use SFTP to do the data transfer.
How does the data transfer happen?This is how the data transfer happens:
- Hospitals can publish their data from the hospital solution, such as information about beds, supplies, equipment, and staff, to a folder in an SFTP server hosted by their regional medical organization. Hospitals can publish data on-demand or can schedule it.
- The hospital data published in the folder on the SFTP server is automatically downloaded to the regional solution and is used to create respective data records (beds, supplies, equipment, and staff) for the hospital in the regional solution.
- SFTP server: The regional health organization must have an SFTP server configured with a folder for each hospital on the SFTP server where the hospital can publish their data. The hospital must get the credentials from regional health organization to connect to the folder on the SFTP server.
For information about creating an SFTP server, see SFTP on Azure
- CDC Short Name: Each
Supply
and
Staffing Type
record must have the
CDC Short Name
value. You can create and manage these records in the
Admin app
of hospital and regional solutions.
- DOH Number: Each
Facility
record must have a valid
DOH Number
value. You can create and manage these records in the
Admin app
of hospital and regional solutions.
Step 1: Create connections- Step 1: Create connections
- Step 2: Enable flows for publishing data to SFTP (Hospital)
- Step 3: Specify the data publish schedule (Hospital)
- Step 4: Enable flow for pulling hospital data from SFTP (Regional)
Both the hospital and regional systems use Power Automate flows to transfer data between the hospital/regional solutions and SFTP server. In this step, we will create connections for Dataverse and SFTP to be used by flows for data transfer.
This step is required for both hospital and regional solutions.
Important
Make sure that you create connections in your Power Apps environment before installing the hospital and regional emergency response solutions or upgrading to the latest version. This will save you a lot of steps later while enabling flows that get installed as part of these solutions.
- Sign in to
Power Apps.
- From the top-right corner, select your hospital or regional environment.
- From the left navigation pane, expand
Data
and select
Connections.
- Select
New Connection, and then type
Common Data Service
in the search box.
- From the search results, select
+
next to
Common Data Service
connector to add a connection.
文章图片
- On the next screen, select
Create. Select or specify the credentials to create the connector. On successful authentication, your connection will be created.
- Select
New Connection, and then type
Common Data Service
in the search box.
- 【Transfer data between DB and CDS on Power Apps】From the search results, select
+
next to
Dataverse (current environment)
connector to add a connection.
- On the next screen, select
Create. Select or specify the credentials to create the connector. On successful authentication, your connection will be created.
- Select
New Connection, and then type
SFTP
in the search box.
- From the search results, select
+
next to
SFTP - SSH
connector to add a connection.
文章图片
- In the
SFTP - SSH
dialog box, provide the credentials to connect to the folder on the SFTP server. These details would have been already provided to you by your regional health organization as mentioned earlier in the
Prerequisites
section.
- Select
Create. Power Apps validates the connection details, and on successful authentication, creates an SFTP connection.
Step 2: Enable flows for publishing data to SFTP (Hospital)
This step has to be performed by the admins of the Hospital Emergency Response solution after they have installed the solution.
In this step, we will enable the following flows that will publish reviewed data from the hospital solution to SFTP server on a set schedule and on-demand:
- Publish Bed Census Data
- Publish COVID Data
- Publish Data for All Facilities
- Publish Equipment Needs Data
- Publish Staff Updates
- Publish Supply Item Details
- Update Sync Census
- Update Sync Equipment Needs
- Sign into
Power Automate.
- From the left pane, select
Solutions.
From the solution list, select
Hospital Emergency Response Solution
to open the solution.
- In the solution, filter on
Flow
to find all the flows.
文章图片
- Select a flow name to open the flow definition. For example, select
Publish Bed Census Data.
- Select
Edit
on the toolbar and verify the embedded connections for this flow. These should be the same connections that you created earlier.
- Select
Save
to save the changes, and then select
Turn On.
- Repeat steps 4-6 for other flows listed earlier.
Step 3: Specify the data publish schedule (Hospital)
The Publish Data for All Facilities flow contains the information about the data publish schedule. You can define the recurrence schedule when the flow will run automatically and publish the data that you have reviewed and marked as ready for publish.
- Sign into
Power Automate.
- From the left pane, select
Solutions.
From the solution list, select
Hospital Emergency Response Solution
to open the solution.
- In the solution, search for "Publish Data for". The
Publish Data for All Facilities
flow appears in the search result.
文章图片
- Select the flow name to open the flow definition, and then select
Edit
in the toolbar.
- In the flow definition, select
Recurrence
and then select
Edit.
文章图片
- Specify the data publish recurrence schedule.
文章图片
- Select
Save
to save your changes.
This step has to be performed by the admins of the Regional Government Emergency Response and Monitoring solution.
In this step, we will enable the Create Record when a File is Created in SFTP Location flow that will automatically create a record for hospital in the regional solution based on the data uploaded from the hospital system in the SFTP server.
Important
For each hospital registering with regional organization to send data, the regional admins will need to do one of the following to ensure data for each hospital is copied from the SFTP server to the regional solution:
- Copy data from all the hospitals to a single folder on the SFTP server to enable the
Create Record when a File is Created in SFTP Location
flow to copy all the data.
- Create a copy of the
Create Record when a File is Created in SFTP Location
flow for each Hospital registering with them to send data, and in each flow instance change the SFTP server folder path as per the hospital. We鈥榣l show you how to do this later in this section.
- Sign into
Power Automate.
- From the left pane, select
Solutions.
From the solution list, select
Regional Emergency Response Solution
to open the solution.
- In the solution, filter on
Flow
to find all the flows.
文章图片
- Select the
Create Record when a File is Created in SFTP Location
flow to open the flow definition.
- Verify the embedded connections for this flow. These should be the same connections that you created earlier.
- Select
Save
to save the changes, and then select
Turn On.
- If regional admins are expecting data from multiple hospitals that are stored in different folders on SFTP server, they can create copies of the
Create Record when a File is Created in SFTP Location
flow to create one for each hospital, and update the SFTP folder name accordingly in the copied flow instance. To do this:
- Select
Save As
on the toolbar to create a copy of the flow.
- Rename the flow accordingly and save it. This flow will become available under
My flows.
- Select the flow to open it for editing. Select
Edit
on the toolbar.
- Select
When a file is added or modified, and select appropriate value in the
Folder
field:
文章图片
- Select
Save As
on the toolbar to create a copy of the flow.
- Select
Save
to save the changes, and then select
Turn On.
- Sign in to
Power Apps.
- From the top-right corner, select your hospital environment.
- Select
Apps
in the left navigation pane, and then select the
Review and Publish Data
app.
- In the app, all the facilities are listed. Select a facility for which you want to review the data and publish. This will open the facility record.
文章图片
- Scroll down the page to review the following data for your facility: Bed Census, COVID Stats, Equipment Needs, Supply Tracking, and Staff Updates. If necessary, update the data in grids, and then select the save icon to save your changes.
文章图片
- Once reviewed, you can select a row of data, and select
Mark Complete. Select
OK
in the confirmation dialog box to complete the action.
The record鈥榮 review status changes to Completed.
文章图片
Manually publish data
The scheduled flow publishes data at a certain time, but what if you want to manually or immediately publish the data after reviewing it.
- In the
Review and Publish Data
app, select the record that you want to publish from the
Published History
in the left pane. All the published data for the selected entity are displayed. If you want to view the active records for the entity, use the view selector.
文章图片
- In this case, we will publish the data that we reviewed in the previous section. So, select the
Active Bed Censusview, select the row that was marked as completed, and then select
Flow
>
Publish Bed Census Data.
文章图片
- On the next screen, review that the connections are valid, and select
Continue.
文章图片
- On the next screen select
Run flow. A message appears stating that the flow run started successfully and how you can monitor the progress.
推荐阅读
- 运行Appium服务时，启动不了WebDriverAgent的解决方法
- ASP.NET Core 3.1使用AutoMapper（基本使用）
- 安卓购物菜单
- 244 Android Studio中gradle的介绍
- 「转」Android编译选项中的enguseruser-debug
- androidstudio配置http proxy以及配置gradle
- Android自定义ViewGroup-入门
- Android 高版本无法抓取 HTTPS解决方案
- WinXP如何安装Apache+MySQL+PHP环境
- The
Hospital Emergency Response solution
enables you to collect data for situational awareness of available beds and supplies, COVID-19 related patients, staffing, and pending discharges at a
hospital level.
