3 votes
Accepted

Unable to import .CSV files with Solspace Importer Module

This error had to do with line endings in my CSV file. Our workflow is to create the entries in Excel 2011 on the Mac and Save As .CSV. Exporting Excel 2011 to .csv results in a file that is encoded &...
user avatar
  • 1,079
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

Expression Engine Importer(solspace) scheduled cron jobs don't update entry

Seems like your crontask isn't configured correctly. 1) Verify your curl statement works properly by running it in Terminal (Mac) or Putty (Windows). and 2) Verify you're configuring your ...
user avatar
  • 611
2 votes
Accepted

Solspace importer : A Unique Field Element with valid EE Field Are Required

Thanks to a hint from Nicolas @ solspace's support, we found that a little htacces was blocking access to a javascript file. Below code breaks solspace's importer (and everything member related) # ...
user avatar
  • 225
1 vote

How to use Solspace Importer for files

If you look at the data stored in exp_channel_data for regular EE File Upload fields, you'll see files stored this way, eg: {filedir_1}myfile.jpg, where 1 is your upload field ID (this changes ...
user avatar
  • 6,139
1 vote

Modify Solspace importer for email is not required

Hrmm. I think the first-party member module really depends on having an email address for an account, and really scanning through it to modify it is both a very bad practice and impractical. What I ...
user avatar
  • 5,900
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

Solspace Importer: Native EE Grid and Relationships

Nope, Importer does not support importing into Grid fields, nor does it support creating/populating relationship fields. Have you looked at DataGrab? Solspace does have a 30 day money back guarantee.
user avatar
  • 17.4k
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

How to import API data into EE

I've used DataGrab to achieve this in the past. Solspace Importer will also do the same.
user avatar
  • 317
1 vote

Matrix and Solspace Importer issue with saving properly

I would query the matrix table for an entry that doesn't work and one that does and compare the 2 to see if there is any difference.
user avatar
  • 1,987
1 vote

Solspace Importer not set up correctly?

Your errors are saying that files are missing so it's safe to deduce that something isn't set up correctly. I suggest redownloading the files from your Solspace account and reuploading them to your ...
user avatar
  • 12.6k
1 vote

entry "status" not honoured on import [json / solspace importer]

Apparently I did not have the default status group linked to that particular channel. That why Importer could not apply the 'Open' status...
user avatar
  • 316
1 vote
Accepted

Solspace importer cache folder safe to clear?

Yes, you can empty it. Importer temporarily stores the file somewhere to read and use it, whether you submit your original data file through a manual upload, remote URL, server path, etc. The EE ...
user avatar
  • 6,139
1 vote

Importer module for uploading CSV in channel entries is not working for grid

Importer module doesn't support GRID fields.
user avatar
1 vote

Solspace Importer - Merge two fields in one

Unfortunately that's not possible. You would need to combine those fields in your XML beforehand, i.e. before importing into your custom text field using Importer.
user avatar
  • 6,139

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