BUG_NESTED_MANY

Obtain Excel Spreadsheets from a Digital Ocean space and store it in a MySQL database.

Download Data

Download Excel Spreadsheets from Digital Ocean Space.

Variables

Source Parameters

do_spaces_connection required

Digital Ocean Spaces Connection used to access Excel Spreadsheets

region_name required

Digital Ocean Region where the Space exists.

space_name required

Digital Ocean Space name where Excel Spreadsheets exists.

space_folder_path required

Path to the folder on the Digital Ocean Space where the Excel Spreadsheets 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.

Download Options

process_subfolders required

Process Excel files that exist within subfolders of specified folder path.

source_file_column required

Column name within target database that speficies the origin of the data

Mapping Parameters

mappings required

Details about each column within the relational database.

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