1
Support / $1,000,000 importing issue question
« on: June 05, 2009, 11:32:55 pm »
hi everyone,
this is a $1,000,000 question...
1. i create the database from scratch with all the information updated
2. i export all the information to a customized xml file and one of the many fields is <release>{%value=rdate}</release>
3. i open the xml with excel and i modify/add values (dates) in the missing cells in the "release" column
4. i save the file as .xls
5. i import the .xls file into a new database created from scratch as well
6. it shows the release dates and everything is fine exactly as the first database without any problem
7. i export AGAIN all the information to the SAME customized xml file (so that i can have all the missing release dates added)
and GUESS WHAT?
the only data missing is the release dates... can you believe that???
now, i go and create another xml file very simple just title/year/release date and i export from the second database, the one that contains all the updated release dates and GUESS WHAT? it does not work either...
what is killing me is the fact that i can see the release dates on every single movie info on the second database, but i cannot export it again using the same xml export template.
there is anything i am missing in the whole picture?
thanks
dom
this is a $1,000,000 question...
1. i create the database from scratch with all the information updated
2. i export all the information to a customized xml file and one of the many fields is <release>{%value=rdate}</release>
3. i open the xml with excel and i modify/add values (dates) in the missing cells in the "release" column
4. i save the file as .xls
5. i import the .xls file into a new database created from scratch as well
6. it shows the release dates and everything is fine exactly as the first database without any problem
7. i export AGAIN all the information to the SAME customized xml file (so that i can have all the missing release dates added)
and GUESS WHAT?
the only data missing is the release dates... can you believe that???
now, i go and create another xml file very simple just title/year/release date and i export from the second database, the one that contains all the updated release dates and GUESS WHAT? it does not work either...
what is killing me is the fact that i can see the release dates on every single movie info on the second database, but i cannot export it again using the same xml export template.
there is anything i am missing in the whole picture?
thanks
dom