Author Topic: Show database on Android  (Read 22312 times)

0 Members and 2 Guests are viewing this topic.

Offline Zacca

  • User
  • ***
  • Posts: 117
    • View Profile
Show database on Android
« on: March 28, 2011, 07:16:58 pm »
Hi Nostra(tnx for the new version)...Rick...and ALL..
I'm here again ;D

After a long research i' v find the solution (a good program) to show all my movie on a android phone.

How to:

Download "Pocket AMC Reader" from the android market (on the phone)  ;)
From this 3d download the file (XML Android.ptm.zip)
Unzip it in the directory "personal video database/plugins/templates/"
Restart PVD
Export all your database whit this xml
Put all the files in a dir of your sdcard
Select the exported.xml in the setting of "Pocket AMC Reader"
Restart the program.
ps: if the poster is too small you can increase it changing the number "300" in the xml ......... Picture="{%value=poster height="300"}"

I v test my database with 966 movies and work fine.




[attachment deleted by admin]

Offline rick.ca

  • Global Moderator
  • *****
  • Posts: 3241
  • "I'm willing to shoot you!"
    • View Profile
Re: Show database on Android
« Reply #1 on: March 28, 2011, 11:25:03 pm »
Welcome back, Zacca.

I don't have a smart phone, but I'm curious...Would an alternative be to use one svenne's templates to export HTML files, and then view these using the phone's browser? Or would they need to be modified for a hand held screen? And if that were possible, would there be advantages to doing it that way (e.g., easy access from browser, modifications, etc.)?

Offline Zacca

  • User
  • ***
  • Posts: 117
    • View Profile
Re: Show database on Android
« Reply #2 on: March 29, 2011, 07:07:42 pm »
"Pocket AMC Reader" I think is a SQL viewer written for movie database. In a android phone works faster than a browser and with a better layout.
This program was written for Ant movie catalog and my xml export in this format.
BUT it's only a viewer NOT a editor for movie

Offline julians26

  • Member
  • *
  • Posts: 2
    • View Profile
Re: Show database on Android
« Reply #3 on: January 12, 2012, 01:23:24 am »
Zacca

I am interested in following your suggestion for viewing my PVD database on my Android phone. However, I don't understand the step "From this 3d download...". Please can you clarify what is required?

Thanks
Julian

Offline Zacca

  • User
  • ***
  • Posts: 117
    • View Profile
Re: Show database on Android
« Reply #4 on: January 15, 2012, 06:57:45 pm »
Julians26

Download the attached file in this discussion....* XML Android.ptm.zip  :)

Offline julians26

  • Member
  • *
  • Posts: 2
    • View Profile
Re: Show database on Android
« Reply #5 on: January 16, 2012, 02:04:44 am »
OK, thanks.

It's obvious now that I have registered and can see the attachment! :-[

Offline severo1980

  • Member
  • *
  • Posts: 1
    • View Profile
Re: Show database on Android
« Reply #6 on: January 03, 2013, 10:29:05 pm »
2013 on going, and still nice post, worked perfect (except pictures, that wont show off, but who cares). Thanks!  ;D

Offline svenne

  • Power User
  • ****
  • Posts: 145
    • View Profile
Re: Show database on Android
« Reply #7 on: January 15, 2013, 03:30:43 pm »
Welcome back, Zacca.

I don't have a smart phone, but I'm curious...Would an alternative be to use one svenne's templates to export HTML files, and then view these using the phone's browser? Or would they need to be modified for a hand held screen? And if that were possible, would there be advantages to doing it that way (e.g., easy access from browser, modifications, etc.)?

Yes, it is possible, but the only browser that can handle the "HTML Frames"-template is Firefox for Android, as far as i know. That might change in near future with further development of the other browsers. The problem is, that the other browsers don't provide vertical scrolling for the movie list.

Offline rick.ca

  • Global Moderator
  • *****
  • Posts: 3241
  • "I'm willing to shoot you!"
    • View Profile
Re: Show database on Android
« Reply #8 on: January 16, 2013, 11:53:19 pm »
It seems odd to get a response to a post almost two years old, but thanks. I finally got a smart phone, but forgot about this. This is not quite my dream of a PVD app that connects directly to the database, but it's well done. Fast, too. With 1400 movies, it's able to display things like all movies a person is associated with almost instantly. Thanks for the find, Zacca. Now all we need to do is convert the author to PVD... ;)

Offline Pensare

  • Member
  • *
  • Posts: 13
    • View Profile
Re: Show database on Android
« Reply #9 on: March 24, 2013, 04:33:35 am »
Brilliant. 

Thanks so much for posting this quick and easy solution.  With 1100+ movies, it is sometimes hard to remember whether I already own a movie when I see an interesting title in a store.  I have been using Google "Sites" to simply upload a list.  It is great to be able to have my whole database with me at all times.

Thank you, thank you, and again, thank you.

Offline deazo

  • Older Power User
  • *****
  • Posts: 283
    • View Profile
Re: Show database on Android
« Reply #10 on: March 26, 2013, 01:22:32 pm »
Thank you for script, I am trying it but get an error when importing into the pocket reader.
I am using the "western europe" encoding.
I found a post advising to use a script (removebarchars) in AMC but I cannot open the database with AMC so I cannot run the script.

Offline rick.ca

  • Global Moderator
  • *****
  • Posts: 3241
  • "I'm willing to shoot you!"
    • View Profile
Re: Show database on Android
« Reply #11 on: March 26, 2013, 03:51:35 pm »
Quote
I found a post advising to use a script (removebarchars) in AMC but I cannot open the database with AMC so I cannot run the script.

Remove Accents worked for me.

Offline deazo

  • Older Power User
  • *****
  • Posts: 283
    • View Profile
Re: Show database on Android
« Reply #12 on: March 26, 2013, 05:10:08 pm »
Thank you but it's not working, I still get the error.
I thought it was coming from the software you sent me and I tried to remove accents using python script in Notepad++ but I get the same error...
Not sure what is wrong.

Offline pascalvdl

  • Member
  • *
  • Posts: 1
    • View Profile
Re: Show database on Android
« Reply #13 on: July 10, 2013, 06:34:00 pm »
this is incredible! imported 2000 titles in a handful of seconds on my phone, with enough details to browse while on the road...

big thank you!!!!

Offline ssadoff

  • Member
  • *
  • Posts: 4
    • View Profile
Re: Show database on Android
« Reply #14 on: January 10, 2015, 07:07:13 pm »
I was trying to get Android.ptm.zip, but it looks like it was deleted by the admin.
Does anyone have this and if so can they send it to me.

Thanks

Offline ssadoff

  • Member
  • *
  • Posts: 4
    • View Profile
Re: Show database on Android
« Reply #15 on: January 17, 2015, 05:57:02 pm »
Nevermind - I created the following template that works well
%OPTIONS%
replace="<<->&lt;"
replace="><->&gt;"
replace=""<->&#34;"
replace="'<->&#39;"
replace="Á<->&#193;"
replace="é<->&#233;"
replace="&<->&amp;"
filter="XML Files|*.xml"
encoding="UTF8"
imagepath="images\"
%OPTIONS%
%HEAD%<?xml version="1.0" encoding="windows-1252"?>
<AntMovieCatalog Format="42" Version="4.2.0 (2014-04-20)" Date="{%value=231} {%value=232}">
 <Catalog>
  <Properties/>
  <Contents>
%HEAD%<Movie Number="{%value=num}"
Checked="True" ColorTag="0"
OriginalTitle="{%value=origtitle}"
FormattedTitle="{%value=title}"
Director="{%value=directors}"
Actors="{%value=actors}"
Producer="{%value=producers}"
Composer="{%value=composers}"
Writer="{%value=writers}"
Country="{%value=country}"
Year="{%value=year}"
Description="{%value=description}"
Comments="{%value=comment}"
Category="{%value=genre}"
URL="{%value=url}"
Date="{#StringReplace '{#ExtractFilePath {#StringReplace '{#StringReplace '{#StringReplace '{#StringReplace '{%value=dateadded}' ':' ''}:\i.txt' ' AM:\i.txt' ''}' ' PM:\i.txt' ''}' ' ' ':\'}}' ':\' ''}"
DateWatched="{%value=viewdate}"
Rating="{%value=imdbrating}"
Length="{%value=length}"
Subtitles="{%value=subs}"
MediaLabel="{%value=medialabel}"
MediaType="{%value=type}"
Languages="{%value=langs}"
Resolution="{%value=resolution}"
Framerate="{%value=framerate}"
VideoFormat="{%value=videocodec}"
VideoBitrate="{%value=videobitrate}"
AudioFormat="{%value=audiocodec}"
AudioBitrate="{%value=audiobitrate}"
Size="{%value=size}"
Picture="{%value=poster}"
/>
%FOOT%
  </Contents>
 </Catalog>
</AntMovieCatalog>
%FOOT%

Offline svenne

  • Power User
  • ****
  • Posts: 145
    • View Profile
Re: Show database on Android
« Reply #16 on: January 30, 2015, 12:59:20 pm »
Since it was asked by rick some time ago...
http://www.videodb.info/forum_en/index.php/topic,2328.msg12254.html#msg12254

Dolphin browser (which became more or less the standard browser for android) now can handle iframes. So the HTML frames template works fine with that, now.