SanMar Inventory to MySQL Loader

Obtain inventory information from SanMar's FTP server and store it in a MySQL database.

Download Data

Download inventory information from SanMar.

Variables

Source Parameters

ftp_connection required

FTP connection used to access SanMar's inventory information.

ftp_file_path required

Path to the file on the FTP Server where the inventory information exists.

Destination Parameters

mysql_connection required

MySQL database where the inventory information will be stored.

target_table_name required

Table name, in schema.table format, where the deduplicated inventory data will be permanently stored.

staging_table_name required

Table name, in schema.table format, where the FTP file data will be temporarily stored and examined for deduplication.

create_table_if_dne required

If enabled, tables specified that do not exist will be created.

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