Title: Import empty value and mapping value
Last modified: August 19, 2020

---

# Import empty value and mapping value

 *  Resolved [notelseit](https://wordpress.org/support/users/notelseit/)
 * (@notelseit)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/import-empty-value-and-mapping-value/)
 * I have a column with three values, E, I and empty, now I have to map the three
   values which are categories, how can I do for the empty field to give it a name
   during import?

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

 *  Plugin Author [WP All Import](https://wordpress.org/support/users/wpallimport/)
 * (@wpallimport)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/import-empty-value-and-mapping-value/#post-13289824)
 * Hi [@notelseit](https://wordpress.org/support/users/notelseit/),
 * > how can I do for the empty field to give it a name during import?
 * If each row contains a single value, you could use an XPath IF statement to do
   that. Example:
 * `[IF({category[1][not(string())]})]Default Category Name[ELSE]{category[1]}[ENDIF]`
 * If each row can contain multiple values, e.g. “E,I,”, then you’d need to use 
   a PHP function to change the blank entry: [https://www.wpallimport.com/documentation/developers/custom-code/inline-php/](https://www.wpallimport.com/documentation/developers/custom-code/inline-php/).
 *  Thread Starter [notelseit](https://wordpress.org/support/users/notelseit/)
 * (@notelseit)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/import-empty-value-and-mapping-value/#post-13292288)
 * Thanks for the answer I ran as you told me for the blank value in the single 
   row but I am not assigned to the default category set.
 * as you see of the attached images I did so is it correct?
 * [image 1](https://suxvise.com/listini/column.png)
 * [image 2](https://suxvise.com/listini/column2.png)
 * [image 3](https://suxvise.com/listini/column3.png)
 *  Plugin Author [WP All Import](https://wordpress.org/support/users/wpallimport/)
 * (@wpallimport)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/import-empty-value-and-mapping-value/#post-13324377)
 * Hey [@notelseit](https://wordpress.org/support/users/notelseit/),
 * Using the same data and settings from your screenshot, I’m getting “***” as the
   default category in the preview: [https://d.pr/i/ctuOL2](https://d.pr/i/ctuOL2).
 * Since I can’t replicate it, please reproduce the problem on a debug site at [http://www.wpallimport.com/debug/](http://www.wpallimport.com/debug/)
   and open a support request at [http://www.wpallimport.com/support/](http://www.wpallimport.com/support/)
   with the details.
 *  Thread Starter [notelseit](https://wordpress.org/support/users/notelseit/)
 * (@notelseit)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/import-empty-value-and-mapping-value/#post-13361672)
 * done , i have debug site and send request
 *  Plugin Author [WP All Import](https://wordpress.org/support/users/wpallimport/)
 * (@wpallimport)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/import-empty-value-and-mapping-value/#post-13384151)
 * Thanks [@notelseit](https://wordpress.org/support/users/notelseit/), I’m going
   to mark this thread as resolved since we’re moving the discussion.
 * If anyone else reading this runs into a similar issue, please open your own thread
   with details on what’s happening.

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

The topic ‘Import empty value and mapping value’ is closed to new replies.

 * ![](https://ps.w.org/wp-all-import/assets/icon-256x256.png?rev=2570179)
 * [WP All Import – Drag & Drop Import for CSV, XML, Excel & Google Sheets](https://wordpress.org/plugins/wp-all-import/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-all-import/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-all-import/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-all-import/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-all-import/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-all-import/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [WP All Import](https://wordpress.org/support/users/wpallimport/)
 * Last activity: [5 years, 9 months ago](https://wordpress.org/support/topic/import-empty-value-and-mapping-value/#post-13384151)
 * Status: resolved