AccuCampus How do I troubleshoot the import of Profile information?

AccuCampus How do I troubleshoot the import of Profile information?

INTRO

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.


STEP BY STEP

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. 

1-Manually comparing the profile Key ID in AccuCampus with our failing import.

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.

Note:!! Please notice that maybe the profile-question does not exist or it was deleted recently and that is why it errors when importing because AccuCampus cannot find a profile-question with such ID, so it is not even a misspelling of the profile-question ID, is a non-existing profile-question.


2-Exporting current profile-keys to compare with failing import:

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.




Note:!! Please notice that maybe the profile-question does not exist or it was deleted recently and that is why it errors when importing because AccuCampus cannot find a profile-question with such ID, so it is not even a misspelling of the profile-question ID, is a non-existing profile-question.
​​​​

Test the import after fixing the problem.
    • Related Articles

    • How do I control which demographic information a user can edit in AccuCampus?

      This article explains how to limit users' ability to edit their own demographic information within AccuCampus. Note that this information may be included as part of a nightly import and so any changes a user would make would be overwritten each time ...
    • How do I create a new profile in AccuCampus?

      This article will explain how to set up User Profiles within AccuCampus. This is one of the first steps in setting up your AccuCampus account. User Profiles can have unlimited profile keys so any and all information can be imported for student users. ...
    • Accudemia: How do I import profile photos using ADX?

      INTRO  Using ADX you can import your user's profile-photo,  in this article we describe how to do this and how to troubleshoot the process to locate and fix any error we might have.  As a prerequisite, your photos must be in any common image format ...
    • How do I update a basic user profile in Accucampus?

      NOTE: There are two ways to navigate to a user profile – either from the main sidebar, or by using the search function at the top of the page. From the Main Sidebar From the Main Sidebar, hover over General. Click Users. Scroll through the list of ...
    • AccuCampus Reference Guide

      Engineerica Systems, Inc. P.O. Box 677096 Orlando, FL 32765-7096 Phone: (407) 678-0936 Fax: (407) 678-0287 www.engineerica.com Engineerica Systems, Inc. (“Developer”) has made every effort to ensure the accuracy of this document. Developer makes no ...