How To: Import Notes

How To: Import Notes

 

Warning: We highly recommend and always suggest that you run an Import Job on your test platform first, before you upload the data on live.

To learn how to complete an Import Job, click here.

Creating the Import Profile

First, you need to create an Import Profile to user for the upload. Click here for more information on how to do this.

For Notes you will need to create a Notes Destination.

The following fields will need to be Key Fields for the Notes Profile if you are importing one note against your object:

  • Mapped ID - This is the ID of what you are wanting to import against. For example, the Course Date ID or the Company ID

The following fields will need to be Key Fields for the Notes Profile if you are importing multiple notes against your object:

  • Mapped ID - This is the ID of what you are wanting to import against. For example, the Course Date ID or the Company ID

  • Note - This is the content of the Note

The following fields are also mandatory for this import but not Key Fields:

  • Mapped ID - This is the ID of what you are wanting to import against. For example, the Course Date ID or the Company ID

  • Mapped ID Type - This is the type of object you are wanting to import against. For example, a Course Date or Company. This field is a constant value and you must enter the numerical value. See below for your options:

    • 1: User

    • 3: Company

    • 7: Award

    • 8: Course

    • 12: CourseDate

    • 13: UserCourseDate

    • 17: Invoice

    • 21: Opportunity

    • 22: UserAward

    • 25: Resource

    • 27: ResourceRequirement

    • 29: Placeholder

    • 34: Order (Purchase)

  • User ID - This is the ID of the User that owns the note

  • Note - This is the content of the Note

  • Note Type - This is the ID of the Note Type (Not the label) (For assistance in finding your note type ID’s, please contact the support team)

Filling in the Import File

Then, you need to create your import file that you will use to upload the data. Below is a sample file showing you how to format it:

Notes.csv

All imports should be uploaded in a CSV format, as they lack formatting that would otherwise be included within the file.


Contact Our Team

If you can't find what you're looking for, access our Support Portal, and our team of experts will be happy to help!

Follow Us

Facebook|height=20 LinkedIn|height=20 Instagram|height=20 Twitter|height=20

Copyright © 2025 accessplanit.

Social media icons by icons8.com