Bulk import and Listing report

[Mike Dewhirst]

Use a spreadsheet from an inhouse system to cover the minimum data required to create a chemical in Chemintro with a view to determining the AICIS listing on every import run in order to refresh that Listing status.

Input spreadsheet first five columns for Chemintro

• Chemical name
• CAS number
• Physical state
• Origin Local/Imported/Both (might need a default if that isn't available)

The spreadsheet needs to be run every now and again to update the chemicals in Chemintro and retrieve the changes once again.

Chemicals missing from the spreadsheet will be set 'Excluded' in Chemintro.

The annual report in Chemintro would deliver the necessary info for the AICIS Annual Declaration.

Success test is to discover any changes in the AICIS listing status of each chemical.

The mechanism for reporting the changes is yet to be decided.