2,299
edits
Changes
no edit summary
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.
: [[Image:TextImport1.png]]
[[Category:Custom Fields]]
==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 the fields in the organisation, contact or activity recordcustom 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.
: [[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.
* As a minimum requirement you should enter a Display Order value, a Field Type and a Field Name value.
: [[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.
* 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.
: [[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.
: [[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.
* Define the mappings between the entered data and the custom field settings as appropriate.
: [[Image:TextImport5.png|800px]]
* 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.
: [[Image:TextImport7.png|750px]]
* 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.
: [[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.
===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
{| class="wikitable"
|-
! Custom Field Type Name |SmartField View option!! Custom Field Type |ID
|-
| Creation - Date |Include| 55|0
|-
| Display Only - External Entity Details |Exclude| 96 |1
|-
| Display |Only - Image 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. {| 34 class="wikitable"
|-
!| Display Only - Tabbed Web Page View Custom Field Type Name!|| 112 Custom Field Type ID
|-
|| Display Only - Text or System Object External Entity Details|| 3696
|-
|| Display Only - Web Page View Image|| 11034
|-
| Dynamic Data |Display Only - Data Grid Web Page View|| 88110
|-
|| Dynamic Data - Dynamic Control Field || 87
|-
|| Link - Email Multiple Files|| 3780
|-
|| Link - Multiple Files Single File|| 8033
|-
| Link |Lookup - Single File Address Validation|| 3378
|-
| Link |Lookup - SmartFolder Ajax Options|| 3273
|-
| Link |Lookup - Website Entity and People|| 35 76
|-
|| Lookup - Address Validation External Entity|| 78 95
|-
|| Lookup - Ajax Options External People|| 73 75
|-
|| Lookup - Entity and People ICD Codes|| 76 74
|-
|| Lookup - External Entity NAIC Codes|| 95 77
|-
|| Lookup - External People MeSH Codes|| 75 81
|-
| Lookup |Read Only - ICD Codes System Variables|| 74 109
|-
| Lookup |Read Only - NAIC Codes Text|| 77 39
|-
| Read Only |Select Many - System Variables Check Boxes|| 109 20
|-
| Read Only |Select One - Text Combo Box|| 39 10
|-
|| Select Many One - Check Boxes Internal Entity|| 2090
|-
|| Select Many One - List Box Internal People|| 22 70
|-
|| Select Many One - Scrolling Check Boxes Ledger Code|| 2172
|-
| Select One |Special - Combo Box Auto Number|| 10 50
|-
| Select One |Special - Internal Entity Auto Save|| 90 79
|-
| Select One |Special - Internal People Barcode|| 70 45
|-
| Select One |Special - Ledger Code Browser Script|| 72 103
|-
| Select One - Multi|Special -level Combo Box Calculated Value|| 12760
|-
| Select One |Special - User Group ePad Signature|| 15100
|-
|| Special - Auto Number Geo Mapping|| 50 115
|-
|| Special - Barcode Hand Drawing|| 45 99
|-
|| Special - Browser Script Hidden Value|| 103 38
|-
|| Special - Calculated Value MSWord Merge|| 60 113
|-
|| Special - Color Code XML Data|| 126 125
|-
| Special |Store Value - ePad Signature System Variables|| 100 111
|-
| Special |Text - Hand Drawing Password Protected|| 99 44
|-
| Special |Text Box - Hidden Value Multiple Lines|| 38 40
|-
| Special |Text Box - MSWord Merge Rich Text|| 11342
|-
| Special |Text Box - Timer Single Line|| 31 30
|-
| Special |Title Bar - UTA Peers Combo Multiple Columns|| 12 5
|-
| Special |Creation - XML Data Date|| 125 55
|-
| Store Value |Display Only - System Variables Tabbed Web Page View|| 111 112
|-
| |Display Only - Text - Password Protected or System Object|| 44 36
|-
| Text Box |Dynamic Data - Multiple Lines Data Grid|| 40 88
|-
| Text Box |Link - Rich Text Email|| 42 37
|-
| Text Box |Link - Single Line SmartFolder|| 30 32
|-
| Title Bar |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 - Multiple Columns UTA Peers Combo|| 5 12
|}
==See Also==
* [[Custom_Fields_%E2%80%93_General_Information#Import_and_Export_Custom_Fields|Import and Export Custom Fields]]
