Personal Video Database

For the custom field:
There are 4 SQL tables that store the data. They are:
CUSTOM_VALUES_DATE - for date custom fields
CUSTOM_VALUES_INT - for?? custom fields
CUSTOM_VALUES_LONGSTR - for long text fields (memo I guess as well)
CUSTOM_VALUES_REAL
CUSTOM_VALUES_SHORSTR - for short text fields.

You will have to choose the proper table for the type of data you store.
The CUSTOM_FIELDS_MOVIES holds the reference of the fields display value and types.

To add a custom field to your Movie details for instance. You would insert a new file into the MovieDetail-x sequence. Rename all the MovieDetail-*.html from 8 to 10 with an increment of 1 making them 9 to 11. So you can now create a file called MovieDetail-8.html.

Put this content in the -8.html file:

<!--DBINFO
REQUEST=SELECT FIRST 1 "value" FROM "CUSTOM_VALUES_SHORTSTR" INNER JOIN "MOVIES" ON "MOVIES"."mid" = "CUSTOM_VALUES_SHORTSTR"."mid" INNER JOIN "CUSTOM_FIELDS_MOVIES" ON "CUSTOM_FIELDS_MOVIES"."cmfid" = "CUSTOM_VALUES_SHORTSTR"."cmfid" WHERE "CUSTOM_FIELDS_MOVIES"."dispname" = 'My custom display' AND "MOVIES"."mid"=[parentref]
MYCUSTOMFIELD-S=value
RECORDCHARSET=UTF-8
-->

<tr>
           <td class="title3" colspan="1">My field</td>
     <td class="normal" colspan="3"><!--MYCUSTOMFIELD-S--></td>
</tr>

Replace all occurrence of CUSTOM_VALUES_SHORTSTR with the proper table name for the type of custom field you use.
Replace the 'My custom display' value with want you see in PVD for your custom field.
We could use the globalParam file to store table names or what not and/or other SQL request but I think this is the simplest way.

Make sense?

You do have the number listing (kind of). If you select "all" entries at the top, the listing will be sorted alphabetically starting with the movies having their titles starting with space, numbers and none-English characters. Make sense?

As for you second question, I'm not sure to understand. Are you asking if there is a way to edit the movies in batch in PVD? or if a change to an sql request within the DBINFO header in the template can be easily change in all the necessary template files?

PVDTemplate was the first template I made, it is tedious to change something because it has a lot of files but its a much simpler template (to understand) then the LG template for instance.

What is your rendering engine? using a PC, a Porcorn hour (which model?) or ...?

Nono

Hello Gang,

New version of Kroozbox available at:

http://www.mediaplayersite.com/Kroozbox

Modification done to accomodate new Syabas flash based templates (for Popcorn hour C-300, Popbox ,etc) and LG Smart TV template.

The LG template requires download from the LG market - search for 'Kroozbox' on the LG TV. Note that, at this time, the app is not yet available. Still under review by LG staff - hopefully available soon. In the mean time, connection can still be made using LG browser.

Enjoy,
Nono

It still happens but only when you create a new entry in the series episode list not when you change it (adding or setting the path to the actual video file for instance).

It has been a problem for me as well and finally decided to fix it.

Attached you will find the file that you need.
Extract and overwrite the file in your "template/PVDTemplate-HD/html" folder.
The zip file only contains the necessary file - not the whole folder. And please, make a backup first of your template... juuust in case.

With this update you will always see the series that got the lastest modification and the listing of the episode will state the modification date and not the creation date.

This is for Kroozbox 2.0a. Shoudl work with 2.0. No need to restart Kroozbox.

Let me know.
Nono



[attachment deleted by admin]

Hi,

I must create my own PVD file of my movie library, but how do i do that?

Heu... we are here in forum of the PVD software. Meaning that the PVD file is created by the PVD software that you can download from http://www.videodb.info/forum_en/index.php?action=down

To start the STARTME file you might need to be in the working folder of Kroozbox. Not sure how you are starting it.
Note that if Kroozbox is working in service mode, you don't need to start it with STARTME.

The only thing you have to do is build your movie database with PVD and point Kroozbox to it by changing the value of "dbName" in the Kroozbox.properties file located in your template folder (typically: \Kroozbox2.0\templates\PVDTemplate-HD\kroozbox.properties).

Restart Kroozbox. that should work providing that the path of the movie provided in the PVD software is the same path for Kroozbox. (ex.: if PVD point to d:\mymovie\title\title.avi , the machine running kroozbox should see this movie with this path). Otherwise there are ways to dynamically cahnge the path but that's for another time when/if you provide us with a a mapping of your network.

Noet that Kroozbox won't be able to play  the movie file located on the PCH local drive.

Nono

I've been reading Dune specification.
You don't (should not) need smb protocol to play your movie through Kroozbox. Kroozbox can be configure for it but it would be a long road to make it work.

From what you told me here - Kroozbox should work. I suspect some type of right access to the file.

We need to know your network layout for this...
Please provide more details on your configuration:

* Is Kroozbox running as a service - for now you should make it run with STARTME.bat.
* Where are the movie file located? on the Dune machine directly? on a dedicated network machine/nas.
* Is Kroozbox running on the same machine where the movie files are located (\\Newsky-server) ? if not, where is it running in regards to Dune and movie file location?
* Are you using PVD program on the same machine where the movie files are located? I suspect the anser is "no" but need to be sure.
* Is "\\Newsky-server" the Dune machine (that has an internal hard disk)?
* You do see the Kroozbox interface on the Dune machine - only the movie doesn't play. Right?

You are saying that the movie get downloaded when you click on the play link in Kroozbox interface in the browser. It means that it should also work with the Dune machine. I am puzzled.
Really need more information on your configuration/layout. There are a zillion way to install all this.

Thanks,
Nono

Hi,

I have created the same structure that you show here (Мультфильмы\Ш\Шрэк Навсегда (2010)\Shrek_Forever_After_(2010)(multi)(1080).mkv) and I was *not* able to reproduce your problem.  Working fine with my setup.

Soooo, a few points:

* Make sure that the Kroozbox machine has access to the "\\Newsky-server" machine - try kroozbox in a *none* service mode by running the STARTME.bat file (and the service turned off). If that works it means that the service account under which Kroozbox is running doesn't have proper access to the "\\Newsky-server" serveur - change in the service management.

* You can play with UUEncodeMediaLink value (true or false) in the kroozbox.properties of your template to see if it change anything (kroozbox has to be restarted for this to take effect).

* I didn't try your link using the path with a server name - it should work but maybe mapping the server to a drive on the machine running kroozbox might be an option. You can then add entry to your "PVDLinkRelocation.properties" of your template to change the link from the PVD entry to the drive mapping that you used. For instance:
\\Newsky-server\=n:\
(replace n: with whatever drive name you use in your mapping - Kroozbox need to be restart after that)
You can verify the link value in your browser.

* You could always set the "debug" flag to true in the kroozbox.properties file of your template, run with startme.bat and see the output on the screen when you click your media link in the borwser. Kroozbox would tell you more information on what is happening.

Let me know,
Nono

Hi,

I like to believe that Kroozbox is easy to install even if there is no user interface for the installation. Most of the posts on this thread relates to specific problems or adjustments that users would like to have. You don't need to understand all of the posts.
You should at least open the readme.txt file inside the package. Windows have what it takes to extract all the files from the zipped package.
Extract:
* Make sure that Java runtime 1.5 or more is installed. Run "Java -version" from the cmd prompt to ensure its availability.
  (Java can be downloaded from http://www.java.com/en/download/index.jsp)
* Unzip the content of Kroozbox package to the forlder of your choice.
* Start the software by running the "STARTME.bat" file.
* Turn on your Media Tank and TV and select the service you want (standard or high definition service)

When this is working (with the sample provided), point Kroozbox to your PVD file and restart it.
You do that by opening  ./template/PVDTemplate-HD/Kroozbox.properties
Change the value of the "dbName" property to point to your PVD file.


Hope that helps,
Nono

I am pretty sure that is has to do with this specific image only (some encoding that kroozbox doesn't recognize). Try a different one and let me know (you may have to restart Kroozbox if the image cache is 'on' - not sure anymore).

Originaly the template would not allow those big images by asking the browser (or the NMT) to force-resize the image - I removed those browser side instructions to have a faster rendering (NMT can be quite slow on some stuff). Maybe I should have left it there - as a fall back in case Kroozbox failes the resize... oh well.

N

Maybe this:

There is no automatic mounting of a share on the NMT (grrr). So, you have to activate the share in the NMT box before Kroozbox can access it. Doing this is simple; just open your share once from the top menu of the NMT. Come back to the top menu and open Kroozbox - go to movie and play.

If that doesn't work, it means the share link build by Kroozbox is not proper. Tell us what the complete link is. You can get it by using your browser to connect to Kroobox on port 9008  (http://<ip address of Kroozbox>:9008). And go to your movie where the ISO file is located (or the Video structure) and get the link from the browser status bar (on bottom) when you put the cursor over the link.