Data delivery
The SPIN site contains access for endusers to substance data from the database, the guide and help system and general related content on the homepage.
The database can be updated fully from the web interface with the knowledge of username / password and the help of this data delivery guide.
Yearly common data adjustments
After the delivery of data from the participating countries there must be done some common housekeeping to get the last data in place. This is done at the database data control panel at http://spin2000.net/spinmy/main.php This control panel is password protected. Use admin / admin to login and the choose the menu item Controls in the […]
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 […]
Updating Preferred Name
Newly added substances will lack a preferred name. The preferred name should be found in the general list of names and added to the substance description. The preferred name will be the first found name in this type-priority: CAS, COM, PRD, PRN, FIN The function for updating preferred names is part of the database operations […]
Find substances with no name
When new use-data is added to the database, you might end up with some substances without any name. The database control functions can add substances with their pid / casnumber if substances found in the use data are missing in the substance table. Such records can be updated with a name from the substance name […]
Updating code tables
Every codetable in the SPIN system can be updated with new values by anyone with the username / password protected access. The update is initiated from the datacontrol panel at http://spin2000.eu/spinmy/main.php
Find missing CAS-names
Newly added substances will lack a name of type CAS. These added substances should be found and the casnumber list should be used by the casname partner to produce a list of supplemental casnames. The database can tell us which substances need a casname in two ways: Either the simple way by finding all substances […]
Checking for Orphan Codes
If your uploaded data uses codes, that are not found in the codetables, you need to update the code tables. You have a database control, that can help to identify this problem: By running the “Finding orphans” database control, you get a csv file containing the records, that uses a code (or a PID), that’s […]
Updating number syntax
The SPIN substances are registered with CAS numbers, EC numbers and Index numbers. Each of these numbers are registered in the database with and without the format enhancing “-“. If the upload only contained the number in one of these formats, you have three database controls for calculating the other version. Each databse control will […]
Link table for OECD
Yearly updates should be finalized with generating and delivery of a link table to OECD. The last generated link table can be downloaded here: Procedure: Make sure all new substances are added to SPIN Update the OECD link table using the two database controls at http://spin2000.eu/spinmy (1: Update OECD table with new substances, 2: Generate […]