Re^2: Copy XML file, write new attributes and move the old files.

id (prim key, auto increment)

name (VARCHAR(255)

Comment on Re^2: Copy XML file, write new attributes and move the old files.

Replies are listed 'Best First'.
Re^3: Copy XML file, write new attributes and move the old files. by poj (Abbot) on Jan 27, 2015 at 09:34 UTC
In that case, here's a working script to demonstrate the basics of what I think you are trying to do. Read more... (4 kB) poj	[reply] [d/l]
Re^4: Copy XML file, write new attributes and move the old files. by Nevamonk (Novice) on Jan 27, 2015 at 09:42 UTC
thats it! You are indeed a wise monk sir, thanks alot!	[reply]
Re^4: Copy XML file, write new attributes and move the old files. by Nevamonk (Novice) on Jan 27, 2015 at 10:09 UTC
there are just 2 things i need to alter. First of all, the files are read from a directory, so i'd have to have that readXmlDir sub, and second, It's not the database that needs updating, its the file nodes that need their attribute changed so it matches with the database. This is because we get XML from different servers and they all have their own ID's for the Element names. other then that, this is exactly what i was looking for.	[reply]