Overview

The Excel plugin enables Mitto to pipe data from Excel and store the data in a database.

Create an Excel job

Click + Add Job.

Choose Excel.

Fill out the forms.

  • Source - Choose the Excel file you want to pipe data from. The Excel file must exist in the Mitto file manager.

Click Next.

  • Sheet - This is the tab/sheet in the Excel file. You will only create 1 table in the database from 1 sheet in the Excel file. In the Excel plugin wizard, the list of sheets will be available in the dropbox. In the resulting Excel job, sheet can either use the name of the sheet as a string or the index of the sheet as an integer (0 is the first sheet).
  • Start Row - This is optional, but allows you to skip rows in the Excel file. 0 is the first row. 0 by default.
  • Start Column - This is optional, but allows you to skip columns in the Excel file. 0 is the first column. 0 by default.
  • Include Header - Check this if the data has a header. Checked by Default.
  • Noneify - Check this if you want to convert empty values to NULL. Checked by default.

Click Next.

  • Title - This is the resulting job's title.
  • Type - This is the output database.
  • Table - This is the output table.
  • Schema - This is the output schema.

For Excel job naming best practices, see the following convention:

  • If the name of the Excel file is Orders.xlsx and the name of the tab in the file is Sheet1 then the name of the job should be: [Excel] Orders.xlsx - Sheet 1.

Click Done.

Configure an existing Excel Job

Navigate to the job and click Edit.

The main sections to edit are input and output.

Input:

source: This is the Excel file on the Mitto box.

sheet: This is the tab/sheet in the Excel file. You will only create 1 table in the database from 1 sheet in the Excel file. sheet can either use the name of the sheet as a string or the index of the sheet as an integer (0 is the first sheet).

start_column: This is optional, but allows you to skip columns in the Excel file. 0 is the first column.

start_row: This is optional, but allows you to skip rows in the Excel file. 0 is the first row.

Output:

dbo: This is the connection string of the output database. If you are outputting data into Mitto's internal PostgreSQL database, leave this as is.

schema: This is the output schema in the database.

table: This is the output table in the database.

Example Excel Inputs

mitto-job-templates/io/inputs/excel at master ยท zuarbase/mitto-job-templates
Job templates for Mitto. Contribute to zuarbase/mitto-job-templates development by creating an account on GitHub.