Importing Data Overview

Importing Data Overview

Under Settings there is an option to import various kinds of files into ChartCaddy. In general the system imports data from a spreadsheet in CSV or XLS format, but certain import operations require specific import file times. When importing a spreadsheet the system expects the first row to be the column headers, and uses the headers to determine what data is in which column. See the later sections on more information about what information can be imported, and what the headers of each type of file should be. Columns of generic data can be added manually to a file before being imported to, for example, specify valid facilities or programs for clients. When a column type says that a string list is expected, it means that you can list multiple items separated by semicolons (preferably) or commas.

When exporting data from Milan, please be aware that most of the reports allow three generic columns of various types of data. This presents two major issues. First, because the system uses column headers to determine what data is which column, before importing the file into ChartCaddy from Milan you usually need to edit the first line in the file appropriately. Secondly, in order to get all information possible out of Milan it is usually necessary to export a report multiple times and then either A) import each file individually or B) combine all the data into one file. In general, due to export bugs, importing client address information from Milan is imprecise and not recommended. Milan also allows quotes in the data and exports the data in CSV which sometimes causes problem, so it is recommended that you view the data first in an application to make sure it looks right before importing.


Name
Description
Generic ClaimItem XLS
Import a generic spreadsheet of claim items.
Generic Client XLS
Import a generic spreadsheet of clients.
Generic User XLS
Import a generic spreadsheet of users.
Milan PDF
Import a Milan encounter, service plan, or chart in PDF format.
Millennium XDP
Import a Millinium service plan.
ODMHSAS Extract XLS
Import an ODMHSAS CDC or PriorAuth extract spreadsheet.
OKDHS HH XLS
Import an OKDHS client or claim item export spreadsheet.
Therapy Notes PDF
Import Therapy Notes encounter, service plan, or chart in PDF format.