ghs classification system import export operating manual · 2. import / export product information...

GHS Classification System Import Export Operating Manual

Ver.1.2

Contents 1. the beginning....................................................................................................................................... - 1 -

2. Import / export product information ................................................................................................ - 1 -

2.1.The follow of product information import .................................................................................... - 1 -

2.2. Import of product information ..................................................................................................... - 1 -

2.2.1 Checking the substance number for the product ingredient ........................................... - 1 -

2.2.2. Creating text file (TSV format) to import product information. .......................................... - 2 -

Enter one of the information about ‘air ,’’solid’,’liquid’ and ‘aerosol’. ................................................ - 3 -

2.2.3. Import of a text file to import product information .............................................................. - 7 -

2.3 Export of product information .................................................................................................... - 11 -

3. Import ・Export of chemical substance information ...................................................................... - 16 -

3.1.The follow of chemical substance information import ............................................................ - 16 -

3.2. Import of product information ................................................................................................... - 16 -

3.2.1Checking the substance number for the the chemical substance information. .................. - 16 -

3.2.2 .Creating text file (TSV format) to import the chemical substance information. .............. - 18 -

■"Targeted Organ, Exposure Routes List" .................................................................................. - 25 -

3.2.3 Import of the text file to import the chemical substance information. ............................... - 31 -

3.3 export of the chemical substance information ........................................................................... - 35 -

【Reference】 How to compile the exported file in excel format. ...................................................... - 39 -


- 1 -

1. the beginning

This manual is for your operating the ‘Manage product information’ and the ‘Manage

substance information’ at GHS Mixture Classification System in importing and exporting.

2. Import / export product information

You can import /export your product information in text format (TSV format) for your GHS

Mixture Classification by using this system.

When importing a product information, the ingredients information for the product which should

be imported must be registered as chemical substance information in advance.

If the product not registered, first, you should follow the section "5.2.1 Registering Chemical

Substance Information" in the operating manual or "Import of product information" mentioned

later in this manual.

2.1.The follow of product information import

(1)Check the substance number for the product ingredient

(2)Create a text file (TSV format) to import the product information.

(3)Import the text file (TSV format) to import the product information.

2.2. Import of product information

2.2.1 Checking the substance number for the product ingredient

(1)Click on the ‘ Manage substance information’ in the GHS Mixture Classification System Menu

to get chemical substance information display.

Click


- 2 -

(2)Search a substance included in your product ingredient information, and leave the ‘Substance

number’ at the cell in the Substance information list.

Leave all substance number included in your product ingredient information at the Substance

information list.

2.2.2. Creating text file (TSV format) to import product information.

Creating a text file to import the product information in Excel format is more convenient.

In this book, it is explained how to create your text file in Excel format.

A text file to import product information should be created as follow;

Search

Check


- 3 -

Text file format to import product information

Version Number

Item # Data part

*Essential items (the Exception can have a blank cell.) L M S

P* 1* 1* Product Number User control number Product name* Judment rule*

P 2 1 UN number Physical state Flash point Initial boiling point Kinematic viscosity

P 3 1 Remarks 1 Remarks 2 Remarks 3 Remarks 4

S 1 1 Substance number* CAS number Substance name Content* Source*

S 2 1 Substance number CAS number Substance name Content Source

S 3 1 Substance number CAS number Substance name Content Source

Comment

■Information about the version of import file

Put ‘1.0’ of half size of character for your information about import file version.

■Item number

In case of inputting data parts, the item number would be essential.

Large: Enter a sign showing its type of information. When importing product information, only the

‘P’ and the ’S’ will be specified.

P：Basic product information

S：Product composition information

Midium: Enter Serial Number of large item.

When the large is ‘P’, the 1 to 3 will be fixed.

When the large is ‘S’, enter the serial numbers equivalent to the number of the product

information from the ‘1’

Small: ‘1’ is designated number at the product information.

■Data part

Product Number ： It should be blank when registered first time.

Specify the product number when updating the registered product

information.

User control

number ：

Enter the arbitrary control number (only half size of character and number

is acceptable.)

Product name ： Enter the product name to be registered.

Judment rule ： Enter ‘ UN’ or ‘JIS’ in capital letter with the half size of character for the

rule of GHS Mixture Classification.

UN number ： Enter the number in the half size.

Physical state ： Enter one of the information about ‘air ,’’solid’,’liquid’ and ‘aerosol’.When it is blank, the Physical state will be registered as ‘air’.


- 4 -

Flash point ：

Enter the information in the half size of character and number. (decimal

point is acceptable.)

Initial boiling

point ：



Kinematic

viscosity ：



Remarks1-4 ： Enter other information at the Remarks.

It separates columns for each row. ‘1～4’ mean the number of row .

Substance

number ： Enter the number left in the Substance information list.

Enter the half-width numbers of 11 digits and zero padding.

CAS number ： Enter the half-width number and half size of ‘-‘.

When importing, the CAS number left at the ‘Substance number’in the

substance information list will be registered.

Substance name ： Enter the chemical substance name.

When importing, the substance name left at the ‘Substance number’ in the

substance information list will be registered.

Content ： Enter only the half size of number.( decimal point is acceptable.)

Unit symbol is not acceptable. For example,’ %’.

Source ： Enter the source registered at the optional setting in this system.

An example following the formats in above.

【NOTE】

When entering number in an Excel format, put an single quote (‘ ) at the head of number to

prevent to get the ‘Version number’, the ‘Product number’ , the ‘Substance number’, and the ‘CAS

number’ converted automatically.

【Reference】

Repeat entering the large item ‘P’ ～’S’ except the version information after the first product

information inputting.

Save the product information you created as text file (in TSV format).

Click on ‘Save as’ →’other format’. (Excel 2007)


- 5 -

Choose the ‘text (tab delimited, TSV)’ in the file type.

Click the other format

Click

Select txt file(TSV)


- 6 -

Put the file name to save , and click on ‘Save(S)’.

The display with warning comment, the file type you chose does not support the book including

some sheet , will show up.

Click on ‘OK’ to go on.

Next, you will get the message about non-interchangeability .Click on ‘Yes(Y)’ to save.

The Excel file to import product information is saved as text file in above process.

Click

Click

Click


- 7 -

2.2.3. Import of a text file to import product information

Importing the created text file to import the product information in above into the system .

(1)Click on ‘Manage product information’ in the GHS Mixture Classification System Menu

to get the product information display.

(2) Click on ‘Import’ in the Product informaion list.

Click

Click


- 8 -

(3)When the product information import display coming up, click on ‘Browse’ to get the import file

you created. And click on the ‘Product information import list’.

(4)You will have the’ product information import list ‘to check your import result.

You can see the number of successfully imported.

Click

Click


- 9 -

If you had one ‘Failed’ and more, click on the ‘Error details’ to get the error information file.

Choose the storage place for the error file and click on ‘Save(S)’.

Clicknumber of failed files

Click


- 10 -

The file saved has the details about import errors, check the massage and fix the data .

Try to import the file again.


- 11 -

2.3 Export of product information

Exporting the registered product information into the text file (TSV format) .

And based on the exported file, it is possible to register the new information or to change the

registered information

(1)Click on ‘Manage product information’ in the GHS Mixture Classification System Menu to

have the product information list .

(2)Search the product information to export. Put a check mark at the ‘Select’ , and click on

‘ Export’.

Search Product

Check

Click

Click


- 12 -

(3) Click on ‘Browse’ to choose the save location.

After exported without any probrem , the following massage will show up.

In case of the product information classified, the exported file will have the result in two kinds of

rules, JIS and UN.

Click

Click


- 13 -

The format of the text file outputted is following;

Format of export file about product information.

Version Number

Item # Data part

L M S

P 1 1 Product Number User control

number Product name

Judment

rule

P 2 1 UN number Physical state Flash point Initial

boiling point

Kinematic

viscosity


S 1 1 Substance number CAS number Substance

name Content Source


name Content Source


name Content Source

D 1 1 Explosives Classification

not possible Basis1 Basis2 …

D 2 1 Flammable gases Category 1 Basis1

：：：

D 16 1 Corrosive to metals Category 1 Basis1

H 1 1 Acute toxicity (oral) Category 2 Basis1

H 2 1 Acute toxicity (dermal) Not applicable Basis1

：：：：

H 13 1 Reproductive toxicity Not applicable Basis1

H 13 2 Reproductive toxicity,

effects on or via lactation Additional… Basis1

H 14 1 Specific target organ

toxicity (single exposure) Yes Category Basis1 Basis2


toxicity (single exposure) Category 1 Organ1

Exposure

route1


toxicity (single exposure) Category 1 Organ2

Exposure

route2

H 15 1

Specific target organ

toxicity (repeated

exposure)

Yes Category Basis1 Basis2

H 15 2 Specific target organ Category 1 Organ1 Exposure


- 14 -

toxicity (repeated

exposure)

route1

H 15 3


toxicity (repeated

exposure)

Category 1 Organ2 Exposure

route2

H 16 1 Aspiration hazard Category 1 Basis1

E 1 1

Hazardous to the

aquatic

environment(acute

hazard)

Category 1 Basis1

E 2 1

Hazardous to the

aquatic

environment(long-term

hazard)

Category 1 Basis1

E 3 1 Hazardous to the ozone

layer Category 1 Basis1

When classified the product, the classification result is included in the export file.

■item number

Large

When classified the product, following letter will show up.

P：Basic product information

S：Product composition information

D：Physical hazards Classification result

H：Health hazards Classification result

E：Environmental hazards Classification result

Midium:

When the large is ‘P’, the 1 to 3 will be fixed.

When the large is ‘S’, enter the serial numbers equivalent to the number of the product

information from the ‘1’

When the large is ‘D’,’H’,’E’,’T’, one set of the number and the hazardous item .

It is necessary to put the number corresponding to each items.

Small

When the product was classified in Specific target organ toxicity (single exposure or

repeated exposure), The same number of classified organ and exposure root will show up

from the 2.


- 15 -

■The data part

Items in the classification result will be added.

Item ： Hazardous item in GHS classification will be shown.

Classification result ： Each classification results in hazardous item will be shown.

Basis1-n ： The Basis for classification result will be shown.

When there are some rows ,enter‘1’in each rows.

Specific target organ toxicity ： In case of the classification result is 「Yes Category」

1.In the sub-item「1」, the basis for the classification result will

be shown after 「Yes Category」 .

2.After the sub-item「2」, each classifications will be shown

And target organs and exposure route will be shown next.

3. (Whether categories are the same or not,) When there are

multiple targets for organ toxicity; they will be displayed in

different lines with their category, targeted organ and

exposure route information.

In case of the results is “Classification not possible” or “Not

classified”,

1.In the sub-item「1」,Classification will be shown and the

basis for the result will be shown next.


- 16 -

3. Import ・Export of chemical substance information

You can import and export chemical substance information as ingredient information of a product in

text file (TSV format) by using this system.

By importing and exporting , you can update the registered information and register new

information.

If you are managing the data of plural chemicals in the Excel file format (1 substance per line

format), please use the GHS Chemical Substances Information TSV Conversion Tool.

3.1.The follow of chemical substance information import

(1)Check the substance number for the chemical substance information.

(2)Create a text file (TSV format) to import the chemical substance information.

(3)Import the text file (TSV format) to import the chemical substance information.

3.2. Import of product information

3.2.1Checking the substance number for the the chemical substance information.

(1)Click on the ‘ Manage substance information’ in the GHS Mixture Classification System Menu


* Repeat entering the large item「P」-「T」 except the version information after the first product

information inputting.

* When registering the same chemical substances with different sources:

Will repeatedly enter "Source P-4-1" and items after that.

* When using the GHS Chemical Substances Information TSV Conversion Tool:

There are limits on remarks field, classification basis and specific target organ toxicity, and

when the limit is exceeded, it is required to enter the excessive data manually after converting

it to chemical import text file. Also, please remove the unnecessary empty fields.

Click


- 17 -

(2)Search a substance included in your product ingredient information, and leave the ‘Substance

number’ at the cell in the Substance information list.

Search Substance information

note the substance number


- 18 -

3.2.2 .Creating text file (TSV format) to import the chemical substance information.

Creating a text file to import the product information in Excel format is more convenient.

In this book, it is explained how to create your text file in Excel format.

A text file to import product information should be created as follow;

Compared to the text file format to import product information, GHS classification results and

toxicological information are added.

Text file format to import the chemical substance information.

Version number

Item number Data part

L M S

P 1 1 Substance number CAS number Substance

name

P 2 1 Equivalency factor

Oxygen

eqivalent

coefficient

pH

Maximun

concentration

of the

flammable

gas

Minimum

concentration

of the

flammable

gas

P 3 1 Acid Base Inorganic

salt Aldehyde Phenol

Surfactant or

other

ingredient

P 4 1 source


D 1 1 Explosives Not applicable Basis 1 Basis 2

D 2 1 Flammable gases (including

chemically unstable gases)

Classification

not possible Basis 1 Basis 2

D 3 1 Aerosols Classification


D 4 1 Oxidizing gases Classification


D 5 1 Gases under pressure Classification


D 6 1 Flammable liquids Category 2 Basis 1 Basis 2

D 7 1 Flammable solids Classification


D 8 1 Self-reactive substances and Not applicable Basis 1 Basis 2


- 19 -

mixtures

D 9 1 Pyrophoric liquids Not applicable Basis 1 Basis 2

D 10 1 Pyrophoric solids Classification


D 11 1 Self-heating substances and

mixtures Not applicable Basis 1 Basis 2

D 12 1

Substances and mixtures

which, in contact with water,

emit flammable gases

Not applicable Basis 1 Basis 2

D 13 1 Oxidizing liquids Not applicable Basis 1 Basis 2

D 14 1 Oxidizing solids Classification


D 15 1 Organic peroxides Not applicable Basis 1 Basis 2

D 16 1 Corrosive to metals Not applicable Basis 1 Basis 2

H 1 1 Acute toxicity (oral) Not applicable Basis 1 Basis 2

H 2 1 Acute toxicity (dermal) Not applicable Basis 1 Basis 2

H 3 1 Acute toxicity (inhalation:

gas)

Classification



vapour) Category 4 Basis 1 Basis 2


dust, mist) Not applicable Basis 1 Basis 2

H 6 1 Skin corrosion/irritation Category 2 Basis 1 Basis 2

H 7 1 Serious eye damage/eye

irritation Category 2B Basis 1 Basis 2

H 8 1 Respiratory sensitization Not applicable Basis 1 Basis 2

H 9 1 Skin sensitization Not applicable Basis 1 Basis 2

H 10 1 Germ cell mutagenicity Not applicable Basis 1 Basis 2

H 11 1 Carcinogenicity Category 2 Basis 1 Basis 2

H 12 1 Reproductive toxicity Category 1A Basis 1 Basis 2

H 13 2 Reproductive toxicity, effects

on or via lactation Additional… Basis 1 Basis 2

H 14 1 Specific target organ toxicity

(single exposure) Yes Category Basis 1 Basis 2


(single exposure) Category 1 Organ 1

Exposure

route 1


(single exposure) Category 1 Organ 2

Exposure

route 2


- 20 -


(repeated exposure) Yes Category Basis 1 Basis 2


(repeated exposure) Category 1 Organ 1

Exposure

route 1


(repeated exposure) Category 1 Organ 2

Exposure

route 2

H 16 1 Aspiration hazard Not applicable Basis 1 Basis 2

E 1 1 Hazardous to the aquatic

environment(acute hazard) Category 2 Basis 1 Basis 2

E 2 1

Hazardous to the aquatic


hazard)

Category 3 Basis 1 Basis 2

E 3 1 Hazardous to the ozone layer Not applicable Basis 1 Basis 2

T 1 1 Toxicity value:Acute toxicity

(oral) Toxicity value


(dermal) Toxicity value


(inhalation: gas) Toxicity value


(inhalation: vapour)ppm Toxicity value


(inhalation: vapour)mg/L Toxicity value


(inhalation: dust, mist) Toxicity value

T 7 1

Toxicity value:Hazardous to

the aquatic

environment(acute

hazard)LC50(fish)

Toxicity value

T 8 1


the aquatic

environment(acute

hazard)EC50(crustacea

species)

Toxicity value

T 9 1


the aquatic

environment(acute

hazard)EC50(algal species)

Toxicity value


- 21 -

T 10 1


the aquatic

environment(acute

hazard)Toxicity multiplying

factor

Toxicity

multiplying

factor

T 11 1


the aquatic


hazard)NOEC(fish)

Toxicity value

T 12 1


the aquatic


hazard)NOEC(crustacea

species)

Toxicity value

T 13 1


the aquatic


hazard)NOEC(algal species)

Toxicity value

T 14 1


the aquatic


hazard)Rapid degradability

Rapid

degradability

T 15 1


the aquatic


hazard)Toxicity multiplying

factor

Toxicity

multiplying

factor


- 22 -

■Information about the version of import file

Put ‘1.0’ of half-width numbers for your information about import file version.

■Item number

In case of inputting data parts, the item number would be essential.

Large: Enter a sign showing its type of information.

P：Basis information of substance

D：Physical hazards Classification results

H：Health hazards Classification result

E：Environmental hazard Classisification result

T：Toxicity value

Note: If Large item is "P", the number is fixed 1 to 5.

Medium: Enter Serial Number of large item.

When the large is ‘D’,’H’,’E’,’T’, one set of the number and the hazardous item .

It is necessary to put the number corresponding to each items.

If the hazardous item doesn’t have its number, the classification will be registered as a blank.

Small: For all items, put the number from the 「1」. However, in case of the product is classified as

‘Specific target organ ‘, put the serial numbers from「2」 corresponding to the number of

classification.

■Data part

Substance number ： When registering first time, it should be blank.

When updating the chemical substance information about the

registered substance , enter the substance number to be udated.

CAS number ： Enter the CAs number to be registered.

Substance name ： Enter the chemical substance name to be registered .Essential.

Equivalency factor ： Enter the half size number(decimal point is acceptable)

Oxygen eqivalent

coefficient ： Enter the half size number(decimal point is acceptable)

pH Enter the half size number(decimal point is acceptable)

Maximun

concentraton of the

flammable gas

： Enter the half size number(decimal point is acceptable)

Minimum

concentraton of the

flammable gas

： Enter the half size number(decimal point is acceptable)

Acid(ph≦2) ： Enter the word of 「Applicable」or「Not Applicable」

The blank is registered as 「Not Applicable」.


- 23 -

Base(ph≧11.5) ： Enter the word of 「Applicable」or 「Not Applicable」

The blank is registered as 「Not Applicable」.

Inorganic salt ： Enter the word of 「Unknown」,「Applicable」and「Not Applicable」

The blank is registered as 「Unknown」.

Aldehyde ： Enter the word of 「Unknown」,「Applicable」and「Not Applicable」


Phenol ： Enter the word of 「Unknown」,「Applicable」and「Not Applicable」


Surfactant or other

ingredient ： Enter the word of 「Unknown」,「Applicable」and「Not Applicable」


Remark1～4 ： Fill out the remarks with basic information about the chemical

substnace.

It separates columns for each row.1～4 mean the number of remark

row.

source ： Enter the source registered at the optional setting in this system.

■GHS Classification part

Item ： Enter only the half size number(decimal point is acceptable)

Blank is acceprable.

Classification result ： Enter the classification result for each hazardous items.

Enter the half size of character and number for classification.

The blank will be registered as 「Not Applicable」.

Basis 1-n ： Enter the basis for each classification result.

When there are some rows ,enter‘1’in each rows.


toxicity item ：

In case of the classification result is 「Yes Category」

1.In the sub-item「1」, enter the classification result (category)and the

basis next.

After the sub-item「2」, enter the categories , and enter the target

organs and exposure route.

About target organ and exposure route, pick up from the appendix .

In case of the results is “Classification not possible” or “Not classified”,

1.In the sub-item「1」,Classification will be shown and the basis for the

result will be shown next.


- 24 -

■Toxicity part

Item ：Enter only the half size number(decimal point

is acceptable)Blank is acceprable.

Toxicity value: Acute toxicity (oral) ：

Enter only the half size number(decimal point

is acceptable)

The unit for the value is mg/kg.

Toxicity value: Acute toxicity (dermal) ：


is acceptable)

The unit for the value is mg/kg.

Toxicity value: Acute toxicity (inhalation: gas) ：


is acceptable)

The unit for the value is ppm.

Toxicity value: Acute toxicity (inhalation:

vapour)ppm ：


is acceptable)

The unit for the value is ppm.

Toxicity value:Acute toxicity (inhalation:

vapour)mg/L ：


is acceptable)

The unit for the value is The unit for the value

is mg/mL.

Toxicity value:Acute toxicity (inhalation: dust,

mist) ：


is acceptable)


is mg/mL.

Toxicity value:Hazardous to the aquatic

environment(acute hazard)LC50(fish) ：


is acceptable)


is mg/mL.


environment(acute hazard)EC50(crustacea

species)

：


is acceptable)

The unit for the value is mg/mL.


environment(acute hazard)EC50(algal species)：


is acceptable)

The unit for the value is mg/mL.


environment(acute hazard)Toxicity multiplying

factor

：Enter only the half size number(decimal point

is acceptable)


environment(long-term hazard)NOEC(fish) ：


is acceptable)



- 25 -

is mg/mL.



hazard)NOEC(crustacea species)

：


is acceptable)


is mg/mL.


environment(long-term hazard)NOEC(algal

species)

：


is acceptable)


is mg/mL.


environment(long-term hazard)Rapid

degradability

：Enter the one of ‘unknown’ ,’present’ or ‘not

present’

The blank eill be registered as ‘unknown’


environment(long-term hazard)Toxicity

multiplying factor

：Enter only the half size number(decimal point

is acceptable)

■"Targeted Organ, Exposure Routes List"

Selected specific target organs and exposure routes in the list below are recorded in the chemical

import text file.

Organ list

Respiratory

tract irritancy Joints Visual system

Digestive

system Kidneys

Skeletal

system

Bronchial

tubes

Skin

appendages Blood system

Digestive

organs Bladder Bone

Immune

system Red blood cell

Respiratory

system Teeth

Reproductive

organs Skeleton

Cerebral

blood vessels

Nervous

system Blood Digestive tract

Male

reproductive

organs

Bone tissue

Oral cavity Nerves Hematopoietic

system

Respiratory

tract Testes Joints

Esophagus

Central

nervous

system

Bone marrow Stomach Appendix

testis

Systemic

toxicity

Intestinal

tract

Central

nerves Immune system Intestines

Upper

respiratory

tract

Systemic

symptoms


- 26 -

Large

intestine

Central

neurological Lymph system Small intestine Prostate Systemic

Teeth/periodo

ntal tissue Brain Thymus Duodenum Ovary

Nasal mucous

membranes

Periodontal

tissue

Peripheral

nervous

system

Spleen Salivary gland Uterus Blood

Gums

Autonomic

nervous

system

Reticuloendothel

ial system

Submandibula

r gland

Accessory

reproductive

organs

Lymph nodes

Liver/gallblad

der

Narcotic

effects

Circulatory

system Pancreas

Endocrine

system Nasopharynx

Lungs

Cranial

nervous

system

Circulatory

organs Liver Pituitary gland

Lower

respiratory

tract

Reproductive

system Optic organs

Respiratory

organs Liver Thyroid gland Larynx

Male

reproductive

system

Eyes Cardiovascular

system Gallbladder Adrenal gland Trachea

Female

reproductive

system

Optic nerve Cardiovascular

system

Upper

respiratory

organs

Skin Spinal cord

Parathyroid Retina Heart Pancreas Hair (hair loss) Peripheral

nerves

Skin/skin

appendages

Auditory

organs Heart muscle Urinary organs Nasal cavity Motor nerves

Body hair Sense of

hearing Vascular system

Urinary

system Muscle

Hematopoieti

c organs

Muscular

system

Olfactory

organs Blood vessels Kidneys

Skeletal

muscle

Exposure route list

Inhalation

Dermal

Oral


- 27 -

(Gas)inhalation

(Vapor)inhalation

(Dust,mist)inhalation


- 28 -

An example following the formats in above.

NOTE:

When entering number in an Excel format, put an single quote (‘ ) at the head of number to

prevent to get the ‘Version number’, the ‘Substance number’, and the ‘CAS number’ converted

automatically

Save the product information you created as text file (in TSV format).

Click on ‘Save as’ →’other format’. (Excel 2007)

Click other format

Click


- 29 -

Choose the ‘text (tab delimited, TSV)’ in the file type.

Put the file name to save , and click on ‘Save(S)’.

Choose the ‘text (tab delimited, TSV)’

Click


- 30 -

The display with warning comment, the file type you chose does not support the book including

some sheet , will show up.

Click on ‘OK’ to go on.

Next, you will get the message about non-interchangeability .Click on ‘Yes(Y)’ to save

The Excel file to import product information is saved as text file in above process.

Click

Click


- 31 -

3.2.3 Import of the text file to import the chemical substance information.

Importing the text file to import the chemical substance information.

(1) Click on the ‘Manage substance information’ in the GHS Mixture Classification System Menu


(2)Click on ‘ import ‘ in the Substance information list.

Click

Click


- 32 -

(3)When the product information import display coming up, click on ‘Browse’ to get the import

file you created. And click on the ‘Substance information import list’.

(4) When the ‘substance information import list’ showing up, check the result of import.

You can see the number of data imported without any problem at the ‘Successfully’ in the

window.

Click

Click


- 33 -

If you had one ‘Failed’ and more, click on the ‘Error details’ to get the error information file.

Choose the storage place for the error file and click on ‘Save(S)’.

Clicknumber of failed files

Click


- 34 -

The file saved has the details about import errors, check the massage and fix the data .

Try to import the file again.


- 35 -

3.3 export of the chemical substance information

Exporting the registered chemical substance information into the text file (TSV format) .

And based on the exported file, it is possible to register the new information or to change the

registered information .

(1)Click on ‘Manage substnace information’ in the GHS Mixture Classification System Menu to

have the chemical substance information list .

(2)Search the chemical substance information to export. Put a check mark at the ‘Selct’, and

click on ‘ Export’.

Search

check

Click

Click


- 36 -

3) Click on ‘Browse’ to choose the save location.

After exported without any probrem , the following massage will show up.

The exported file is following;

Exported file format is the same as the chemical import text file format.

Refer to ‘3.2.2 .Creating text file (TSV format) to import the chemical substance information’ for

the details of items.

Click

Click


- 37 -

4. Importing the exported result of the product information into the chemical substance

information.

In case of using the classification result from this tool as one substance included in another

mixture, you can use the exported result of the product information as the chemical substance

information by importing.

The method to compile an export file is following;

Refer to ‘3.2.2 .Creating text file (TSV format) to import the chemical substance information’ for

the details of items.

List of edit item to export the product information.

Version Number

Item # Data part

L M S

P 1 1 The results of export data will rewrite the contents of the information on chemical substances for import.

If you do not specify a material number, the system registered as a new substance.



P 4 1 Add one line, and then add the "source" to information on chemical substances.

P 5 1 Add one line and then add the "Remarks", if necessary. (optional)

S Delete all "S" items.

D

L item of "D", "H", "E" (GHS classification) is not need edit the data. H

E

T 1 1 Toxicity value:Acute toxicity (oral)

You add the data, if there is a test result of the mixture.

T 2 1 Toxicity value:Acute toxicity (dermal)


(inhalation: gas)


(inhalation: vapour)ppm


(inhalation: vapour)mg/L


(inhalation: dust, mist)

T 7 1 Toxicity value:Hazardous to the aquatic

environment(acute hazard)LC50(fish)

T 8 1 Toxicity value:Hazardous to the aquatic

environment(acute


- 38 -

hazard)EC50(crustacea species)

T 9 1


environment(acute hazard)EC50(algal

species)

T 10 1


environment(acute hazard)Toxicity

multiplying factor

T 11 1



hazard)NOEC(fish)

T 12 1



hazard)NOEC(crustacea species)

T 13 1



hazard)NOEC(algal species)

T 14 1


environment(long-term hazard)Rapid

degradability

T 15 1


environment(long-term hazard)Toxicity

multiplying factor


- 39 -

【Reference】 How to compile the exported file in excel format.

(1)Click on ‘ Open (O)’

(2)Choose the all type of file for the file format.

Click

select All items


- 40 -

(3)Choose the export file (TSV format) saved, click on ‘open(O)’.

(4)When the text file wizard display showing up, click on ‘complete(F)’.

Select export file.

Click

Click


- 41 -

(5)You will be able to compile the information in Excel .

(6)When saving the changes after compiling, you will get the message

about non-interchangeability .Click on ‘Yes(Y)’ to save

Click

ghs classification system import export operating manual · 2. import / export product information...

Documents