The Auto Importer

Is there a maximum import capacity (# lines)?

There is no maximum number of lines that can be imported in a single file. Speed depends on the hardware and import method but on a low specification server using the auto importer with the file posted to a folder on its local network, 10,000 rows would normally take less than 10 minutes.

Will my data import to MP-5 without amendment?

The MP-5 importers are very flexible, and will import many data files unamended.

Many suppliers of monitoring equipment, monitoring contractors and laboratories will provide files designed for MP-5. Here is a list.

Three layouts of file are common, those with parameters (variables) across the top, sample points across the top - or long list formats with one reading per row.

Header aliases are easily set up, for example where MP-5 may be expecting 'Date', but the file has 'DT', set up a header alias for this.

Object aliases can also be set up, for example 'Borehole 1' can have aliases of 'BH1', BH001', BH_01' and so on.

Absent columns can be 'virtually' added. For example a weather station file is unlikely to provide information within the file of the name of the station. This absent column can be automatically added to its files as they arrive.

Where files are too different for the above options, we can provide custom import routines to plug into your importer.