Import CSV file, XML file, Text file and Zip file with WP Ultimate CSV Importer Pro 4.3

September 22, 2015

Newly added import file types:
WP Ultimate CSV importer Pro 4.3 supports XML file import, text file import and zip file import in addition to the CSV file import. The import procedure is same as that of the usual CSV import.

How to import file?
Import process includes the following steps:

1. Upload File
2. Template Page
3. Mapping Section
4. Summarize Page
5. Import Section
6. Log Section
7. Image Populate

STEP I: UPLOAD FILE

The plugin supports multiple types of file format import and schedule. The supported format is XML, zip, text and already existing CSV files. The initial step to import this file is to upload the required file. There are four different ways to load these files.
1. Required file can be loaded by browsing the file from computer, FTP, external link or server.
Upload File (from computer)
Click the “Browse” button to load the required file from the computer.
Drag and drop method can also be used instead of using Browse button.
drag and drop upload
Upload using FTP

To load using FTP provide the FTP details such as hostname, path, FTP username, FTP password and port number.
Sample value:
Hostname: smackcoders.com or 54.213.74.129
Path: /var/www/posts.csv or /var/www/posts.zip
FTP username: smackcoders
FTP password: smackpassword
Port number: 21 (by default it is 21)
Now click on “Download” button to download the file from FTP server.
ftp file upload

Upload from external link

To load from external link provide the URL path of the required file and then click “Download”.
Example: http://hostname/path/post.xml
Import from external URL

Choose file in the server

Select the required file from the directory list.

null
After loading the file, “Import” and “Update” button will be enabled.
After loading the file, to update the records with a previously created template, click on “Update” button. It is redirected to the template page(step II).
And to import the records click on “Import” button. It is redirected to the mapping section(step III).
To clear the page, click on “Reset” button.
STEP II : TEMPLATE PAGE

The template page consists of a list of already created templates. It enables to update the file with the existing templates.
1. The template page has filters and pagination to locate the template easily. It also consists of a reset button to clear the content entered in filter option.
2. There are to two types of filters. They are template name filter and specific period filter.
3. Pagination limits the number of templates to be displayed on each page and provides navigation with slide through all the pages.
4. Template table consists of a template name, loaded file name, module, created time and action.
5. The file is imported by using “Fresh Update” (or) “Update”
a) To import the file as if a fresh import without choosing any existing template, click on “Fresh Update” button.
b) To update the mapping field with the existing template in the list, click on “Update” button in the corresponding template name with which the file need to be updated.

null
6. Now it will be redirected to the mapping section.
STEP III: MAPPING SECTION

1. In mapping section, WP fields and headers of the imported module, custom fields and SEO fields are displayed in groups.
2. The basic fields are grouped under “Core Fields”, the default WordPress fields are grouped under default WP fields and other custom fields, the fields of supported plugin are grouped separately under each plugins name. The core custom fields and some custom fields created using the third party can be created in the mapping section by clicking ‘Add custom field’.

null

3. For example, if ACF plugin is activated, WP fields of ACF are displayed under ACF CUSTOM fields. ACF field enabled under Custom Taxonomy is a added feature in this version.
ACF field registration
4. If the WP fields and file headers are same then it will be auto-mapped, if not it should be mapped manually.
5. To map the WP fields with file headers manually, select any of file header from the drop down list.
6. The mandatory fields should be mapped and it cannot be left blank. Post title(post_title) is mandatory for all the module.
7. In WooCommerce variation, the Product ID and Parent SKU are mandatory. In WooCommerce orders, Order ID is mandatory. In WooCommerce coupons, Coupon ID is mandatory. In Woocommerce refunds, Refund ID is mandatory.
8. “Add Custom field” button in WordPress custom field, ACF custom field, Types custom field and Pods custom field enables to register new custom field on the flow of import.
9. To customize/replace the file value of WP fields given in the file(CSV, XML or text), select Header_manipulation in drop down and click the corresponding static/dynamic or formula icon and give the new value for the field.
10. Specify the static or dynamic/formula content of WP field name within curly braces ( {} ).
11. For static, providing {post_status}, the value of post_status will be assigned. Here multiple WP field name can be concatenated by plus(+). Example, {post_title}+{post_author}+{post_status}. The ‘ + ‘ symbol will create a space in between the content so need not give space manually.

null
12. In dynamic/formula, basic arithmetic operators such as +, -, *, /, % are supported. Specify the WP field name in curly brace( {} ) and separat by operators. Example, {product_quantity}/{product_discount}.

Overwrite CSV or XML value

13. To save the mappings as a template click on “Save this mapping as Template” and enter the name in which the template need to be saved.
14. If the template name is not provided, the template will be saved as CSV file name, date and current time stamp. For example: posts_2014-05-17 12:08:17

Mapping CSV or XML with WP fields

15. To update with the previously saved template, select “Update” in step I. It redirects to template page, select “Update” from the specific template name in step II.
16. It loads the mapping from selected template. The saved mapping fields are differentiated by enabling checkbox.
17. Even the selected template can be modified and saved. To update the template with new changes click on “Update”.
update template
18. To save changes as a new template, select “Save this mapping as Template”.

template saving
19. Click on “Next” button to proceed import.
XML mapping view:
The file headers drop down content is different from the CSV file import. The mapping headers are prefixed with post_xxx-items–>node–>
Sample:
i) For post title it is like post_title – items–>node–>post_title
ii) For post content it is like post_content – items–>node–>post_content

xml mapping

Text file mapping view:
The text file mapping view is same as that of the CSV file mapping view.

null

ZIP file view:
The zip file is a folder that contains a number of XML , CSV or text files and their view are same as that of the file imported.

STEP IV : SUMMARIZE PAGE

1. Summarize page lists the total number of records in the imported file.
2. It also displays all the mapped and unmapped WP fields of individual records and its headers in groups.
3. Verify the mapping and click “Proceed Import” to continue importing.

XML file summaryView

null
Text file summary view

Text file view

STEP V: IMPORT SECTION

1. To import the file directly into WordPress select “Import right away”.
2. To detect and skip duplicate content, enable detect duplicate post content and post title.

null

3. Provide number of posts/rows per server request based on system environment. By default, its value is 1.
4. To import specific records, enable “Import Specific Records Only”
5. To include shortcode inline image in post content of the file, select “Advance media handling” and upload the zip file with images.
6. Click on “Next” to import the file.

STEP VI: LOG SECTION

1. To go back to import section, click on “Back” button.
2. To import the file, click on “Import Now”. Now detailed Log is generated for each and every imported record.

null

STEP VII: IMAGE POPULATE
1. If the imported file contains shortcodes for the inline or featured image it must be populated to display the images.
2. To populate the image go to Managers -> Image shortcodes. The mode of shortcodes will be listed along with event key, module, no of shortcodes, status and action.
3. After uploading the image zip file in import section before populating the image, it shows pending status, Click on “Populate” button corresponding to the current event to include the inline and featured images in the imported posts.
4. If some images are missing in the uploaded zip file, it shows the status as partially. Upload the zip with correct images and click “continue” button to resume.

null

5. To upload the image zip file freshly, click on “Update” button. Then click on “Advanced Media Handling”. Browse corresponding zip file that contains inline and featured images then click “Upload” button and close it. Finally, click on “Populate” button.
image import
6. Once successfully completed, it shows the status as “Replaced”.

HOW TO SCHEDULE IMPORT

Schedule process includes the following steps:

1. Upload File
2. Template Page
3. Mapping Section
4. Summarize Page
5. Import Section

First four steps are common for both import and schedule import. Follow the steps as if import.
For scheduling, choose the template in step II or save your mapping as a template in step III. Without template file cannot be scheduled.

STEP V: IMPORT SECTION

1. To schedule the import, click on “schedule now”.
2. Provide schedule date, time and frequency.
3. Schedule frequency has options such as one time, daily, weekly, hourly and monthly. Choose the frequency as per the requirements.

null

4. Click on “Schedule” to schedule the import.
5. To view the scheduled list go to Managers -> Smart Schedule. The list of files to be scheduled is tabulated.

Note:
1. Image shortcode feature is not supported in scheduled import.