Ultimate CSV Importer - Version 5.6.2

Version Description

Download this release

Release Info

Developer smackcoders
Plugin Icon 128x128 Ultimate CSV Importer
Version 5.6.2
Comparing to
See all releases

Code changes from version 5.6.1 to 5.6.2

Files changed (4) hide show
  1. Readme.txt +154 -125
  2. admin/views/form-inform-export.php +52 -0
  3. includes/class-uci-helper.php +51 -9
  4. index.php +2 -2
Readme.txt CHANGED
@@ -1,95 +1,123 @@
1
- === Ultimate CSV Importer ===
2
  Contributors: smackcoders, smacksupport
3
- Donate link: https://www.paypal.me/smackcoders
4
- Tags: csv, csv import, csv importer, import, import csv, import seo, import woocommerce, acf, excel, spreadsheet
5
  Requires at least: 4.5
6
- Tested up to: 5.0.1
7
- Requires PHP: 5.2.4 or above
8
- Stable tag: 5.6.1
9
- Version: 5.6.1
10
  Author: smackcoders
11
  Author URI: http://profiles.wordpress.org/smackcoders/
 
 
12
  License: GPLv2 or later
13
  Simple, powerful and easy CSV Import plugin even for newbies and novice users.
14
 
 
 
15
  == Description ==
16
- Rated as one of the Top 500 plugins by [WPMETA.ORG](http://www.wpmeta.org/plugins/wp-ultimate-csv-importer/). The only well managed, supported and regularly updated importer plugin with great track record. Manage your WordPress content as simple as in a spreadsheet editor like Microsoft Excel or Openoffice, etc,.
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
17
 
18
- [Ultimate CSV Importer](https://www.smackcoders.com/wp-ultimate-csv-importer-pro.html?utm_source=web&utm_campaign=readme&utm_medium=wp_org) is an import tool that helps to build a WordPress site at the drop of a hat by importing Post, Page, Custom Post, Comments, [WordPress Custom Fields](https://www.smackcoders.com/blog/adding-custom-fields-data-wordpress-free-wp-ultimate-csv-importer.html?utm_source=web&utm_campaign=wp_org&utm_medium=readme) & [CustomPress fields](https://www.smackcoders.com/blog/custompress-import.html?utm_source=web&utm_campaign=wp_org&utm_medium=readme), Reviews of WP Customer Reviews and SEO fields of All in One SEO. The plugin supports import of all Custom Post Types.
19
 
20
- The image can be imported from external URL like Google image, pixabay, shutterstock, etc,. The images are imported in the background with the help of WP-CRON to enhance the performance. You can [easily configure your WP-Cron](https://www.smackcoders.com/blog/enable-configure-wp-cron.html?utm_source=web&utm_campaign=wp_org&utm_medium=readme) for faster import.
21
 
22
- Please show your support for CSV Importer by giving it a [rating](https://wordpress.org/support/view/plugin-reviews/wp-ultimate-csv-importer?rate=5#postform) :)
 
23
 
24
- = Modules supported in Import =
25
- * Core Modules - Post, Page, Custom Post, Comments.
26
- * Users - [Import Users](https://wordpress.org/plugins/import-users/) add-on to import your WordPress Users
27
- * Custom Post - CPT UI, CustomPress and default WordPress Custom Post.
28
- * Custom Field - WordPress default Text and Text area fields.
29
- * SEO field - Free version of All in One SEO.
30
- * Reviews - WP Customer Reviews
31
 
32
- = Highlighted Feature =
33
- * High performance rocket speed import.
34
- * Imports images from an external URLs mentioned in CSV files.
35
- * Import with enhanced duplicate handling to optimize your database.
36
- * Free add-on to [Import Users](https://wordpress.org/plugins/import-users/) to upload user info into WordPress
37
- * WordPress core custom fields can be dynamically registered on the flow of CSV import.
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
38
  * Post type import with terms & taxonomies with any of depth of parent-child values.
39
- * WP Ultimate CSV Importer can be used in WordPress multisite.
40
  * Post Type CSV import along with multi category & multi tag.
41
  * Import CSV with any delimiter in UTF-8 format can be imported.
42
- * Free export add-on to [export](https://wordpress.org/plugins/wp-ultimate-exporter/) all your WP content in CSV file.
43
 
44
- = Note =
45
- * Featured image from password protected image location can't be imported.
46
- * All languages supported by WordPress can be imported in UTF-8 without BOM format.
47
 
48
- [youtube https://www.youtube.com/watch?v=Uho22R0BCHQ&feature=youtu.be]
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
49
 
50
- = Ultimate CSV Importer PRO =
51
- CSV Importer PRO has all the features of WP Ultimate CSV Importer and it is extended with a lot of features that enables to import, schedule(recurring import), update and export CSV files. All import details over a year is in dashboard chart to easily track the WordPress site updates in a fraction of a second. Any changes like modifying existing WP content or appending new content can be done in simple update flow. WP Ultimate CSV Importer can also update or import the WP content from any CSV file periodically with scheduler. The update or Scheduled import (recurring import) is done with the templates which is created with mapped fields in the mapping section of WP Ultimate CSV importer. The export option enables to export the imported modules as CSV, XLS, XML and JSON based on the filters.
52
-
53
- Import of CSV involves few simple steps. Choose your CSV file to import. Map your CSV fields with WP fields with two different mapping Advanced Mode (Automap fields, if your CSV header same as that of WP header) or Drag & Drop Mode (More intuitive drag & drop mapping). Media Handling to optimize your image import. Finally, import all your CSV content in just a click inside your WordPress.
54
-
55
- = Supported Modules To Import and Export =
56
- * Core Module - Post, Page, Custom Post, Comments, Category, Tags, Users, Customer Reviews.
57
- * eCommerce Products - WooCommerce, MarketPress, WP e-Commerce & eShop.
58
- * SEO field - Free & Pro version of All in One SEO and Yoast SEO.
59
- * Multilingual - [WPML](https://www.youtube.com/watch?v=yvSPfvPp5s0&t=8s) & [qTranslate X](https://www.smackcoders.com/blog/import-marketpress-pro-event-manager-and-more.html?utm_source=web&utm_campaign=readme&utm_medium=wp_org)
60
- * Image - NextGEN Gallery
61
- * Events Management - Events Manager FREE & Pro
62
- * Custom fields - CustomPress, [ACF](https://youtu.be/RVoqPX3Ib94), [Toolset Types](https://www.smackcoders.com/documentation/ultimate-csv-importer-pro/toolset-types-import?utm_source=readme&utm_medium=wp_org), Pods, CCTM & WordPress default Text & Textarea fields.
63
- * Custom Post - CustomPress, Types, Pods, CPT UI, CCTM & default WordPress Custom Post.
64
-
65
- = Highlighted Feature of PRO =
66
- * CSV Import - WP Ultimate CSV Importer support the import of any CSV or XML file content into WordPress
67
- * Import from different location - WP Ultimate CSV Importer provides four different options (Desktop, FTP/ SFTP, URL and Server) to upload your CSV file.
68
- * Import image - Use the images from external URL in your CSV file and import all images inside WordPress along with the advanced SEO option to add alt text with WP Ultimate CSV Importer. You can also rename the featured image loaded from external URL.
69
- * More optimized import process - Advanced duplicate handling in WP Ultimate CSV Importer lets you to handle duplicates with any WP fields as primary field, and eliminate duplicate entries in WordPress.
70
- * Scheduled / Recurring Import - WP Ultimate CSV Importer can check for updates and run import periodically without any manual interaction.
71
- * Toolset Types Import - Import of any Toolset Types information in CSV into your WordPress with WP Ultimate CSV Importer. Lets you to import Toolset Types Custom fields, [Post Relation](https://youtu.be/jkkSG0DUnug), Intermediate post, Repeatable Field & [Repeater Field Group](https://youtu.be/qKPwv3Pc7tw).
72
- * Multilingual import - Easy to run multilingual website with WP Ultimate CSV Importer with the support for the import of WPML & qTranslate X add-on.
73
- * WP Ultimate CSV Importer supports WooCommerce product import along with 6 WooCommerce add-on.
74
- * Import products of MarketPress Lite & PRO version add-on.
75
- * Registers Custom Fields of ACF (FREE & Pro), Types, Pods and WordPress fields in the flow of import.
76
- * All imported modules are managed in the Importer File manager.
77
- * Complete import history i.e. detailed logs are maintained in the Log manager.
78
- * Import all the supported features of CSV Importer plugin with [Rest API](https://www.smackcoders.com/document/wp-ultimate-csv-importer-rest-api.html?utm_source=web&utm_campaign=readme&utm_medium=wp_org).
79
- * Extendable for your needs with [API](https://www.smackcoders.com/document/docs/api/classes/SmackUCI_API.html?utm_source=web&utm_campaign=readme&utm_medium=wp_org).
80
-
81
- = Helpful Links =
82
- [Documentation](https://www.smackcoders.com/documentation/ultimate-csv-importer-pro/how-to-import-csv?utm_source=web&utm_campaign=readme&utm_medium=wp_org).
83
-
84
- You can try the [live demo](https://demo.smackcoders.com/wordpress/wp-admin/admin.php?page=sm-uci-dashboard) or request for free trial by clicking Try Now in [WordPress Ultimate CSV Importer](https://www.smackcoders.com/wp-ultimate-csv-importer-pro.html?utm_source=web&utm_campaign=readme&utm_medium=wp_org) page to generate your own WordPress test environment.
85
-
86
- Read our [blog](https://www.smackcoders.com/blog/category/wordpress?utm_source=web&utm_medium=wp_org&utm_campaign=readme) to know more about the new [features](https://www.smackcoders.com/wp-ultimate-csv-importer-pro.html?utm_source=web&utm_campaign=readme&utm_medium=wp_org) of our WordPress plugins.
87
-
88
- [FAQ](https://www.smackcoders.com/wordpress-products-faq.html?utm_source=web&utm_campaign=readme&utm_medium=wp_org) and [Troubleshooting tips](https://wordpress.org/support/topic/tips-to-trouble-shoot-wp-ultimate-csv-importer-issues-1)
89
-
90
- == Installation ==
91
- 1. Extract the wp-ultimate-csv-importer.zip in wordpress/wp-content/plugins using FTP or with plugin install in wp-admin.
92
- 2. Activate the plugin in WordPress plugin list.
93
 
94
  == Screenshots ==
95
  1. Dashboard view of the importer.
@@ -101,37 +129,36 @@ Read our [blog](https://www.smackcoders.com/blog/category/wordpress?utm_source=w
101
  7. Downloadable log manager for all imported events.
102
 
103
  == Frequently Asked Questions ==
104
- = Common Issues =
105
- 1. What are reasons for my import to break?<br />
106
- Import may hang due to the following reasons<br />
107
- * CSV not properly validated.<br />
108
- * CSV not properly encoded to UTF-8.<br />
109
- * System Requirements are not matched the required values.<br />
110
 
111
- 2. How to validate a CSV? <br />
112
- CSV Importer plugin allows you to import CSVs that are validated. So kindly validate your CSV using [CSV Lint](https://csvlint.io/). Your CSV may have any escape characters and misplaced skip characters which may cause the import to cease.<br />
113
 
114
- 3. What are the supported CSV Formats? <br />
115
- Wordpress CSV Importer plugin recognizes only the UTF-8 encoded characters. You can check on the UTF-8 encode with CSV Lint. Any chance if you are using Excel, we recommend you to use Google Sheets. Excel will miss some characters to be encoded to proper UTF-8.<br />
116
 
117
- 4. What are the Minimum Requirements needed to upload CSV? <br />
118
- Basic System Requirements need to be met to upload a CSV with bulk of records. Kindly check your System Requirements by Settings → Security and Performance on CSV Importer plugin settings tab. You have to increase the system requirements values to the minimum values mentioned in the plugin. <br />
119
 
120
- 5. Why my featured images not getting uploaded? <br />
121
- The importer uploads images in the background for faster performance and it requires WP-Cron to be enabled. You can [easily configure WP-Cron](https://www.smackcoders.com/blog/enable-configure-wp-cron.html?utm_source=wp_org&utm_campaign=readme&utm_medium=faq) for smooth and speedy import. <br />
122
 
123
- 6. What are the supported custom fields in FREE version? <br />
124
- The importer supports [default WordPress Text and Text area fields](https://www.smackcoders.com/blog/adding-custom-fields-data-wordpress-free-wp-ultimate-csv-importer.html?utm_source=wordpress_org&utm_campaign=readme&utm_medium=faq). You can also import the Text & Text area fields created with custom codes in WordPress standards.
125
 
126
- For more FAQ, you can refer [here](https://www.smackcoders.com/wordpress-products-faq.html?utm_source=wp_org&utm_campaign=readme&utm_medium=faq).
 
 
 
127
 
128
  == Changelog ==
129
- =5.6.1=
 
 
130
  * Added: WP CSRF Protection
131
- =5.6=
132
  * Added: Compatibility for WordPress 5.0
133
  = 5.3.7 =
134
- * Removed: Registering custom field in Mapping section.
135
  = 5.3.6 =
136
  * Added: Compatibility for WordPress 4.9.8
137
  * Added: Import Post parent import with Post Title
@@ -154,21 +181,21 @@ For more FAQ, you can refer [here](https://www.smackcoders.com/wordpress-product
154
  * Moved: User import as add-on.
155
  * Removed: Export
156
  = 5.3.1 =
157
- * Modified: Hide the filter based on Condition.
158
- * Fixed: data loss when page refresh (export).
159
- * Fixed: warning during Upload.
160
- * Fixed: user export above 1000 records.
161
- * Fixed: Custom Field Suite issue.
162
- * Fixed: Forced quotes issue.
163
  = 5.3 =
164
- * Added: Prevent loss of Mapping data
165
  * Added: Custom field group plugin support
166
  * Added: Maintenance mode
167
  * Added: Inclusion feature
168
  * Updated: Exclude selection as include selection in export module
169
  * Fixed: User import
170
  * Fixed: Delimiter issue
171
- * Fixed: Advance Mapping issues
172
  * Fixed: Post status in Mapping
173
  * Fixed: Featured image in Mapping
174
  * Fixed: Post comment in Mapping
@@ -176,11 +203,11 @@ For more FAQ, you can refer [here](https://www.smackcoders.com/wordpress-product
176
  * Fixed: Comment Export
177
  * Fixed: Text changes
178
  = 5.2 =
179
- * Added: Advance mapping view with Drag ‘n’ Drop support.
180
  * Added: Ultimate member plugin support for Users Import.
181
  * Fixed: Issue with Post format.
182
  * Fixed: Month order in dashboard charts.
183
- * Added: Latest version support on All In One SEO 2.3.12.1.
184
  * Added: Compatibility for WordPress 4.7.3.
185
  = 5.1.1 =
186
  * Fixed: Broken when SCRIPT_DEBUG is true. [Solved](https://wordpress.org/support/topic/broken-when-script_debug-is-true/).
@@ -189,8 +216,8 @@ For more FAQ, you can refer [here](https://www.smackcoders.com/wordpress-product
189
  * Removed: Unwanted console warnings.
190
  * Added: Compatibility for WordPress 4.7.2.
191
  = 5.1 =
192
- * Added: Language Support for German, French, Italian, Spanish, Dutch & Russian.
193
- * Added: Restriction to show “Admin dashboard widget” only for users with Admin role. [Solved](https://wordpress.org/support/topic/admin-dashboard-widget-is-showing-to-all-users)
194
  * Added: Notice to [enable wp-cron](https://www.smackcoders.com/blog/enable-configure-wp-cron.html?utm_source=wp_org&utm_campaign=readme&utm_medium=change_log) to populate the feature images. [Solved](https://wordpress.org/support/topic/version-5-03-issues).
195
  * Added: Warning messages to notify when uploads directory is missing, insufficient permission to access and uploaded file size exceeds your server limits.
196
  * Added: Duplicate handling feature to skip the duplicate records.
@@ -216,11 +243,11 @@ For more FAQ, you can refer [here](https://www.smackcoders.com/wordpress-product
216
  = 5.0 =
217
  * Added: Compatibility for WordPress 4.7 and PHP 7.
218
  * Added: Option to replace imported CSV file value with static and dynamic value.
219
- * Added: Image image import from external URL
220
  * Added: Send email to newly imported User with Password Information
221
  * Added: Any Custom Post Type import.
222
  * Added: Post Type import with terms & taxonomies with any depth of parent-child hierarchy.
223
- * Improved: High speed import with enhanced UI.
224
  * Improved: User role import with capability value or role name in CSV
225
  = 3.11.1 =
226
  * Fixed: Browse button disappears in 3.11.0 https://wordpress.org/support/topic/browse-button-disappears-in-3110
@@ -247,7 +274,7 @@ For more FAQ, you can refer [here](https://www.smackcoders.com/wordpress-product
247
  * Fixed: jQuery conflicts.
248
  = 3.9 =
249
  * Added: PHP 7 compatibility.
250
- * Added: Support for all post date formats.
251
  * Fixed: Featured image and Inline image naming issues.
252
  * Fixed: Auto mapping issues in Custom Fields and SEO Fields.
253
  = 3.8.8 =
@@ -263,7 +290,7 @@ For more FAQ, you can refer [here](https://www.smackcoders.com/wordpress-product
263
  = 3.8.6 =
264
  * Added: Compatibility for WordPress 4.4.
265
  * Modified: Support page UI.
266
- * Fixed: Post date issue.
267
  * Fixed: Custom Post Type listing issue.
268
  = 3.8.5 =
269
  * Added: Restriction to view the image without password for protected status content.
@@ -293,7 +320,7 @@ For more FAQ, you can refer [here](https://www.smackcoders.com/wordpress-product
293
  * Removed : Direct usage of wp-content.
294
  = 3.8 =
295
  * Added : Multi language support (fr_FR,es_ES,nl_NL).
296
- * Added : Inline image handling with shortcode along with image attributes.
297
  * Added: Any delimiter support for CSV export.
298
  * Fixed: Warnings and bugs Fixes
299
  = 3.7.4 =
@@ -334,7 +361,7 @@ For more FAQ, you can refer [here](https://www.smackcoders.com/wordpress-product
334
  * Added: https format support for all WP instances.
335
  * Added: Warning to guide user to create uploads directory with writable permissions.
336
  * Improved: Security and performance tab under settings module.
337
- * Fixed: Featured image handling issues.
338
  * Fixed: Multisite compatibility issue.
339
  * Fixed: All console warnings.
340
  * Removed: Post Content field mandatory option.
@@ -347,11 +374,11 @@ For more FAQ, you can refer [here](https://www.smackcoders.com/wordpress-product
347
  * Added: Export features for all missing modules.
348
  * Fixed: All console warnings and reported logs.
349
  = 3.6.6 =
350
- * Fixed: Dashboard chart issue in multi site.
351
  * Modified: UI to improve usability.
352
  * Fixed: Groups plugin conflicts.
353
  = 3.6.5 =
354
- * Added : Inline image support with advanced media handling.
355
  * Added: PDO check.
356
  = 3.6.4 =
357
  * Added: WordPress 4.0 compatibility.
@@ -392,7 +419,7 @@ For more FAQ, you can refer [here](https://www.smackcoders.com/wordpress-product
392
  * Import posts with author names as numerical apart from User ID
393
  * Added: menu_order attribute import
394
  * Added: Auto image rename option
395
- * Option to cancel an partial import at middle
396
  * Improved image handling even special characters in URL
397
  * Import can handle image URLs without any extensions
398
  * User reported bugs fixed
@@ -445,13 +472,13 @@ For more FAQ, you can refer [here](https://www.smackcoders.com/wordpress-product
445
  * Fixed: Image URL for featured image issues fixed
446
  * Fixed: PHP 5.4 upgrade fix
447
  = 3.0.0 =
448
- * Added: Category in numerics are restricted and skipped to Uncategorized
449
  * Added: Protected status password inclusion as {password}.
450
  * Added: Post authors can be User ID or name
451
  * Improved: Much improved workflow
452
  * Improved: Add custom field option improved.
453
  * Improved: Date format handling improved
454
- * Improved: Any Date format is supported now
455
  * Improved: Future scheduling and status improved
456
  * Improved: Can apply post status for individual post via CSV itself
457
  * Improved: Featured image handling improved and fixed. More improvement are scheduled.
@@ -495,13 +522,15 @@ For more FAQ, you can refer [here](https://www.smackcoders.com/wordpress-product
495
  * Added featured image import feature along with post/page/custom post.
496
  = 1.0.2 =
497
  * Bug fixed to recognize the trimmed trailing space in the CSV file
498
- * Added validation for the duplicate field mapping.
499
  = 1.0.1 =
500
  * Added features to import multiple tags and categories with different delimiters.
501
  = 1.0.0 =
502
  * Initial release version. Tested and found works well without any issues.
503
 
504
  == Upgrade Notice ==
 
 
505
  = 5.6.1 =
506
  * Important update for security fixes.
507
  = 5.6 =
@@ -527,7 +556,7 @@ For more FAQ, you can refer [here](https://www.smackcoders.com/wordpress-product
527
  = 5.1.1 =
528
  * Upgrade now to get the fix for duplicate handling feature.
529
  = 5.1 =
530
- * Upgrade now for 6 language support, duplicate handling and more.
531
  = 5.0.3 =
532
  * Upgrade now for Chinese character support and a fix for category import.
533
  = 5.0.2 =
@@ -535,7 +564,7 @@ For more FAQ, you can refer [here](https://www.smackcoders.com/wordpress-product
535
  = 5.0.1 =
536
  * Upgrade now to get the fix for WP Customer Review add-on support.
537
  = 5.0 =
538
- * Upgrade now for high speed import, WP Customer Review add-on support, WordPress 4.7 Compatibility and much more.
539
  = 3.11.0 =
540
  * Upgrade now for WordPress 4.5.3 and WooCommerce 4.3.1 compatibility and other minor enhancements.
541
  = 3.10.0 =
@@ -545,7 +574,7 @@ For more FAQ, you can refer [here](https://www.smackcoders.com/wordpress-product
545
  = 3.9.3 =
546
  * Upgrade now to get support for custom port id in MAMP environment and WordPress 4.5 compatibility.
547
  = 3.9.2 =
548
- * Upgrade now to get high speed robust parser.
549
  = 3.9.1 =
550
  * Upgrade now for import post parent with post name and post title.
551
  = 3.9 =
@@ -559,7 +588,7 @@ For more FAQ, you can refer [here](https://www.smackcoders.com/wordpress-product
559
  = 3.8.4 =
560
  * Upgrade now for new dashboard view.
561
  = 3.8.3 =
562
- * Upgrade now for improvements in multi language translation.
563
  = 3.8.2 =
564
  * Upgrade now for more improvements.
565
  = 3.8.1 =
@@ -623,7 +652,7 @@ For more FAQ, you can refer [here](https://www.smackcoders.com/wordpress-product
623
  = 3.3.1 =
624
  * Upgrade now for multisite compatibility.
625
  = 3.3.0 =
626
- * Upgrade now for WP 3.8 compatibility and added bulk user,comments feature.
627
  = 3.2.3 =
628
  * WordPress 3.7.1 compatibility and minor bug fixes
629
  = 3.2.2 =
@@ -647,7 +676,7 @@ For more FAQ, you can refer [here](https://www.smackcoders.com/wordpress-product
647
  = 2.0.1 =
648
  * WordPress-3.5 compatibility.
649
  = 2.0.0 =
650
- * Major Bug fix and need to be upgraded.
651
  * WPDEBUG error fixed.
652
  * CSV import folder changed to WP native uploads folder.
653
  = 1.1.1 =
@@ -655,8 +684,8 @@ For more FAQ, you can refer [here](https://www.smackcoders.com/wordpress-product
655
  = 1.1.0 =
656
  * Major feature added.
657
  = 1.0.2 =
658
- * Bug fixes along with new features. Need to be upgraded immediately.
659
  = 1.0.1 =
660
  * Added features to import multiple tags and categories with different delimiters.
661
  = 1.0.0 =
662
- * Initial release of plugin.
1
+ === Import Export Post as CSV File===
2
  Contributors: smackcoders, smacksupport
 
 
3
  Requires at least: 4.5
4
+ Tested up to: 5.2.2
5
+ Stable tag: 5.6.2
6
+ Version: 5.6.2
7
+ Requires PHP: 5.2.4
8
  Author: smackcoders
9
  Author URI: http://profiles.wordpress.org/smackcoders/
10
+ Donate link: https://www.paypal.me/smackcoders
11
+ Tags: csv, csv import, csv importer, import, import csv, import seo, import woocommerce, acf, excel, spreadsheet
12
  License: GPLv2 or later
13
  Simple, powerful and easy CSV Import plugin even for newbies and novice users.
14
 
15
+ A powerful plugin that fits for all your CSV Import and export needs.
16
+
17
  == Description ==
18
+ Ultimate CSV Importer provides all the necessary Import and Export features in one bundle with simplified steps to follow.
19
+
20
+ How to import data to your WordPress?
21
+
22
+ There are 3 simple steps to follow,
23
+
24
+ 1. Upload your CSV/XML file.
25
+ 2. Relate or map your CSV fields with WP fields using drag and drop or simple left/right pick list method.
26
+ 3. Click import once done.
27
+
28
+ [youtube https://www.youtube.com/watch?v=Uho22R0BCHQ&feature=youtu.be]
29
+
30
+ There are more features bundled to make even complicated post data import simplified.
31
+
32
+ = 1.Upload your CSV =
33
+
34
+ * Upload your CSV file from different sources like desktop, FTP/SFTP, remote URLs or a location from your host server.
35
+ * CSV, Zip, txt and XMl data (pro) file types supported.
36
+ * Once uploaded, choose New items if you want to import as new posts.
37
+ * Choose existing option in case to import the data to update or replace existing posts records.
38
+ * Pick a post type like Post, Page, Custom Post, Comments or any other from the drop down.
39
+ * This is under which post type your data get imported.
40
+ * It can be a complete post content replacement or partial update like selected set of fields for each post in CSV.
41
+ * Click continue button.
42
 
43
+ = 2.Relate or map your CSV fields to WP fields =
44
 
45
+ In mapping section, CSV Importer plugin allows you to relate the uploaded data set against WordPress fields. There are two methods available to relate your data set.
46
 
47
+ * A simple left and right drop downs that allows you to map CSV field with the related WordPress fields.
48
+ * You can choose each field from left side and assign a field from right to where it should go.
49
 
50
+ = Drag 'n' Drop method =
 
 
 
 
 
 
51
 
52
+ * You can visually drag field by field from the right side bar and drop it to post create view like place holder.
53
+ * For e.g. you can drag title filed and drop it under post title box.
54
+ * To make it easier you can see both field label and sample record in side bar, which allows you to understand how data placed.
55
+ * In top side bar header, you can rotate this sample records by choosing a row item no. in case the default sample data is not helpful.
56
+
57
+ = 3. Click Import =
58
+
59
+ * Once the mapping completed, click import to start the import process.
60
+ * In import view, you can pause and resume the import process.
61
+ * A section shows post count and status of successful imports with a timer.
62
+ * A log section shows you detailed real time log of the process step by step.
63
+ * Log is downloadable using the link provided.
64
+
65
+ = What can you import in WordPress =
66
+ Core Modules – Post, Page, Custom Post, Comments.
67
+ Users – Import Users add-on to import your WordPress Users
68
+ Custom Post – CPT UI, Custom Press and default WordPress Custom Post.
69
+ Custom Field – WordPress default Text and Text area fields.
70
+ SEO field – Free version of All in One SEO.
71
+ Reviews – WP Customer Reviews
72
+
73
+ = Highlights =
74
+ * High performance, much comparable & much faster than all the other available plugins.
75
+ * Can handle 1000s of records on the fly.
76
+ * Supports WordPress Custom Fields, Custom Press fields, WP Customer Reviews and All in One SEO fields.
77
+ * Media images from any external URL like Google Images, pixabay, shutterstock, or any domain you own can be imported.
78
+ * Image import processed from the background using WP-CRON to improve the performance.
79
+ * Import with duplicate handling for optimized database.
80
+ * Free add-on to Import Users <link> to upload user info into WordPress.
81
+ * WordPress core custom fields registered dynamically on the flow of CSV import.
82
  * Post type import with terms & taxonomies with any of depth of parent-child values.
83
+ * WordPress multisite import supported.
84
  * Post Type CSV import along with multi category & multi tag.
85
  * Import CSV with any delimiter in UTF-8 format can be imported.
86
+ * Free export add-on to export <link> all your WP content in CSV file.
87
 
88
+ = Important Notes =
89
+ * Featured image import from any publicly accessible external URL.
90
+ * All languages supported by WordPress imported in UTF-8 without BOM format.
91
 
92
+ = Other useful tools =
93
+ * Dashboard
94
+ * General settings >> Scheduled log emails, send password in users get imported etc.
95
+ * Database optimization
96
+ * Security and performance monitoring
97
+ * Manager >>File manager, log manager
98
+ * Support >> Documentation
99
+
100
+ = Premium Features =
101
+ * CSV and XML import
102
+ * Reusable Mapping Templates with Template manager
103
+ * Smart Schedule/Recurring Import to run import periodically without any manual interaction.
104
+ * Toolset Types Import – Custom fields, Post Relation, Intermediate post, Repeatable Field & Repeater Field Group support
105
+ * Multilingual import – support for the import of WPML & qTranslate X add-on
106
+ * WooCommerce product import along with six WooCommerce add-on
107
+ * Handles Custom Fields of ACF (FREE & Pro), Types, Pods and WordPress fields with the flow of import
108
+ * Import history i.e. detailed log maintained in the Log manager.
109
+ * Import all the supported features with Rest API.
110
+ * Extendable for your needs with API.
111
 
112
+
113
+ = HELPFUL LINKS =
114
+ [Documentation](https://www.smackcoders.com/documentation/ultimate-csv-importer-pro/how-to-import-csv?utm_source=web&utm_campaign=readme&utm_medium=wp_org)
115
+
116
+ [Try our live demo here](https://demo.smackcoders.com/wordpress/wp-admin/admin.php?page=sm-uci-dashboard)
117
+
118
+ [Request a free trial by visiting here](https://www.smackcoders.com/wp-ultimate-csv-importer-pro.html?utm_source=web&utm_campaign=readme&utm_medium=wp_org) and Click Try Now option to generate your own WordPress test environment.
119
+
120
+ [For samples and tutorials visit our blog](https://www.smackcoders.com/blog.html?utm_source=wp.org&utm_medium=plugin&utm_campaign=readme)
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
121
 
122
  == Screenshots ==
123
  1. Dashboard view of the importer.
129
  7. Downloadable log manager for all imported events.
130
 
131
  == Frequently Asked Questions ==
 
 
 
 
 
 
132
 
133
+ * What is a csv file?
134
+ A csv or comma separated value file is a simple text based file format to store tabular data. In general, a character like a comma used as a separator between commas separated values as tables.
135
 
136
+ * How to open or edit csv file?
137
+ A csv file could be edited in any program like notepad or notepad+. However, a spreadsheet editor like MS Office, Open Office Calc is more useful to directly edit as tabled structure.
138
 
139
+ * What are the types of CSV files?
140
+ Most common type is csv or comma separated value file. The other one is delimited file where a character like a tab or a semicolon used instead of comma as a delimiter.
141
 
142
+ * What is csv file format?
143
+ There are different file formats available based on encode like ANSI, UTF-8, UTF-8 without BOM, USC-2 BE BOM and USC-2 LE BOM. For WordPress, the default format will be UTF-8 and for non-Latin character data, UTF-8 without BOM used.
144
 
145
+ * How to validate a CSV?
146
+ You can validate a csv file using [CSV Lint](https://csvlint.io/). Your CSV may miss escaping characters and misplaced/skipped character, which may cause the import to cease. Validate any csv file for issues or warning and fix them before importing it to WordPress.
147
 
148
+ * How to import content to WordPress?
149
+ Import to WordPress done in different methods based on content source type, platform, and file types. The most common types of imports are XML, CSV and DB files.
150
+ 1. Xml method needs advanced knowledge to edit/update them in case of any changes required on source data. Otherwise, users are limited to do import without any changes to source file. Hence, editing done post by post in WordPress only possible after import.
151
+ 2. CSV methods allow any users with basic excel or any spreadsheet knowledge can audit, change, edit or update the data visually in bulk before importing. So painful manual works avoided and time saved. Also, CSV file is the most preferred method for any offline programs.
152
 
153
  == Changelog ==
154
+ = 5.6.2 =
155
+ * Added: support for remote url without extensions
156
+ = 5.6.1 =
157
  * Added: WP CSRF Protection
158
+ = 5.6 =
159
  * Added: Compatibility for WordPress 5.0
160
  = 5.3.7 =
161
+ * Removed: Registering custom field in mapping section.
162
  = 5.3.6 =
163
  * Added: Compatibility for WordPress 4.9.8
164
  * Added: Import Post parent import with Post Title
181
  * Moved: User import as add-on.
182
  * Removed: Export
183
  = 5.3.1 =
184
+ * Modified: Hide the filter based on Condition.
185
+ * Fixed: data loss when page refresh (export).
186
+ * Fixed: warning during Upload.
187
+ * Fixed: user export above 1000 records.
188
+ * Fixed: Custom Field Suite issue.
189
+ * Fixed: Forced quotes issue.
190
  = 5.3 =
191
+ * Added: Prevent loss of mapping data
192
  * Added: Custom field group plugin support
193
  * Added: Maintenance mode
194
  * Added: Inclusion feature
195
  * Updated: Exclude selection as include selection in export module
196
  * Fixed: User import
197
  * Fixed: Delimiter issue
198
+ * Fixed: Advance mapping issues
199
  * Fixed: Post status in Mapping
200
  * Fixed: Featured image in Mapping
201
  * Fixed: Post comment in Mapping
203
  * Fixed: Comment Export
204
  * Fixed: Text changes
205
  = 5.2 =
206
+ * Added: Advance mapping view with Drag and Drop support.
207
  * Added: Ultimate member plugin support for Users Import.
208
  * Fixed: Issue with Post format.
209
  * Fixed: Month order in dashboard charts.
210
+ * Added: Latest version support on All in One SEO 2.3.12.1.
211
  * Added: Compatibility for WordPress 4.7.3.
212
  = 5.1.1 =
213
  * Fixed: Broken when SCRIPT_DEBUG is true. [Solved](https://wordpress.org/support/topic/broken-when-script_debug-is-true/).
216
  * Removed: Unwanted console warnings.
217
  * Added: Compatibility for WordPress 4.7.2.
218
  = 5.1 =
219
+ * Added: Language Support for German, French, Italian, Spanish, and Dutch & Russian.
220
+ * Added: Restriction to show Admin dashboard widget only for users with Admin role. [Solved](https://wordpress.org/support/topic/admin-dashboard-widget-is-showing-to-all-users)
221
  * Added: Notice to [enable wp-cron](https://www.smackcoders.com/blog/enable-configure-wp-cron.html?utm_source=wp_org&utm_campaign=readme&utm_medium=change_log) to populate the feature images. [Solved](https://wordpress.org/support/topic/version-5-03-issues).
222
  * Added: Warning messages to notify when uploads directory is missing, insufficient permission to access and uploaded file size exceeds your server limits.
223
  * Added: Duplicate handling feature to skip the duplicate records.
243
  = 5.0 =
244
  * Added: Compatibility for WordPress 4.7 and PHP 7.
245
  * Added: Option to replace imported CSV file value with static and dynamic value.
246
+ * Added: Image import from external URL
247
  * Added: Send email to newly imported User with Password Information
248
  * Added: Any Custom Post Type import.
249
  * Added: Post Type import with terms & taxonomies with any depth of parent-child hierarchy.
250
+ * Improved: High-speed import with enhanced UI.
251
  * Improved: User role import with capability value or role name in CSV
252
  = 3.11.1 =
253
  * Fixed: Browse button disappears in 3.11.0 https://wordpress.org/support/topic/browse-button-disappears-in-3110
274
  * Fixed: jQuery conflicts.
275
  = 3.9 =
276
  * Added: PHP 7 compatibility.
277
+ * Added: Support for all postdate formats.
278
  * Fixed: Featured image and Inline image naming issues.
279
  * Fixed: Auto mapping issues in Custom Fields and SEO Fields.
280
  = 3.8.8 =
290
  = 3.8.6 =
291
  * Added: Compatibility for WordPress 4.4.
292
  * Modified: Support page UI.
293
+ * Fixed: Postdate issue.
294
  * Fixed: Custom Post Type listing issue.
295
  = 3.8.5 =
296
  * Added: Restriction to view the image without password for protected status content.
320
  * Removed : Direct usage of wp-content.
321
  = 3.8 =
322
  * Added : Multi language support (fr_FR,es_ES,nl_NL).
323
+ * Added : Inline image handling with short code along with image attributes.
324
  * Added: Any delimiter support for CSV export.
325
  * Fixed: Warnings and bugs Fixes
326
  = 3.7.4 =
361
  * Added: https format support for all WP instances.
362
  * Added: Warning to guide user to create uploads directory with writable permissions.
363
  * Improved: Security and performance tab under settings module.
364
+ * Fixed: Featured image-handling issues.
365
  * Fixed: Multisite compatibility issue.
366
  * Fixed: All console warnings.
367
  * Removed: Post Content field mandatory option.
374
  * Added: Export features for all missing modules.
375
  * Fixed: All console warnings and reported logs.
376
  = 3.6.6 =
377
+ * Fixed: Dashboard chart issue in multisite.
378
  * Modified: UI to improve usability.
379
  * Fixed: Groups plugin conflicts.
380
  = 3.6.5 =
381
+ * Added: Inline image support with advanced media handling.
382
  * Added: PDO check.
383
  = 3.6.4 =
384
  * Added: WordPress 4.0 compatibility.
419
  * Import posts with author names as numerical apart from User ID
420
  * Added: menu_order attribute import
421
  * Added: Auto image rename option
422
+ * Option to cancel any partial import at middle
423
  * Improved image handling even special characters in URL
424
  * Import can handle image URLs without any extensions
425
  * User reported bugs fixed
472
  * Fixed: Image URL for featured image issues fixed
473
  * Fixed: PHP 5.4 upgrade fix
474
  = 3.0.0 =
475
+ * Added: Category in numeric are restricted and skipped to Uncategorized
476
  * Added: Protected status password inclusion as {password}.
477
  * Added: Post authors can be User ID or name
478
  * Improved: Much improved workflow
479
  * Improved: Add custom field option improved.
480
  * Improved: Date format handling improved
481
+ * Improved: Any Date format supported now
482
  * Improved: Future scheduling and status improved
483
  * Improved: Can apply post status for individual post via CSV itself
484
  * Improved: Featured image handling improved and fixed. More improvement are scheduled.
522
  * Added featured image import feature along with post/page/custom post.
523
  = 1.0.2 =
524
  * Bug fixed to recognize the trimmed trailing space in the CSV file
525
+ * Added validation for the duplicate field mapping.
526
  = 1.0.1 =
527
  * Added features to import multiple tags and categories with different delimiters.
528
  = 1.0.0 =
529
  * Initial release version. Tested and found works well without any issues.
530
 
531
  == Upgrade Notice ==
532
+ = 5.6.2 =
533
+ * Update for improve image import.
534
  = 5.6.1 =
535
  * Important update for security fixes.
536
  = 5.6 =
556
  = 5.1.1 =
557
  * Upgrade now to get the fix for duplicate handling feature.
558
  = 5.1 =
559
+ * Upgrade now for six language support, duplicate handling and more.
560
  = 5.0.3 =
561
  * Upgrade now for Chinese character support and a fix for category import.
562
  = 5.0.2 =
564
  = 5.0.1 =
565
  * Upgrade now to get the fix for WP Customer Review add-on support.
566
  = 5.0 =
567
+ * Upgrade now for high-speed import, WP Customer Review add-on support, WordPress 4.7 Compatibility and much more.
568
  = 3.11.0 =
569
  * Upgrade now for WordPress 4.5.3 and WooCommerce 4.3.1 compatibility and other minor enhancements.
570
  = 3.10.0 =
574
  = 3.9.3 =
575
  * Upgrade now to get support for custom port id in MAMP environment and WordPress 4.5 compatibility.
576
  = 3.9.2 =
577
+ * Upgrade now to get high-speed robust parser.
578
  = 3.9.1 =
579
  * Upgrade now for import post parent with post name and post title.
580
  = 3.9 =
588
  = 3.8.4 =
589
  * Upgrade now for new dashboard view.
590
  = 3.8.3 =
591
+ * Upgrade now for improvements in multi-language translation.
592
  = 3.8.2 =
593
  * Upgrade now for more improvements.
594
  = 3.8.1 =
652
  = 3.3.1 =
653
  * Upgrade now for multisite compatibility.
654
  = 3.3.0 =
655
+ * Upgrade now for WP 3.8 compatibility and added bulk user, comments feature.
656
  = 3.2.3 =
657
  * WordPress 3.7.1 compatibility and minor bug fixes
658
  = 3.2.2 =
676
  = 2.0.1 =
677
  * WordPress-3.5 compatibility.
678
  = 2.0.0 =
679
+ * Major Bug fix and need to upgraded.
680
  * WPDEBUG error fixed.
681
  * CSV import folder changed to WP native uploads folder.
682
  = 1.1.1 =
684
  = 1.1.0 =
685
  * Major feature added.
686
  = 1.0.2 =
687
+ * Bug fixes along with new features. Need to upgraded immediately.
688
  = 1.0.1 =
689
  * Added features to import multiple tags and categories with different delimiters.
690
  = 1.0.0 =
691
+ * Initial release of plugin.
admin/views/form-inform-export.php ADDED
@@ -0,0 +1,52 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+ /*********************************************************************************
3
+ * WP Ultimate CSV Importer is a Tool for importing CSV for the Wordpress
4
+ * plugin developed by Smackcoders. Copyright (C) 2016 Smackcoders.
5
+ *
6
+ * WP Ultimate CSV Importer is free software; you can redistribute it and/or
7
+ * modify it under the terms of the GNU Affero General Public License version 3
8
+ * as published by the Free Software Foundation with the addition of the
9
+ * following permission added to Section 15 as permitted in Section 7(a): FOR
10
+ * ANY PART OF THE COVERED WORK IN WHICH THE COPYRIGHT IS OWNED BY WP Ultimate
11
+ * CSV Importer, WP Ultimate CSV Importer DISCLAIMS THE WARRANTY OF NON
12
+ * INFRINGEMENT OF THIRD PARTY RIGHTS.
13
+ *
14
+ * WP Ultimate CSV Importer is distributed in the hope that it will be useful,
15
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
16
+ * or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Affero General Public
17
+ * License for more details.
18
+ *
19
+ * You should have received a copy of the GNU Affero General Public License
20
+ * along with this program; if not, see http://www.gnu.org/licenses or write
21
+ * to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
22
+ * Boston, MA 02110-1301 USA.
23
+ *
24
+ * You can contact Smackcoders at email address info@smackcoders.com.
25
+ *
26
+ * The interactive user interfaces in original and modified versions
27
+ * of this program must display Appropriate Legal Notices, as required under
28
+ * Section 5 of the GNU Affero General Public License version 3.
29
+ *
30
+ * In accordance with Section 7(b) of the GNU Affero General Public License
31
+ * version 3, these Appropriate Legal Notices must retain the display of the
32
+ * WP Ultimate CSV Importer copyright notice. If the display of the logo is
33
+ * not reasonably feasible for technical reasons, the Appropriate Legal
34
+ * Notices must display the words
35
+ * "Copyright Smackcoders. 2016. All rights reserved".
36
+ ********************************************************************************/
37
+
38
+ if ( ! defined( 'ABSPATH' ) )
39
+ exit; // Exit if accessed directly
40
+ ?>
41
+
42
+ <div class="list-inline pull-right mb10 wp_ultimate_csv_importer_pro">
43
+ <div class="col-md-6 mt10"><a href="https://goo.gl/jdPMW8" target="_blank"><?php echo esc_html__('Documentation','wp-ultimste-csv-importer');?></a></div>
44
+ <div class="col-md-6 mt10"><a href="https://goo.gl/fKvDxH" target="_blank"><?php echo esc_html__('Sample CSV','wp-ultimste-csv-importer');?></a></div>
45
+ </div>
46
+ <div class="wp_ultimate_csv_importer_pro panel col-md-12" style="font-size:14px; height: 500px;width:99%;">
47
+
48
+ <div style="text-align: center;margin-top: 200px;font-size: 16px;">
49
+ <div> Exporter feature in Ultimate CSV Importer FREE moved to a separate add-on. </div> <br>
50
+ <div> To continue using this feature, kindly install <a href="https://wordpress.org/plugins/wp-ultimate-exporter/" target="_blank">WP Ultimate Exporter </a>. </div>
51
+ </div>
52
+ </div>
includes/class-uci-helper.php CHANGED
@@ -2025,19 +2025,61 @@ $currentMapping = $this->generateDataArrayBasedOnGroups( $available_groups_type,
2025
 
2026
  #TODO: Need to import the media for scheduler
2027
  /* Set Featured Image */
2028
- if(isset($data_array['featured_image'])) {
2029
- if ( preg_match_all( '/\b(?:(?:https?|ftp|file):\/\/|www\.|ftp\.)[-A-Z0-9+&@#\/%=~_|$?!:,.]*[A-Z0-9+&@#\/%=~_|$]/i', $data_array['featured_image'], $matchedlist, PREG_PATTERN_ORDER ) ) {
2030
- $nextGenInfo = array();
2031
- $media_settings = $this->parse_media_settings($mediaConfig, $data_array);
2032
- $featured_image_info = array(
2033
- 'value' => trim($data_array['featured_image']),
2034
- //'rename_image' => $renameimage,
2035
  'nextgen_gallery' => $nextGenInfo,
2036
  'media_settings' => $media_settings
2037
- );
2038
- update_option( 'smack_featured_' . $retID, $featured_image_info );
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
2039
  }
 
 
 
 
2040
  }
 
2041
  $uci_admin->detailed_log[$uci_admin->processing_row_id]['Status'] = $data_array['post_status'];
2042
  $returnArr['ID'] = $retID;
2043
  $returnArr['MODE'] = $mode_of_affect;
2025
 
2026
  #TODO: Need to import the media for scheduler
2027
  /* Set Featured Image */
2028
+ if(isset($data_array['featured_image'])) {
2029
+ if ( preg_match_all( '/\b(?:(?:https?|ftp|file):\/\/|www\.|ftp\.)[-A-Z0-9+&@#\/%=~_|$?!:,.]*[A-Z0-9+&@#\/%=~_|$]/i', $data_array['featured_image'], $matchedlist, PREG_PATTERN_ORDER ) ) {
2030
+ $nextGenInfo = array();
2031
+ $media_settings = $this->parse_media_settings($mediaConfig, $data_array);
2032
+ $featured_image = explode('|', $data_array['featured_image']);
2033
+ $featured_image_info = array(
2034
+ 'value' => trim($featured_image[0]),
2035
  'nextgen_gallery' => $nextGenInfo,
2036
  'media_settings' => $media_settings
2037
+ );
2038
+ $orig_img_src= $featured_image_info['value'];
2039
+ $post_id= $retID;
2040
+ $attachid = $this->set_featureimage( $orig_img_src, $post_id, $media_handle );
2041
+ global $wpdb;
2042
+ $wpdb->insert($wpdb->postmeta,array('post_id' => $post_id,'meta_key' => '_thumbnail_id','meta_value' => $attachid));
2043
+ $query1 = $wpdb->get_results($wpdb->prepare("select meta_value from $wpdb->postmeta where post_id = %d AND meta_key='_wp_attached_file'",$attachid));
2044
+ foreach ($query1[0] as $key => $value) {
2045
+ $path = pathinfo($value);
2046
+ if($media['thumbnail']=='on'){
2047
+ if(!empty($media['imageName'])){
2048
+ $dir = wp_upload_dir();
2049
+ $file = $dir['path'] . '/'.$path['filename'].".".$path['extension'];
2050
+ //$path['filename']=$media_settings['imageName'];
2051
+ $renamevalue1= $path['dirname'].'/'.$media['imageName'].'.'.$path['extension'];
2052
+ $renamevalue = preg_replace('/(?<=jpg|png|jpeg).*/', '', $renamevalue1);
2053
+ $newfile = $dir['path'] . '/'.$media_settings['imageName'].".".$path['extension'];
2054
+ $rename = preg_replace('/(?<=jpg|png|jpeg).*/', '', $newfile);
2055
+ rename($file, $rename);
2056
+ $updt_query = "update $wpdb->postmeta set meta_value ='$renamevalue' where post_id = '$attachid' and meta_key='_wp_attached_file'";
2057
+ $wpdb->query($updt_query);
2058
+ }
2059
+ }
2060
+ } if(!empty($media['title']))
2061
+ { $value=$media['title'];
2062
+ $wpdb->query("update ".$wpdb->prefix."posts set post_title ='".$value."' where ID='".$attachid."'");
2063
+ }
2064
+ if(!empty($media['caption']))
2065
+ { $value=$media['caption'];
2066
+ $wpdb->query("update ".$wpdb->prefix."posts set post_excerpt='".$value."' where ID='".$attachid."'");
2067
+ }
2068
+ if(!empty($media['alttext'])) {
2069
+ $value=$media['alttext'];
2070
+ $wpdb->query("insert into ".$wpdb->prefix."postmeta (meta_key,meta_value,post_id) values('_wp_attachment_image_alt','".$value."','".$attachid."')");
2071
+
2072
+ }
2073
+ if(!empty ($media['description'])) {
2074
+ $value=$media['description'];
2075
+ $wpdb->query("update ".$wpdb->prefix."posts set post_content='".$value."' where ID='".$attachid."'");
2076
  }
2077
+ if($mode == 'Update') {
2078
+ $wpdb->query("update wp_postmeta set post_id='".$post_id."',meta_key='_thumbnail_id',meta_value='".$attachid."' where post_id='".$post_id."'");
2079
+ }
2080
+ //update_option( 'smack_featured_' . $retID, $featured_image_info );
2081
  }
2082
+ }
2083
  $uci_admin->detailed_log[$uci_admin->processing_row_id]['Status'] = $data_array['post_status'];
2084
  $returnArr['ID'] = $retID;
2085
  $returnArr['MODE'] = $mode_of_affect;
index.php CHANGED
@@ -2,7 +2,7 @@
2
  /******************************
3
  * Plugin Name: WP Ultimate CSV Importer
4
  * Description: Seamlessly create posts, custom posts, pages, media, SEO and more from your CSV data with ease.
5
- * Version: 5.6.1
6
  * Author: smackcoders
7
  * Author URI: http://www.smackcoders.com/wp-ultimate-csv-importer-pro.html?utm_source=plugin&utm_campaign=csv_importer_pro&utm_medium=wordpress
8
  * Text Domain: wp-ultimate-csv-importer
@@ -56,7 +56,7 @@ if ( ! class_exists( 'SM_WPUltimateCSVImporter' ) ) :
56
  */
57
  class SM_WPUltimateCSVImporter {
58
 
59
- public $version = '5.6.1';
60
 
61
  /**
62
  * The single instance of the class.
2
  /******************************
3
  * Plugin Name: WP Ultimate CSV Importer
4
  * Description: Seamlessly create posts, custom posts, pages, media, SEO and more from your CSV data with ease.
5
+ * Version: 5.6.2
6
  * Author: smackcoders
7
  * Author URI: http://www.smackcoders.com/wp-ultimate-csv-importer-pro.html?utm_source=plugin&utm_campaign=csv_importer_pro&utm_medium=wordpress
8
  * Text Domain: wp-ultimate-csv-importer
56
  */
57
  class SM_WPUltimateCSVImporter {
58
 
59
+ public $version = '5.6.2';
60
 
61
  /**
62
  * The single instance of the class.