Hot answers tagged

4 votes

EE3: Importing into EE3 - updating existing entries

Simply put, if you value your time even a little bit, I would use DataGrab rather than rolling your own import / export routines. Datagrab is simple and it works. The 'updating existing entries' ...
user avatar
  • 3,572
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

Member Import Error - Unable to parse XML

EE's built in Member Importer can be a bit fickle from time to time and the error reporting is.... well it is anything but useful. So I have a list of things that you can try Upload the file to the ...
user avatar
  • 7,556
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

Internal Server Error when trying to import members with Solspace Importer

Had to submit a support ticket over at Solspace and got help right away. Solution was to set the Unique Field setting to something other than member_id and the import worked beautifully. Big thanks to ...
user avatar
  • 626
2 votes

Internal Server Error when trying to import members with Solspace Importer

I think you should try to narrow down the error a little more. Cut the list in half and try each half individually. Does one half go through and the other error? Put aside the working half and cut the ...
user avatar
  • 1,232
2 votes

How can I import a Filemaker database into EE?

DataGrab and Solspace Importer add-ons can both import various types of data into EE, such as CSV, XML, etc that can be exported from FileMaker. I would look at both of these add-ons and work out ...
user avatar
2 votes

Export and import of Cartthrob/EE data?

For data import, I highly recommend using AJW datagrab with CSV data. http://brandnewbox.co.uk/products/details/datagrab data export is a little bit trickier, but you can setup a template to output ...
user avatar
  • 589
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
2 votes

Import data into Expression Engine channels content

You can use datagrab fot that http://brandnewbox.co.uk/news/details/datagrab-for-expressionengine-3
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,572
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

Moving Ratings from EE1 to EE3 site

Realistically, the best way to go about this would be to do this in stages. I'd make a clone of the original site. Then upgrade it to EE2 and Rating 3.x. Then upgrade that site to EE3 and Rating 4.x. ...
user avatar
  • 6,139
1 vote

Bulk Import to Expression Engine

There are a couple of add-ons for importing data that you could look at. I imagine you'd need some further customization though to scoop up that format. https://solspace.com/software/expressionengine/...
user avatar
1 vote
Accepted

Export and import of Cartthrob/EE data?

For a simple EE to EE migration (within v.2 at least) there's no need for Datagrab et al, just export the SQL tables that you want and import into the other database.
user avatar
  • 4,885
1 vote

Import data from EE2 to EE3 site

Late answer i know... But i tend to always use Datagrab: http://brandnewbox.co.uk/products/details/datagrab
user avatar
1 vote
Accepted

Import data from EE2 to EE3 site

There's no silver bullet unfortunately. I'd bring in the latest site to local. Upgrade local to V3. On local create/rename fields but don't delete. Document every change to the channels & fields ...
user avatar
  • 3,163
1 vote
Accepted

Best Practices for Large Number of Entries

Yes, that is a sound approach. Create a Channel for your your government agencies with the necessary Custom Fields to hold data. Then use a data import module to map the data to appropriate Channel ...
user avatar
  • 7,941
1 vote

Importing assets programmatically

All files in asset fields are stored in a bunch of the exp_assets_* tables. You can insert/delete/update rows to make the changes you want. For instance, you can add new files to exp_assets_files, and ...
user avatar
  • 1,232
1 vote

Sync a channel with google docs spreadsheet

With DataGrab, you can point to a URL to import from. I've successfully imported directly by using the following URL pattern https://spreadsheets.google.com/feeds/download/spreadsheets/Export?key=...
user avatar

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