Yearly national data delivery

The yearly update from each national participant is mainly done by simply uploading some csv files with the new usedata. The upload is initiated from the upload operations panel

at http://spin2000.net/spinmy/main.php

This control panel is password protected. Contact admin(at)infoshare(dot)dk to get login information, if you cannot find them. The database operations panel gives you some definition options for your upload: You can choose any of the SPIN database tables for data maintenance – choose from the dropdown list in the field “Table”. Next choose the type of operation, you want to perform – for yearly delivery you would have a csv file with new data for the year/country combintion and you will chose Add:

• Replace: Replaces the entire database table with the content uploaded by you.
• Add: Add the linies in your csv file to the content of the database table
• Update: Updates the existing data by adding your uploaded content to the existing records.
• Restore: If for some reason you want to reverse to the data as they were before your upload.

The fast track to do an yearly update is to verify, that the column headings in your csv file is spelled the same way as it is shown on the screen when you select the table – including upper/lowercase – and the put a tick mark in the “Enable custom fields”. Remember this site is using English and expecting the decimalpoint to me a . (full stop) not a comma.

Generally you have two options for defining the contents of your csv file to the upload system: You can select the fields you wish to upload from the list of fields in the box Field Name – your csv file must contain the selected fields in the same order as shown in the box. Or you can “Enable custom fields” by the tickmark: In this case the upload system will take the first line of your csv file and interpret the content here as the names of fields. You must use same spelling as shown in the box “Field name”.

The File input button “Gennemse..” (Text is dependent on the language of your computer) is for finding the csv file on your computer.

Csv files can have slightly different syntax: If the separator between your field values is anything else than ; (semicolon) – typical , (comma) – you can enter this in the Separator field and if your text values are enclosed with a special character, typical ” (double quotation marks), you can enter this in the field Enclose value. Decimal point is always assumed to be . (full stop).

Finally, when you have everything in place, you click on submit. For large datafiles the upload can take some time. Your upload will start by making a backup copy of the database table for later restore if necessary.

If your yearly update also include an update of the substance names, you can do this exactly the same way. But, if for some reason your csv file contains both new names and existing names, this procedure will fail. You have to do it slightly different: Upload your names csv file to the table temp_spinname using the Replace function and then change to Database Controls and activate the controlfunction Copy values from temp_spinname to spinname replacing duplicates. This will both add new names of the same nametype and update the spelling of existing names.

Adding new substances: If you would like to be able to find new substances right away, you should also add the new substances to the spinstof table. You can do this by uploading a csv file with the new substances, but a faster shortcut to this is to choose the database control Add new spinstof from spinname.

And the you are all done. (Except for the yearly special updates, that isn’t done by each country).