Using the Workbook Converter
The iMIS Workbook Converter is a tool that reads and converts contact data from Excel spreadsheets, or a workbook, into iMIS. The Workbook Converter can be used to populate the iMIS database with the following information.
The data import process should consist of the following process:
- Review the following articles:
- Pre-conversion tasks
- Locating the Workbook Converter
- Preparing the workbook data
- Importing the workbook data
- Post-conversion tasks
Table 1: Viewing included and not included items when converting
| INCLUDED IN CONVERSION | NOT INCLUDED IN CONVERSION |
|---|---|
| - Contacts (people and organizations) - Historical activity - User-defined data - You can define multiple objects with all their properties. These objects are converted to panel sources that are accessible to IQA and the Panel Editor. - AutoPay enrollments | - Open orders/invoices/accounts receivable - Setup (products, events, dues) - Notes - Subscriptions (billing details on open items) - Lookup/validation tables - Change log - Passwords (can generate new based on email addresses) - Adhoc searches, reports and letter templates - Pictures - Transactions (such as fill event, donations, orders, and membership fees) |
