Import Venues in Bulk (simplified)

There are two files to download to support your import, there is a reference spreadsheet which you can look at to understand the import options, and there is an import template which you will edit and fill with your import data.

1. Please download our reference Import Profile here to view all of the options for your import file:
   

   1. All mandatory fields are shown in Red

   2. All optional fields are shown in Grey

   3. This file is a reference file only
      
      

2. Please download our blank Import Template here (this is the file you will add your import data into):
   
   

1. Using the 'EXAMPLE Venue Import Template’ file as a reference, add your Venue data into your 'BLANK Venue Import Template’ file

2. The table below outlines each column that you can include in your BLANK import file:

Column	Description	Format	Rules
ResourceType Mandatory	This is the type of the Venue Resource Open	Text	Available options: External Venue In-House Venue
ResourceTypeID Mandatory	The Resource Type ID You can find this by going to Profile>Administration> Resource Type and then adding the ‘ID’ column to the DataGrid Open	Text	This must match to an existing Resource Type ID in your platform This is usually External Venue = extern4j5i In-House Venue = inhous93ku
ResourceLabel Mandatory	The Name of the new Venue you are importing   Open	Text
CompanyID Mandatory	The Account ID of the Training Provider your new Venues will fall under You can find this by going to the Accounts DataGrid and adding a filter for Training Providers Open	Text	This MUST match an existing ID within the Platform Please see our dedicated page on how to create filters The filter you would require is Industries ID > Is In > Training Provider
CompanyName Mandatory	This is the Name of the Training Provider you want your Course Template to be associated with Open	Text
Capacity Mandatory	This is the capacity of the Venue and how many people it can hold Open	Number
MappedIDType Mandatory	This is the ID that is used to identify the type of record that would be associated with the Venue Open	Number	This will always be ‘10’ for Venues

1. Once you have all the information you require within your import file, you can then save it as a .csv file

   Open

   

    

2. Within Excel, click the ‘File’ option in the top left-hand corner

   Open

   

3. Click ‘Save as’

   Open

   

    

4. Using the drop-down box under the file name, select CSV (comma delimited) (*.csv) and name your file (for example ‘New Venue Import’)

   Open

   

5. Click the ‘Save' button to complete the Save

   Open

   

Your Import file has now been saved, ready for importing.

1. Open the ‘Administration’ menu from the 'Profile' options at the top-right of your platform

   Open

   

    

2. Scroll down the page until you find the ‘Import Profiles’ menu option
   The menu is in alphabetical order

   Open

   

3. Click on the ‘Import Profiles’ option to be taken to the Import Profiles page

   Open

   

4. Click the ‘New Profile’ button at the top right corner of the page to create a new Import Profile

   Open

   

    

5. Provide a ‘Profile name’ for your Import Profile
   We advise providing your Profile with a unique name so that's easily identifiable

   Open

   

6. Select ‘Course Date’ as your import ‘Destination’, this lets the platform know that you will be importing Course information

   Open

   

7. The next step is to upload the .csv file that you created and saved earlier, click the ‘Choose file’ button and select the file from your saved location

   Open

   

8. Leave the ‘Header Label Row’ set to '1', this tells your platform that the column headings of your import are in the first row

   Open

   

    

9. Click the ‘Next ->’ option at the top right of your page to proceed to the column mapping step for your Import Profile

   Open

   

10. In the column mappings step you will match each column in your import file (Source column) to a Venue setting in your accessplanit platform (Destination column), this will define where the information in your import file will be imported to and displayed in your platform, a lot of the destination columns will be pre-populated for you!

    Open

    

11. If you see ‘IGNORE' within the 'Destination Column’, you will need to select the correct column from the drop-down options
    Leaving it as IGNORE will mean the Platform will ignore this column in the file when running the Import Job

    Open

    

12. When running an Import, your platform needs to know which column(s) can be used to uniquely identify each row, this is important as the importer supports both creating Venues and updating Venues, if each row is not uniquely identified by its key columns there is a risk that the existing Courses will overwritten with the details of the new Courses. Use the ‘Key column' field to select 'Yes’ for your unique identifiers.

    Open

    

     

13. Click the ‘Finish’ button at the top right of your page to complete your Import Profile

Open

14. Click the ‘OK’ button to return to the ‘Import Profiles’ page

Open

Your Import Profile has now been created

1. Open the csv file with all your data and check you are happy with the file

   Open

   

2. Within your accessplanit platform, open the ‘Administration’ menu from the ‘Profile’ options at the top-right of your platform

   Open

   

    

3. Scroll down the menu and click ‘Import Jobs’, the menu is in alphabetical order

   Open

   

    

4. Click on the ‘Import Jobs’ option to be taken to the Import Jobs page

   Open

   

    

5. Click ‘New job’ in the top right-hand corner

   Open

   

6. Select your Profile from the drop-down menu. This is the name of the Profile created in the step above. In this case, it is ‘Venue Resources - New Venues’

   Open

   

7. Select the ‘File’ you wish to upload, this is the original import file you created and saved earlier

   Open

   

8. The ‘Initial State’ option is where you can choose to Import now or put the Import on Hold if needed

   Open

   

    

9. Click the ‘Upload’ button to start your Import Jobs

   Open

   

    

10. Once you have uploaded your Import Job, it will show the Import Job uploading

    Open

    

    a. ID - This is the ID number of the Import Job
    b. Profile - This is the name of the Profile used for the Import
    c. Filename - This is the name of the Import file uploaded
    d. Status - This is the status of the Import Job, it will begin as ‘Queued’ but will change to ‘Completed’ once the Import has finished
    e. Due - This is when the Import is due to run
    f. Started - This will be blank to begin with, once the Import Job has started, the Start date and time will populate.
    g. Completed - This will be blank and will populate once the Import has been completed
    h. Row Count - This shows how many rows are to be imported
    i. Processed - This will show the number of rows that have been imported and will change as the Import runs.
    
    

11. Your Import will have the status of ‘Completed’, the Completed time and date will be populated and the Processed' column number will match the same number as the ‘Row Count' column

Open

12. There is a section at the end of the Import named ‘Actions’. Here you will find the option to ‘Show Errors’, ‘Restart’, ‘Stop’ and ‘Cancel’ your Import

Open

13. You can use the ‘Show Errors’ button to see if anything has stopped your Import from working correctly, if the Import Errors page is blank, this means the data in your import file hasn’t failed any validation checks

Example of an Import with no errors:

Open

Example of an Import with Errors:

Open

The Import Errors page shows you which rows have failed

14. The ‘Stop’ and ‘Restart' buttons can be used while your Import Job is processing, to pause and restart your import, please note that it can take a few seconds for these to be actioned after you have clicked them

Open

15. We do not recommend using the 'Delete’ button for your Import Jobs unless absolutely necessary