export_bgc_phyto_raw changes

[leonardolaiolo]

Hi Leo,
Good to see you at the AM,
We have altered some of the permissions on the export_bgc_phyto_raw table we send to you. We are now allowing 3 columns to be null which previously required values.

cell_count - nulls now allowed
sampVol_L - nulls now allowed
comments - nulls now allowed

This is because we don't have this information for SOTS or SARDI (and never will) and we need these data served alongside the current collection. Please can you update your tables and re-harvest and let me know that it all went OK. You can check that it has worked as there will be trip codes that contain 'GSV' and 'SAM' and 'Pulse_7'.

Sorry to have not picked this up when we were talking about this issue recently,
Claire