In AccuCampus it is very common to import information using CSV files, when importing profile-based information it is very important to make sure that the CSV Column-Heading (which are the Profile-question-Keys) match exactly the AccuCampus Profile-question-Key that were specified during the configuration of the "User Profile" module in the system, in this article, we review how to troubleshoot the process of importing profile-information if it fails.

For this article, we are importing a CSV file with profile-based information:

For example, we want to import this file you can see below, it has 4 columns, the first one is the user's email (with uniquely identifies the user) and the other 3 columns are profile-based columns. AccuCampus should locate that user in the system (using the email) and should record that user profile-answers matching the column-headings(which are the Profile-questions Key) to its own Profile-questions Key.

However, when we try to run the import AccuCampus launches an exception saying that one(or more) of the CSV columns(Profile-questions-Keys) does not match with a Profile-question-Key specified in AccuCampus. The error looks similar to this:

In this case, we can proceed by manually checking each Profile-question-Key in AccuCampus with our CSV column-heading,  or we can export all Profile-question-Keys from AccuCampus in another file for faster comparison, both methods are described below.

Method #1 is best used when you have a few profile-keys(columns in your CSV to be imported) so a manual search/comparison could tell what Key is misspelled/non-existent. If your CSV has many columns you should use Method #2. 

This method is best used when you have a few profile-keys(columns in your CSV-to-be-imported) so a manual search/comparison could tell what Key is misspelled/wrong/inexistent. If your CSV-to-be-imported has many columns you should use Method #2. 

1.1 Go to the User Profile module.

1.2 Select the questionnaire by clicking the name(if there is more than 1). In this example, we selected the first questionaire.

1.3- Go to the Form Designer section.

In the Form-Designer select each question (or only those that you need based on what you are importing) and click on "Edit"  so you can see the Profile-question-Key (to compare with your CSV-to-be-imported columns-headings). Here we are checking the "Degree-Seeking Status" question.

1.4 Compare the Profile-key(highlighted) with your  CSV-to-be-imported column headings and look for differences. 

Choose

1.5-Continue the same process for the other profile-questions.

This method is better used if you have many profile-keys so searching manually which key might be wrong could take a long time. For this method, we will export all our Profile-questions-Keys in a file so we can easily compare.

2.1 Go to the Advanced Options--> Export menu.

2.2- Select the highlighted option.

2.3 Select the first questionnaire(this process must be repeated for all questionnaires as needed)

2.4 Open the exported-CSV we have just created  in excel and copy this highlighted column(containing the Profile-questions-Keys) into a new clean spreadsheet:

2.5 Remove duplicate for easier comparison.

2.6- Check the clean list of Profile-questions-Keys VS your CSV-to-be-imported column headings to search for issues.

For this example, these are the 32 Profile-keys we got from this questionnaire,

Do the same with all questionnaires as needed.

Compare these values with the CSV-to-be-imported column headings, there must be one Key that does not match, in this example below the Profile-Key DEGSK is misspelled in the CSV-to-be-imported, changing the column with the correct value should solve the issue.

Test the import after fixing the problem.