Importing Data into an Object

From Subscribe-HR Wiki Help
Jump to: navigation, search
 
(13 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
{{page.name: Core Human Resources: Importing Data into an Object - Subscribe-HR Wiki}}
+
{{page.name: Core Human Resources: Importing Data into an Object: Data Upload - Subscribe-HR Wiki}}
 
{{page.head: Importing Data into an Object}}
 
{{page.head: Importing Data into an Object}}
  
 
__TOC__
 
__TOC__
  
−
==Importing Data==
+
==Data Import Tool - Data Upload Tool==
−
The Excel Data Uploader allows clients to up-load data directly into the Subscribe-HR System. It is an extremely convenient and fast way to import data from excel to the Subscribe-HR system. Validation is available so that, prior to import, if there is an error made, such as incorrect date time format, empty mandatory fields, incorrect email format, you can go back to the spread sheet to perform and update rather than having to execute this process in the Subscribe-HR system. The validation occurs in the Excel Spreadsheet. Please ask your Account Manager or send a request through the SupportZone to access the Excel Plugin file so you can download it and set-up the "Add-In".
+
−
<br>
+
−
<br>
+
  
−
===Data Upload Process Excel "Add-In" - New Data===
+
The Data Import Tool allows you to import a .csv file to create new records, or update existing records. The tool can be accessed via the List All app.
−
There are three Steps to follow when using the Excel Data Uploader.
+
 
−
* Clients need to login using their normal Subscribe-HR system account user name and password. To access the login area, locate the "Ädd-Ins" option at the top of the Spreadsheet, after you have installed the "Ädd-In" using the relevant file.  
+
===Importing New Records===
−
* Click the Export button (located on the top left of screen" to select which Objects or Related Objects you want to use in the import. Once you have selected Parent Objects and Related Objects, you can select the fields you would like to add into the Excel Spreadsheet so that these fields can be used / populated so that the final import can take place. Please note, the spreadsheet will validate the Subscribe-HR Fields to ensure that data integrity is maintained. You can select Multiple Related Objects and the fields that relate to them.  
+
 
−
* After inserting or updating data in spread sheet, click the "Import and Update" button to import the data to Subscribe-HR.
+
To create new records using the Data Import Tool:
−
* IMPORTANT: You can Leave the ID Column in the Spreadsheet blank. Subscribe-HR will generate them for you. If you try and type and ID in here manually, no entry will be saved
+
=====Import Data Page=====
 +
# Navigate to the Import Page.
 +
# Select the '''File''' you wish to import. This file must be a '.csv' file. '.csv' cn be saved from Excel.
 +
# Select the '''Delimiter''' you chose when saving the excel file. This will most commonly be 'Comma Delimited'.
 +
# Select the '''Text Qualifier'''. This will most commonly be '"'.
 +
# Check the '''First Row Contains Column Names''' if the '.csv' file has the names of each column in it's first row.
 +
# Do '''not''' check the '''Perform Update''' box. This is for updating existing records.
 +
# If you are importing into the parent object, and also wish to import into the children objects with the same file, check the '''Advanced Import(Multi-Layered Data)''' checkbox.  
 +
 
 +
=====Map Fields Page=====
 +
On this page, you will need to scroll through and find each of the fields you will be importing into. Next to them will be the first row entry of each column. You will be able to select which column will populate into each field for each record.
 +
 
 +
If the '''First Row Contains Column Names''' was selected, the system will try to auto-match fields with columns of the same name.
 +
 
 +
If the '''Advanced Import(Multi-Layered Data)''' has been checked, all children objects of the chosen object will be visible beneath the parent objects fields. You can include a child object by selecting the checkbox on the right of that object. All fields for this object will now appear, and have to be mapped.
 +
 
 +
'''Note''': All fields with a red asterisk(*) must be mapped.
 +
 
 +
=====Preview First Record=====
 +
This page will allow you to preview the first record before you import the file. It is an opportunity to review the data mapping that has been selected.
 +
 
 +
Once you have confirmed the preview is correct, press the Import button to import the data.
 +
 
 +
 
 +
===Updating Existing Records Records===
 +
 
 +
To update existing records using the Data Import Tool:
 +
=====Import Data Page=====
 +
# Navigate to the Import Page.
 +
# Select the '''File''' you wish to import. This file must be a '.csv' file. '.csv' cn be saved from Excel.
 +
# Select the '''Delimiter''' you chose when saving the excel file. This will most commonly be 'Comma Delimited'.
 +
# Select the '''Text Qualifier'''. This will most commonly be '"'.
 +
# Check the '''First Row Contains Column Names''' if the '.csv' file has the names of each column in it's first row.
 +
# Check the '''Perform Update''' box. This is for updating existing records.
 +
# If you are importing into the parent object, and also wish to import into the children objects with the same file, check the '''Advanced Import(Multi-Layered Data)''' checkbox.
 +
 
 +
=====Map Fields Page=====
 +
On this page, you will need to scroll through and find each of the fields you will be importing into. Next to them will be the first row entry of each column. You will be able to select which column will populate into each field for each record. '''You must have the IDs of the parent records in the '.csv' file, and they must be mapped'''.
 +
 
 +
If the '''First Row Contains Column Names''' was selected, the system will try to auto-match fields with columns of the same name.
 +
 
 +
If the '''Advanced Import(Multi-Layered Data)''' has been checked, all children objects of the chosen object will be visible beneath the parent objects fields. You can include a child object by selecting the checkbox on the right of that object. All fields for this object will now appear, and have to be mapped.
 +
 
 +
'''Note''': All fields with a red asterisk(*) must be mapped.
 +
 
 +
=====Preview First Record=====
 +
This page will allow you to preview the first record before you import the file. It is an opportunity to review the data mapping that has been selected.
 +
 
 +
Once you have confirmed the preview is correct, press the Import button to import the data.
  
  
−
===Import or Update Data From Excel Spreadsheet===
 
−
Import or Update is used if there is already data that exists in the Parent Object / Related Object. Please ensure you have installed the Excel "Add-In" Uploader.
 
−
* In the Excel Spreadsheet, click export, the data that exists in Parent Object/s - Related Object/s will be export out into the Spreadsheet, including the ID's.
 
−
* To perform an Update simply type over the data in the row/s that you would like to update and Click "Import / Update"
 
  
 
<br>
 
<br>
 
[[File:subscribehr_logo.gif]]
 
[[File:subscribehr_logo.gif]]

Latest revision as of 04:41, 29 October 2021

Data Import Tool - Data Upload Tool

The Data Import Tool allows you to import a .csv file to create new records, or update existing records. The tool can be accessed via the List All app.

Importing New Records

To create new records using the Data Import Tool:

Import Data Page
  1. Navigate to the Import Page.
  2. Select the File you wish to import. This file must be a '.csv' file. '.csv' cn be saved from Excel.
  3. Select the Delimiter you chose when saving the excel file. This will most commonly be 'Comma Delimited'.
  4. Select the Text Qualifier. This will most commonly be '"'.
  5. Check the First Row Contains Column Names if the '.csv' file has the names of each column in it's first row.
  6. Do not check the Perform Update box. This is for updating existing records.
  7. If you are importing into the parent object, and also wish to import into the children objects with the same file, check the Advanced Import(Multi-Layered Data) checkbox.
Map Fields Page

On this page, you will need to scroll through and find each of the fields you will be importing into. Next to them will be the first row entry of each column. You will be able to select which column will populate into each field for each record.

If the First Row Contains Column Names was selected, the system will try to auto-match fields with columns of the same name.

If the Advanced Import(Multi-Layered Data) has been checked, all children objects of the chosen object will be visible beneath the parent objects fields. You can include a child object by selecting the checkbox on the right of that object. All fields for this object will now appear, and have to be mapped.

Note: All fields with a red asterisk(*) must be mapped.

Preview First Record

This page will allow you to preview the first record before you import the file. It is an opportunity to review the data mapping that has been selected.

Once you have confirmed the preview is correct, press the Import button to import the data.


Updating Existing Records Records

To update existing records using the Data Import Tool:

Import Data Page
  1. Navigate to the Import Page.
  2. Select the File you wish to import. This file must be a '.csv' file. '.csv' cn be saved from Excel.
  3. Select the Delimiter you chose when saving the excel file. This will most commonly be 'Comma Delimited'.
  4. Select the Text Qualifier. This will most commonly be '"'.
  5. Check the First Row Contains Column Names if the '.csv' file has the names of each column in it's first row.
  6. Check the Perform Update box. This is for updating existing records.
  7. If you are importing into the parent object, and also wish to import into the children objects with the same file, check the Advanced Import(Multi-Layered Data) checkbox.
Map Fields Page

On this page, you will need to scroll through and find each of the fields you will be importing into. Next to them will be the first row entry of each column. You will be able to select which column will populate into each field for each record. You must have the IDs of the parent records in the '.csv' file, and they must be mapped.

If the First Row Contains Column Names was selected, the system will try to auto-match fields with columns of the same name.

If the Advanced Import(Multi-Layered Data) has been checked, all children objects of the chosen object will be visible beneath the parent objects fields. You can include a child object by selecting the checkbox on the right of that object. All fields for this object will now appear, and have to be mapped.

Note: All fields with a red asterisk(*) must be mapped.

Preview First Record

This page will allow you to preview the first record before you import the file. It is an opportunity to review the data mapping that has been selected.

Once you have confirmed the preview is correct, press the Import button to import the data.



Subscribehr logo.gif

Retrieved from "https://wiki.subscribe-hr.com.au/index.php?title=Importing_data_into_an_object&oldid=9509"