Import Entries from Old BlogCFC

[Madamqueen]

I have a BlogCFC dated Jan 06 - can't find the version #. I would like
to import the old entries into the latest version but can't just
import the tables through MYSQL because they overwrite the new table
setup and the passwords don't encrypt.

I tried using the updater but it gave me an error message that it
couldn't find the files it needed. The path the error message was
displaying was incomplete

How can I import the data from the old MYSQL database to the new
database and maintain all the IDs to keep everything connected?

[Darrell Miller]

If the database architecture is re same between versions then just do a export to script and run it on the new database. What I would try first

Darrell

[Madamqueen]

The problem is the database architecture is NOT the same since the
newer version has additional fields and encrypts the password in the
tblusers. I tried just importing all the tables (except the tblusers)
but the tables did not connect properly - the relationships didn't
work.

On Jul 9, 9:47 am, Darrell Miller <darrellmille...@gmail.com> wrote:
> If the database architecture is re same between versions then just do a
> export to script and run it on the new database. What I would try first
>
> Darrell

[Raymond Camden]

Well, the entries table has a few new columns, but it should be ok if
they stay blank. So I'd simply import the entries, the categories, and
the join table. That should work fine.

--
===========================================================================
Raymond Camden, Adobe Developer Evangelist

Email : raymon...@gmail.com
Blog : www.coldfusionjedi.com
Twitter: cfjedimaster

[Madamqueen]

When you say "the join table" do you mean "tblblogentriesrelated"?
That table is empty in the old database and the new version database.

> Email : raymondcam...@gmail.com
> Blog :www.coldfusionjedi.com
> Twitter: cfjedimaster

[Raymond Camden]

No I meant btn entries and categories.

Email : raymon...@gmail.com
Blog : www.coldfusionjedi.com
Twitter: cfjedimaster

[Madamqueen]

I have set up the blogcfc as a new blog, then exported entries from
the oldblog to a txt file or xlsx file and imported the entries into
each table in the new blog database. All the entries and pages are
listed (and I have refreshed the blog cache. No entries appear - even
though the archive by subject pod and the recent comments pod have
data with hyperlinks (which do not display the entry when clicked) and
the recent entries pod is empty. The main entry area says "sorry no
blog entries available"

I did not change anything from the default set up - except to change
the path to the blog since I am testing it locally.

There must be something broken in the table relationships - any ideas?

[Raymond Camden]

Do the blog entries have a valid author value?

[Madamqueen]

That was the problem! I did not import the authors because of the
password encryption, but I manually reentered their user info and
voila! The entries all appeared! Thank you!

[Raymond Camden]

No worries. Glad you got it up and running. :)

--

===========================================================================
Raymond Camden, Adobe Developer Evangelist

Email : raymon...@gmail.com
Blog : www.coldfusionjedi.com
Twitter: cfjedimaster

[Morris Fourie]

I wish to import subscribers from another location to blogcfc 5.9.8. What do I do regarding the "token" field? Is it required

[Raymond Camden]

Just create a random UUID via CF's createUUID function. 

--
You received this message because you are subscribed to the Google Groups "BlogCFC" group.
To unsubscribe from this group and stop receiving emails from it, send an email to blogcfc+u...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
===========================================================================
Raymond Camden, Adobe Developer Evangelist

Email : raymon...@gmail.com

Blog : www.raymondcamden.com
Twitter: cfjedimaster