You're viewing old version number 11. - Current version

2 min

In Progress - Migrating content to live site

Use simple REST API to migrate my real content from this Jot Hut test site and from Toledo Talk into the live Jot Hut site.

From test jot jut

select * from content where type in ('b','m') and status='o' order by id asc

Preserve all the data except anything that was a reply blog post, so ignore the parentid from the test content.

Preserve created date.

may need to add an import date column to content table

July 29, 2013 update

  • created rest client script to read content from kestrel and to send it to junco server app.
  • created a server module to receive client data and to input it into the database, preserving created and modified dates.
  • junco content db table does have the importdate column, and that info is displayed on blog and microblog posts.

In July/August, 2013, all the blog and microblog content in the Kestrel app was migrated/imported to Junco and the live JotHut site.

Sep 17, 2013 update

Need to import my microblog content from Toledo Talk to Jot Hut (Junco).

If a script is used to import blog/wiki posts from Toledo Talk to Jot Hut, then read this: Migrating tt blog and wiki posts to junco.

I'm finally resuming this. I migrated a batch of 250 microblog posts back in mid-August, and I only migrated the second batch today. So as of Sep 17, 2013, 500 of my microblog posts at Toledo Talk have been migrated to Jot Hut.

A total of nearly 17,160 microblog posts need to be migrated!! Whoa.

I created the microblog feature at Toledo Talk in September 2007. I used it some, but when Yahoo! shutdown the Delicious bookmarking service, then I used the TT microblog feature as a link blog tool.

I planned to migrate 250 microblog posts per day, so as to no raise suspicion with my Web hosting company even though both sites are hosted at the same company, and both sites are owned by me. I suppose that I could contact support and ask if I can do larger bulk migrations.

17,000 mb posts migrated in batches of 250 per day will take 68 days to complete or just over two months. I would have five weeks down, if I had kept up with this when I started.

Maybe I'll migrate 1000 per day but in four batches spread throughout the day. Morning. Afternoon. Evening. Late night.

Microblog posts migrated

  • 250 on Aug 13
  • 250 on Sep 17
  • 250 on Sep 25 a
  • 250 on Sep 25 b
    • 1000 total thus far
  • 500 on Sep 26
  • 500 on Sep 27 a
    • 2000 total
  • 500 on Sep 27 b
  • 500 on Sep 30
    • 3000 total

#junco
#juncotodo
#inprogress

From JR's : articles
451 words - 2448 chars - 2 min read
created on
updated on - #
source - versions

Related articles
In Progress - Add webmention client code to Junco - Oct 21, 2013
In Progress - Migrating content to live site - Dec 06, 2013
In Progress - Junco end-user testing - Oct 17, 2013
In Progress - Add Microformats support - Oct 07, 2013
Resolved - Add keyboard shortcuts to split-screen typing mode - Mar 28, 2014



A     A     A     A     A

© 2013-2017 JotHut - Online notebook

current date: Dec 23, 2024 - 12:53 p.m. EST