Bulk transfer
Menu location: Maintenance menu, System Administration, Bulk Transfer
See also: Bulk Transfer Details
The Bulk Transfer feature allows you to import certain master file data from external files to reduce manual data entry mistakes. It supports the ability to make multiple changes at once.
The feature can import and export data for the Facility master, Physician master, Physician Auto-Entry master, and Payer Alias master. The key to the transfer is a delimited file of data. You can create the delimited files using a script or third-party software like as Microsoft® Excel. For example, use the feature to export existing system, edit the data in Excel, and then import the updated file. Refer to the file specification for details on the format of the delimited files. You can take advantage of "search and replace" features in Excel to make mass updates.
Facility/Physician transfer allows you to select the delimiter for the fields (pipe or tab) and whether or not to include a header row that names each column.
When exporting files, do not open the files in Internet Explorer. IE will add <CRs> that will make the data useless. Use Download files to download the exported data.
Make multiple changes
First, follow these steps to export the existing system master data:
- Select the Export tab.
- Select the Field Delimiter (Pipe or Tab).
- Select the Header Row checkbox, if you want this information .
- Select the master file data you want to export and update.
- Click OK. The system creates a Bulk Transfer file (.txt file) available from Download Files.
- Navigate to the Reports menu, Download Files option.
- Select the file(s).
- Click Download Files. The system creates a .zip file that you can open and save locally.
Open the file in a third-party software application such as Excel. Follow these guidelines to instruct the system to add, delete, or the update records upon import:
- To remove a record, add the letter "D" within the Delete parameter.
- To update an existing record, locate the entry and edit the information. The system uses the ID value to determine which record to change.
- To add a new record, enter a new row. The system compares the ID value between the spreadsheet and the database. It adds a new record whenever it cannot find a match for an existing ID.
- Check the file specifications for details about adding, deleting, and editing records.
Follow these steps to import the changes using the Bulk Transfer tool:
- Select the Import tab.
- Select the Field Delimiter (Pipe or Tab).
- Select the Header Row checkbox, if your file has a header row.
- Click Browse next to the master file data you want to import. The system opens a window. Navigate to the file for upload, and select it.
- Click Open. The Bulk Transfer feature displays the path and file name.
- Click OK. Check the Job Queue to monitor system progress.