CSV Import allows you to quickly import contact details from any spreadsheet application into Connections in bulk. Featuring a multiple category import, this extension can save you valuable time and give you quick and accurate access to all of your data in the organized fashion you’ve come to expect from all of our Connections extensions.
Video
Walk thru of importing a CSV file.
Screen Captures
Features
- Plug and play with no configuration required.
- Detailed step by step directions.
- Simple three step import process.
- Comes with a sample Excel spreadsheet for the column/fields headers.
- Auto mapping of column/field headers.
- Auto entry type determination
- Category import support.
Changelog
Show Change Log
= 2.5 12/22/2022 =
- TWEAK: Introduce
Connections_CSV_Import::doTermUpdateCount(). - TWEAK: Type cast is redundant.
- TWEAK: Remove the use of deprecated methods.
- TWEAK: Ensure only a string is passed to
strtolower()to prevent PHP deprecation notice. - TWEAK: Introduce
Connections_CSV_Import::maybeDoTermUpdateCount()and refactor the callback method to utilizeConnections_CSV_Import::doTermUpdateCount(). - TWEAK: Refactor
Connections_CSV_Import::triggerTermUpdateCount()to do term count updates if the async request fails to ensure taxonomy terms counts are updated when the async request fails or is blocked by the web host. - BUG: Method call is provided 2 parameters, but the method signature uses 1 parameter.
= 2.4 11/01/2022 =
- TWEAK: Improve the reliability of importing large CSV files by iterating through the JSON chunks instead of using steps/ticks.
- TWEAK: Set timeout to unlimited when doing the AJAX post request when importing a JSON chunk. If a chunk took longer than 60s, the import would fail.
- TWEAK: Ensure the JSON chuck is deleted for improved garbage collection.
- TWEAK: Do term count updates after all JSON chunks have been imported to improve import performance.
- OTHER: Correct misspellings.
- OTHER: Update filename.
- DEV: phpDoc corrections.
= 2.3 10/04/2022 =
- TWEAK: Remove the use of
create_function(). - TWEAK: Remove instances of deprecated
cnFormObjects::close()method. - OTHER: Correct misspellings.
- OTHER: Remove unnecessary trailing space.
- OTHER: Remove unnecessary whitespace.
- DEV: phpDoc corrections.
- DEV: Update the paths to the parseCSV library.
- DEV: Remove the use of the deprecated method
cnOptions::getDefaultAddressValues(). - DEV: Remove the use of the deprecated method
cnOptions::getDefaultPhoneNumberValues(). - DEV: Remove the use of the deprecated method
cnOptions::getDefaultEmailValues(). - DEV: Remove the use of the deprecated method
cnOptions::getDefaultIMValues(). - DEV: Remove the use of the deprecated method
cnOptions::getDefaultSocialMediaValues(). - DEV: Remove the use of the deprecated method
cnOptions::getDefaultLinkValues(). - DEV: Remove the use of the deprecated method
cnOptions::getDateOptions(). - DEV: Remove the use of the deprecated method
cnFormObjects::buildSelect(). - DEV: Remove the use of the deprecated method
cnFormObjects::buildRadio().
= 2.2.1 04/26/2021 =
- TWEAK: Remove deprecated WP page heading icon div.
- TWEAK: Remove use of deprecated methods.
- TWEAK: Do strict type check when processing fieldset data.
= 2.2 12/17/2019 =
- NEW: Introduce the `cncsv_import_entry_data` action.
- NEW: Introduce the `cncsv_import_entry_data_processed` action.
- NEW: Introduce the `cncsv_import_valid_types` filter.
- NEW: Introduce the `cncsv_import_is_valid_type` filter.
- I18N: Add text domains to mappable field names.
- I18N: Introduce the German (Germany) translation.
- DEV: Add todo.
= 2.1.3 06/11/2019 =
- TWEAK: Remove BOM if it exists in uploaded CSV file.
= 2.1.2 05/17/2019 =
- NEW: Add support for import the Excerpt field.
- BUG: Make the core Connections jQuery UI CSS is set as a dependency when registering the CSS file.
= 2.1.1 04/23/2019 =
- BUG: Ensure entry slug is decoded before passing it to create the folder when sideloading a remote image.
- OTHER: Update plugin header site links from http to https.
- OTHER: Bump requires WP version to 4.7.12 to match core Connections.
- OTHER: Bump requires PHP version to 5.6.20 to match WordPress 5.2.
= 2.1 03/07/2019 =
- NEW: Introduce `cnCSV_Entry::arrayKeyExists()`.
- TWEAK: Check for bio and notes CSV index before importing so existing text is not deleting when updating entries and the update CSV file doe not contain either of those fields.
- TWEAK: Add `text/x-fortran` as a valid CSV file mimetype.
- I18N: Add French (France) translation.
- OTHER: Update “Tested up to” in plugin header.
- OTHER: Bump copyright year.
- DEV: Add a couple @todo’s.
- DEV: Add a note about potentially having to remove BOM.
= 2.0.2 01/02/2019 =
- TWEAK: Add check for `ForceUTF8` library before applying it to the CSV file.
- BUG: Correct text domain.
- I18N: Update POT file.
= 2.0.1 10/16/2018 =
- TWEAK: Attempt to force supplied data to UTF8.
- DEV: phpDoc correction.
= 2.0 07/27/2018 =
- FEATURE: Complete refactor of import process to improve user feedback and performance.
- TWEAK: Load CN_parseCSV outside the check for parseCSV base.
- TWEAK: Pass the `cnCSV_Entry` object as parameter for the `cncsv_import_fields` filter.
- TWEAK: Make `cnCSV_Entry::arrayPull()` public.
- OTHER: Correct plugin home page URL.
- OTHER: Correct plugin name in readme.txt.
- OTHER: The `ul` elements do not belong nested with `p` elements.
- I18N: Update POT file.
- I18N: Add Dutch (Netherlands) translation. props Age!
- I18N: Make menu item translation ready.
= 1.4.7 11/15/2017 =
- TWEAK: Reduce import batches to 10 on WPE.
= 1.4.6 11/08/2017 =
- TWEAK: Allow text/html as a valid type when performing real mime file check on file upload.
= 1.4.5 11/03/2017 =
- BUG: Correct bug which prevented the entry order from being imported.
= 1.4.4 01/26/2017 =
- NEW: Add support for importing a photo and logo from a supplied URL.
- NEW: Add support for setting the category delimiter to comma (default) or semi-colon.
- NEW: Support importing of the entry order.
- NEW: Introduce the `cn_csv_import_batch_limit` filter.
- TWEAK: Disable WP heartbeat on CSV Import admin page to reduce site load.
- TWEAK: Ensure the result from inserting a term is not a WP_Error before attempting to get the term ID.
- BUG: Correct scenario when updating an existing entry would remove all associated categories.
- OTHER: Correct misspellings.
- DEV: phpDoc corrections.
- DEV: Reflow long line of code.
= 1.4.3 01/26/2017 =
- BUG: Categories with an ampersand in the name would not be imported.
= 1.4.2 01/07/2017 =
- TWEAK: Fix for WordPress 4.7.1 security release causing the “ERROR: Sorry, this file type is not permitted for security reasons.” error message.
= 1.4.1 12/12/2016 =
- TWEAK: Defer updating the category counts when importing a batch of entries.
- BUG: Correct option name to retrieve the default category ID.
- OTHER: Correct misspelling.
= 1.4 07/14/2016=
- FEATURE: Support importing the link title attribute.
- FEATURE: Support the importing of the viability status for address, phone, email, IM, social, link and date fields.
- FEATURE: Support the auto mapping of fields from CSV file exports of the core Connections Tools.
- NEW: Introduce CN_CSV_Options::buildMapKey().
- NEW: Introduce CN_CSV_Options::addressFields().
- NEW: Introduce CN_CSV_Options::addressFieldIDs().
- NEW: Introduce CN_CSV_Options::phoneFields().
- NEW: Introduce CN_CSV_Options::phoneFieldIDs().
- NEW: Introduce CN_CSV_Options::emailFields().
- NEW: Introduce CN_CSV_Options::emailFieldIDs().
- NEW: Introduce CN_CSV_Options::imFields().
- NEW: Introduce CN_CSV_Options::imFieldIDs().
- NEW: Introduce CN_CSV_Options::socialFields().
- NEW: Introduce CN_CSV_Options::socialFieldIDs().
- NEW: Introduce CN_CSV_Options::linkFields().
- NEW: Introduce CN_CSV_Options::linkFieldIDs().
- NEW: Introduce CN_CSV_Options::dateFields().
- NEW: Introduce CN_CSV_Options::dateFieldIDs().
- NEW: Introduce cnCSV::processDate() helper method.
- TWEAK: Use cnSanitize::string() to sanitize the category name.
- TWEAK: Remove unnecessary switch break statements.
- TWEAK: Use the parseCSV library bundled in the core plugin instead of the version supplied in this plugin.
- TWEAK: Introduce class CN_CSV_Option as an alias for class connectionsCSVOptions.
- TWEAK: Refactor CN_CSV_Options::fields() to use the new field helper methods to reduce code duplication.
- TWEAK: Add the `cncsv_map_import_fields-address` filter to add support for the extended address type to support Google Contacts CSV export files for auto mapping fields.
- TWEAK: Refactor CN_CSV_Options::fields() to use the new field helper methods to reduce code duplication. MISSED COMMITS.
- TWEAK: Refactor cnCSV::import() to use helper methods to reduce code duplication.
- TWEAK: Remove commented out dead code.
- BUG: Correct CN Log registration.
- OTHER: Correct misspellings in inline docs.
- OTHER: Remove the bundled parseCSV library.
- DEV: phpDoc fixes.
- DEV: code alignment fixes.
= 1.3 09/18/2015 =
- NEW: Add initial support for cnLog to log import errors. To be fully implemented at a later date.
- TWEAK: Use class constant for plugin version instead of global constant.
- TWEAK: Attempt to set max memory limit to WP_MAX_MEMORY_LIMIT.
- TWEAK: Remove use of the deprecated cnTerms methods.
- TWEAK: Use the category set as the default category when importing an entry with not categories set.
- TWEAK: Check that $term is not FALSE and is an object before reading its properties.
- OTHER: Cleanup some code indenting.
- DEV: Update .gitignore.
- DEV: phpDoc fixes.
= 1.2 07/31/2014 =
- FEATURE: Add pre/post import action hooks.
= 1.1 06/12/2014 =
- FEATURE: Add in-admin update support.
- FEATURE: Add basic updating support.
- BUG: Fix a couple minor documentation issues.
- TWEAK: Remove class.upload.php dependency; use core WP functions instead.
- TWEAK: Update plugin header text.
- OTHER: Add `cncsv_import_fields` action to allow plugins to import meta data.
- OTHER: Define version using class constant instead of global constant.
- OTHER: Remove unused/commented out JavaScript code.
= 1.0.4 01/15/2014 =
- BUG: Fixed a few undefined index notices.
- TWEAK: Remove the use of uniqueid() which can cause import issues on Windows servers.
- TWEAK: Reduce import segment from 500 rows to 100 rows per import.
- TWEAK: Change default for import offset from NULL to 0.
= 1.0.3 11/17/2013 =
- BUG: Fix a possible fatal error when importing a CSV with no categories.
- OTHER: Comment out a couple unused JavaScript variables.
= 1.0.2 11/17/2013 =
- TWEAK: Increase import segment from 100 to 500.
- TWEAK: Use jqXHR Object method .always() to process data import segment response data and fire off the recursive function.
- BUG: Fix an instance where the “Uncategorized” category was being assigned to entries in which it should have not.
= 1.0.1 11/16/2013 =
- TWEAK: Updated styles to include support for pre Connections 0.8.
- TWEAK: Updated styles to include support for pre WP 3.8.
= 1.0 11/16/2013 =
- Complete rewrite.
= 0.9 2/19/2012 =
- BUG: Fix bug that prevented social media URL/s from being imported correctly.
= 0.8 =
- FEATURE: Add support for address line three.
= 0.7 =
- BUG: Fix bug that prevented categories from importing on ISS.
= 0.6 =
- FEATURE: Added the ability to import to multiple categories, pre-existing or create new categories as needed.
- BUG: Fix mapping bug when mapping to Address 1.
- BUG: Fix adding more than one email address issue. Counter var was not being incremented.
- OTHER: Added additional Social Media mappings to be in synce with Connections.
- OTHER: Make compatible with Connections >= 0.7.2.1
= 0.5 =
- Initial Release