LIMS.eu

Import transformation codes for import interfaces offer the possibility to convert the loaded raw data into a different format, or to process it further before it is imported into the LDB. The first parameter contains a String with the raw data. This can be processed either manually or with one of the provided libraries. The second parameter contains the filename, also as a String.

The return value must be an Array of objects whose keys correlate with the columns to be imported.

Example of a transformation code:

function transform (data, filename) {
  const parsedData = xmlParser.parse(data)
  const filenameWithoutExtension = filename.match(/(.*)\.\w+/)[1]
  
  let result = parsedData.ERGEBNIS.map((e) => {
    return {
      'Datum': e.Datum,
      'Stichwort': e.Stichwort,
      'Probenstatus': e.Probenstatus,
      'Datei': filenameWithoutExtension
    }
  })

  return result
}