By jefdrupal on

I am a newbie to drupal. I am moving a 1500 post Wordpress website to drupal. I used wp2drupal. Somehow I did not get any tags in drupal OR I just don't know where they are (as I am new to this). All the posts, trackbacks, comments, users came in correctly (and seem to be working correctly)

Obviously I need to fix this. The drupal db show no data in any of the terms_ and I have 2 vocabulary entries and 2 vocab node types in the database. I don't think the tags came into drupal. I see the tags in the wp database I imported from (in a table called wp_tags).

I am trying to learn about taxonomy and it's relationship to tags as quickly as I can. I need to get the tags in drupal or its pretty much a dealbreaker for wp to drupal migration (retagging 1500 posts by hand won't be fun).

I can bumble my way through phpmyadmin. Is there some way to get the data from wp_tags into the drupal database (in a way that won't cause me problems down the road). How do i set up the taxonomy so that the tags are attached to the proper posts.

Or another way to accomplish the same thing.

Thanks

⋅ Categories: Drupal 6.x

Comments

damienmckenna’s picture

damienmckenna
Location TN, USA
commented

A few questions to get started:

  • What version of Wordpress are you using?
  • Do you have any plugins installed that might affect the tags?
  • Did you select/enter destination vocabularies for the existing tags?
  • Are there any vocabularies in your migrated data ("vocabularies" table)?

--
Damien McKenna | Mediacurrent

jefdrupal’s picture

jefdrupal commented

Still a newbie, but I think I can answer well enough to help.

I have since done some more testing. I installed wp 2.3, 2.5, 2.9 and then imported the xml file I outputted from the current wp site, which is wp 2.0 or 2.1. The tags in wp are in Ultimate Tag Warrior, which is not supported in wp2.3. There is however a built in wp importer in 2.3 that is supposed to bring in the tags. My next move was to try to import my wp xml file into 2.3, use the UTW import. If that worked I was going to use that database to run wp2drupal (because technically, it should have all the things wp2drupal needs in there). The problem is that wordpress would not import my xml file in 2.3 (which is odd because it will import in 2.5 and 2.9???).

So what I currently have is two things:
A) The original site in wp 2.1. The tags are in Ultmate Tag Warior which has three tables wp_post2tag, wp_tag_synonyms, wp_tags. When I run its database through wp2drupal, posts, comments, users, paths get imported and related correctly. I do not see any indication that categories or tags came into the drupal database (either as taxonomy or connected to the proper nodes). My guess is that this is because that data is in the utw tables (which is why I tried to upgrade wp to 2.3+)

B) I have a 2.5 wp upgraded site that I tried to update my version to. In this site, all the tags from the old site were converted to wp categories. I have posts, comments, and the "new" categories are attached to the post correctly. Oddly, I don't have the original authors name attached to the post (although the comments have authors), nor do I have the users email addresses in the backend.

My preference would be to try to use A. All the data is there, and I worry that I will miss/lose soemthing with all the intermediate steps. I just can't get it converted correctly.

Now, to try to specifically answer your questions:
- What version of wordpress - see above
- I have UTW and I believe it is affecting the tags
- I am not sure if I selected or entered destination vocabularies for existing tags (this might be a problem). I have hundreds of tags, so if each hand to be selected individually, I didn't do that. I am a bit hazy on vocab vs tags thing, so this might be my error.
- I am not sure exactly what your are asking. I have been fiddling around with this development site (NOTE: using wordress import drupal module too). I may have made some of the values... not wp2drupal??. Currently here is the contents of the table "vocabulary", but I would be careful interpreting it due to all my fiddling. Is this what you needed to know?
Hide Browser transformation
vid name description help relations hierarchy multiple required tags module weight
Edit Delete 1 Categories NULL 0 0 1 0 0 taxonomy 0
Edit Delete 2 Tags Topics imported from Wordpress 0 0 1 0 1 taxonomy 1
Edit Delete 3 TestVocab This is a test of vocabulary in Taxonomy 1 0 1 1 1 taxonomy 0
Edit Delete 4 Wordpress category NULL 0 2 1 0 0 wordpress_import 0
Edit Delete 5 Wordpress tag NULL

Thanks for helping. If i can get this data converted I can proceed with my drupal education!