Difference between revisions of "Custom Field Import Wizard"

From SmartWiki
Jump to: navigation, search
 
(6 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
 
 
System Administrators are able to import custom fields and associated settings within any Custom Field Settings page.
 
System Administrators are able to import custom fields and associated settings within any Custom Field Settings page.
  
−
Each Custom Field settings page, whether UTA, contact or company specific, will have the Text Import tab.
+
Each Custom Field settings page, whether UTA, contact or company specific, will have the Text Import tab.
  
 
: [[Image:TextImport1.png]]
 
: [[Image:TextImport1.png]]
−
 
 
[[Category:Custom Fields]]
 
[[Category:Custom Fields]]
  
 
==Overview of how to use Custom Field Import Wizard==
 
==Overview of how to use Custom Field Import Wizard==
−
 
 
The import process consists of the following steps:
 
The import process consists of the following steps:
  
Line 19: Line 16:
  
 
4. Upload the data to SmartSimple.
 
4. Upload the data to SmartSimple.
 +
  
  
 
==Enter information into the Custom Field Import Wizard==
 
==Enter information into the Custom Field Import Wizard==
−
 
 
* Click on the the Text Import tab within the relevant Custom Field settings page, whether UTA, contact or company specific, to access the Import Wizard screen. Step 1 of the Import Wizard is displayed.
 
* Click on the the Text Import tab within the relevant Custom Field settings page, whether UTA, contact or company specific, to access the Import Wizard screen. Step 1 of the Import Wizard is displayed.
  
 
: [[Image:TextImport2.png|700px]]
 
: [[Image:TextImport2.png|700px]]
 +
* If you wish to paste text into this field then click the mouse in the import text box, and then select the Edit Paste menu or press Control + V. Alternatively you can type directly into the field.
  
−
* If you wish to paste text into this field then click the mouse in the import text box, and then select the Edit Paste menu or press Control + V. Alternatively you can type directly into the field.
+
* As a minimum requirement you should enter a Display Order value, a Field Type and a Field Name value.
  
−
* As a minimum requirement you should enter a Display Order value, a Field Type and a Field Name value.
 
 
: [[Image:TextImport3.png]]
 
: [[Image:TextImport3.png]]
 +
'''NOTE:''' Some of the Custom Field settings can only be imported using IDs rather than the displayed values. These are discussed further in the Custom Field Settings section below.
  
−
'''NOTE:''' Some of the Custom Field settings can only be imported using IDs rather than the displayed values. These are discussed further in the Custom Field Settings section below.
+
* Once all the relevant field data is enter then you set the '''Column delimiter''' as required.
−
 
 
−
* Once all the relevant field data is enter then you set the '''Column delimiter''' as required.  
 
  
 
* Click the '''First row contains field names''' check box if the first row is column headers rather than real data.
 
* Click the '''First row contains field names''' check box if the first row is column headers rather than real data.
Line 41: Line 37:
  
 
* Click the '''Analyze''' button.
 
* Click the '''Analyze''' button.
 +
  
  
 
==Map the fields in the pasted data to custom field settings==
 
==Map the fields in the pasted data to custom field settings==
 +
* Step 2 of the Import Wizard should now be displayed.
  
−
* Step 2 of the Import Wizard should now be displayed.
 
 
: [[Image:TextImport4.png]]
 
: [[Image:TextImport4.png]]
 +
* The top of the screen includes an option to map each column in the entered data with a corresponding custom field settings.
  
−
* The top of the screen includes an option to map each column in the entered data with a corresponding custom field settings. 
 
 
: [[Image:TextImport6.png|700px]]
 
: [[Image:TextImport6.png|700px]]
−
'''NOTE:''' Only the first row of data is used to define the mappings, but the settings are applied to all rows of data.  
+
'''NOTE:''' Only the first row of data is used to define the mappings, but the settings are applied to all rows of data.
 +
 
 +
* Define the mappings between the entered data and the custom field settings as appropriate.
  
−
* Define the mappings between the entered data  and the custom field settings as appropriate.
 
 
: [[Image:TextImport5.png|800px]]
 
: [[Image:TextImport5.png|800px]]
 +
* Click Parse Data button at the bottom of the screen.
  
−
* Click Parse Data button at the bottom of the screen.
 
  
  
 
==Validate the information mapping before uploading==
 
==Validate the information mapping before uploading==
 +
* Step 3 of the Import Wizard should now be displayed.
  
−
* Step 3 of the Import Wizard should now be displayed.
 
 
: [[Image:TextImport7.png|750px]]
 
: [[Image:TextImport7.png|750px]]
−
 
+
* This lists all rows of data and shows what values are to be mapped to what custom field settings.
−
* This lists all rows of data and shows what values are to be mapped to what custom field settings.  
 
  
 
* Review the data to confirm that mappings are correct for all rows.
 
* Review the data to confirm that mappings are correct for all rows.
Line 70: Line 67:
  
  
−
==Upload the data to SmartSimple==  
+
==Upload the data to SmartSimple==
−
* If no issues exist then click on the Upload button.  
+
 
 +
* If no issues exist then click on the Upload button.
  
 
* User will be taken to Step 4 of the Import Wizard, which indicates whether the upload succeeded or not.
 
* User will be taken to Step 4 of the Import Wizard, which indicates whether the upload succeeded or not.
 +
 
: [[Image:TextImport8.png|750px]]
 
: [[Image:TextImport8.png|750px]]
  
 +
==Custom Field Settings==
 +
Some of the Custom Field settings can only be imported using IDs rather than the displayed values. These are discussed further in the sections below.
  
−
 
−
==Custom Field Settings==
 
−
Some of the Custom Field settings can only be imported using IDs rather than the displayed values. These are discussed further in the Custom Field Settings section below.
 
  
  
 
===Settings requiring a 0 or 1===
 
===Settings requiring a 0 or 1===
 +
A number of the custom fields settings are enabled using the numeric value "1" and disabled using the numeric value "0".
  
−
A number of the custom fields settings are enabled using the numeric value "1" and disabled using the numeric value "0".
+
The exact list of these field settings are shown below . . .
−
 
 
−
The exact list of these field settings are shown below . . .  
 
  
 
* Allow Empty
 
* Allow Empty
Line 94: Line 91:
 
* Use As Tab
 
* Use As Tab
 
* Track Changes
 
* Track Changes
−
* Show as Radio Buttons  
+
* Show as Radio Buttons
  
 
* Enable Multiple Select
 
* Enable Multiple Select
  
−
* Show Display Value in List Views  
+
* Show Display Value in List Views
  
 
* Sort Values To Display Vertically
 
* Sort Values To Display Vertically
Line 126: Line 123:
 
* Count Words
 
* Count Words
  
−
* Show Currency Format in Edit Mode  
+
* Show Currency Format in Edit Mode
  
  
Line 132: Line 129:
 
===Custom Field Label Display===
 
===Custom Field Label Display===
 
The following values should be used when trying to define how the label should be displayed against the field.
 
The following values should be used when trying to define how the label should be displayed against the field.
 +
  
  
 
{| class="wikitable"
 
{| class="wikitable"
 
|-
 
|-
−
! Label Display option !! ID
+
!|Label Display option
 +
!|ID
 
|-
 
|-
−
| Label on Left || 0
+
||Label on Left
 +
||0
 
|-
 
|-
−
| Label Above Field || 1  
+
||Label Above Field
 +
||1
 
|-
 
|-
−
| Empty Label || 2  
+
||Empty Label
 +
||2
 
|-
 
|-
−
| Hide Label || 3  
+
||Hide Label
 +
||3
 
|}
 
|}
−
 
  
  
 
===Custom Field SmartField View===
 
===Custom Field SmartField View===
 +
The following values should be used when trying to define how the field will be handled within the [[SmartField view|SmartField View]].
  
−
The following values should be used when trying to define how the field will be handled within the [[SmartField view|SmartField View]].
 
  
  
 
{| class="wikitable"
 
{| class="wikitable"
 
|-
 
|-
−
! SmartField View option !! ID
+
!|SmartField View option
 +
!|ID
 
|-
 
|-
−
| Include || 0
+
||Include
 +
||0
 
|-
 
|-
−
| Exclude || 1
+
||Exclude
 +
||1
 
|-
 
|-
−
| Only display for SmartField View || 2
+
||Only display for SmartField View
 +
||2
 
|}
 
|}
−
 
  
  
 
===Custom Field Type Values===
 
===Custom Field Type Values===
−
 
+
The following IDs should be used when trying to create a custom field for that type.
−
The following IDs should be used when trying to create a custom field for that type.  
 
  
 
{| class="wikitable"
 
{| class="wikitable"
 
|-
 
|-
−
! Custom Field Type Name !! Custom Field Type ID
+
!|Custom Field Type Name
 +
!|Custom Field Type ID
 +
|-
 +
||Display Only - External Entity Details
 +
||96
 +
|-
 +
||Display Only - Image
 +
||34
 
|-
 
|-
−
| Creation - Date || 55
+
||Display Only - Web Page View
 +
||110
 
|-
 
|-
−
| Display Only - External Entity Details || 96
+
||Dynamic Data - Dynamic Control Field
 +
||87
 
|-
 
|-
−
| Display Only - Image || 34
+
||Link - Multiple Files
 +
||80
 
|-
 
|-
−
| Display Only - Tabbed Web Page View || 112
+
||Link - Single File
 +
||33
 
|-
 
|-
−
| Display Only - Text or System Object || 36
+
||Lookup - Address Validation
 +
||78
 
|-
 
|-
−
| Display Only - Web Page View || 110
+
||Lookup - Ajax Options
 +
||73
 
|-
 
|-
−
| Dynamic Data - Data Grid || 88
+
||Lookup - Entity and People
 +
||76
 
|-
 
|-
−
| Dynamic Data - Dynamic Control Field || 87
+
||Lookup - External Entity
 +
||95
 
|-
 
|-
−
| Link - Email || 37
+
||Lookup - External People
 +
||75
 
|-
 
|-
−
| Link - Multiple Files || 80
+
||Lookup - ICD Codes
 +
||74
 
|-
 
|-
−
| Link - Single File || 33
+
||Lookup - NAIC Codes
 +
||77
 
|-
 
|-
−
| Link - SmartFolder || 32
+
||Lookup - MeSH Codes
 +
||81
 
|-
 
|-
−
| Link - Website || 35
+
||Read Only - System Variables
 +
||109
 
|-
 
|-
−
| Lookup - Address Validation || 78
+
||Read Only - Text
 +
||39
 
|-
 
|-
−
| Lookup - Ajax Options || 73
+
||Select Many - Check Boxes
 +
||20
 
|-
 
|-
−
| Lookup - Entity and People || 76
+
||Select One - Combo Box
 +
||10
 
|-
 
|-
−
| Lookup - External Entity || 95
+
||Select One - Internal Entity
 +
||90
 
|-
 
|-
−
| Lookup - External People || 75
+
||Select One - Internal People
 +
||70
 
|-
 
|-
−
| Lookup - ICD Codes || 74
+
||Select One - Ledger Code
 +
||72
 
|-
 
|-
−
| Lookup - NAIC Codes || 77
+
||Special - Auto Number
 +
||50
 
|-
 
|-
−
| Read Only - System Variables || 109
+
||Special - Auto Save
 +
||79
 
|-
 
|-
−
| Read Only - Text || 39
+
||Special - Barcode
 +
||45
 
|-
 
|-
−
| Select Many - Check Boxes || 20
+
||Special - Browser Script
 +
||103
 
|-
 
|-
−
| Select Many - List Box || 22
+
||Special - Calculated Value
 +
||60
 
|-
 
|-
−
| Select Many - Scrolling Check Boxes || 21
+
||Special - ePad Signature
 +
||100
 
|-
 
|-
−
| Select One - Combo Box || 10
+
||Special - Geo Mapping
 +
||115
 
|-
 
|-
−
| Select One - Internal Entity || 90
+
||Special - Hand Drawing
 +
||99
 
|-
 
|-
−
| Select One - Internal People || 70
+
||Special - Hidden Value
 +
||38
 
|-
 
|-
−
| Select One - Ledger Code || 72
+
||Special - MSWord Merge
 +
||113
 
|-
 
|-
−
| Select One - Multi-level Combo Box || 127
+
||Special - XML Data
 +
||125
 
|-
 
|-
−
| Select One - User Group || 15
+
||Store Value - System Variables
 +
||111
 
|-
 
|-
−
| Special - Auto Number || 50
+
||Text - Password Protected
 +
||44
 
|-
 
|-
−
| Special - Barcode || 45
+
||Text Box - Multiple Lines
 +
||40
 
|-
 
|-
−
| Special - Browser Script || 103
+
||Text Box - Rich Text
 +
||42
 
|-
 
|-
−
| Special - Calculated Value || 60
+
||Text Box - Single Line
 +
||30
 
|-
 
|-
−
| Special - Color Code || 126
+
||Title Bar - Multiple Columns
 +
||5
 
|-
 
|-
−
| Special - ePad Signature || 100
+
||Creation - Date
 +
||55
 
|-
 
|-
−
| Special - Hand Drawing || 99
+
||Display Only - Tabbed Web Page View
 +
||112
 
|-
 
|-
−
| Special - Hidden Value || 38
+
||Display Only - Text or System Object
 +
||36
 
|-
 
|-
−
| Special - MSWord Merge || 113
+
||Dynamic Data - Data Grid
 +
||88
 
|-
 
|-
−
| Special - Timer || 31
+
||Link - Email
 +
||37
 
|-
 
|-
−
| Special - UTA Peers Combo || 12
+
||Link - SmartFolder
 +
||32
 
|-
 
|-
−
| Special - XML Data || 125
+
||Link - Website
 +
||35
 
|-
 
|-
−
| Store Value - System Variables || 111
+
||Select Many - List Box
 +
||22
 
|-
 
|-
−
| Text - Password Protected || 44
+
||Select Many - Scrolling Check Boxes
 +
||21
 
|-
 
|-
−
| Text Box - Multiple Lines || 40
+
||Select One - Multi-level Combo Box
 +
||127
 
|-
 
|-
−
| Text Box - Rich Text || 42
+
||Select One - User Group
 +
||15
 
|-
 
|-
−
| Text Box - Single Line || 30
+
||Special - Color Code
 +
||126
 
|-
 
|-
−
| Title Bar - Multiple Columns || 5
+
||Special - Timer
 +
||31
 +
|-
 +
||Special - UTA Peers Combo
 +
||12
 
|}
 
|}
 +
 +
==See Also==
 +
* [[Custom_Fields_%E2%80%93_General_Information#Import_and_Export_Custom_Fields|Import and Export Custom Fields]]

Latest revision as of 09:18, 29 August 2019

System Administrators are able to import custom fields and associated settings within any Custom Field Settings page.

Each Custom Field settings page, whether UTA, contact or company specific, will have the Text Import tab.

TextImport1.png

Overview of how to use Custom Field Import Wizard

The import process consists of the following steps:

1. Enter information into the Import Wizard.

2. Map the fields in the pasted data to custom field settings.

3. Validate the information mapping before uploading.

4. Upload the data to SmartSimple.


Enter information into the Custom Field Import Wizard

  • Click on the the Text Import tab within the relevant Custom Field settings page, whether UTA, contact or company specific, to access the Import Wizard screen. Step 1 of the Import Wizard is displayed.
TextImport2.png
  • If you wish to paste text into this field then click the mouse in the import text box, and then select the Edit Paste menu or press Control + V. Alternatively you can type directly into the field.
  • As a minimum requirement you should enter a Display Order value, a Field Type and a Field Name value.
TextImport3.png

NOTE: Some of the Custom Field settings can only be imported using IDs rather than the displayed values. These are discussed further in the Custom Field Settings section below.

  • Once all the relevant field data is enter then you set the Column delimiter as required.
  • Click the First row contains field names check box if the first row is column headers rather than real data.
  • Click the Values enclosed by double quote check box if the first row is the values being imported include any that are enclosed in double quotes.
  • Click the Analyze button.


Map the fields in the pasted data to custom field settings

  • Step 2 of the Import Wizard should now be displayed.
TextImport4.png
  • The top of the screen includes an option to map each column in the entered data with a corresponding custom field settings.
TextImport6.png

NOTE: Only the first row of data is used to define the mappings, but the settings are applied to all rows of data.

  • Define the mappings between the entered data and the custom field settings as appropriate.
TextImport5.png
  • Click Parse Data button at the bottom of the screen.


Validate the information mapping before uploading

  • Step 3 of the Import Wizard should now be displayed.
TextImport7.png
  • This lists all rows of data and shows what values are to be mapped to what custom field settings.
  • Review the data to confirm that mappings are correct for all rows.
  • If issues exist in the mappings then use the Back button to navigate back to an earlier step and make appropriate changes.


Upload the data to SmartSimple

  • If no issues exist then click on the Upload button.
  • User will be taken to Step 4 of the Import Wizard, which indicates whether the upload succeeded or not.
TextImport8.png

Custom Field Settings

Some of the Custom Field settings can only be imported using IDs rather than the displayed values. These are discussed further in the sections below.


Settings requiring a 0 or 1

A number of the custom fields settings are enabled using the numeric value "1" and disabled using the numeric value "0".

The exact list of these field settings are shown below . . .

  • Allow Empty
  • Appear Mandatory
  • Searchable
  • Use As Tab
  • Track Changes
  • Show as Radio Buttons
  • Enable Multiple Select
  • Show Display Value in List Views
  • Sort Values To Display Vertically
  • Disable Lookup Button
  • Enable Builder
  • Enable Server-Side Validation
  • Enable KML
  • Disable Quick Edit
  • Hide Field
  • Hide For Portal
  • Enable Map Service
  • Enable People Search Service
  • Enable Organization Search Service
  • Show Counter
  • Count Words
  • Show Currency Format in Edit Mode


Custom Field Label Display

The following values should be used when trying to define how the label should be displayed against the field.


Label Display option ID
Label on Left 0
Label Above Field 1
Empty Label 2
Hide Label 3


Custom Field SmartField View

The following values should be used when trying to define how the field will be handled within the SmartField View.


SmartField View option ID
Include 0
Exclude 1
Only display for SmartField View 2


Custom Field Type Values

The following IDs should be used when trying to create a custom field for that type.

Custom Field Type Name Custom Field Type ID
Display Only - External Entity Details 96
Display Only - Image 34
Display Only - Web Page View 110
Dynamic Data - Dynamic Control Field 87
Link - Multiple Files 80
Link - Single File 33
Lookup - Address Validation 78
Lookup - Ajax Options 73
Lookup - Entity and People 76
Lookup - External Entity 95
Lookup - External People 75
Lookup - ICD Codes 74
Lookup - NAIC Codes 77
Lookup - MeSH Codes 81
Read Only - System Variables 109
Read Only - Text 39
Select Many - Check Boxes 20
Select One - Combo Box 10
Select One - Internal Entity 90
Select One - Internal People 70
Select One - Ledger Code 72
Special - Auto Number 50
Special - Auto Save 79
Special - Barcode 45
Special - Browser Script 103
Special - Calculated Value 60
Special - ePad Signature 100
Special - Geo Mapping 115
Special - Hand Drawing 99
Special - Hidden Value 38
Special - MSWord Merge 113
Special - XML Data 125
Store Value - System Variables 111
Text - Password Protected 44
Text Box - Multiple Lines 40
Text Box - Rich Text 42
Text Box - Single Line 30
Title Bar - Multiple Columns 5
Creation - Date 55
Display Only - Tabbed Web Page View 112
Display Only - Text or System Object 36
Dynamic Data - Data Grid 88
Link - Email 37
Link - SmartFolder 32
Link - Website 35
Select Many - List Box 22
Select Many - Scrolling Check Boxes 21
Select One - Multi-level Combo Box 127
Select One - User Group 15
Special - Color Code 126
Special - Timer 31
Special - UTA Peers Combo 12

See Also

Retrieved from ‘https://wiki.smartsimple.com/index.php?title=Custom_Field_Import_Wizard&oldid=36964’