Importing data from other programs (ThirdPartySync)

Summary:  Third Party Sync provides a fast and easy data import for your patients, their account and address information into Chiro or ChiroPad by using the data from your existing chiropractic software.  Third Party Sync imports your patients and is designed for the user to re-run the import as new patients are entered or changed in your existing chiropractic billing system.

Third Party Sync supports data exports from the Universal Data Export format as well as a variety of data exports from 3rd party chiropractic software vendors.  Data conversions have never been easier using Third Party Sync and best of all, our Third Party Sync utility is available for Chiro and ChiroPad users. 

* Some data conversion use proprietary ODBC drivers available from your chiropractic billing software vendor for a nominal fee.

Step 1:  Launch the ThirdPartySync.exe application from the Desktop or Start Menu shortcut of your computer.  (This program requires an existing installation of Chiro, ChiroPad, or ChiroOffice.)

Step 2:  Choose the appropriate data format for your other chiropractic software.  Patient data conversions include Auto-DOC, MBA Forte Systems Chiro 7000, DBConsultants AS/PC, HNA MPN Eclipse, Lytec, Medisoft and Addison Health Systems WritePad, which are all trademarks of their respective companies.

Step 3:  Choose the appropriate data export source file to import.

Step 4:  Choose the appropriate ChiroPad data file which will receive the imported data.

Step 5:  Press the "import" button to import your data.

Final comments:  As you add new patients into your billing system, you can re-run the Third Party Sync software to add new patients (or enter name/address changes of existing patients) to your existing Chiro/ChiroPad database.

---

Universal Data Export format comma/quote/new-line delimited import format for billing system integration

If your chiropractic billing software is not included in the dropdown list, to best serve chiropractic software users, we have published this import/export format table, such that software developers of 3rd party billing systems can provide a convenient level of integration for their users.  End users should contact their billing system vendors for them to provide this basic export and the resulting integration between their billing system and Chiro.

Users are encouraged to refer their billing system software companies to this page for these minimal data export specifications of patient general information.  The ThirdPartySync.exe import application is for registered Chiro and ChiroPad users.

Chiro supports import of the patient personal information from a 3rd party developer's export format described in the following table.  Also included below is an example file.  Developers also please make note of the support@chiropad.com source for assistance.  For accurate technical service, import and export questions from developers should be directed toward our support staff at this address.  Thank you.

A developer's role is simply to provide an output file as described below.  Chiro's import feature will manage the remaining import requirements.

Chiro's import feature will import a patient file from this comma/quote/new-line delimited format.  Chiro's import feature will add a new patient if the account number does not already exist in Chiro's data files.  The import feature will flush changes into Chiro's data files if the account number already exists.  This will ensure that changes to the patient's account, such as addresses and phone numbers, will be properly updated.

Once imported into Chiro's desktop data files, Chiro's ActiveSync libraries will synchronize the files on each Pocket PC device upon device connection.

The export file from a developer's application should be created with the name of "Chiro.txt" and placed in the path of your choice. 

Chiro import format "Version 04-19-2000":

Field Name	Description	Example
CHART	Up to 10 characters. This is the unique identifier of the patient's demographic record.  Required.	"1994-00238" or "A00569"
TITLE	Up to 8 characters.	"Mr.", "Miss", "Dr." or ""
FIRST	Up to 15 characters.  Required.	"John"
MI	Exactly 1 character.	"J" or ""
LAST	Up to 15 characters.  Required.	"Smith"
SUFFIX	Up to 8 characters.	"Jr.", "III", "D.C." or ""
ADDR1	Up to 35 characters	"970 Boston Ave." or ""
ADDR2	Up to 35 characters	"Suite 100" or ""
CITY	Up to 20 characters	"Tulsa" or ""
STATE	Exactly 2 characters	"OK" or ""
ZIP	Up to 10 characters.	"741014036" or ""
SEX	Exactly 1 character  Required.	"M" or "F"
DOB	Exactly 10 characters.  The hyphen is the only acceptable character between MM-DD-YYYY.  Required.	"01-01-1950"
ACTIVECHART	Up to 10 characters.  This may refer to an alternative chart number for the same patient if this account is inactive.	"2000-00238", "CAV882" or ""
STATUS	For legacy compatibility with ChiroPad 2.0 data, these are restricted to the entries listed in the example.  Required.	"Active", "Inactive", "PRN", "Dismissed", "Deceased", "Archive"
ADMITDATE	Exactly 10 characters.  The hyphen is the only acceptable character between MM-DD-YYYY.	"04-19-2000" or ""
PAYTYPE	Up to 10 characters	"Cash", "GeneralIns", "PI", "WC" or ""
PROVIDERID	Up to 5 characters.  Required.	"EHW", "0", "100", "JDC10"
HPHONE	Exactly 10 characters	"9185832259" or ""
EMAIL	Up to 35 characters	"support@chiropad.com" or ""
WPHONE	Exactly 10 characters	"4073327159" or ""
WEXTENSION	Up to 5 characters	"222" or ""
SSN	Exactly 9 characters	"386391989" or ""
MARITAL	For legacy compatibility with ChiroPad 2.0 data, these are restricted to the entries listed in the example.	"Single", "Married", "Divorced", "Widow", "Widower" or ""
ADDLCHART	Up to 10 characters.  Optionally used to cross-reference ChiroPad or Chiro data with an independent patient software system.	"2000-00381" or ""
XRAYFILE	Up to 10 characters.  Used to reference an x-ray file if separate file numbers are used.	"XR-5/6/00" or ""
DRVLICENSE	Up to 20 characters.	"OK C032-450-299-0" or ""
LASTMODIFY	Exactly 19 characters, in the format of "MM-DD-YYYY HH-MM-SS".  This is the date/time that this record was last added or modified, to the resolution of seconds.  Hours are noted as 00 to 23 hours in the users's local time zone.   Required.	"09-14-2000 14:36:41"

Sample quote/comma/new-line delimited file for Chiro's import:

To download sample file, click here:  Chiro.txt  Any questions? E-mail support@chiropad.com.  Thank you.
C++ Developers:  Note that each record ends with a new line character "\n", not carriage return new line "\r\n".
Visual Basic Developers:  Note that each record ends with a new line character vbLf, not vbCrLf.

"Version 04-19-2000" "1994-00238","Mr.","John","J","Smith","Jr.","970 Boston Ave.","Ste. 100","Tulsa","OK","74101-4036","M","01-01-1950","2000-00238","Active","04-19-2000","Cash","EHW","9185832259","support@chiropad.com","4073327159","222","386391989","Single","2000-00381","XR-5/6/00","OK C032-450-299-0","09-14-2000 14:36:41"