Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Roy22

Pages: [1] 2
1
Support / Re: Linking to a local folder/files?
« on: July 19, 2015, 02:14:16 pm »
CAD,

Cheers mate, worked a treat for me too!  Fine within Comment field, but not within URL field oddly in case that helps anyone.

2
Support / Linking to a local folder/files?
« on: July 12, 2015, 04:04:24 pm »
Can anyone tell me whether there's a simple way to embed a hyperlink in one of the displayed fields, so I can click on this and open a related file or folder of files on my hard drive?

3
Support / Re: Relative File Paths for movies.
« on: June 30, 2012, 09:20:20 pm »
Would there be any way to add this as a future feature?  Users running PVD on more than one PC and with different drives must be quite common.

4
Support / Re: Relative File Paths for movies.
« on: June 30, 2012, 05:50:46 pm »
Will PVD by default, eg if no file path is given, seek video files in the same folder as the database file resides?  Just wondering if I could keep a copy of it alongside videofiles in whichever portable drive I used?

5
Support / Relative File Paths for movies.
« on: June 28, 2012, 07:38:40 pm »
I know this question has been asked in one way or another before, but I just want to be clear before restructuring some disks, folders etc.

Movies stored on removable drives may obviously have different paths (ie drive letters) depending on which USB drives are plugged in, the order they're plugged, and which laptop/PC I might be running PVD on.  A file path beginning 'F:\video\...' might appear as 'G:\video\...' when plugged into another machine.

How to I ensure PVD can always find the films to play etc, or do I have to manually search for & replace drive letters as I move between different PCs?

6
Support / Re: Can't get Excel import to work at all - any ideas?
« on: January 22, 2012, 05:06:02 pm »
This may have been covered elsewhere, but is the beta version anywhere near become officially released?  I usually like to let others get the nasty surprises first.  ;)

7
Support / Re: Can't get Excel import to work at all - any ideas?
« on: January 22, 2012, 02:11:52 pm »
Quote
Is there any chance you were trying to do other things with the program when the error occurred?

Only in terms of the PC video processing other stuff, which I expected to slow PVD down, though not crash it.  Or do you mean something else with PVD, as I'm not aware you can get it to do more than one thing at once?

Quote
Just chiming in that I used the Excel import plugin successfully this week, but was having troubles using it with v9.9.21, so I downloaded the latest beta version of PVD, and it worked great.

I am using 9.9.21.  By 'having troubles using it with v9.9.21' do you mean something similar to my experiences?  It may be that something has been knowingly or unknowingly fixed in the beta release.

I'll try and get the crash data you requested.

8
Support / Re: Can't get Excel import to work at all - any ideas?
« on: January 21, 2012, 08:52:36 pm »
rick.ca,

Thanks for the offer, but I owe you an apology, as somewhere in all this I think I got confused between ID (numeric?) and Title, and may have wasted quite some time in this confusion. 

The other issue which put me off the scent, is that there seems to be some practical limit when running the Excel import.  The original 1300 or so line Excel sheet would lead to a crash with a message from PVD about Continue/Abort etc, but would always end with nothing changed.  A bit of trial & error has lead to 600 records at a time being targeted successfully for update, so I can get it to work in a few goes with the import sheet cut-down into smaller ones.  I'm not sure exactly sure what the limit is, or if it derives from PVD itself or something related to my hardware/software setup, but there does appear to be one beyond which no import will work.

It might be worth your while finding out if there is one, and if so adding it to the manual, to save others a lot of time.

Cheers,

Roy22

9
Support / Re: Can't get Excel import to work at all - any ideas?
« on: January 16, 2012, 10:00:03 pm »
Quote
All you need to do is include [ID] and [Actors], and make those the first two columns of your worksheet.

Yes, that's all I did in the end, and even for tests of just two or three Actors names to add, it didn't do.

10
Support / Re: Can't get Excel import to work at all - any ideas?
« on: January 16, 2012, 07:03:18 pm »
Quote
If there is, you won't be able to add them without overwriting what you're importing now.

I'm not looking to overwrite this Actor data in future, simply trying to automatically add what I've got now as a one-off.

Quote
Neither. It works as described.

Well I can promise you that I wouldn't be wasting my time (and yours) if it worked flawlessly for me.  I'm curious that you did your experiment with CSV data, when my post was about Excel problems and the current manual says:

Quote
The best tool for doing that is a spreadsheet. If you have Excel, use that and the Excel import plugin.

I did briefly try CSV, amid hours of variations, but I don't think I even saw the 'merge options' dialogue appear so reverted to Excel.  I stopped trying to use 'Path' early on and changed to ID followed by Actors as the only two columns in the Excel file, both with & without headers in row 1.

I'm using Excel 2003, and saving in the default .xls format in the absence of any other instructions in the manual.  It did cross my mind that Excel versions might matter, but it was one variable I didn't try.  Is it likely to matter?

11
Support / Re: Can't get Excel import to work at all - any ideas?
« on: January 16, 2012, 11:30:49 am »
It may seem like an odd application, but it's a real one.  Back before the days of PVD, I used to append the names of actors onto the end of filenames, in a systematic way.  I could then find films with a certain actor through a simple file browser wildcard.  Sometimes there's one name, sometimes a few separated by commas, a format PVD doesn't mind when I've manually pasted such data into the Actors field.

Now, I'd like to extract these appended actors names and update the bare imported movie names with them.  I've managed the Excel extraction bit OK, but after several frustrating hours yesterday, have come to the conclusion that PVD isn't working as described in the manual.

I'd have hoped that an exactly matching ID (name) was enough for a match, but I'm starting to think that it isn't, even if the manual says it is.

I'm not sure if PVD should be changed, or the manual.  Perhaps someone could try adding a dummy movie to their database (title only) then try running an Excel import with just 'ID' and 'Actor's columns, to replicate the fault?

12
Support / Re: Can't get Excel import to work at all - any ideas?
« on: January 15, 2012, 07:45:03 pm »
OK, with much fiddling I've got is as far as the 'Update/Merge/Add....' dialogue appearing.  Whichever I choose, it goes away for some time (updating over a 1,000) or seconds if I cut it down to just one or two.  But nothing changes.  I've tried endlessly, and I know that the ID field is correct, all I'm adding is a simple Actor's name, but the record appears unchanged.  I did try downloading the latest MS Excel plugin from the download page.

Does this ever work for anyone?

13
Support / Can't get Excel import to work at all - any ideas?
« on: January 15, 2012, 02:59:33 pm »
OK, this is probably some thing stupid, but I just can't get Excel import to work. 

I've read the help file guide, configured PVD via Preference\Plugins\MS Excel general import\ to read 'Path, Actors' and created an Excel sheet with data to add as Path then Actors.  I've tried with & without headings in Excel.  I've tried substituting ID for path.  Every time, I see a message down low saying ' Excel Importing records, please wait' but I get no dialogue re update/merge etc, and I find nothing has changed in PVD despite there being data to update.

Any ideas?

14
Support / Re: Can user-defined star ratings be exported?
« on: June 13, 2011, 06:21:53 pm »
Quote
Place the cursor at the end of the last line, and press <Enter>

Oh, how 1980s. Stupidly, I thought Enter would just bring me onto another line in the template editor, 'cos if it's inserting a control character (aka Enter) then it's not otherwise visible.  But yes, it certainly works and it explains some haphazard behaviour whilst I played with templates.

Cheers,

Roy22

15
Support / Re: Can user-defined star ratings be exported?
« on: June 12, 2011, 11:13:29 pm »
Yes, but how?  Wasn't sure how Asci 13 was specified?

Roy22

16
Support / Re: Can user-defined star ratings be exported?
« on: June 12, 2011, 06:01:07 pm »
I've played around with the Text Importer quite a lot already.  It makes sense to say it's delimited with semi colons, which it takes fine.  It just doesn't seem to react to 'new line', making all the exports tab endlessly across row one.  Does your export plugin place any kind of 'end of line' characters after each movie row exported?

Roy22

17
Support / Re: Can user-defined star ratings be exported?
« on: June 12, 2011, 04:44:32 pm »
rick,

Belated thanks for your reply.  I've been playing around with options similar to what you suggest, but one small problem is driving me mad.

How do you ensure the exported test is treated as one movie line per line of Excel? I tried removing the #13#10 replace in the example, and with adding/removing the semicolon on the end of the last line, but Excel keeps treating it as one long series of fields, not a new movie per line, and complaining about the size.  I know this must be simple, please enlighten me?

Cheers,

Roy22

18
Support / Can user-defined star ratings be exported?
« on: May 08, 2011, 01:04:16 pm »
Is there a way to export the user defined star rating alongside other data?  I know that I can filter the database view down by star rating, one rating at a time, and then export each sub view, but is there a way to create a single export with, say, filename, file size & user star rating?

19
Support / Re: Specifying a networked video file location/replacing existing locations with it.
« on: April 06, 2011, 09:53:30 pm »
Thanks!  Why didn't it do that first time?  ???

20
Support / Re: Specifying a networked video file location/replacing existing locations with it.
« on: April 06, 2011, 08:33:09 pm »
Rick,

Sorry about taking so long to reply.  I don't know if I'm missing something, but I can specify a path in the 'Find' half of that box, but I can't enter any text in the 'Replace' half.  It just stays highlighted but won't accept text.  Am I being thick?!

Roy.

Pages: [1] 2
anything