10 votes

Exporting fields for content type

UPDATE You might also try Drupal Console's drupal config:export:content:type command. It's description says: The config:export:content:type command Export a specific content type and their ...
otarza's user avatar
  • 954
10 votes
Accepted

Import CSV to nodes/entities in Drupal 8 including a UI

I do this all the time, making use of migration configuration entities (provided by the migrate_plus module). Define a migration plugin in your migration module's config/install directory, using the ...
Mike Ryan's user avatar
  • 1,333
8 votes
Accepted

How to migrate multilingual image alt fields from CSV?

I think I've figured this out. You need to define the 'content_translation_source' property on the translated node, so that Drupal knows what language it's coming from. Eg: migrate_plus.migration....
vasi's user avatar
  • 196
7 votes

Mapping or migrating path alias using using Migrate Source CSV

@Jigar's answer is close but not quite. Here is what I eventually figured out. It should be path/alias and not just path. Also, if you have pathauto module installed it will create the path based on ...
oli-chowdhury's user avatar
6 votes

Automatically import data from Google spreadsheet using feeds module

Sorry, bit late to the party. How I solved this was: Publish the file to the web using the option in Google Sheets' file menu. This gets you a special link to an always up-to-date version with the ...
Dr. Gubó's user avatar
6 votes

Mapping or migrating path alias using using Migrate Source CSV

Just tried it out while trying to find an answer to a similar question. Here's how it should look: source: ... constants: slash: '/' process: ... // This parameter should be "path" and ...
Jigarius's user avatar
  • 3,109
6 votes

How do I export and import content types (including fields) between environments?

You're on the right track with the configuration export but I am guessing you did the single export option for the content type. Each field on your content type has several configuration items that ...
Leigh's user avatar
  • 2,953
6 votes
Accepted

Export Paragraph bundles

Turns out it can be done with the config:export:entity command. drupal config:export:entity paragraphs_type [PARAGRAPH_TYPE] --module="[YOUR_MODULE]" --optional-config --remove-uuid --remove-...
Bram's user avatar
  • 249
5 votes

How do I export the list of URL alias into an excel or csv?

This is easy with a query: select source, alias from url_alias INTO OUTFILE '/tmp/url_aliases.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'; If you are good with mysql, you ...
oknate's user avatar
  • 14.3k
5 votes
Accepted

How do I export and import content types (including fields) between environments?

Configuration management Deploying content types, fields, views, site settings (everything that is not content) from one environment (local) to another (stage, prod etc.) in Drupal 8+ works by ...
leymannx's user avatar
  • 18.1k
4 votes
Accepted

What happened to the links to import or export a View?

That Views import/export facility is no longer available in Drupal version 8 (within "admin/structure/views") ... A possible way to do similar Views imports/exports in Drupal version 8 is to use the ...
Pierre.Vriens's user avatar
4 votes

How to export 'Content-Type' data into JSON?

You could use the Forena module (disclosure: I'm a co-maintainer of it) as your 1-stop-solution (using only 1 contributed module) to: Build your custom query to fetch the data, whereas these data can ...
Pierre.Vriens's user avatar
4 votes
Accepted

How to migrate multilingual content from CSV to Drupal 8?

Migrate from CSV basics As stated elsewhere, the migration code has only recently (as of 8.2.x or 8.3.x) seemed to settle down and there are loads of old, outdated and incorrect instructions in blog ...
JamesWilson's user avatar
  • 2,148
4 votes
Accepted

How to import multiple images with Feeds importer from CSV?

You can accomplish this with choosing a character to separate your image urls with in the CSV file and using the Feeds Tamper plugin "Explode". Separate the image URLs in your CSV file with a certain ...
MegaChriz's user avatar
  • 800
4 votes
Accepted

How to migrate multiple columns to single field in CSV Migrate

It took a while for me to solve the issue. However, I was able to manage the same without having to write additional plugin or module. I solved the issues in two steps: First used the plugin concat ...
esafwan's user avatar
  • 1,348
4 votes

Possible to extract multiple key/value pairs (links) from string in CSV and migrate into multiple link field

Here is my solution to solve a similar problem: temp_data: - source: data plugin: explode delimiter: ',' - plugin: explode delimiter: '|' destination_field: plugin: ...
Mithenks's user avatar
  • 141
4 votes

Export/import users

Export/Importing user tables might work if you're doing some sort of crude one-and-done migration. The caveat is you're going to have to think through everything in the source userbase you want to ...
Shawn Conn's user avatar
  • 26.9k
4 votes
Accepted

Exclude settings from a contrib module on export

You don't need to exclude the API keys from export; instead, you can set them in code, and then it doesn't matter what gets exported. (...probably. Some modules will not work with this approach.) You ...
Patrick Kenny's user avatar
3 votes

How to export users to a CSV file?

Yes, the Views Data Export is the right module, but if you've big data files, you've to increase proper PHP limits, such as: PHP max_execution_time and memory_limit, unless you're using batch process, ...
kenorb's user avatar
  • 14.2k
3 votes

Exporting the entire website, except users and content?

I would suggest to put your code in a version control like Git. There are many free services you can use like Github and Bitbucket. With Git you can easily ship your code from one server to another. ...
Gulok's user avatar
  • 918
3 votes

SQL query to CSV

I found it easiest to export the results to .tsv format D7: drush sql-query "SELECT nid, title FROM node LIMIT 10" > nid-title.tsv D8: drush sql-query "SELECT nid, title FROM node_field_data ...
David Thomas's user avatar
  • 21.9k
3 votes
Accepted

Importing a bunch of users from csv spreadsheet file into Drupal 8

Check out the Migrate Source CSV I know that it uses drush and can import nodes through mapping it in a twig file and I'm pretty sure that it supports users too. Full steps located here.
Chris Happy's user avatar
  • 1,897
3 votes

How to migrate multilingual content from CSV to Drupal 8?

you need both migration-tasks, the yml files in the migration folder: migrate.migration.external_translated_test_node.yml migrate.migration.external_translated_test_node_translation.yml Then in the ...
rémy's user avatar
  • 5,710
3 votes

How to get the view fields in rows in the word document generated using Views data export module?

As an alternative to using the Views data export module, you may want to use the Forena module (disclosure: I'm a co-maintainer of it) to create a "report" that includes the data that you're ...
Pierre.Vriens's user avatar
3 votes
Accepted

Import/export views

There is currently (D8.4 october 2017) no migrate update path for views (D6 or D7) to D8. It doubful if this will ever happen because of the complexity of views. I.e. missing views handlers, changed ...
firfin's user avatar
  • 250
3 votes

How do I export Entityform submissions to CSV?

My problem was that I installed Views Data Export after installing Entityforms. I had to go to the Entityforms view (which is the automatically generated admin view showing the form's submissions), ...
Lincoln Bergeson's user avatar
3 votes

How to migrate multiple columns to single field in CSV Migrate

I was struggling with this very same issue. Even though the official migration docs suggest that multivalued fields will be handled by the pipeline automatically, it didn't happen for me(at least at ...
Badri's user avatar
  • 831
3 votes
Accepted

How to securely authenticate content embeded in another site?

1- build the content structure well in your first site and create a view from admin/structure/views/add that return the data needed to the second site which acts like a client consuming your first ...
Mohammed Gomma's user avatar
3 votes

How do I export and import content types (including fields) between environments?

The best way in my opinion is to use git work flow. What we do to export content type configuration with fields between the environments is we take a git feature branch and create content type and it'...
miststudent2011's user avatar
3 votes
Accepted

How can I export the raw body of a node?

Under FORMAT, click on Settings, check mark "Keep HTML Tags"
No Sssweat's user avatar
  • 31.3k

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