Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

SuperMemo Palm database converion

Help
wolo
2010-03-26
2013-04-14
  • wolo
    wolo
    2010-03-26

    I found http://karatasi.sourceforge.net/manual/en/palm_import.html with instructions for conversion of a SuperMemo palm database conversion into a karatasi database.
    Well, I must confess, that I'm not familiar with Perl and so I would a more help regarding this issue:
    I installed the windows distribution of Strawberry Perl and tried then to install the other required modules with the cpan client.
    But it turned out that the modul names, given in the instruction mentioned above are not complete and so I don't know which modules I really should install. So my questions are
    1. What is the exact specification of the required moduls?
    2. How to download and install the modules? With cpan install?
    Thanks in advance for your help.
    Best regards,
    Wolfram

     
  • Christa Runge
    Christa Runge
    2010-03-27

    Hi Wolfram,

    thanks a lot for the notification of the broken link. I have verified it and asked the user who posted it if he could please fix it.

    Regarding the required Perl modules:
    - you need modules to read the Palm database format
    - you need a module to write SQLite database format (this is used by karatasi)
    - you need modules for character encoding and decoding
    - you need a module for html (this is how karatasi stores the format templates)
    - you need a module to handle time
    - you need a module to handle filenames
    Unfortunately I am not familiar with the Strawberry Perl modules, so I do not know if all these are available for Strawberry.

    But finally I have another news for you: we are planning to release very soon a new beta version of our karatasi Java program.
    This version will support import of Palm Supermemo databases without Perl (only a Java environment is required).

    Regards,

    Christa

     
  • wolo
    wolo
    2010-03-27

    Hi Christa,
    thank you very much for your reply. This are indeed very good news that the karatasi Java program will be able to do the database conversion. But anyway, meanwhile I would like to try if I get it done with Perl. Actually I wanted to know if there is a pricise specificaiton of the required modules, so that I can download them from cpan. E.g. in your database conversion instruction you are requesting the Perl module DBI::SQLite. To download and install the module I started the cpan client and entered "install DBI::SQLite". The cpan client couldn't find the module and advised me to search for a module with "i /DBI::SQLite/. Doing so, I get the following list of modules:

    cpan> i /DBI::SQLite/
    Module  < Apache2::ASP::Model::CDBI::SQLite (JOHND/Apache2-ASP-Model-CDBI-SQLite
    -0.01.tar.gz)
    Module  < Audio::DB::Adaptor::dbi::sqlite (TWH/Audio-DB-0.01.tar.gz)
    Module  < Bio::DB::SeqFeature::Store::DBI::SQLite (CJFIELDS/BioPerl-1.6.1.tar.gz
    )
    Module  < Class::DBI::SQLite     (MIYAGAWA/Class-DBI-SQLite-0.11.tar.gz)
    Module  < DBIx::Class::Schema::Loader::DBI::SQLite (RKITOVER/DBIx-Class-Schema-L
    oader-0.05003.tar.gz)
    Module  < DBIx::Class::Storage::DBI::SQLite (RIBASUSHI/DBIx-Class-0.08119.tar.gz
    )
    Module  < DBIx::Skinny::Schema::Loader::DBI::SQLite (NEKOYA/DBIx-Skinny-Schema-L
    oader-0.10.tar.gz)
    Module  < Data::Conveyor::Storage::DBI::SQLite (MARCEL/Data-Conveyor-0.11.tar.gz
    )
    Module  < Data::Storage::DBI::SQLite (MARCEL/Data-Storage-0.11.tar.gz)
    Module  < ORM::Db::DBI::SQLite   (AKIMOV/ORM-0.85.tar.gz)
    Module  < Pixie::Store::DBI::SQLite (JDUNCAN/Pixie-2.06.tar.gz)
    Module  < RDF::Trine::Store::DBI::SQLite (GWILLIAMS/RDF-Trine-0.117.tar.gz)
    Module  < SPOPS::DBI::SQLite     (CWINTERS/SPOPS-0.87.tar.gz)
    Module  < SQL::Translator::Parser::DBI::SQLite (RIBASUSHI/SQL-Translator-0.11004
    .tar.gz)
    14 items found

    Now, which of these modules should I install? The list shows, that I need the complete specification of the modules. That was, what I wanted to know. Or do I make something completely wrong?
    Best regards,
    Wolfram

     
  • Christa Runge
    Christa Runge
    2010-03-28

    Sidney has meanwhile fixed the broken link  http://cognicents.com/karatasi/    to the detailed instructions how to install and configure Perl for the Palm SuperMemo database import       (thanks again, Sidney, for your fast response).

    Christa

     
  • wolo
    wolo
    2010-03-28

    Hi Christa and Mathias,
    you both are really providing an excellent support - thank you very much.
    Now, with the help of Mathia's instructions, I could verify, that my Strawberry Perl completed with all required modules.
    Now, when I try to convert my SuperMemo databases, I'm getting an error as listed below. Any ideas?
    Best regards,
    Wolfram

    C:\Downloads\Karatasi\karatasi-tools-1.5.3>perl import_palmpdb.pl -v -v sm_Tradu
    cciones.PDB
    log: ARGV: "sm_Traducciones.PDB"
    log: input file: "sm_Traducciones.PDB"
    log: database full name: "Traducciones"
    log: output file: "Traducciones.kdb"
    Der Befehl "." ist entweder falsch geschrieben oder
    konnte nicht gefunden werden.
    *G* creation date: 09.04.2006, commit date: 09.04.2006

    *L* category order  

    *L* categories 
    *L*    entries: #:1 (15)

    *L* test  
    *L*    date 28.03.2010
    *L*    entries: #:0

    *L* drill  
    *L*    entries: #:9 (18)(88)(92)(96)(101)(106)(124)(126)(145)

    *C* format  
    *C*    index: 0
    *C*    strings: (0)"{^0}" (1)"" (2)"" (3)"" (4)"" (5)"" (6)"" (7)"" (8)"" (9)""
    (10)"{^1}" (11)"{^2}" (12)"{^3}" (13)"{^4}" (14)"{^5}" (15)"" (16)"" (17)"" (18)
    "" (19)""
    *C*    flags: (0:) left (1:) centered (2:) centered (3:) centered (4:) centered
    (5:) centered (6:) centered (7:) centered (8:) centered (9:) centered (10:) left
    (11:) left (12:) left (13:) left (14:) left (15:) centered (16:) centered (17:)
    centered (18:) centered (19:) centered
    (0:) left (1:) centered (2:) centered (3:) centered (4:) centered (5:) centered
    (6:) centered (7:) centered (8:) centered (9:) centered (10:) left (11:) left (1
    2:) left (13:) left (14:) left (15:) centered (16:) centered (17:) centered (18:
    ) centered (19:) centered
    *C* category "Nicht abgelegt"  
    *C*    index: 0
    *C*    tags: (0)deutsch (1)espa├▒ol (2)Alt. 1 (3)Alt. 2 (4)Alt. 3 (5)Alt. 4
    *C*    columns: left 0 | right 1 | sort 0
    *C*    entries: #:131 (16)(17)(18)(19)(20)(21)(22)(23)(24)(25)(26)(27)(28)(29)(3
    0)(31)(32)(33)(34)(35)(36)(37)(38)(39)(40)(41)(42)(43)(44)(45)(46)(47)(48)(49)(5
    0)(51)(52)(53)(54)(55)(56)(57)(58)(59)(60)(61)(62)(63)(64)(65)(66)(67)(68)(69)(7
    0)(71)(72)(73)(74)(75)(76)(77)(78)(79)(80)(81)(82)(83)(84)(85)(86)(87)(88)(89)(9
    0)(91)(92)(93)(94)(95)(96)(97)(98)(99)(100)(101)(102)(103)(104)(105)(106)(107)(1
    08)(109)(110)(111)(112)(113)(114)(115)(116)(117)(118)(119)(120)(121)(122)(123)(1
    24)(125)(126)(127)(128)(129)(130)(131)(132)(133)(134)(135)(136)(137)(138)(139)(1
    40)(141)(142)(143)(144)(145)(146)

    DBD::SQLite::db prepare failed: no such table: card at import_palmpdb.pl line 89
    0.
    no such table: card at import_palmpdb.pl line 890.

    C:\Downloads\Karatasi\karatasi-tools-1.5.3>import_palmpdb.pl -v -v sm_Traduccion
    es.PDB

     
  • Christa Runge
    Christa Runge
    2010-03-28

    Hi Wolfram,

    the reason for the error message is a bug in the perl script which occurs only on Windows systems.
    We have published now a new version karatasi-tools-1.5.4 which contains the bugfix for it.

    Regards,

    Christa

     
  • wolo
    wolo
    2010-03-28

    Hi Christa,
    incredible - I have converted my Palm SuperMemo databases for karatasi :-))
    I think tomorrow I can try it on the iPhone of a friend where we already installed karatasi.
    I'm quite sure that I will like it and so I just have to wait for iPhone G4 to buy it.
    Thanks a lot for your help.
    Best regards,
    Wolfram
    PS: I think the same problem with import_palmpdb.pl exists in import_csv.pl.

     
  • Christa Runge
    Christa Runge
    2010-03-28

    Hi Wolfram,

    > PS: I think the same problem with import_palmpdb.pl exists in import_csv.pl.

    Ooops - yes, you are right. We have done a re-release of karatasi-tools 1.5.4 with the additional bugfix.

    Christa