| Author |
Message |
| Registered: July 20, 2007 | | Posts: 5 |
| | Posted: | | | | Hi there,
When trying to back up my database i get a message halfway through that reads
'0/00/0000 is not a valid date' and it stops the backup.
Im sure its something simple that needs to be changes somewhere , Any tips? thanks. |
|
| Registered: March 10, 2007 |  Posts: 524 |
| | Posted: | | | | There is a date - potentially like a loaned to date that is blank. Unfortunately, I don't have a good automated solution to help you find it, and repairing the database probably won't fix it either.
-Gerri | | | | Invelos Software, Inc. Representative |
|
| Registered: March 13, 2007 | | Posts: 4,596 |
| | Posted: | | | | Perhaps you can download a Report that shows the loaned to dates and see if a there is an invalid date?
Or, if you have MS Excel, you can export your database to xml and open it in Excel and see where the offending date is? | | | | My WebGenDVD online Collection | | | | Last edited: by Bad Father |
|
| Registered: July 20, 2007 | | Posts: 5 |
| | Posted: | | | | thanks ,
I checked the loaned out dates and they are all fine.
I also checked all the purchased and release dates but i couldnt find anything there.
Any other suggestions? |
|
| Registered: March 10, 2007 | | Posts: 524 |
| | Posted: | | | | It can be any other dates in the program: Purchase date, Watched on, Returned dates.
8Ball's suggestion about exporting it to XML and then importing it into Excel is a good idea.
-Gerri | | | | Invelos Software, Inc. Representative |
|
| Registered: March 13, 2007 | Reputation:  | | Posts: 2,372 |
| | Posted: | | | | You could try backing up just a portion of your collection at a time. A-F, G-M, etc. Without doing the scans it will backup pretty quick. Once you find the group that doesn't backup properly narrow it down again until you find the bad profile. Good Luck... and welcome to the forums!  |
|
| Registered: July 20, 2007 | | Posts: 5 |
| | Posted: | | | | thanks for all the replies!
I tried backing them up in sections , A-B , C-D etc and this worked fine. However it still wont let me back it up as one file.
The only thing i can think of is there is a discrepency between the total dvd's and the Dvd's filtered by 1 dvd on a permanent basis. Clearing the filters doesnt do anything to bring them into line.
If i restore the database will this be fixed? and if i restore will i lose all my personal info like watched dates etc? |
|
| Registered: May 19, 2007 | Reputation:  | | Posts: 5,917 |
| | Posted: | | | | I would try backing them up into sections, each using a different file (you may still have those). Then create a new database and restore each section into that. |
|
| Registered: March 14, 2007 | | Posts: 3,830 |
| | Posted: | | | | likely yes, you will lose everything to the point when you made the backup. Did you try the Excel proposal? This seems the way to go. If you don't have Excel you could download this free alternative: OpenOfficeand you would use this application from the program suite: Calc | | | | Sources for one or more of the changes and/or additions were not submitted. Please include the sources for your changes in the contribution notes, especially for cast and crew additions. | | | | Last edited: by ? |
|
| Registered: March 13, 2007 | Reputation:  |  Posts: 2,217 |
| | Posted: | | | | Quoting 8ballMax: Quote:
Or, if you have MS Excel, you can export your database to xml and open it in Excel and see where the offending date is? I wouldn't even use Excel. Just open the XML in an editor and search for '0000'. cya, Mithi | | | | Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki |
|
| Registered: March 13, 2007 | | Posts: 252 |
| | Posted: | | | | Quoting sandy1010: Quote:
thanks for all the replies!
I tried backing them up in sections , A-B , C-D etc and this worked fine. However it still wont let me back it up as one file. (to expand on what Dr K mentioned...) If this way of making your emergency backup has worked for you, you can restore the multiple backups into a new single database: - Create a new database {recommended, but not required} (File > Open Database > New database) - restore your first backup - restore your next backups but select "Restore Specific Profiles" then click "Select All", this will add to your existing data without erasing the previous sets. Quote:
If i restore the database will this be fixed? and if i restore will i lose all my personal info like watched dates etc? Likely will be fixed... anything that Profiller can't display is not likely to be backed up - especially if you are using flags to make your partial backups (if you can't see it, you can't flag it  ) All personal data is retained - even the online version of backup keeps that data (the only exception I recall is if you've made custom overviews or easter eggs) Finding the offending profile and fixing the problem directly is perhaps preferable to the long multi-backup/restore method tho. |
|
| Registered: July 20, 2007 | | Posts: 5 |
| | Posted: | | | | Thanks for all the help everyone ! I Have identified the offending titles and sorted out all the problems!  thanks again. |
|