Post reply

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.

Name:
Email:
Subject:
Message icon:
Attach:
(Clear Attachment)
(more attachments)
Allowed file types: gif, jpg, png, txt, tpl, lng, ini, pvd, psf, ini, cfg, csv, zip, xml, pas, 7z
Restrictions: 4 per post, maximum total size 1024KB, maximum individual size 1024KB
Note that any files attached will not be displayed until approved by a moderator.
Verification:
Type the letters shown in the picture
Listen to the letters / Request another image

Type the letters shown in the picture:
How many words are in this question?:

shortcuts: hit alt+s to submit/post or alt+p to preview


Topic Summary

Posted by: deazo
« on: April 02, 2010, 03:48:24 pm »

Quote
Have you configured the Excel import plugin properly?

It sounds obvious now that you say it... I' ll check that out and get back to you if problems.

Thanks
Posted by: rick.ca
« on: April 01, 2010, 08:58:43 pm »

Quote
Can you try again?

This one works fine.

Quote
I don't get the error you are getting

The exception was quoted from your bug report.

Have you configured the Excel import plugin properly? The order of the fields must match the order of the columns in the Excel file exactly (the column headers are ignored).
Posted by: deazo
« on: April 01, 2010, 08:16:26 pm »

 
 Strange.
 I have just tested it again, excel opens the file fine and displays the info related to the two movies of my test database.
 Have you changed the extension to .xls?
 I have just compressed it for you with Winrar (Then changed the extension to .zip so that I can attach it here), instead of changing the extension.
 Can you try again?

 Also when trying to import it with PVD I don't get the error you are getting, but a crash.

[attachment deleted by admin]
Posted by: rick.ca
« on: April 01, 2010, 07:26:38 pm »

According to my Excel, your Book2.xls is not a valid Excel file (although Excel is able to recover a portion of it). And the exception reported is "Specified file is not a Personal Video Database XML file." Are you sure you're creating a valid XLS file, and importing it with the Excel import plugin?
Posted by: deazo
« on: April 01, 2010, 10:28:37 am »


 I am working at exporting and re-importing my database in an attempt to fix the firebird problem we have already covered with Nostra, Buah and Rick.
 I have created a test database of two movies and I am only testing a simple export import of these out/in pvd.
 Exporting into an xml file goes with no problem but when I want to import it into pvd the databse just crashes on me.
 I have no idea why so I am attaching the bug report here if it helps. I am also attaching the .xls file (I have changed the extension to txt so that I could attach it)
 
 I have not yet updated to version 19 of PVD because this mean I would have to again manipulate firebird embedded files and all that mess I have to do with every new version of PVD.

 May I add that this is properly scarying me, as I need to do this on a 700Mb database file with many many movies...
 I would love to have Nostra help me fix the file instead...

[attachment deleted by admin]