View Single Post
Old 01-31-2013, 06:57 AM   #6
xiquinho
Junior Member
xiquinho began at the beginning.
 
Posts: 7
Karma: 10
Join Date: Jan 2013
Device: ipad
Hi again! I am building this in VB and I was able to convert the JSON field to a XML file and from there read all the data originally stored on the JSON. I know this sound strange but it is exactly what I need. The part I don’t understand now is how to “relate” the data stored in the JSON field with the other tables. For example, I have a user category in JSON like this:
"Computers": [
[
"Adobe",
"tags",
10943
]…etc
After the conversion, my XML file looks like this:
<Computers>
<Computers>Adobe</Computers>
<Computers>tags</Computers>
<Computers>10943</Computers>
</Computers>…etc
But in the table “tags” the Adobe tag have an id:
"9383","Adobe"
So, my question is: where does the value 10943 (stored in JSON) comes from? How can I make a relationship between the two values? (10943 and 9383). Is there a formula for this or something?
Thanks in advance for your help!

Last edited by xiquinho; 01-31-2013 at 07:02 AM.
xiquinho is offline   Reply With Quote