public
Created

Get data from Sony PRS-T1

  • Download Gist
databases.sql
SQL
1 2 3 4
-- Get highlighted parts
-- in /media/READER/Sony_Reader/database/books.db:
 
SELECT file_name, page, name FROM markups;
sonyprsnote2svg.xsl
XSLT
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
<?xml version="1.0" encoding="UTF-8"?>
<!--
sonyprsnote2svg.xsl - extract SVG notes from Sony PRS reader data
apply this to /media/READER/Sony_Reader/media/notepads/*.note files
-->
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"
xmlns:note="http://www.sony.com/notepad"
xmlns:svg="http://www.w3.org/2000/svg"
xmlns:xlink="http://www.w3.org/1999/xlink"
xmlns:xml="http://www.w3.org/XML/1998/namespace">
 
<xsl:template match="/note:notepad">
<!-- TODO: multiple pages -->
<xsl:apply-templates select="//note:page[1]"/>
</xsl:template>
 
<xsl:template match="note:page">
<xsl:copy-of select="svg:svg"/>
</xsl:template>
</xsl:stylesheet>

Please sign in to comment on this gist.

Something went wrong with that request. Please try again.