Imports Overview

Imports Overview

Learn about Imports


Search the Knowledge Base


Β 

About Imports

Imports allow you to upload and manage large volumes of data within accessplanit quickly and efficiently using a structured file. By mapping your data to the correct fields through an Import Profile, you can create new records or update existing ones in bulk, without the need for manual data entry.

This makes imports a powerful tool for saving time, reducing human error, and keeping your system accurate and up to date, especially when working with large or regularly changing datasets.

Please Note!
The Import tool is available to Super Administrators, if you are not able to access the Import options, please speak to a member of the accessplanit team.


Benefits

Here are the benefits of using Imports

Time Saving

Imports let you upload hundreds or thousands of records in one go instead of entering them manually. This dramatically reduces admin effort and frees up time for more valuable tasks.

Reduces human error

Manual data entry can be prone to mistakes, typos, missed fields, and inconsistencies. Imports use structured data and predefined mappings, helping ensure accuracy and consistency across your system.

Enables bulk updates

You can update large sets of existing records at once (e.g. contact details, course information, or statuses), rather than editing each one individually. This keeps data current with minimal effort.

Supports data consistency and standardisation

By using import profiles and predefined formats, you ensure data is entered in a consistent way every time. This improves reporting, searching, and overall data quality.

Makes it easy to integrate external data

Imports allow you to bring data in from other systems (e.g. spreadsheets, CRMs, finance tools). This helps keep everything aligned without needing complex integrations.

Β 


Key Terms and Glossary

Import

The process of uploading data into the system using a structured file (usually CSV) to create or update records in bulk.

Import Profile

A saved configuration that defines how columns in your import file map to fields in the Platform, allowing consistent and repeatable imports.

Import Job

A single instance of an import being run. An import job tracks the progress and outcome of the import, including how many records were processed, successfully imported, or failed, along with any associated error reporting.

Key Field

A field used during an import to uniquely identify a record in the system (such as an ID or email address). Key fields are essential for determining whether a record should be updated or if a new one should be created.

CSV File

A CSV file (short for Comma-Separated Values) is a simple file format used to store data in a table-like structure, making it ideal for importing information into systems.

Simplified Imports

An import type that uses only essential fields to quickly create or update records with minimal data preparation.

Comprehensive Imports

An import type that includes a full set of fields, allowing detailed creation and configuration of records within the platform.

Β 


Additional Information

Please note
If you are completing a new import, we always recommend importing a sample file first with only a few rows of data, so that you can verify there are no errors with the Import Profile.

The columns on your Import profile must match exactly to the columns within your CSV file for your Import Job. If they don't match correctly, your import will not work.


What can you Import?

Below is a list of import destinations within accessplanit. We’ve ordered these based on our recommended import sequence, particularly if you are implementing accessplanit for the first time, carrying out a major data cleanse and reupload, or completing a reimplementation.

Destination

Used for

Destination

Used for

Company Group
(Account Group)

Used to create and maintain your Account Group structure, allowing you to organise Accounts into logical groupings (e.g. parent companies or departments) for reporting, management, and permissions.

Company
(Account)

Used to create and update Accounts within the platform, storing key organisational details such as company information, contact details, and relationships to account groups.

User

Used to create and manage individual Users within the system, including their personal details, login information, and their association to Accounts.

Trainer Resource

Used to create and update Trainer records, defining individuals who can be assigned to deliver Courses and linking them to the wider resource pool.

Venue

Used to create and manage physical or virtual training locations where Courses take place, including address details and capacity information.

Venue Resource
If required

Used to define specific resources available at a venue (e.g. rooms or equipment), allowing for more detailed scheduling and allocation.

Resource

Used to create and manage all resource types (e.g. trainers, venues, equipment), enabling them to be scheduled and assigned to Courses.

Resource Unavailability
If required

Used to record periods when a resource is unavailable, ensuring they are not scheduled for Courses during those times and improving scheduling accuracy.

Course Template

The first step in Course setup is used to create the core structure of a Course, including its name, duration, pricing, and key configuration settings.

Course Company

The second step in course setup is used to assign course templates to a specific training provider or company within the platform.

Resource Course
If required

Used to link resources to specific Course templates, defining which resources are eligible to be assigned to particular courses

Session Plan Item
If required

Used for sessional courses to define the structure and sequence of sessions within a Course, including timings and session relationships.

Course Date
(Course)

Used to schedule individual Courses, including dates, times, locations, and assigned resources.

Candidate
(Delegate)

Used to enrol Delegates onto scheduled Courses (classroom or webinar), or update their booking details and attendance information.

eLearning and Document Delegates
If required

Used to enrol Delegates onto eLearning or document-based Courses, managing participation outside of scheduled classroom sessions.

Award

Used to create and manage Awards or certifications that can be ΰ¦…ΰ¦°ΰ§ΰ¦œed through course completion.

User Award

Used to assign Awards or certifications to Delegates, recording their achievements and qualification history.

Opportunities

Used to create and manage sales Opportunities, helping track potential business, pipeline activity, and expected revenue.

Notes

Used to add or update Notes against records (e.g. users, accounts, courses), capturing additional context or internal communication.

Transaction
Optional

Used to import financial Transaction data linked to invoices, supporting accurate financial tracking and reporting.

User Manager
Optional

Used to define management relationships, specifying which users can manage other users, accounts, or account groups.

Permission record for a user
Optional

Used to assign roles and permissions to users, controlling their level of access and what actions they can perform within the platform.


Import Profiles

The Import Profiles area is where you create and manage templates that define how your data should be structured during the import process.

An Import Profile is essential when uploading data into accessplanit, as it controls how information from your source file (typically an Excel or CSV spreadsheet) is mapped to the corresponding fields within the platform. By setting up a profile in advance, you ensure that each column of your spreadsheet is correctly aligned to the right system field, helping to maintain consistency, accuracy, and efficiency when importing data.

Each individual Import Helpguide page will help you format your Import Profile for that Import Type

Import Jobs

The Import Jobs area is where you manage and schedule your data imports into the platform. This is where you can upload your prepared files and run your imports using the appropriate Import Profile, ensuring your data is processed correctly and efficiently.

Each import job provides a record of the import activity, allowing you to track progress, review results, and confirm whether records have been successfully created or updated within the system. This helps you maintain visibility and control over all data being brought into accessplanit.

Each individual Import Helpguide page does have a blank template to assist you with your Import Job

Β 

Please note
Important Info regarding special characters Č, Ε , Ε½ and Δ†:

If your organisation/business operates using Languages where the following special characters are present - Č, Ε , Ε½ and Δ† - and you wish to use the importer to upload content containing these characters to the platform - you will need to contact the accessplanit Support Team. Please raise a ticket via the Support Portal, available from the β€˜Help’ option in your platform.

image-20260417-085418.png

Β 


Where to find Imports

Please note
The Import tool is available to Super Administrators, if you are not able to access the Import options, please speak to a member of the accessplanit team.

  1. Select Profile and then Administration in the top right-hand corner

    image-20260416-103456.png

    Β 

  2. Using the search bar, search for 'Import Profiles'

    image-20260416-103551.png

    Β 

  3. This will open the Import Profiles menu

    image-20260416-103638.png
  1. Select Profile and then Administration in the top right-hand corner

    image-20260416-103456.png

    Β 

  2. Using the search bar, search for 'Import Jobs'

    image-20260416-103811.png

    Β 

  3. This will open the Import Jobs list

    image-20260416-103845.png

Β 


Import Management

Learn how to create and manage Imports in your platform:

Profiles

How To: Import Profiles

Β 

Comprehensive Imports

Import Users in bulk

Import Accounts in Bulk

Import new Courses in bulk

How To: Import Course Templatesarchived

Import Delegates onto Class and Web Courses in Bulk

How To: Import Delegates to an E-Learning or Knowledge Document course

Import Venues in Bulk

Import Trainers in Bulk

How To: Import Resources

How To: Import Resource Course

How To: Import User's Management of Users/Accounts/Account Groups

How To: Import Notes

How To: Import User Awards

How To: Import Awards

How To: Import Course Awards

How To: Import Job Roles to Users

Import Transactions in Bulk

Import Opportunities in Bulk

How To: Import Resource Unavailability

How To: Import Sessional Course Templates

Β 

Simplified Imports

Import Accounts in bulk (simplified)

Import Users in bulk (simplified)

Import new Courses in bulk (simplified)

Import Delegates onto Class and Web Courses in Bulk (simplified)

Import Venues in Bulk (simplified)

Import Trainers in Bulk (Simplified)

Import other Resources (simplified)

Β 

Update Imports

Import Course updates to existing Courses in bulk

Import Trainer or Venue updates to existing Courses in bulk

Import Course Cost updates to existing Courses in bulk

Β 

Troubleshooting

https://accessplanit.atlassian.net/wiki/x/AgAO6


FAQ’s

Is it possible to import course attendance data?

Yes, you would need to use the Delegates import module and set the delegate status to completed or no attend.

Please use the link below for a step-by-step guide for importing Delegate information.

https://accessplanit.atlassian.net/wiki/x/AYDH1w

Can I undo an import if I make a mistake?

Imports can’t be undone, so we recommend doing a 'Test run' first on your Sandbox Platform and keeping a backup of your original data before uploading.

Is there a limit to how much data I can import

While there’s no strict limit, very large files (e.g. tens of thousands of records) may take longer to process. Splitting large files into smaller batches is recommended if you experience issues.

Can I import custom fields?

Yes β€” if you have Custom Fields, you can include them in your import file as long as the field name matches the Platform within the Import file

Will Imports overwrite my data?

Yes, if you are updating data rather than adding new Data

Why do I need to complete a Course Template import and a Course Company import?

  1. The first Course Template import creates the Template itself

  2. The second Course Company import, maps the Course Template to your Training Provider.

You need to do both for the Course Template to be available to manage/view in your Course Templates DataGrid.


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