Our need is to create a flat MySQL table that replaces text from XML lookup lists.
-current field data is: 1.1,1.2,1.4
-lookup values: 1.1=red,1.2=yellow,1.3=green,1.4=blue,1.5=black
-resulting new flat table with field data: red,yellow,blue
Desired product = an automating script that can parse through the single XML file and update all the lookup values into this new database table.
IMPORTANT: This script is needed within the next couple days, so experience and speed is highly desired.