Import/Export JSON Files
The WebChart system allows users to create, import, and export JSON files from one database to another. Users with the appropriate permissions can create JSON files from the system, using the System Configuration tab of the Control Panel. This allows administrators to easily review, approve, and export a JSON file from one WebChart system (e.g., DEV, QA, etc.) and easily import into another WebChart system (e.g, PROD), avoiding duplicative work and ensuring consistency. For example, if a client needs several document types created (e.g., 2 Forms, 2 Word templates, 1 Consent doctype, and 1 HIPAA doctype) for an interface, these documents can be created and tested in a Development or QA environment and then easily migrated into a Production database using the JSON export/import tool, also known as the System Configurator.
Users with proper permissions can create JSON files of the following sections/modules:
|Abbreviations||Document Types||Health Surveillance||Observation Flowsheets||Scripted Logic & Scripted Rules|
|Apt Types||Drug Aliases||Kits||Order List||Security Roles|
|AutoComplete Fields||Drug Indications||Language Translations||Order Pick List||Stations|
|Chart Tabs||Drug Reactions||Layouts||Partitions||System Files|
|Chart Types||Encounter Exams||Libraries||Print Definitions||System Reports|
|Common Scripts||Encounter Types||Locations||Refer to Systems||System Settings|
|Common Sigs||Esign Rules||Menu Editor||Restriction Types||Tasklist Events|
|Custom Allergies||Fast Tasks||My Settings||Scheduled Jobs||Term Replacement|
|Departments||Frequencies||Observation Codes||Schedules||User Portlets|
Creating a JSON File for Export
In order to create a JSON file for export, the logged-in user must have the appropriate permissions to access and utilize the System Configuration tab of the Control Panel. Once access has been granted, the user may perform the following:
- From the export database (i.e., the database from which the JSON file is being exported), navigate to the Control Panel.
- Go to the System Configuration tab.
- Select the module(s) needed for export from the database. It is permissible to select multiple modules for one JSON file.
- After selecting the module(s), click the Search button.
- A ListView will display for each of the modules selected. Users may choose to scroll through the page, marking each individual item for export, as needed; otherwise, there are two quick links available to Jump to Bottom of each ListView, or jump to the Bottom of Page.
- Unless all items within each module need to be exported, be sure to click the Uncheck All [Module Name] button and select all of the items to be exported, individually.
- When finished selecting all of the items for export, go to the bottom of the page and provide a meaningful name for the export file and click the Export button.
- A message will display at the bottom of the screen, prompting the user to Save the file, or Cancel. Select Save to create the file for export.
If the file has been saved, another message will display at the bottom of the screen allowing the user to open the file, or containing folder, once the file finishes saving.
Import a JSON File
Once the necessary JSON file has been created and exported from the WebChart system, any user with the proper security permissions may import the file to the new, or alternative, system. The JSON file should be copied to the computer; however, the file does not have to be created on the computer. For this reason, the file may be delivered via a Redmine ticket, sent via email, available on a share drive, etc.
- From the import database (i.e., the database into which the JSON file is being imported), navigate to the Control Panel.
- Go to the System Configuration tab.
- Click the Import link in the upper-right corner of the page.
There are several import options available. The following instructions will focus on the process for importing a saved file.
- After navigating to the Import screen, click the Choose File button and browse to the JSON file.
- Select and Open the JSON file. A status window will appear, briefly.
- Once the file has loaded, users will want to select the link to Jump to Bottom.
- With all of the necessary files selected, click the Import Selected button at the bottom of the page.
- A status window will appear, displaying the progress of the importing of the JSON file. When all columns are green, the import is complete.
- Test the import, immediately upon completion, to ensure proper functionality.