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.
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.