0

I have a custom content type and I now need to create thousands of entries using that type. It would take a very, very long time to go through the interface and add these one by one. I'm hoping there is a plugin, module, or some kind of API so that I can create all of these entries in an excel and simply import them into the database. Is this possible?

I have not been able to get Drush working so that isn't really an option for me.

1

The most direct answer to your question is Migrate Source XSL module for the D8 Migrate API.

Or hell, dont have Windows/Excel installed do the same with Google Sheets Migrate Plus plugin.

I'm not sure if there is a UI for Migrate yet in D8. But this would be the most flexible solution. If needed you could use the drupal api itself to code simple insertion from a php script to create Nodes from an excel script; but the above migrate plugins should be much for flexible to debug in the long run -- but may require Drush support currently.

Edit

Ask previously, how to create a Node in D8: Programmatically create nodes

  • But the fields for each content type are all in separate tables in the database. If I use the drupal API to code an insertion, do I have to manually update every field in every table or is there an API that can hook into my custom content type? The Entity API? – garek007 Apr 21 '17 at 16:16
  • Hey one more question about the stackoverflow link you referenced above. Where would I place and run that script? – garek007 Apr 21 '17 at 16:41
  • Nevermind. I made a module and I just load that page and I am able to insert new content. This worked great! – garek007 Apr 21 '17 at 17:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.