User Guide Cancel

Unable to upload CSV

  1. Learning Manager User Guide
  2. Introduction
    1. New features summary
    2. Release Notes
    3. System requirements | Adobe Learning Manager
    4. Adobe Learning Manager reference site (ALM reference site) package for AEM Sites
    5. Learning Manager compliance to GDPR
    6. Accessibility in Learning Manager
    7. Support for custom domain
  3. Get Started
    1. Getting started as Administrator
    2. Getting started as an Author
    3. Getting started as a Learner
    4. Getting started for Managers
    5. Getting started as an instructor in Learning Manager
  4. Administrator
    1. User log in
    2. Add users and create user groups
    3. Add classroom locations
    4. Create course modules, instances, and learning programs
    5. Learning Manager Content Catalog
    6. Content marketplace
    7. Reports
    8. Learning Paths
    9. Learning plans
    10. Manage Learning Manager orders and billing
    11. Job Aids
    12. Certifications
    13. Catalogs
    14. Add users in bulk
    15. Peer accounts
    16. Create and modify skills and levels
    17. AI-based recommendation of courses
    18. Gamification
    19. Customize learner homepage
    20. Badges
    21. Color themes
    22. Learner transcripts
    23. Waitlist & attendance management
    24. Fluidic player
    25. Announcements
    26. Email templates
    27. Adobe Connect integration
    28. Settings
    29. Notifications
    30. iPad & Android tablet users
    31. Getting started as Administrator
    32. Purge users
    33. Tags
    34. Learning Manager Content Catalog
    35. Custom roles
    36. Catalog labels
    37. xAPI in Learning Manager
    38. Monitoring and moderating Social Learning as an admin
    39. Enable full control of shared catalog
    40. Map skill with skill domains
  5. Integration Admin
    1. Migration manual
    2. Learning Manager Connectors
    3. Integrate Learning Manager with AEM
    4. Install Salesforce package in Learning Manager
    5. Install Microsoft Teams connector
    6. Application developer manual
    7. Learning Manager App for Salesforce
    8. Settings
    9. Manage custom roles via CSV files
  6. Authors
    1. User login
    2. Content library
    3. Creating, modify, and publish courses
    4. Catalogs
    5. Job Aids
    6. Adobe Connect integration
    7. Add learning objects in different locales
    8. User notifications
    9. Email templates
    10. How to choose course modules?
    11. Preview as learner
    12. Settings
    13. xAPI in Learning Manager
  7. Instructor
    1. Modules
    2. Managing learners for your session
  8. Learner
    1. Log in
    2. Profile Settings
    3. Catalogs
    4. Courses
    5. Fluidic player
    6. Learning Programs
    7. Certifications
    8. Job Aids
    9. Badges
    10. Skills & Levels
    11. Gamification
    12. User notifications
    13. Announcements
    14. Waitlist & attendance management
    15. Learning Manager app for Salesforce
    16. Adobe Connect integration
    17. Learner App for mobiles and tablets
    18. Social Learning in Learning Manager
    19. Adobe Learning Manager desktop application
    20. Learner home page
    21. Share to Social Learning
    22. System requirements | Adobe Learning Manager desktop application
  9. Manager
    1. User log in
    2. Manager dashboard
    3. Reports
    4. Learning Objects
    5. User notifications
    6. Learner transcripts
    7. Settings
    8. iPad & Android tablet users
  10. Frequently Asked Questions
    1. Frequently Asked Questions for Administrators
    2. Frequently Asked Questions for Authors
    3. Frequently Asked Questions for Instructors
    4. Frequently Asked Questions for Managers
  11. Knowledge Base
    1. Unable to log in to Learning Manager
    2. Learning Summary does not display current data
    3. Unable to upload a CSV
    4. Generate a HAR file
    5. L1 feedback auto popup does not appear
    6. Unable to view certain courses under catalog while creating a Certification
    7. Unable to view certain course under catalog while creating a Learning Program
    8. Issues in retiring a Learning Program
    9. Unable to assign a badge
    10. Session expires in Learning Manager
    11. Unable to search a course
    12. Troubleshoot migration issues
    13. Troubleshoot Learning Manager app issues
    14. Users get auto deleted in Learning Manager
    15. Publishing issues in the EU domain
    16. Unable to register as external user
    17. Okta Active Directory integration with Adobe Learning Manager
    18. Unable to view learners in a course
    19. Unable to view calendar
    20. Module is not marked complete after completing a course
    21. Unable to achieve a skill after completing a course
    22. Radio buttons are missing
    23. Unable to view file submissions in Learning Manager

Error: Data truncation: Data too long for column

When trying to upload a CSV in Adobe Learning Manager, you see the following error message.

Cause

The error happens if the data present in the specified column exceeds the character limit that is defined for the column.

Resolution

  • Open the CSV.
  • Check the data in the column that is mentioned in the error.
  • If there is any value that is large (for example, greater than 60 characters), change the value to correct the data.

Error: First column in the CSV displays a special character

You are unable to upload a CSV because the first column displays a special character when mapping the columns.

Cause

The issue occurs when the CSV is saved as a UTF-8 format in Excel. When you save a CSV in Excel as UTF-8, the file is saved in a UTF-BOM format. You can either verify this using Notepad++ or when you upload a CSV to Prime, while mapping the columns, the first column displays a special character.

Resolution

  • A: Saving via Excel:
    1. Open the CSV in Excel.
    2. Save the file as a normal CSV.
  • B: Saving via Notepad or Notepad ++:
    • Open the CSV in Notepad or Notepad++.
    • Save the file in a UTF-8 format.

Error: Email address of user already present in the system

You are unable to upload a CSV because CSV processing has failed. You see the error message below:

Cause

This issue occurs if there is a user who is already present in the system with the same email address or UUID.

Resolution

Scenario 1

Accounts on which UUID is not enabled.

In this scenario, there are two reasons for this error:

  1. The user that you are trying to add is a Manager of an External profile. To resolve this, open the external profile the user is a part of, select the user, click Actions > Assign Role > Manager, and change the Manager of the profile.
  2. The user that you are trying to add has been purged. In this scenario, you will not be able to add the user with the same email address until the purge process is completed. As a workaround, add the user with a secondary email address to provide access to the platform. Once the purge process is complete, edit the user and change the email address to the correct email address.

Scenario 2

UUID-enabled accounts.

For UUID-enabled accounts, this issue can occur if a user has been assigned a UUID that is already being used by another user on the account or if the user has a different email address.

For example, let there be two users, A and B, with email addresses,  a@xyz.com and b@xyz.com with UUID 1 and 2 respectively.

Now, if you upload a CSV that has user A's UUID as 3 and user B's UUID as 2, then you will see an error.

To resolve this issue, you must have the same email address and UUID for the user on the CSV and the system. 

Adobe logo

Sign in to your account