How to generate automatically CSRs with mooring coordinates retrieved from two separate database fields?

In MIKADO automatic, the mooring coordinates are combined into one field (var36 = Longitude, Latitude).

If you want to link the var36 "Coordinates" to two separate fields (latitude and longitude) of your database, you have to concat them in your query; MIKADO will be able to separate them in the XML output file. For example:

  • For Oracle database: var36 = longitude || ',' || latitude
  • For Sybase: var36 = ltrim(str(longitude,9,5))+ ', '+ ltrim(str(latitude,9,5))