Title: Category Data Not Importing/Seen?
Last modified: August 18, 2016

---

# Category Data Not Importing/Seen?

 *  [BigBirdy](https://wordpress.org/support/users/bigbirdy/)
 * (@bigbirdy)
 * [18 years, 7 months ago](https://wordpress.org/support/topic/category-data-not-importingseen/)
 * I have some data (journal) that I have tried to import into WP. The table is 
   pretty basic, with fields like entry date, journal_text, category etc and so 
   I started by creating the same categories in WP as were used for the journal.
   I can import the data just fine into the wp_posts table, and although the post_category
   field is populated with the correct category numbers, and the posts show up fine.
   But the categories do not show up so I am betting there are some other tables
   that need to be populated. Can someone suggest how I can import some data from
   another table, into the wp_posts table and also populate any corresponding tables/
   data so the categories listed in wp_posts show up properly? This is the sql I
   am using for the import…..the “j_entries” table is the table containing the old
   journal entries.
 * insert into wp_posts (ID, post_author, post_date, post_date_gmt, post_content,
   post_title, post_category, post_excerpt, post_status, comment_status, ping_status,
   post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, 
   post_content_filtered, post_parent, guid, menu_order, post_type, post_mime_type,
   comment_count)
 * select ”, 2, Edate, Edate, Etext, Etitle, catID, ”,’publish’,’open’,’open’,”,”,”,”,
   Edate, Edate,”,0,”,0,’post’,”,”
    from j_entries where eid=1;

The topic ‘Category Data Not Importing/Seen?’ is closed to new replies.

## Tags

 * [categories](https://wordpress.org/support/topic-tag/categories/)
 * [importing](https://wordpress.org/support/topic-tag/importing/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [BigBirdy](https://wordpress.org/support/users/bigbirdy/)
 * Last activity: [18 years, 7 months ago](https://wordpress.org/support/topic/category-data-not-importingseen/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics