Difference between revisions of "Import/Export and Integration Techniques Overview"

From SmartWiki
Jump to: navigation, search
 
(24 intermediate revisions by 4 users not shown)
Line 1: Line 1:
 +
{{DeprecatedPage}}
 +
 
SmartSimple supports a number of techniques for importing, exporting and integration with other systems.   
 
SmartSimple supports a number of techniques for importing, exporting and integration with other systems.   
  
 
This article describes the techniques available with links to related articles.
 
This article describes the techniques available with links to related articles.
  
−
{|border="1"
+
{|class="wikitable"
 
|-
 
|-
−
|'''Feature'''||'''Can be used to manipulate'''||'''Complexity'''||'''Import'''||'''Export'''||'''Integration'''
+
|'''Feature'''||'''Can be used to manipulate'''||'''Complexity'''||'''Import'''||'''Export'''||'''Integration'''||'''Type'''
 
|-
 
|-
−
|Import Wizard 1
+
|[[Import Wizard]]
 
|
 
|
 
* Imports field level data to organizations, contacts.
 
* Imports field level data to organizations, contacts.
−
|Low||Yes||No||One time import only.
+
|Low||Yes||No||One time import only.||Browser based process
  
 
|-
 
|-
−
|Autoloader 2
+
|[[Auto Loader]]
 
|
 
|
−
* Loads bulk records for Organisation, contact, Universal Tracking Application, Level 1 and Level 2 entities.
+
* Loads bulk records for organizations, contacts, Universal Tracking Application Level 1, Level 2 and Level 3 entities and [[Transactions]].
−
* Currently does not support level 3 items or organisation or contact type transactions.
+
<!--* Does not support Transactions (Company or People) [See Previous_Upgrade:_October_1st_2010]-->
 
* Recommended for large imports and updates
 
* Recommended for large imports and updates
−
|Medium||Yes||No||Provides for automated upload/update processes.
+
|Medium||Yes||No||Provides for automated upload/update processes.||Server based process
  
 
|-
 
|-
−
|File Sync 3
+
|[[SmartSync for Folder Synchronization|File Sync]]
 
|
 
|
−
* SmartFolders – Files and Folders ONLY
+
* [[SmartFolders]] – Files and Folders ONLY
−
|Medium||Yes||Yes||Used to synchronize on-line and off-line folders.
+
|Medium||Yes||Yes||Used to synchronize on-line and off-line folders.||Desktop application
  
 
|-
 
|-
−
|SmartFileRetriever 3
+
|[[SmartFileRetriever]]
 
|
 
|
−
* Files attached to Universal Tracking applications.
+
* Files attached to [[Universal Tracking Application]]s.
−
|Low||No||Yes||Used to export and backup files.
+
|Low||No||Yes||Used to export and backup files.||Desktop application
  
 
|-
 
|-
−
|SmartFiler 3
+
|[[SmartFiler]]
 
|
 
|
−
* Files attached to Universal Tracking applications.
+
* Files attached to [[Universal Tracking Application]]s.
−
|Low||Yes||No||
+
|Low||Yes||No|| ||Desktop application
  
 
|-
 
|-
−
|MS Access Plug in 4|
+
|[[SmartSimple Microsoft Access Plug-In|MS Access Plug-in]]
 +
|
 
* Reports created in SmartSimple can be accessed to create tables in MS Access.
 
* Reports created in SmartSimple can be accessed to create tables in MS Access.
−
|Medium||No||Yes||User requires administrative access rights to their machine to install and configure.
+
|Medium||No||Yes||User requires administrative access rights to their machine to install and configure.||MS Office extension
  
 
|-
 
|-
−
|MS Excel Plug-in 4
+
|[[SmartSimple Excel Plug-in|MS Excel Plug-in]]
 
|
 
|
−
* Reports created in SmartSimple can be accessed to create spreadsheets in MS Excel.
+
* Reports created in [[SmartSimple]] can be accessed to create spreadsheets in MS Excel.
 
* Additional pivot table feature can be used to pivot SmartSimple data.
 
* Additional pivot table feature can be used to pivot SmartSimple data.
−
|Medium||No||Yes||User requires administrative access rights to their machine to install and configure. User requires role based access to specific report.
+
|Medium||No||Yes||User requires administrative access rights to their machine to install and configure. User requires role based access to specific report.||MS Office extension
  
 
|-
 
|-
−
|MS Outlook Plug-in 4
+
|[[SmartSimple Microsoft Outlook Synchronization|MS Outlook Plug-in]]
 
|
 
|
 
* Organisations, contacts, calendars and email records.
 
* Organisations, contacts, calendars and email records.
−
|Medium||Yes||Yes||Basic integration between MS Outlook and SmartSimple. User requires administrative access rights to their machine to install and configure.
+
|Medium||Yes||Yes||Basic integration between MS Outlook and SmartSimple. User requires administrative access rights to their machine to install and configure.||MS Office extension
  
 
|-
 
|-
−
|MS Word Plug-in 4
+
|[[SmartDoc for Microsoft Word Overview|MS Word Plug-in]]
 
|
 
|
 
Provides two distinct functions:
 
Provides two distinct functions:
 
# Ability to merge data from a SmartSimple report into a document template.
 
# Ability to merge data from a SmartSimple report into a document template.
 
# When used in conjunction with the Applicant Tracking system provides the ability to create (or update) an applicant record from an open resume (CV) file (MS Word only) and upload the resume to their profile.
 
# When used in conjunction with the Applicant Tracking system provides the ability to create (or update) an applicant record from an open resume (CV) file (MS Word only) and upload the resume to their profile.
−
|Medium||Yes||Yes||User requires administrative access rights to their machine to and configure. User requires role based access to specific report. When used with the Applicant Tracking System, the user also required rights to place a person in an applicant role and to specific applicant folders.
+
|Medium||Yes||Yes||User requires administrative access rights to their machine to and configure. User requires role based access to specific report. When used with the Applicant Tracking System, the user also required rights to place a person in an applicant role and to specific applicant folders.||MS Office extension
  
 
|-
 
|-
−
|Universal Tracking Application Data Exchange 2
+
|[[:Category:Data Exchange|UTA Data Exchange]]
 
|
 
|
−
* Provides for synchronization of Universal Tracking application data at Level 1, level 2 and Level 3 and associated organisations and contacts (including organisation and contact custom fields).
+
* Provides for synchronization of Universal Tracking application data at Level 1, level 2 and Level 3 and associated organisations and contacts (including organization and contact custom fields).
−
|Medium||Yes||Yes||Only useful for inter-instance integration.
+
|Medium||Yes||Yes||Only useful for inter-instance integration.||Server based process
  
 
|-
 
|-
−
|ObjectSync 2
+
|[[:Category:ObjectSync|ObjectSync]]
 
|
 
|
−
* Provides for synchronization of organisations and contacts (including organisation and contact custom fields).
+
* Provides for synchronization of organizations and contacts (including organization and contact custom fields).
−
|Medium||Yes||Yes||Only useful for inter-instance integration.
+
|Medium||Yes||Yes||Only useful for inter-instance integration.||Server based process
  
 
|-
 
|-
−
|Reports 2
+
|[[:Category:Reports|Reports]]
 
|
 
|
 
Provides two distinct functions:
 
Provides two distinct functions:
 
# A report can be configured with a specific layout and file extension set to launch an application such as MS Excel and populate a spreadsheet.
 
# A report can be configured with a specific layout and file extension set to launch an application such as MS Excel and populate a spreadsheet.
 
# A report can be configured with an XML layout to create a XML version of the data.
 
# A report can be configured with an XML layout to create a XML version of the data.
−
|High||No||Yes||XML reports can be configured to allow access by a system generated URL and password allowing an external system to request data from SmartSimple.
+
|Medium-High||No||Yes||XML reports can be configured to allow access by a system generated URL and password allowing an external system to request data from SmartSimple.||Server based process
 +
 
 +
|-
 +
|[[Exporting List View Results to Microsoft Excel|Exporting List Views to Microsoft Excel]]
 +
|
 +
The results of [[List View Overview|list views]] can be exported directly to Microsoft Excel with a one-click functionality.
 +
|Low||No||Yes||Excel spreadsheets can be created on the fly, using blank worksheets or [[Using an Excel Template for List View Export Results|user-built Excel templates]].||Server based process
  
 
|-
 
|-
−
|Workflow 2
+
|[[Workflows]]
 
|
 
|
 
*Workflow supports [[Workflow Task Type: Internet Communication - HTTP POST|HTTP Post task type]].
 
*Workflow supports [[Workflow Task Type: Internet Communication - HTTP POST|HTTP Post task type]].
−
|High||No||Yes||When configured with appropriate XML layout and posting URL (from receiving system) records can be dynamically posted to other system based on workflow triggers.
+
|High||No||Yes||When configured with appropriate XML layout and posting URL (from receiving system) records can be dynamically posted to other system based on workflow triggers.||Server based process
  
 
|-
 
|-
−
|API 3
+
|[[UTA PDF Parser]]
 
|
 
|
−
* All system objects, organisations, contacts, roles, Universal tracking Application data including files stored in single and multiple file fields can be manipulated with the API.
+
*Fillable forms in PDF format can be downloaded from SmartSimple, completed ''offline'' and then re-uploaded to create records within SmartSimple.
−
* API cannot be used to manipulate files in SmartFolders.
+
|Low ''(for end users)''<br>Medium ''(configuration)''||Yes||Yes||Users can fill out PDF documents while offline and upload to SmartSimple at their convenience, thereby automatically creating records in SmartSimple without having to re-enter the data.||Server based process
−
|High||Yes||Yes||Main component designed for programmer level system integration.
 
  
−
[[Category:Integration]]
+
<!-- DESKTOP API NO LONGER SUPPORTED [June 5, 2013]
 +
|-
 +
|[[API]]
 +
|
 +
* All system objects, organizations, contacts, roles, [[Universal Tracking Application]] data including files stored in single and multiple file fields can be manipulated with the API.
 +
* [[API]] cannot be used to manipulate files in [[SmartFolders]].
 +
|High||Yes||Yes||Main component designed for programmer level system integration.||Desktop application
 +
-->
 +
 
 +
|-
 +
|[[API|API's]]
 +
|
 +
* All system objects, organizations, contacts, roles, [[Universal Tracking Application]] data including files stored in single and multiple file fields can be manipulated with the API.
 +
|High||Yes||Yes||Main component designed for programmer level system integration.||Web/Browser applications

Latest revision as of 14:38, 19 October 2017


Ambox warning pn.png This article is deprecated and the information contained within may no longer be correct.

SmartSimple supports a number of techniques for importing, exporting and integration with other systems.

This article describes the techniques available with links to related articles.

Feature Can be used to manipulate Complexity Import Export Integration Type
Import Wizard
  • Imports field level data to organizations, contacts.
 Low Yes No One time import only. Browser based process
Auto Loader
  • Loads bulk records for organizations, contacts, Universal Tracking Application Level 1, Level 2 and Level 3 entities and Transactions.
  • Recommended for large imports and updates
 Medium Yes No Provides for automated upload/update processes. Server based process
File Sync Medium Yes Yes Used to synchronize on-line and off-line folders. Desktop application
SmartFileRetriever Low No Yes Used to export and backup files. Desktop application
SmartFiler Low Yes No Desktop application
MS Access Plug-in
  • Reports created in SmartSimple can be accessed to create tables in MS Access.
 Medium No Yes User requires administrative access rights to their machine to install and configure. MS Office extension
MS Excel Plug-in
  • Reports created in SmartSimple can be accessed to create spreadsheets in MS Excel.
  • Additional pivot table feature can be used to pivot SmartSimple data.
 Medium No Yes User requires administrative access rights to their machine to install and configure. User requires role based access to specific report. MS Office extension
MS Outlook Plug-in
  • Organisations, contacts, calendars and email records.
 Medium Yes Yes Basic integration between MS Outlook and SmartSimple. User requires administrative access rights to their machine to install and configure. MS Office extension
MS Word Plug-in

Provides two distinct functions:

  1. Ability to merge data from a SmartSimple report into a document template.
  2. When used in conjunction with the Applicant Tracking system provides the ability to create (or update) an applicant record from an open resume (CV) file (MS Word only) and upload the resume to their profile.
 Medium Yes Yes User requires administrative access rights to their machine to and configure. User requires role based access to specific report. When used with the Applicant Tracking System, the user also required rights to place a person in an applicant role and to specific applicant folders. MS Office extension
UTA Data Exchange
  • Provides for synchronization of Universal Tracking application data at Level 1, level 2 and Level 3 and associated organisations and contacts (including organization and contact custom fields).
 Medium Yes Yes Only useful for inter-instance integration. Server based process
ObjectSync
  • Provides for synchronization of organizations and contacts (including organization and contact custom fields).
 Medium Yes Yes Only useful for inter-instance integration. Server based process
Reports

Provides two distinct functions:

  1. A report can be configured with a specific layout and file extension set to launch an application such as MS Excel and populate a spreadsheet.
  2. A report can be configured with an XML layout to create a XML version of the data.
 Medium-High No Yes XML reports can be configured to allow access by a system generated URL and password allowing an external system to request data from SmartSimple. Server based process
Exporting List Views to Microsoft Excel

The results of list views can be exported directly to Microsoft Excel with a one-click functionality.

Low No Yes Excel spreadsheets can be created on the fly, using blank worksheets or user-built Excel templates. Server based process
Workflows High No Yes When configured with appropriate XML layout and posting URL (from receiving system) records can be dynamically posted to other system based on workflow triggers. Server based process
UTA PDF Parser
  • Fillable forms in PDF format can be downloaded from SmartSimple, completed offline and then re-uploaded to create records within SmartSimple.
 Low (for end users)
Medium (configuration)		 Yes Yes Users can fill out PDF documents while offline and upload to SmartSimple at their convenience, thereby automatically creating records in SmartSimple without having to re-enter the data. Server based process


API's
  • All system objects, organizations, contacts, roles, Universal Tracking Application data including files stored in single and multiple file fields can be manipulated with the API.
 High Yes Yes Main component designed for programmer level system integration. Web/Browser applications
Retrieved from ‘https://wiki.smartsimple.com/index.php?title=Import/Export_and_Integration_Techniques_Overview&oldid=31307’