Data Import

Developer

Percipio

3rd Party (Free)

3 downloads (last 90 days)

MIT License Download v2.0

EE Version Support

  • ExpressionEngine 2

Compatibility

If an item is crossed out, it might be untested, not applicable or incompatible. Contact the developer to be sure.

  • Updater
  • Multi Site Manager
  • Stand Alone Entry Form
  • Low Variables
  • Content Elements
  • Better Workflow
  • Matrix
  • Grid
  • Webservice
  • Publisher

Requirements

Add-On Type(s)

Module

Tags

Import content from any mysql database directly into EE - Allows for data to be imported from a remote/local database table to Channel, Matrix and Expresso Store fields.

DISCONTINUED

This module allows you to connect to a remote or local database and import that data into a chosen channel.

With compatibility for expresso Store and Matrix, it means you can now import data from a legacy system, either initially, or on a regular basis via a Cron task and populate your inventory.

Perfect for importing data from an old CMS / eCommerce system into Expression Engine.  Due to the dynamic nature of the DataImport module you can now import content from any other mysql based CMS into EE in a single import.

We have successfully imported data from the following CMS databases - EE 1.xx / EE 2.xx / WordPress / Joomla / Drupal / CMSms

This item is no longer supported / in active development

Usage

Once installed, add your remote database connection information to the Remote DB Settings tab - this could be localhost / external connection.

Create a new Import from the Import List tab, you will see your database tables populated in a select field:

     
  • Select the table you wish to import from
  •  
  • If you need to join multiple tables to collate data, click the join link - the DataImport module will attempt to locate a common key (eg entry_id) - You can override this setting by manually changing the text field
  •  
  • Select the channel you wish to import to. This will auto generate the fieldtypes set for this channel and allow you to select which column corresponds to which field. It is advisable to setup the required fields / matrixes before running the import
  •  
  • Key - tells the module what field to use to check for duplicates. So every row will match by the key field. Eg: remote.sku=local.sku.
  •  
  • Required - will not create record / entry if field is empty / null.
  •  
  • Condition - will not create record / entry if condition is not met.

Finally, once all your fields are mapped, you can submit the import to save it.

Road Map

The following features are due in subsequent releases:

     
  • Import authors / comments
  •    
  • Support for More 3rd party fieldtypes

Release Notes

1.7 - Added MSM, author_id
1.6 - Bug fixes
1.5 - Category Support / Entry_id as key
1.4 - Table Join Update
1.3 - bug fix for required entries
1.2 - Run import from CP
      - Import entry dates & assign status
1.1 - Bug fixes, added option to join tables

 

 

 

 

Download Data Import

EE Support Downloads Add-On Version Release Date
Not Specified Download 2.0

This entry was created June 28, 2012, 12:04 pm.
This entry was last updated January 20, 2015, 11:58 am.

Disclaimer: Information about ExpressionEngine add-ons is provided as a service to you, the user, and every member of the ExpressionEngine community. devot:ee is not responsible if you hose, mangle, wreck, or otherwise destroy your EE website by installing an add-on that you found out about at this site, regardless of its rating, Favorites status, commercial or free status, or general popularity. Caveat EEmptor!

Returns: devot:ee has a 30-day return policy on all commercial add-ons sold through devot-ee.com. If you need to return an add-on, do not go to the developer or the developer's site, but rather visit our returns page at https://devot-ee.com/returns to initiate your return. If you have questions, email support@devot-ee.com.

2 Reviews:

Yuri Salimovskiy 12.30.14

Yuri Salimovskiy
Rating - {addon_rating_average}

Import works just fine on EE 2.9.2

Akwadnet 07.05.14

Akwadnet
Rating - {addon_rating_average}

Great add-on,
BUT:
bad documentation
bad support some of the issues with no reply.
they are not replying emails too :(
no 2.8.+ support,
no progress import bar.
no good memory handler :(
I HAD TO:
-downgraded EE version to make it works.
-add 10GB of ram to make it works with big import