English > Scripts and Templates
Export template: HTML List (English + German)
arj0n:
--- Quote from: svenne on October 04, 2011, 12:58:08 am ---Special characters could be an issue. I tried several special characters including chinese symbols... only space+"(" as well as "," (both without quotes) would give unexpected results, shortening or splitting up language entries. I will correct that soon. Nevertheless, the three filter buttons always did their job.
--- End quote ---
Yes, I guess it must have been a comma or something like "(".
I removed several things so I can't tell you what exactly caused this...
--- Quote from: svenne on October 04, 2011, 12:58:08 am ---I could imagine some kind of "interference" if you choose the same export filename a second time or over and over again. Perhaps it might be only if you don't delete the old files first. But it's just a guess.
--- End quote ---
I always delete the old export before making a new one, just in case. ;)
--- Quote from: svenne on October 04, 2011, 12:58:08 am ---The export would/should run fine and do a proper job. But your browser might have parts of the former file versions in its cache, causing some weird behaviour. Empty the browser's cache, that might help.
If it's not the browser's cache and if you can reproduce the error, tell me the details and I will eliminate the bug.
--- End quote ---
I haven't encountered that error anymore, so it must have been something in the 'special characters' corner.
Question: could you please add a fourth filter-button, one for for 'Actors'?
svenne:
"," and " (" won't be a problem in future versions.
A filter button/menu for actors is not practicable. In my database there are aproximately 12600 actors. And I only imported the most prominent actors from the first page for each movie in IMDB!
In a small database there might be a few thousand actors only, but even those could not be handled in such a menu. One major thing that keeps the exported HTML files from bloating to infinity is that I only link actors that occur in two or more movie entries.
Remember that all exported data is stored in HTML files. There is a lot of redundant information. As an example: movie entry x is listed in several files... for each actor that participates in it (+ at least in one other movie), in the file with the filmlist of the director, in the genre list, etc.
If you want to have a film list available for each actor without having a few ten thousand lists prestored as HTML files bringing your hard drive's file system to its knees... you will need to generate the lists on demand. It would take a lot of time to gather the corresponding data from all the exported movie sheets (pimpHTMLframesExport does so) on the fly. To be able to generate such lists fast you would need a genuine database... like Personal Video Database. ;) By the way, javascript's access to the file system is very restricted, too. That can be changed, but I wanted to keep the exported thing publishable on any PC and on the net.
If you want to have such features outside of Personal Video Database (which uses Firebird as database): there are some approaches to get the data to mysql as a backend for web pages on common hosters and alikes:
PVD .9.9.21 Website Template Easy to Web scripts based on PK Template
(PK's MovieDB dynamic website template)
Kroozbox - PVD to media theatre solution
mgpw4me:
The database is directly accessible via HTML scripting (JavaScript / VbScript), if you install the Firebird driver...Internet Explorer version below:
<html>
<head><title>ActiveX Data Objects (ADO)</title></head>
<body BACKGROUND="CLDSHALF.JPG" TEXT="#000000">
<select size="40">
<script language="VBScript">
Dim cn, cmd, rs, i, dbpath, timein
dbpath ="Database=c:\program files\personal video database\movies 3.pvd"
Set cn = CreateObject ("ADODB.Connection")
cn.Open "DRIVER={Firebird/InterBase(r) driver};User=SYSDBA;Password=masterkey;" & dbpath & ";auto_commit=true"
set rs = cn.execute("select MOVIES.""title"", MOVIES.""year"", MOVIES.""mid"" from MOVIES order by MOVIES.""title"", MOVIES.""year""")
do while not rs.eof
document.write ("<option value='" & rs("mid").value & "'>" & rs("title").value & " (" & rs("year").value & ")")
rs.movenext
loop
rs.close
cn.close
</script>
</select>
</body>
</html>
svenne:
Thanks for the info. Nice to know. So, there are lots of opportunities...
All depends on what you want to do. Setting up a PC for customers in a video store? Or host a personal list of favourite movies on a third party internet server? Or do you want to share your DVD collection with friends, having the exported HTML files on an USB stick in your pocket? Or have a tiny list that you can attach to an email?
By the way, you can run Personal Video Database from your USB stick on any PC without having to install it there. There is a portable mode.
Concerning the HTML export templates: I want to keep them as "independent" as possible. They should not depend on a certain operating system or third party drivers and should stay apart from the original (comprehensive) database. They depend on a browser capable of javascript and iframes, of course. But that should be sufficient.
svenne:
New versions:
- HTML Frames: I changed the behaviour of the menus. Now they disappear if you click somewhere else on the page. Found it quite annoying that I could only get rid of them by choosing something or pressing the "Further options..." button again.
- writers, composers and producers will be exported if the fields in Personal Video Database are not empty
- pimpHTMLframesExport processes exported credits for writers, composers and producers
- nonalphanumeric characters in the language field should not be a problem anymore
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version