Excel Uploader Usage

The topics in this section cover how to open, configure and use the MineMarket Excel Uploader.

The Excel Uploader can be edited and run without saving the spreadsheet. The Excel Uploader can be run multiple times, either with different data sheets selected, or with the same data sheets selected.

If the Excel Uploader is run multiple times with the same data sheets selected, only new objects (which do not have upload records in the Id column (A) and In Database column (B) of the data worksheets) are uploaded. Data that already exists in the MineMarket database is not changed, even if the Excel Uploader has data for objects with matching Alias1 values.

The Excel2007Sample.xlsm file can be saved with a different file name (with the extension XLSM). Multiple XLSM files can be located in the MineMarket installation folder. Only the default DLL, DLL.MANIFEST and VSTO files are required.

For data to be uploaded, it must:

  • Be on a data worksheet that has a name that has a corresponding Sheet Name on the Mapping worksheet (in Column A)
  • Be on a data worksheet that is selected (that is, with a lowercase y) on the Mapping worksheet
  • Be above any empty rows in the data worksheet
  • Be in a column of the data worksheet that corresponds to a MineMarket field
  • Be the correct data type for the MineMarket field (for example, text string, integer)
  • Not have data in the Id column (A) and the In Database column (B)
  • Have matching prerequisite data either already in the MineMarket database, or in the data upload
  • Not have the same Alias1 value as any object already in the MineMarket database

Note: If any data displays as strikethrough text, check the Calculation Options on the Formulas ribbon menu of Excel. In Excel’s Manual calculation mode, an option was introduced in 2023 called Format Stale Values. When enabled, Format Stale Values adds strikethrough formatting to some cells, and this may lead to upload errors. When using the Manual calculation mode, ensure Format Stale Values is unchecked, and press F9 to update calculations before running the Excel Uploader.