WordPress.org

Ready to get started?Download WordPress

Forums

Sunlog Converter (9 posts)

  1. Reimer
    Member
    Posted 10 years ago #

    Hi,
    I just took a closer look at WordPress and wish to switch to it. In the moment I'm using Sunlog ( http://sunlog.ch/ ) and would like to know, if anybody got an idea how I can convert all entries to WordPress. In the moment I have about 200 articles and I don't want to add it all of them by hand.
    You can download the latest version of Sunlog at http://sunlog.ch/pub/sunlog/dist/current/sunlog-0.2.4.tar.gz and maybe someone of you can help me out.
    Greetings
    Reimer

  2. Matt Mullenweg
    Troublemaker
    Posted 10 years ago #

    If you send me your database dump from Sunlog I'll take a look at it.

  3. Reimer
    Member
    Posted 10 years ago #

    Thanks a lot. Here are the important tables of the database. I didn't add all, because the others are not important.
    <pre>
    CREATE TABLE articles (
    id int(10) unsigned NOT NULL auto_increment,
    title varchar(255) NOT NULL default '',
    lead text NOT NULL,
    article text NOT NULL,
    linebreaks enum('1','0') NOT NULL default '1',
    convert enum('1','0') NOT NULL default '0',
    display enum('1','0') NOT NULL default '1',
    comments enum('1','0') NOT NULL default '1',
    amount_c int(10) unsigned NOT NULL default '0',
    author int(10) unsigned NOT NULL default '0',
    timestamp datetime default NULL,
    PRIMARY KEY (id),
    KEY display (display),
    KEY timestamp (timestamp),
    KEY author (author),
    FULLTEXT KEY admin_search (title,lead,article)
    ) TYPE=MyISAM;
    # --------------------------------------------------------
    #
    # Tabellenstruktur für Tabelle authors
    #
    CREATE TABLE authors (
    id int(10) unsigned NOT NULL auto_increment,
    name varchar(255) NOT NULL default '',
    email varchar(255) NOT NULL default '',
    homepage varchar(255) NOT NULL default '',
    pwd varchar(32) NOT NULL default '',
    rights char(1) NOT NULL default '',
    PRIMARY KEY (id),
    KEY pw_check (name,pwd)
    ) TYPE=MyISAM;
    # --------------------------------------------------------
    #
    # Tabellenstruktur für Tabelle categories
    #
    CREATE TABLE categories (
    id int(10) unsigned NOT NULL auto_increment,
    lft int(10) unsigned NOT NULL default '0',
    rgt int(10) unsigned NOT NULL default '0',
    root_node int(10) unsigned NOT NULL default '0',
    level int(10) unsigned NOT NULL default '0',
    title varchar(255) NOT NULL default '',
    optional_1 varchar(255) NOT NULL default '',
    optional_2 varchar(255) NOT NULL default '',
    optional_3 text NOT NULL,
    display enum('1','0') NOT NULL default '1',
    PRIMARY KEY (id),
    KEY display (display)
    ) TYPE=MyISAM;
    </pre>

  4. Reimer
    Member
    Posted 10 years ago #

    If you have any questions, just post them :)

  5. Reimer
    Member
    Posted 10 years ago #

    Any news on this? Maybe a RSS-Feed might help you.

  6. Toaster
    Member
    Posted 10 years ago #

    Hello,
    I would like to switch to WordPress, too! I use Sunlog 2.2 (what the most Sunlog users do), but can update to the latest version Sunlog Lite 0.2.4 and then switch to WordPress with an import script. Will this script become possible? That would be great!
    Toaster

  7. Cena
    Member
    Posted 10 years ago #

    It'd probably be more effective if either of you could send Matt your database dump by EMAIL rather than posting to the forums.
    m@wordpress.org

  8. Toaster
    Member
    Posted 10 years ago #

    Yes, I will send him a dump of my database ...
    Toaster

  9. melle
    Member
    Posted 10 years ago #

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.