Title: Automatic Post Tagger
Last modified: August 20, 2016

---

# Automatic Post Tagger

 *  Resolved [sandrabooher](https://wordpress.org/support/users/sandrabooher/)
 * (@sandrabooher)
 * [13 years, 8 months ago](https://wordpress.org/support/topic/automatic-post-tagger/)
 * I am currently using this plugin and I am very satisfied with it, BUT….
 * I can’t seem to import tags from a backup file on my computer.
 * The file name i am using is apt_backup.csv. I have approx 400 tags in column 
   A1 to A400. Do i need a header or something in cell A1?????? When I click “Import
   From a Backup”, I get the message “ERROR: Some tags were not imported because
   their names were missing”
 * Can you please help me with this issue.
 * [http://wordpress.org/extend/plugins/automatic-post-tagger/](http://wordpress.org/extend/plugins/automatic-post-tagger/)

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Plugin Author [Devtard](https://wordpress.org/support/users/devtard/)
 * (@devtard)
 * [13 years, 8 months ago](https://wordpress.org/support/topic/automatic-post-tagger/#post-3075976)
 * That’s weird. I would have to take a look at the content of the file, could you
   upload it somewhere or post it on [http://pastebin.com](http://pastebin.com),
   please?
 *  Thread Starter [sandrabooher](https://wordpress.org/support/users/sandrabooher/)
 * (@sandrabooher)
 * [13 years, 8 months ago](https://wordpress.org/support/topic/automatic-post-tagger/#post-3075985)
 * Hello Devtard
 * The file is below:
    tutvids.s3.amazonaws.com/apt_backup.csv
 *  Plugin Author [Devtard](https://wordpress.org/support/users/devtard/)
 * (@devtard)
 * [13 years, 8 months ago](https://wordpress.org/support/topic/automatic-post-tagger/#post-3075991)
 * Hey, your file does not have its required format, that’s the reason why it cannot
   be imported. It must look like this:
 *     ```
       1|tag name|related word;foo;lorem ipsum
       2|another tag|dolor sit;amet
       3|random keyword|related words
       ```
   
 * The ID is not important but just make sure that it is unique for every row.
 * You can download a sample backup file if you have created some tags via the plugin
   already.
 *  Thread Starter [sandrabooher](https://wordpress.org/support/users/sandrabooher/)
 * (@sandrabooher)
 * [13 years, 8 months ago](https://wordpress.org/support/topic/automatic-post-tagger/#post-3076003)
 * This works Perfect! I am really loving your plugin…
 * I do have another question though… When I click to delete the tags, the plugin
   appears to work fine. The number of tags show 0 in the plugin. However, the tags
   are still in wordpress.
 * When I click on Posts, Then Tags, I see all 8,000 tags that must go!
 * Can you help me here too please.
 * Thank you
 *  Plugin Author [Devtard](https://wordpress.org/support/users/devtard/)
 * (@devtard)
 * [13 years, 8 months ago](https://wordpress.org/support/topic/automatic-post-tagger/#post-3076008)
 * APT is able to delete only those tags that are present in its own MySQL table.
 * You can delete all your tags via the administration interface ([http://i49.tinypic.com/2vmimme.png](http://i49.tinypic.com/2vmimme.png))
   or by a SQL query via your phpMyAdmin or your theme file functions.php (use function**
   mysql_query(“$sql_command”);** for that – replace the variable with the query
   below):
 *     ```
       DELETE a,b,c
       FROM
       	database.prefix_terms AS a
       	LEFT JOIN database.prefix_term_taxonomy AS c ON a.term_id = c.term_id
       	LEFT JOIN database.prefix_term_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id
       WHERE (
       	c.taxonomy = 'post_tag' AND
       	c.count = 0
       	);
       ```
   

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Automatic Post Tagger’ is closed to new replies.

 * ![](https://ps.w.org/automatic-post-tagger/assets/icon-256x256.png?rev=1049934)
 * [Automatic Post Tagger](https://wordpress.org/plugins/automatic-post-tagger/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/automatic-post-tagger/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/automatic-post-tagger/)
 * [Active Topics](https://wordpress.org/support/plugin/automatic-post-tagger/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/automatic-post-tagger/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/automatic-post-tagger/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [Devtard](https://wordpress.org/support/users/devtard/)
 * Last activity: [13 years, 8 months ago](https://wordpress.org/support/topic/automatic-post-tagger/#post-3076008)
 * Status: resolved