i have an xml file, which needs to have more data added into it. the format of the xml file should be exactly the same. i tried to add more data using excel, and saving the file as an xml format in excel, however it changes it to a different xml format, which gives errors. so it is very important that the xml file format remains exactly the same.
the xml file contains data for around 1050 products. however we need to add more data for each product. i am attaching the first 3 products in a file so that you know exactly what needs to be done
what needs to be changed: for each product:-
1) change the mpn value. the mpn value would increase in numberic format for each product, going from RHJGJaewe1, RHJGJaewe2 etc....
2) add a new value Female to each product
3) add a new value Adult to each product
4) add a new value White to each product
5) add a new value 7 to each product
6) add a new value Yes to each product
so besides the value in 1, which changes for each product, all the other values would remain the same for each product.
this is very simple and easy work. i need it within 1 hour. again it is very important to maintain the file format exactly.