Changes

Auto Loader

17 bytes added, 14:57, 17 September 2019
no edit summary
: [[Image:Auto5b.png|thumb|none|400px]]
 
====Activate Autoloader====
Enable this check box for the Autoloader to execute.
: [[File:Connectiontypes.PNG|thumb|none|400px]]
Select a connection type and complete the ''Schedule'' section below to specify the launch times of the autoloader everyday.
 
[[Image:External-Schedule.PNG]]
* Frequency - drop-down list that allows the user to select when the Autoloader should be run.
'''On File Upload''' - will process autoloader upon file upload
* Launch Hour - only displayed if Frequency is set to Scheduled. Sets the time on a daily basis that the autoloader will execute. This should be a comma delimited list of the hour values in 24-hour format.
 
e.g. 07,15,23
* '''Record Node Filter''' - Only presented when the File Type is XML.
====Defining the Column Mapping====
Once you have defined the number of fields, you define the field order to match the column order in the upload file.
* These fields would normally be used if you have extracted data from [[SmartSimple]] including those ID fields, updated the data outside of [[SmartSimple]] and wish to import the updated information.
'''NOTE:'''
1. If you wish to deactivate a user using the Autoloader then select the '''Disable User Login (use value of 1)''' Field option and ensure that the uploaded file has a value of 1 in the relevant cells.
* ''' Trigger On All Records ''' - check-box that is populated if you wish to have a workflow execute against all records, whether new records or updated records.
  ==='''HISTORY''' tab===<span style="color: #ff0000;">Available after February 2019 upgrade.</span> <br/>A new Autoloader feature that shows a new History information tab. The list includes the file name, user who uploaded the file, start time, end time, records added/updated and status of last run.  ==Updating Account Owners===
When you are updating company type information you can automatically associate an account field to a user field in order to establish “account ownership”. This section is only displayed at the bottom of the Autoloader page if you have set the Record Type to Company and Item to company.
''For example, if the imported account file contains an employee ID field, then this can be matched to the user table – providing each user with an employee ID field.''
===Updating Account Parent===
When you are updating company type information you can automatically associate an account field to a parent account field in order to establish “company hierarchy”. This section is only displayed at the bottom of the Autoloader page if you have set the Record Type to Company and Item to company.
Result: The Account records with a Company ID IN (278520,297733,316703) will have their Parent ID changed to 349238.
===Updating Event / Transaction Parent Company===
When you are updating company type information related to an Event or a Transaction you can automatically associate an account field to a transaction or event field in order to establish a parent for the transaction. This includes using Account standard fields.
If no matches exist then you can select the required action using the '''No parent matched action''' drop-down.
 
 
* Reject Record - record is not loaded into the system
[[Image:Auto10c.png]]
===Updating Parent Company===
When you are updating people type information you can automatically associate an account field to a user field in order to attach the user to the correct account. This section is only displayed at the bottom of the Autoloader page if you have set the Type to People.
[[Image:Auto10f.png]]
===Updating Event / Transaction Parent User===
When you are updating user type related to a Transaction information you can automatically associate a user field to a transaction field in order to establish a parent user for the transaction.
If no matches exist then you can select the required action using the '''No parent matched action''' drop-down.
 
 
* Reject Record - record is not loaded into the system
[[Image:Auto10f.png]]
===Branch, Company and Owner Custom Field Matching===
When you are updating UTA information you can automatically associate a standard field on the UTA with user and company fields in order to establish individual or organizational ownership. This section is only displayed at the bottom of the Autoloader page if you have set the Record Type to [[UTA]] and the Level to Level 1.
[[Image:Auto10e.png]]
===Updating Tracking Parent===
When you are updating UTA Level 2 or 3 information you can automatically associate a field on the level 2 with a field on the level 1, or associate a field on the level 3 with a field on the level 1, in order to establish a relationship between the entities.
[[Image:Auto10g.png]]
===Parent record match field ids===
This section allows for manipulation of the data prior to the Autoloader actually loading the data onto the system.
[[Image:AutoXML.png]]
 
 
 
==='''HISTORY''' tab===
<span style="color: #ff0000;">Available after February 2019 upgrade.</span> <br/>
A new Autoloader feature that shows a new History information tab. The list includes the file name, user who uploaded the file, start time, end time, records added/updated and status of last run.
 
 
 
 
==File Preparation==
* '''Login Name''' - username to allow access to the system
* '''Login Password''' - password to allow access to the system
 
Smartstaff
1,385
edits