Author Topic: UK Date Errors  (Read 12068 times)

0 Members and 2 Guests are viewing this topic.

Offline John666

  • Member
  • *
  • Posts: 28
  • Who wants to live for ever?
    • View Profile
UK Date Errors
« on: October 08, 2011, 11:12:56 pm »
Hi, I have found that there seems to be a lot of problems with dates and date conversions.
I assume this is because I am in the UK and we always seem to do things differently here.

Examples of this are:
   I cannot 'duplicate' a record after the 12 of the month, I have to do them before or change my system date first.
   If I change the date in the 'Date Added' field it switches the month and daye before the 13 of the month.
   When I do a filter by date I have to remember to use the american format to make it work properly.

There are more of these but I can't think of them right now.

Thank you in advance.

Windows 7 (64bit)
PVD v1.0.2.7

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: UK Date Errors
« Reply #1 on: October 09, 2011, 12:35:26 am »
Is the date format in UK not the same as in Europe??? As I have the German one working pretty well here...
Gentlemen, you can’t fight in here! This is the War Room!

Offline rick.ca

  • Global Moderator
  • *****
  • Posts: 3241
  • "I'm willing to shoot you!"
    • View Profile
Re: UK Date Errors
« Reply #2 on: October 09, 2011, 01:53:12 am »
A minor annoyance I'll report now—in case it's somehow related...

[Date Added] includes the time (probably since raldo requested it for [Date Modified] for PvdImport...0.9.9.12). Any attempt to duplicate a record with a [Date Added] that includes the time results in the error...

Quote
conversion error from string "10/03/2011 04:35:26 PM"
Overflow occurred during data type conversion.
Error Code: 14.

Duplicate works fine when the time is removed.

Offline John666

  • Member
  • *
  • Posts: 28
  • Who wants to live for ever?
    • View Profile
Re: UK Date Errors
« Reply #3 on: October 09, 2011, 09:50:29 am »
Is the date format in UK not the same as in Europe??? As I have the German one working pretty well here...

I'm not sure what date format is used in Germany, in the UK it is DD/MM/YYYY hh:mm:ss.
Windows 7 (64bit)
PVD v1.0.2.7

Offline John666

  • Member
  • *
  • Posts: 28
  • Who wants to live for ever?
    • View Profile
Re: UK Date Errors
« Reply #4 on: October 09, 2011, 09:54:46 am »
Quote
Duplicate works fine when the time is removed.

I see what you mean about removing the time. It works fine without it.

What about adding/editing dates and filtering?
Windows 7 (64bit)
PVD v1.0.2.7

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: UK Date Errors
« Reply #5 on: November 09, 2011, 01:06:35 am »
I will fix these issues in the next version 1 release.
Gentlemen, you can’t fight in here! This is the War Room!

Offline John666

  • Member
  • *
  • Posts: 28
  • Who wants to live for ever?
    • View Profile
Re: UK Date Errors
« Reply #6 on: November 09, 2011, 10:42:00 am »
Thanks for letting me know.

Two other question I have...

1. Could you tell me what the '(Media) Count' field does please?

    I assumed that it was a count of the files associated to the series or film as entered in the 'File Path' field.
    No matter what I enter it just resets to 1 whenever I change anything in the File Path field.

    Is there any other field I can use that automatically counts the number of files entered into the File Path field?


2. Is there any way of exporting the 'Release Date' associated with each episode? All I seem to be able to get is the Release Date for the series.

    I have looked through the list of available fields and it doesn’t seem to be mentioned under episode data and the ‘rdate’ field produces nothing.
« Last Edit: November 09, 2011, 11:04:41 am by John666 »
Windows 7 (64bit)
PVD v1.0.2.7

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: UK Date Errors
« Reply #7 on: November 09, 2011, 11:11:10 am »
Quote
I assumed that it was a count of the files associated to the series or film as entered in the 'File Path' field.
    No matter what I enter it just resets to 1 whenever I change anything in the File Path field.

    Is there any other field I can use that automatically counts the number of files entered into the File Path field?

The field counts the media a movie is on (CDs, DVDs, BDs, etc.). It will count files if they are on HDD from version 1, so your problem should be solved with it.

Quote
2. Is there any way of exporting the 'Release Date' associated with each episode? All I seem to be able to get is the Release Date for the series.

    I have looked through the list of available fields and it doesn’t seem to be mentioned under episode data and the ‘rdate’ field produces nothing.

No, not yet
Gentlemen, you can’t fight in here! This is the War Room!

Offline John666

  • Member
  • *
  • Posts: 28
  • Who wants to live for ever?
    • View Profile
Re: UK Date Errors
« Reply #8 on: November 09, 2011, 11:33:13 am »
Good to know about the 'count' field changes in the new version - thanks.

Is the listing of full Episode information something that will come with this new version?

At the moment there seems to be no way to list things like Duration, Release Date etc. for episodes which would be really useful for creating web pages etc.
Windows 7 (64bit)
PVD v1.0.2.7

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: UK Date Errors
« Reply #9 on: November 09, 2011, 07:40:26 pm »
Export will be improved in future, so you can expect episodes to be exported properly in one of the next releases.
Gentlemen, you can’t fight in here! This is the War Room!

Offline John666

  • Member
  • *
  • Posts: 28
  • Who wants to live for ever?
    • View Profile
Re: UK Date Errors
« Reply #10 on: November 10, 2011, 11:03:50 am »
That's good to hear. Thanks

Where is the best place to download the latest version from?

I assume that once it is installed it will update automatically?
Windows 7 (64bit)
PVD v1.0.2.7

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: UK Date Errors
« Reply #11 on: November 10, 2011, 11:13:21 am »
I post the beta releases in Version 1 [Testing] section. The update feature works currently only for stable releases.
Gentlemen, you can’t fight in here! This is the War Room!

Offline John666

  • Member
  • *
  • Posts: 28
  • Who wants to live for ever?
    • View Profile
Re: UK Date Errors
« Reply #12 on: November 10, 2011, 06:09:50 pm »
Thanks, I'll check it out.
Windows 7 (64bit)
PVD v1.0.2.7

Offline John666

  • Member
  • *
  • Posts: 28
  • Who wants to live for ever?
    • View Profile
Re: UK Date Errors
« Reply #13 on: November 11, 2011, 09:06:07 pm »
Another question for you...

I use multiple boot drives and I physically remove the current hard disk and then place a different one into my computer using a hard drive rack system.
This means that the C Drive is always changing but all my other drive remain unchanged.

Is there any way I can place the export template files somewhere other than on my C Drive?
I was wondering if they could go under '\My Documents\Personal Video Database\Templates\' for example but I can't see any way of pointing the program to look there.

Again, if this is not an option now, could it be included in the new version.
Windows 7 (64bit)
PVD v1.0.2.7

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: UK Date Errors
« Reply #14 on: November 11, 2011, 10:44:39 pm »
There is no such possibility, but you can just install (copy) PVD on the hard drive that is always connected. You will probably want to use the application in portable mode for this to work on all of your systems...
Gentlemen, you can’t fight in here! This is the War Room!

Offline John666

  • Member
  • *
  • Posts: 28
  • Who wants to live for ever?
    • View Profile
Re: UK Date Errors
« Reply #15 on: November 12, 2011, 10:13:58 am »
OK, thanks, I'll give that a try.
Windows 7 (64bit)
PVD v1.0.2.7

Offline John666

  • Member
  • *
  • Posts: 28
  • Who wants to live for ever?
    • View Profile
Re: UK Date Errors
« Reply #16 on: November 13, 2011, 01:54:17 pm »
Do I need to install the application if I'm running it in 'portable' mode?

I was wondering if it would make any difference to the speed and/or stability if I simply copied it to a location and ran it from there.
Windows 7 (64bit)
PVD v1.0.2.7

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: UK Date Errors
« Reply #17 on: November 13, 2011, 02:15:58 pm »
In fact, you should just copy it if you plan to use PVD in portable mode. If you install it, then unnecessary registry entries and shortcuts will be created. 
Gentlemen, you can’t fight in here! This is the War Room!

Offline John666

  • Member
  • *
  • Posts: 28
  • Who wants to live for ever?
    • View Profile
Re: UK Date Errors
« Reply #18 on: November 14, 2011, 02:54:32 pm »
Thanks, that sounds even simpler than I expected.
Windows 7 (64bit)
PVD v1.0.2.7