2x DB source of GHS symbols and H-code (Hazard statements) a P-code (Precautionary statements)
Please help me: I have 2 data source: 1) MS SQL DB inc. code and 2) Google or Excel with a table what does it mean. How to pair this and put it on the label? Any script?
1) Source CSV from SQL: H290; H314; P260; P280; …
2) Source Google/XLS table:
H290; May be corrosive to metals.
H314; Causes severe skin burns and eye damage.
P260; Do not breathe dust/fume/gas/mist/vapours/spray.
P280; Wear protective gloves/protective clothing/eye protection/face protection.
-
You need to add the two databases to the label format and will then be prompted to declare a join statement to say, for example that the H290 code is field #3 in the SL table whilst the same value is field #1 in the Excel sheet
0 -
I thought that if I put the P and H sentences in one field (user variable, de facto CSV inserted into one SQL field), I would be able to handle it somehow - ideally directly in Bartender. Unfortunately, that didn't happen and the SW supplier didn't help me either, they referred me to the SW authors. Do you know of a solution in Bartender?
ERP program, CSV inside SQL: https://drive.google.com/file/d/16AaTK74gGoUBEVwWUWlhpWBk2jHpNPfD/view
I have proble made couple, because I have in one “field” more codes:
https://drive.google.com/file/d/1sIAg2ZpZIgMSCRkkEtpMV_G_WgHuUmRp/view
Can I split this field in Bartender?0
Vous devez vous connecter pour laisser un commentaire.
Commentaires
2 commentaires