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 ...
- 2,177
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 ...
- 45
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 &...
- 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 ...
- 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 ...
- 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 ...
- 491
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....
- 121
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 ...
- 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 ...
- 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
- 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 ...
- 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 ...
- 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.
...
- 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 ...
- 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 ...
- 306
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 ...
- 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....
- 442
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 ...
- 5,332
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 ...
- 12.2k
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 ...
- 1,079
Only top scored, non community-wiki answers of a minimum length are eligible