Migrate Photoplog to vB5

[pyro2927]

I'm working on a script to migrate existing Photoplog pictures to vBulletin 5 photos/albums. It looks like each element in vB5 is a node, and the photo table links an entry on filedata and a node.

I have userids, descriptions, and files currently in place. I've been able to import the files into the filedata table by using LOAD_FILE() in MySQL, but I haven't been able to get the photos to show up on the user's profile page. I am attempting to create an Album node, and it appears in the database and is assigned to the correct userid, but it doesn't show up on their page.

Here is the script I've been working on:
http://hastebin.com/vulefepega.rb

[Lynne]

I don't see you inserting the data into the photo or gallery tables. filedata basically has the image data for every file, but photo has the nodeid for each along with any caption. And then gallery keeps track of everybodies 'galleries' (a person may have several galleries each for a different subject).

So, say I have three 'galleries' in my media tab, like this:

Cats
- image 1
- image 2
Dogs
- image 3
- image 4
Favorite Images
- image 1 (again)
- image 4 (again)

That is four different entries into the filedata table (for four different images)
That is six different entries into the photo table (for each time the image is used)
That is three different entries into the gallery table (for the three galleries for this user)
That is nine different entries into the node table (for the three galleries and the six photos)

I hope that helps out.

[pyro2927]

I think that helps get me on the right track, thanks!

I've added a gallery in as a node and as by adding an entry under the "gallery" table, linking the newly created nodeid. The node is assigned to my userid and has a routeid of 50 and a contenttypeid of 22. The gallery I created through the UI seems to have similar values, yet this hand-inserted one is not showing up on my user page. Any idea on why that might be? Pasted below is the entry:

nodeid routeid contenttypeid publishdate unpublishdate userid groupid authorname description title htmltitle parentid urlident displayorder starter created lastcontent lastcontentid lastcontentauthor lastauthorid lastprefixid textcount textunpubcount totalcount totalunpubcount ipaddress showpublished oldid oldcontenttypeid nextupdate lastupdate featured CRC32 taglist inlist protected setfor votes hasphoto hasvideo deleteuserid deletereason open showopen sticky approved showapproved viewperms commentperms nodeoptions prefixid iconid
650540 50 22 1396136765 NULL 1750 NULL BlueGT88 NULL Photoplog Migration Photoplog Migration 9 photoplog_migration NULL 649830 1396136765 1396136765 649830 BlueGT88 1750 0 0 0 0 1 NULL NULL NULL NULL 0 NULL 1 0 0 0 0 0 NULL NULL 1 1 0 1 1 2 1 138 0

Update: Looks like the previous script isn't loading anymore, here is the updated one:
http://pastie.org/private/pcvethjqfi60yivnzegwa

[Lynne]

Did you make sure to go to Maintenance > Clear System Cache after you added your stuff to the database?

And, I forgot to mention... the closure table. (Honestly, I try to forget about that table!).

Every one of your nodes will have at least one row in there. For Galleries, they will have one for themselves and each photo in it.
parent: 650540
child: 650540
depth: 0
display order: 0
publishdate: 1396136765

Then say you have a photo with nodeid x in that gallery (same publish date):
parent: 650540
child: x
depth: 1
display order: 0
publishdate: 1396136765

AND, a row for itself:
parent: x
child: x
depth: 0
display order: 0
publishdate: 1396136765

[pyro2927]

Ah, totally didn't know about the closure table! Maybe that's the piece I've been missing! I'll work on that and see if it works, thank you so much!