4 votes
Accepted

importing entry status via CSV - does uppercase or lowercase status matter

While firing a query in DB, No matter you pass "Open" or "open". Both are same. Your first question's answer is: As per EE Standards, It should be "open". EE save "open/closed" in database, it shows ...
user avatar
3 votes
Accepted

Importing nested categories with Datagrab

From the Developer: Use a slash ‘/‘ to separate subcategories, so you can do something like, 'Category / SubCategory' The delimiter is hard-coded but if you want to change it is around line 1420 of ...
user avatar
3 votes
Accepted

Importing formatted body copy into EE

It really all depends on what field you're ultimately going to import into. If you're importing into an XML-formatted textarea or a Rich Text Editor field, then you'll need to totally remove both the &...
user avatar
  • 2,724
2 votes
Accepted

exp_channel_data matrix field contains YTowOnt9

Issue was with DataGrab 1.8.0 If a matrix field has a value and DataGrab has the field option "Action to take when an entry is updated" is set to, "Delete all existing rows" even though there are no ...
user avatar
  • 319
2 votes
Accepted

Bulk Import of Categories

Data Grab does support category importing (See configuration grab) but as part of entry import (as far as I'm aware), so possibly discard entry information after import if it's not needed...? You ...
user avatar
  • 5,353
2 votes
Accepted

How do I import checkbox field values using DataGrab?

If you are using a normal, EE checkbox, you should just need to supply pipe-delimited values (eg, One|Two|Three). If you are using a Field Pack checkbox, these aren't currently supported within ...
user avatar
2 votes
Accepted

Datagrab stuck/fail on 90% 4/5

Figured it out. Posting here to help others in the same spot. I had the batch field set to 500/batch, since we did huge imports at the start. Got the problem when we started importing <500 I guess....
user avatar
1 vote
Accepted

Datagrab import, relationshipfield inside grid

This is one that really you should direct to the author of Datagrab... it is quite possible though that the add-on does not support the importing of relationships within grids. The datagrab web site ...
user avatar
  • 3,562
1 vote

Best practices for importing matrix data

A matrix (or native grid field) can become unwiedly with a lot of records so I'd go down the relationship route. Create a new channel for the data, you can then use relationship field(s) to associate ...
user avatar
  • 1,577
1 vote
Accepted

Trouble Using DataGrab to Import into Solspace Calendar in EE3

DataGrab's developer added a base import option for Solspace's Calendar module. Special thanks to http://www.brandnewbox.co.uk
user avatar
  • 79
1 vote
Accepted

DataGrab fails if not run from EE Control Panel (logged in)

I was running into this issue as well, I don't know if this will resolve your issue. It tries to create a session for a member with a member_id of 1, do you have a member with an id of 1 that belongs ...
user avatar
  • 572
1 vote

Pulling data from external database

For an operation of this size, you should be using an enterprise solution, not a web application. You should be exporting the data from the other SQL database in chunks so you can move it gently. What ...
user avatar
  • 5,900
1 vote
Accepted

DataGrab - is there a hook?

It looks like DataGrab has three hooks: ajw_datagrab_pre_import ajw_datagrab_modify_data ajw_datagrab_post_import If you open up datagrab_model.php and search for active_hook you will find them. ...
user avatar
  • 7,941
1 vote

Import Channel Entries into New Channel?

IF the channels share the same custom field group you should be able to use a bit of SQL to check for a specific channel_id and convert it to the channel_id you are keeping. If the channels do not ...
user avatar
  • 7,556
1 vote
Accepted

Wordpress to ExpressionEngine, missing tags

The developer of DataGrab emailed me the solution. I figured I would post it here so that anyone else who may have this problem down the road is able to solve it! First, you need to update the ...
user avatar
1 vote

Wordpress to ExpressionEngine, missing tags

DataGrab doesn't currently have support for the Tagger field type. However DataGrab does have support for Solspace Tag which may provide the correct functionality for you without having to manually ...
user avatar
  • 1,449
1 vote

Importing formatted body copy into EE

One option you could try is to convert the HTML to Markdown format and import that into a MarkItUp or Markdown formatted text field. Brett Terpstra's online Markdownifier tool (http://heckyesmarkdown....
user avatar
1 vote

How do i export/import MX Google Map entries

You could use Google Maps for EE to do this, but you would need a .csv to do it. It comes with a geocoder/import utility that is really robust and will work for almost all data files. I know it's not ...
user avatar
1 vote

Export Expresso Store customer data

It depends entirely on what format you need the data to be export into (CSV, JSON, XML, etc). Even when you have decided on a format, you probably need to massage the data into specific columns which ...
user avatar
1 vote
Accepted

PHP Erros With DataGrab

Recasting my comments as an "Answer": I would guess both DataGrab and Magpie.pi incorporate the Magpie RSS processor written in PHP That's fine. What isn't fine is that both add-ons are defining ...
user avatar
  • 1,079

Only top scored, non community-wiki answers of a minimum length are eligible