You can't use this until you register with us!

Description

Obtain jobs and orders from Syncore and store them in a MySQL database.

Purchasing Options

Syncore to MySQL Loader - $149.99 / month

Available Actions

Load Jobs and Orders

Download jobs, sales orders and purchase orders from Syncore and store them in a MySQL database.

Variables

Source Parameters
syncore_connection required

Credentials to use to connect to Syncore.

skip_error required

Continue downloading subsequent data if an error occurs.

errors_table

Optional name of the table, in schema.table format, where Syncore errors will be stored.

filters

Filters to limit the data to download. Refer to slide out help for more information.


Range Parameters
pointer

Datetime stamp indicating the starting point, based on creation datetime, of the data to download. Only data created after the datetime specified will be downloaded. This field will be automatically updated after each increment of data is loaded. Formatted as YYYY-MM-DDTHH:MM:SS in UTC timezone.

range_start_point_query

SQL Query to use to determine the start point of the data to process. If specified, Next Run Start Point will be ignored.

end_range_pointer

Optional datetime stamp indicating the stopping point, based on creation datetime, of the data to download. Only data created before the datetime specified will be downloaded. If blank, the current datetime will be used. Formatted as YYYY-MM-DDTHH:MM:SS in UTC timezone.


Destination Parameters
db required

MySQL database where the data will be stored.

jobs_table_name required

Table name, in schema.table format, where job data will be stored.

sales_table_name

Optional. Table name, in schema.table format, where sales order data will be stored. If blank, sales order data will not be downloaded.

purchase_table_name

Optional. Table name, in schema.table format, where purchase order data will be stored. If blank, purchase order data will not be downloaded.


Load Suppliers

Download all suppliers from Syncore and store them in a MySQL database.

Variables

Source Parameters
syncore_connection required

Credentials to use to connect to Syncore.


Destination Parameters
db required

MySQL database where the data will be stored.

suppliers_table_name required

Table name, in schema.table format, where supplier data will be stored.


Load Contacts

Download Contacts from Syncore and store them in a MySQL database.

Variables

Source Parameters
syncore_connection required

Credentials to use to connect to Syncore.

skip_error required

Continue downloading subsequent data if an error occurs.

errors_table

Optional name of the table, in schema.table format, where Syncore errors will be stored.

filters

Filters to limit the data to download. Refer to slide out help for more information.


Range Parameters
pointer

Datetime stamp indicating the starting point, based on creation datetime, of the data to download. Only data created after the datetime specified will be downloaded. This field will be automatically updated after each increment of data is loaded. Formatted as YYYY-MM-DDTHH:MM:SS in UTC timezone.

range_start_point_query

SQL Query to use to determine the start point of the data to process. If specified, Next Run Start Point will be ignored.

end_range_pointer

Optional datetime stamp indicating the stopping point, based on creation datetime, of the data to download. Only data created before the datetime specified will be downloaded. If blank, the current datetime will be used. Formatted as YYYY-MM-DDTHH:MM:SS in UTC timezone.


Destination Parameters
db required

MySQL database where the data will be stored.

contacts_table_name required

Table name, in schema.table format, where contact data will be stored.


Load Commission Codes

Download all commission codes from Syncore and store them in a MySQL database.

Variables

Source Parameters
syncore_connection required

Credentials to use to connect to Syncore.


Destination Parameters
db required

MySQL database where the data will be stored.

commission_codes_table_name required

Table name, in schema.table format, where commission code data will be stored.


Load Product Indices

Download all product indices from Syncore and store them in a MySQL database.

Variables

Source Parameters
syncore_connection required

Credentials to use to connect to Syncore.


Destination Parameters
db required

MySQL database where the data will be stored.

product_indices_table_name required

Table name, in schema.table format, where product index data will be stored.