Restful Web API

The RESTful Web API include services for

  • User Authentication
  • Retrieval of Existing Records
  • Creation of New Records
  • Updating of Existing Record
  • Deletion of Existing Records
  • Data Structure Discovery
  • User Permission Retrieval
  • Remote Import/Export Upload and Execution
  • Uploading of New Attachments
  • Retrieval of Existing Attachments
  • Retrieving of a blank Record Template with default values populated
  • Returning User Form Layout

The ODBC Compliant Import/Export Engine can perform duplicate data detection, partial data updates, simple field joins, splits and arithmetic and date-based data manipulations. Imports and Exports can be set to execute on a specific frequency.

Administration Import/ Export

adminexport

Import/Export files are used to import data from other applications or export data from Cartegraph. The functionality to perform these tasks is found in Import/Export. You must be a Cartegraph Administrator to do so.

  • The Import function allows you to transfer data from an existing file into your Cartegraph database. To better facilitate the process, Cartegraph automatically saves imported files to a temporary location and deletes them once the import has concluded.
  • Any file import format can be used for export, although the fixed-width type is not supported.
  • The Export function creates a .CSV or .TXT file for use by other applications such as spreadsheets, databases, or other data management applications. For example, exporting labor records that track employee time for use in a payroll application.
  • Import/Export Formats are created in the Format Editor tab and stored in the Project Home as a format file. Once a format is selected in this tab, the Import and Export buttons become available and a job can be run.
  • The Jobs tab is where historical Import or Export jobs are viewed, where job logs are available for download, and where running jobs can be viewed and canceled.
  • At the conclusion of any Import/Export, Cartegraph reports the number of records it processed, as well as, a count of warnings, errors, and informational messages received as a result. View the results in the Jobs tab.
  • CSV files generated by an export that will be used for importing must use ANSI encoding.


SCHEDULE A DEMONSTRATION

An AGL Representative is standing by to assist you.
For sales and technical support, call now!