The SmartIntegrator Data Dictionary is a listing of SmartOffice objects, lookups and methods exposed to XmlEngine and SiAdapters. The details about the formatting and interrelation of these elements allows developers to derive the proper syntax for any SmartIntegrator request.
To access the data dictionary, you must be signed in to SmartOffice. Once you are signed in, access the Data Dictionary in any of the following ways:
&dump=catalog&type=dict
to the query string in the XML Engine URL (see XmlEngine). Example: https://eval.ez-data.com/xmlengine?AppName=Testbed&dump=catalog&type=dictEbix provides a static HTML copy of the Data Dictionary attached to this wiki page. Download the Data_Dictionary.html.txt file and remove the .txt extension before opening it.
Note: The static version is updated periodically but may not contain the absolute latest changes. If you need the latest changes, access the live version. SmartOffice dynamically generates the Data Dictionary as an HTML file when you request it, as long as the feature has not been disabled in SmartOffice's server configuration.
To access the live version of the Data Dictionary on the server, sign in to SmartOffice, and then use one of these methods:
?AppName=YourAppName&dump=catalog&type=dict
to the XmlEngine URL, where YourAppName
is the AppName assigned to you by Ebix. Example: https://uat.smartofficeonline.com/pprodnew/xmlengine?AppName=YourAppName&dump=catalog&type=dict
This section describes issues you may encounter when trying to access the live version of the Data Dictionary, along with possible solutions. Note: If these solutions do not resolve the issue, download the static copy of the Data Dictionary as described previously.
You receive the error "The Data Dictionary requires an active SmartOffice session. Please log into SmartOffice and try again."
You see a blank page or other error.
<system-info>
element under the <smart-integrator>
element to true
so that it looks like the following, and then restart the server: <system-info type='boolean' restart='false'>true</system-info>
The best way to locate an object in the Data Dictionary is to find the corresponding field in the the SmartOffice user interface. The field names in SmartOffice usually correspond with the object names in the Data Dictionary. The locations of fields in SmartOffice will help you determine the hierarchy of objects that the data element you need falls under. SmartOffice user interface. The field names in SmartOffice usually correspond with the object names in the Data Dictionary. The locations of fields in SmartOffice will help you determine the hierarchy of objects that the data element you need falls under.
If multiple objects in the Data Dictionary have names similar to the data element you are looking for, populate the field in SmartOffice with a unique value you will recognize. Then use the SmartOffice with a unique value you will recognize. Then use the TestBed to retreive all of the fields and see which one contains your value.
If you still cannot find the right object in the Data Dictionary, send an e-mail message to the support team with a SmartOffice screenshot highlighting the field, and we will tell you where the appropriate object is (or tell you if the Data Dictionary needs to be expanded to cover it.) SmartOffice screenshot highlighting the field, and we will tell you where the appropriate object is (or tell you if the Data Dictionary needs to be expanded to cover it.)
What are these objects that are defined as “strings” but are associated with a lookup in the dictionary? (i.e. AcctType) AcctType?)
This field is what we call a “soft choice,” meaning that it is really a string column in the database, but we display it as a drop-down choice in SmartOffice. Sometimes we also let users manually type a string into the field if they don’t want to use the drop-down list. SmartOffice. Sometimes we also let users manually type a string into the field if they don’t want to use the drop-down list.
From a SmartIntegrator perspective, you should treat this field as a string and use the Lookup in the dictionary as a guide to what our default/preferred values are. If none of those values accommodate the information you are trying to represent, populate the string you feel is most appropriate.
What is the difference between Contact Type and Client Type?
Yes, that is a little confusing as weve changed the user-interface field names over the years but couldnt rename the objects for backwards-compatibility reasons.
Contact.Category (Choice Lookup = ContactType) is what appears in the Type field of the Contact detail screen in the user-interface. This is a detail description of the Contact’s classification (Client, Prospect, Lead, Suspect, BGA, Agency, etc). This list can be modified by the users and users can just type any string they want into this field without even defining it as a standard choice. This list only has a loose association with the quick-add list in your screenshot as a “Client” may be a Contact, Business, Advisor, or Agency depending on the nature of the user. ContactType?) is what appears in the Type field of the Contact detail screen in the user-interface. This is a detail description of the Contact’s classification (Client, Prospect, Lead, Suspect, BGA, Agency, etc). This list can be modified by the users and users can just type any string they want into this field without even defining it as a standard choice. This list only has a loose association with the quick-add list in your screenshot as a “Client” may be a Contact, Business, Advisor, or Agency depending on the nature of the user.
ClientType?Contact.ClientType (Choice Lookup = SubTypelookup) is half of what really defines how the record is handled by our system (Contact, Dependant, Agent, Carrier, Service Provider, etc). This data value is not represented by any single field in the user-interface. (Choice Lookup = SubTypelookup?) is half of what really defines how the record is handled by our system (Contact, Dependant, Agent, Carrier, Service Provider, etc). This data value is not represented by any single field in the user-interface.
ContactType?Contact.ContactType (Choice Lookup = RecordType) is the other half of what defines the record for our system. It has two choices, Person (which means the record represents an individual human being) and Business (which is some entity that isn’t a human being). When this is coupled with Contact.ClientType it translates to the terminology you see in the user-interface. A Person-Agent is an Advisor, a Business-Agent is an Agency, a Person-Contact is a Contact, a Business-Contact is a Business. Some combinations wouldn’t make sense (Person-Carrier), so you won’t see them in the system. (Choice Lookup = RecordType?) is the other half of what defines the record for our system. It has two choices, Person (which means the record represents an individual human being) and Business (which is some entity that isn’t a human being). When this is coupled with ClientType? it translates to the terminology you see in the user-interface. A Person-Agent is an Advisor, a Business-Agent is an Agency, a Person-Contact is a Contact, a Business-Contact is a Business. Some combinations wouldn’t make sense (Person-Carrier), so you won’t see them in the system.
The drop-down list in the SO Quick-Search represents the SmartOffice records that people most commonly add to the database. If you are a Financial Advisor or an Insurance Agent and you are trying to quickly add a “Client” to the database, you are probably talking about the Contact or Business choice in the drop-down list. If you work for a BGA, an Independent Marketing Organization, a Broker-Dealer, or a Carrier with a captive sales force, you are probably talking about the Advisor or Agency choice in the drop-down list. SmartOffice records that people most commonly add to the database. If you are a Financial Advisor or an Insurance Agent and you are trying to quickly add a “Client” to the database, you are probably talking about the Contact or Business choice in the drop-down list. If you work for a BGA, an Independent Marketing Organization, a Broker-Dealer, or a Carrier with a captive sales force, you are probably talking about the Advisor or Agency choice in the drop-down list.
How can I get my SmartPad Notes string HTML formatting to show up correctly? SmartPad? Notes string HTML formatting to show up correctly?
You need to use HTML line breaks (not carriage returns) and other HTML formatting tags. These tags need to use escape characters correctly because this is XML inside of XML.
SDC BRYAN_ESHELBRENNER sdc_uat jdoe ****** <b><FONT color="#ff0000">TASK NAME:</FONT></b> SI Dev Guide Revision<br><b>DIFFICULTY LEVEL:</b> Kulzer-Liver<br><b>STATUS:</b> Technical Writing<br> Contact.70746.12077 0 0
Also, you can base64 encode the entire string with the proper HTML formatting if you dont want to deal with escape characters.
SDC BRYAN_ESHELBRENNER sdc_uat jdoe ****** PGI+PEZPTlQgY29sb3I9IiNmZjAwMDAiPlRBU0sgTkFNRTo8L0ZPTlQ+PC9iPiBTSSBEZXYgR3VpZGUgUmV2aXNpb248YnI+PGI+RElGRklDVUxUWSBMRVZFTDo8L2I+IEt1bHplci1MaXZlcjxicj48Yj5TVEFUVVM6PC9iPiBUZWNobmljYWwgV3JpdGluZzxicj4= Contact.70746.12077 0 0
How do I know what timezone is associated with a time stamp value in a SmartIntegrator response?
All of the timestamps in the database are stored in GMT and that is the value returned through SmartIntegrator. There is a Time Zone on the UserProfile object that can be pulled if you want to convert to the user’s configured time zone, but there is no way to have UserProfile? object that can be pulled if you want to convert to the user’s configured time zone, but there is no way to have SmartIntegrator automatically offset the values in the responses.
-- Main.dustin - 24 Oct 2012
I | Attachment | Action | Size | Date | Who | Comment |
---|---|---|---|---|---|---|
txt | Data_Dictionary.html.txt | manage | 3120.3 K | 21 Dec 2023 - 02:15 | DinosLambropoulos | Here is a Data Dictionary file, in case the live access is offline. Remove the .txt extention before opening. |