WP Ultimate CSV Importer FAQ

From Smackcoders WikiPages
Jump to: navigation, search

Contents

FAQ

Added New Features Version 3.6

How auto UTF-8 handling works?

Plugin will automatically try to convert every csv uploaded to utf-8 regardless of any format. This is a test drive feature. Based on user report and suggestion further metrics will be applied.


What is auto delimiter?

Now plugin is improved to detect any delimiters without users interaction. So csv that are not formatted or escaped well may show in single column values. These CSVs are need to be strictly evaluated before import.


How author import access works?

Authors can be allowed to access importer features except the user module import for security concern.


Added New Features Version 3.5

How to define post_format in a csv?

The post_format attribute should be assigned like 1,2,3,4,5,6 or 7 relevant to each row in csv. The values are as follows

1 - Aside 3 - Video 4 - Audio 5 - Quote 6 - Link 7 - Gallery

You can skip these fields leaving empty to assign standard as format.

How to define page_template in a csv?

The page_template attribute should be assigned like 'page-template/full-width.php' for each row in csv depending on theme templates. You can skip these fields leaving empty to assign default template.


CSV File and Format Related

What is csv file?

CSV stands for "Comma Seperated Values". CSV file format is used to store data in a structured table of lists as columns and rows. CSV File otherwise Comma Separated Values file is a simple text file that stores attribute names as headers and their related values in comma separated format.

In general opening csv files in MS Excel or any spread sheet editor will show all values under each header as columns and rows. Each column have a attribute name called as CSV file header and their data/values in rows for each entry.

For ultimate csv importer each row is imported as a post for a selected post type and columns are imported as filed attribute values of the posts. This is done by simple interface of drop downs of header or attribute names are mapped to wordpress post field attributes like post title, content, status. So no of rows are equal to no of posts that to be imported. And columns or csv headers are equal to no of field attributes assigned under each post like author, category, tags, custom fields etc.

What is csv format and types of it?

The CSV file type 'Comma-Separated Variables' or comma delimited file is a records and data from a database or software exported, where each record/data in single line and each field attributes in records are indicated as comma separated. In some cases instead of comma other delimiters also can be used like ; separated.


CSV Format is chosen encoding while saving as a csv file. There are several formats available like ANSI, UCS-2 Big Endian, UCS-2 Little Endian, UTF-8, UTF-8 without BOM etc.

For ultimate csv importer to import csv as wordpress post type, UTF-8 is advised for successful import. In case of other language import or any special characters, diacritics, Cyrillic or Han characters are included in csv import, UTF-8 without BOM format is suggested.

How to choose separator or delimiter for ultimate CSV Importer?

In ultimate csv importer you can choose the delimiter as , or ; while importing the csv file.

How to open csv files? read csv file?

In general to read or open existing CSV files simple text editors can be used. For easy editing and best view, any spread sheet editor like MS Excel or OpenOffice Calc is useful.

How to convert my existing data to csv format?

In general to read or open existing CSV files simple text editors can be used. For easy editing and best view, any spread sheet editor like MS Excel or OpenOffice Calc is useful. To convert encoding format of a csv file open it in text editor and save as with needed file format.

For E.g. open your csv file in Notepad++ copy the text. Now open a new empty file choose UTF-8 without BOM or other from Menus >> Encoding and paste the copied text. Now save and replace the old CSV file. Now your CSV file with choosen format can be imported without any issues in Ultimate CSV importer.

Plugin Related

How to install the plugin?

For detailed installation instruction read here - http://wiki.smackcoders.com/index.php?title=WP_Ultimate_CSV_Importer#Installations

How to use the plugin to import a csv file?

Refer here as below

1.http://blog.smackcoders.com/how-to-import-content-to-wordpress-simple-steps-tutorial-wordpress-ultimate-csv-importer-plugin-part-i.html

2.http://blog.smackcoders.com/how-to-import-content-to-wordpress-simple-steps-tutorial-wordpress-ultimate-csv-importer-plugin-part-ii.html

What is a csv importer plugin?

Csv importer plugin is a tool/plugin that can import your data and records from exported, stored, saved as csv files to your software as useful viewable content to analyze, manage etc. In such way Ultimate CSV importer is a worpdress plugin that imports your offline records or data stored/exported as a csv file into any wordpress post type web content by simple easy mapping feature.

Why we need CSV import for wordpress?

If you need to move data from our local system to live website as post content and their field attributes in bulk you should need a csv importer plugin for reduce manual work and time. In normal affiliates data like amazon, auto blogging, drop shipping ecommerce, inventory management, periodical changes to content in bulk, bulk editing cms content etc can be handled as simple as few easy clicks by an advanced csv importer plugin like Ultimate CSV importer plugin.

More to that features like auto mapping headers, mapping templates, smart scheduling etc in pro version makes periodical imports more easy and automatic even without mapping itself.


CSV Import Related

What csv format is supported?

In normal UTF-8 is needed to import data as wordpress posts using Ultimate CSV Importer. Also comma-separated(, )and semicolon-separated(;)format are supported. You can choose a delimiter at the time of import. In case of special characters or other language import csv with UTF-8 without BOM format is suggested.

How to import other languages using ultimate csv importer?

Simple CSV File Format Conversion Steps for Other Than English Language Import.

It is proven from Users reports and several testing that UTF-8 without BOM works well for all language import using ultimate csv importer like Polish characters and special characters etc.

Follow these simple steps to import other languages. Thanks for the steps mojeprogramy.com.

1) Prepare a CSV file with the data (I used Excel)
2) Saving files to CSV (Excel function)
3) I opened the CSV file in Notepad + +
4) CTR + A, CTR + C (copy all the text)
5) Then in Menu "Encoding"> "Encode without BOM"
6) CTR + V to paste all text
7) Save the file
8) Imports for WordPress.

How to Format a CSV file for simple sleek import using WP Ultimate CSV Importer Plugin?

This video helps you to tweak/format your CSV file to make a fast, simple and easy import using WP Ultimate CSV importer plugin without missing all the features. We have used MS Excel as CSV editor here. You can use other applications also. Take advantage of our importer format by slightly tweaking your csv.


How to create a well formatted csv for ultimate power import?

The other way to learn tweaking We have used text editor here to explain how to create a well formatted csv in seconds for importing. You can use this format to take advantage of our importer format by slightly tweaking your csv. This video helps you to tweak/format your CSV file to make a fast, simple and easy import using WP Ultimate CSV importer plugin without missing all the features.



Where can i get sample files, cheat sheets and other references?

1. You can get sample files for various modules with supported plugins E.g. posts with All In One SEO etc.

https://drive.google.com/a/smackcoders.com/folderview?id=0B6n-BL1YI3MwTFRlOUdGWWJFVUk&usp=sharing#

Post & Page
Post with All in SEO fields
Post with SEO by YOAST fields
Post with Advanced custom fields
Custom Posts for Custom post type UI plugin
Custom Posts for CCTM plugin
Custom Posts for Types plugin
Nested Category
Nested Category with category icons
Tags and Custom Taxonomies
Users with roles
Advanced eshop import
WP ecommerce import
WP ecommerce import with wp ecommerce custom fields,
Advanced Woo commerce import


2. To build your own csv import with complex field attributes you can get simple cheat sheets here - http://blog.smackcoders.com/how-to-make-one-click-easy-csv-import-in-wordpress-free-cheat-sheet-downloads.html

What you mean by mapping?

Mapping is the way users match and relate each CSV header or attribute column name to relevant wordpress field listed as simple drop down. So that users can map any csv file headers to a post field attributes or as a new custom field.


What are mandatory fields?

Mandatory fields are the minimum fields that are required to create a post by mapping to avoid empty post imports. For further references visit:http://blog.smackcoders.com/wordpress-ultimate-csv-importer-error-post_status-are-mandatory-fields.html In advanced ultimate csv importer pro mapping can be automated by two ways now.

1. You can save and recall mapping as template by a name
2. Or use auto mapping header tags to create a csv file template.

What can be imported to wordpress using ultimate csv importer?

Users can import Posts, Pages, users with Roles as Level, Custom fields, Custom Taxonomies, Comments, Categories as bulk along with supported plugin fields attributes like SEO meta etc. In 3.5 version users have to enable required modules from settings tab to view it in UI. Users can also use this option to enable and disable modules based on their requirements to keep the interface clean and simple.

Also in pro version there are no. of 3rd part plugins supported. The supported plugins also can be enabled from settings tab.

What are the list of 3rd party plugins supported? (Pro Only)

  • E-commerce * : E-shop, woo-commerce, WP e-commerce, WP e-commerce custom fields
  • Custom post and custom fields* : Cutstom post Type UI , ACF, CCTM
  • SEO Plugins * : All-in-seo, Yoast seo for wordpress

Supported Third Party plugins list

Ecommerce

   Eshop
   WP eCommerce
   WP eCommerce Custom Fields
   WooCommerce

Custom Post Type and Custom Fields

   Custom Post Type UI 
   CCTM
   ACF 

SEO For Post, Page, Custom Post and Ecommerce

   All in One SEO for SEO
   WordPress SEO by Yoast

Also you can use compatible plugin short codes in content import are

   Next GEN Gallery
   Gallery
   Slideshow
   WP Photo Album Plus
  • Note - Plugins other than listed here may not compatible or needs customization to work as expected *

Can i bulk edit/update existing posts created manually? (Pro Only)

Yes, we can edit/update existing posts created manually in pro version based on post ID or title or both. But you can update only post that are imported using ultimate csv importer.

How to schedule post for publishing?

In CSV you can set a date and time for publishing your posts. Posts that with future date and time will be scheduled for publishing automatically as wordpress do by default.

In Pro version you have a feature to schedule a csv file import for a date and time you assign. Once you complete upload, mapping process instead of import you can choose to schedule it for a date and time in calendar.

What is auto mapping feature? (Pro Only)

Auto mapping feature can map all the wordpress field attributes automatically by reading the csv header tags. So that periodical import of same csv file structures can be simply replaced by copy pasting headers alone before import. This feature is used to reduce the time and pain of mapping several fields each every time to import data from the csv file.

What is mapping template feature? How to use it? (Pro Only)

Mapping template feature is to save a mapping structure as a template. So you can recall a mapping template instead mapping each every field attribute in drop down. You can also review and alter mapping before clicking import or as save as new template structure. This will be really useful for frequent imports, imports with long list of field attributes, scheduled imports etc.

How saved mapping template can be reused? (Pro Only)

You have an option to choose one from list of saved templates. Once the template is chosen mapping is populated for the uploaded csv file for import. This will remove pain of mapping each and every time.

How to schedule csv files for import? (Pro Only)

Once csv file is uploaded and mapping is done manually or auto mapping or by template, instead of import you can use the option to schedule the import for future time and date via Smart Scheduler option.

Is schedule import possible from remote location? (Pro Only)

This is not in current version. Still in development pipeline. Instead you can contact us for customization.

How to automate periodical scheduled import?(Pro Only)

This is not in current version. Still in development pipeline. Instead you can contact us for customization.

Is auto split up schedule import possible? (Pro Only)

This is not in current version. Still in development pipeline. Instead you can contact us for customization.

Data Export Related (Pro Only)

How to export data or export-csv from wordpress? (Pro Only)

There is a separate module for export where you can export a post type. For now you can export a post type completely as csv which can be easily exported without even mapping. There are more features are to be added like filtered export, custom post type export etc. Please check our blog for latest news.

Can i schedule export? (Pro Only)

This is not in current version. Still in development pipeline. Instead you can contact us for customization.

How the export feature works? (Pro Only)

For now you cant filter the data to be exported. You can select a post type to export completely without filtering. But more flexibility will added to export feature in upcoming versions.

Is export feature available to all modules? (Pro Only)

No this feature not available to all modules. For Post, Page, e-commerce, woo-commerce, E-shop modules have export feature and other modules are to be added in future releases.

Check Pro Only Features FAQ here - WP Ultimate CSV Importer Pro FAQ

Common Issues

Why and What to do if my import broke in the middle?

This is common for large data import and badly formatted CSV in general. But in latest version 3.5 the import is handled in real time to avoid such time out issues. You should consider to look into the CSV file. Also check your log to import again from the broken point of import.

Cant get my featured image imported?, Why image import is broken?'

Feature images sgould be referred as complete URL path to the image file and should not return 404. If so you will get error on import. And also if you get Warning: fopen() [function.fopen], you should enable following option in your php.ini: allow_url_fopen.

I am getting time out error? how to solve it?

This may be because of max execution time or memory issue because of your php settings. You have to maximize your max execution time in php. Please refer here - http://stackoverflow.com/questions/16171132/how-to-increase-maximum-execution-time-in-php.

How to handle large data import?

Temporarily increase memory and max execution time in your php ini. Also you can try to split as 2-5 imports to avoid any time out issues.


Existing FAQ From Wordpress

1. How to install the csv importer plugin?

Refer - WP_Ultimate_CSV_Importer#Installations

2.How to use the plugin to import a csv file?

After plugin activation you can see the ' Wp Ultimate CSV Importer ' menu in admin backend.
1)Browse csv file to import the data's.
2)You can mapping the headers to import the data's.
3)If you checked the import as draft, it will import as draft then you can publish the data's later.
4)The data's are imported based on the post type you selected.
Configuring our plugin is as simple as that.


3. Why and What to do if my import broke in the middle?

Check your CSV format. It should be UTF-8. If you get memory related issue, change or create a custom php.ini with increased value for execution_time and memory limit.

4. Cant get my featured image imported?

Check the image url manually in browser. If you can see the image, check that allow_url_fopen is allowed in your php ini. If not, request your hosting or you can enable it in custom php ini settings.

5. How to import other languages using ultimate csv importer?

It should strictly UTF-8 format. Users have reported that utf-8 without BOM works well for languages like Polish characters etc. Follow these simple steps to import other languages. Thanks for the steps mojeprogramy.com.
1) Prepare a CSV file with the data (I used Excel)
2) Saving files to CSV (Excel function)
3) I opened the CSV file in Notepad + +
4) CTR + A, CTR + C (copy all the text)
5) The "Encoding"> "Encode without BOM"
6) CTR + V to paste all text
7) Save the file
8) Imports for WordPress ;)

6. How to Format a CSV file for simple sleek import using WP Ultimate CSV Importer Plugin?

This video helps you to tweak/format your CSV file to make a fast, simple and easy import using WP Ultimate CSV importer plugin without missing all the features. We have used MS Excel as CSV editor here. You can use other applications also. Take advantage of our importer format by slightly tweaking your csv.
http://www.youtube.com/watch?v=pnObJdiedus<
For more details visit www.smackcoders.com

7. How to create a well formatted csv for ultimate power import?- the other way to learn tweaking

We have used text editor here to explain how to create a well formatted csv in seconds for importing. You can use this format to take advantage of our importer format by slightly tweaking your csv. This video helps you to tweak/format your CSV file to make a fast, simple and easy import using WP Ultimate CSV importer plugin without missing all the features.
http://www.youtube.com/watch?v=9W_my0rSybE&lt

8. Where can i get sample files and other references?

We have a set of sample/template files for different purposes with supported plugin fields. All the sample/templates are auto mapping headers enabled which will almost removes manual mapping. [You can find updated news and links to download here] (http://blog.smackcoders.com/category/free-wordpress-plugins/wordpress-ultimate-csv-importer-plugin/). You can use these sample/template files to prepare your CSV to make your import just in few clicks

Post & Page
Post with All in SEO fields
Post with SEO by YOAST fields
Post with Advanced custom fields
Custom Posts for Custom post type UI plugin
Custom Posts for CCTM plugin
Custom Posts for Types plugin
Nested Category
Nested Category with category icons
Tags and Custom Taxonomies
Users with roles
Advanced eshop import
WP ecommerce import
WP ecommerce import with wp ecommerce custom fields,
Advanced Woo commerce import