IDI Software – FAQs
Importing IDI Data
IDI Profiles
- Selecting "Respondent ID" for a group profile doesn't include everyone in the group.
- Combining multiple groups for one group profile.
- Combining individuals from multiple groups for one group profile.

- I wasn’t able to import my online IDI data into the IDI software. I got the message "Field 'F1; doesn’t exist in destination table 'IDI_Main.'" What does that mean?
That means you clicked the "Import Groups – Excel" button in the bottom right corner of the Import / Export Select window. That button can be used only for the electronic exchange of data files between IDI programs.
To import the online IDI data, click the "Excel Worksheet" button on the left side of the window under "Import Manually Entered IDI Individual Group Data."
- While trying to import my online IDI data into the IDI software, I got the message "External table is not in the expected format." What does that mean?
Although the import button says "Excel Worksheet," the data needs to be saved as an "Excel Workbook." Open the file on your A-drive and select "Save As." At the bottom of the window next to "Save as type:" select "Excel Workbook" and click "Save." Make sure it is saved back onto the A-drive. You will then be able to successfully import the file when you return to the IDI software.
- I tried to run a Group Report by selecting "Respondent ID" in the Print Option window, but didn't get the whole group. I know there were more assessments completed. What happened to the rest of the group?
It is not uncommon for people to leave the Identification Number field blank when completing the online IDI. When you select "Respondent ID" in the Print Option window you see only the profiles of the people who entered something into the Identification Number field. To make sure you have everyone in the group, select "Respondent Name" in the Print Option window.
- I would like to combine multiple groups and run a Group Report. Is that possible?
Yes. To run a Group Report for multiple groups:
- Click "Create New Group" in the main window
- Individually select the groups you want to include in the "Select Groups" field at the top of the window. Each time you select a group, the users in that group will be added to the list at the bottom of the window.
- Click "Create New Group" and choose a group name.
- Click "Exit" and you will be returned to the main window.
- I have 20 people that were in 4 different groups when they took the IDI. Is there a way I can run a Group Report of those 20 people?
Yes. To run a group report like this:
- Click "Create New Group" in the main window
- Individually select the groups you want to include in the "Select Groups" field at the top of the window. Each time you select a group, the users in that group will be added to the list at the bottom of the window.
- Mark the people you want included by placing a check in the boxes in the Select column of their records.
- Select "Create New Group Based on Selected Items Only" and choose a group name.
- Click "Exit" and you will be returned to the main window.

