In Half 1, I talked about utilizing Google Docs + Migrate to populate your web site. Now we’re going to do this with Drupal Development Service Migrate Google Sheets Drupal 10 module. Under, I’ll present Drupal Development Service steps to get your personal migration up and working, however if you happen to favor to experiment with a working instance, try a demo of Drupal Development Service Migrate Google Sheets Instance Drupal 10 module (offered as a subDrupal 10 module inside Migrate Google Sheets). All content material on that web site was constructed utilizing this instance Google Sheet. Setup Drupal 10 Upkeep and Help Service Set up Drupal Development Service Drupal 10 Help For those who’ve already bought a 8 web site up and working, you may set up Drupal Development Service Drupal 10 module in any of Drupal Development Service regular methods. I’m assuming right here that you’ve got entry to Drupal Development Service web site utilizing Drush, because it’s not doable to run migrations via something however Drupal Development Service command line right now. At ThinkShout, we use composer to construct our web site distributions, and have a repo for constructing Drupal Development Service demo web site right here. Step 1 Drupal 10 Upkeep and Help Service Creating Your Customized Migration Drupal 10 Help Drupal Developer best technique to get began by yourself set of migrations is to repeat Drupal Development Service migrate_google_sheets_example subDrupal 10 module and rename it one thing of your personal. Let’s say we rename it “my_migration.” Comply with these steps Drupal 10 Upkeep and Help Service Rename your .set up file to “my_migration.set up”, and alter Drupal Development Service operate migrate_google_sheets_example_uninstall to “my_migration_uninstall”. Delete Drupal Development Service helper subDrupal 10 module “migrate_google_sheets_example_setup” totally – that’s simply essential to construct Drupal Development Service content material sorts required for Drupal Development Service instance Drupal 10 module, however you shouldn’t want it to your migration Drupal 10 module. Rename your migrate_google_sheets_example.data.yml as “my_migration.data.yml” and open it up. At Drupal Development Service very least, you’ll need to change Drupal Development Service identify of Drupal Development Service migration to “identify Drupal 10 Upkeep and Help Service my_migration” however you’ll additionally possible want to take away Drupal Development Service migrate_google_sheets Drupal 10 Upkeep and Help Servicemigrate_google_sheets_example_setup dependency. Mine ended up wanting like this Drupal 10 Upkeep and Help Service identify Drupal 10 Upkeep and Help Service my_migration kind Drupal 10 Upkeep and Help Service Drupal 10 module description Drupal 10 Upkeep and Help Service My Migrations core Drupal 10 Upkeep and Help Service 8.x bundle Drupal 10 Upkeep and Help Service Migrate dependencies Drupal 10 Upkeep and Help Service – migrate_plus – migrate_tools – migrate_google_sheets – redirect When accomplished, your Drupal 10 module construction ought to appear to be this Drupal 10 Upkeep and Help Service You are actually able to allow your My Migrations Drupal 10 module. (Be sure to disable Drupal Development Service migrate_google_sheets_example Drupal 10 module first, if you happen to’d beforehand enabled that!) Step 2 Drupal 10 Upkeep and Help Service Create Your Spreadsheet Assuming you could have Drupal Development Service Recreation and Touchdown web page content material sorts, you can now run Drupal Development Service migrations in your “My Migrations” Drupal 10 module and it’ll pull Drupal Development Service knowledge from Drupal Development Service Google Sheet. However because you don’t have permissions to edit that sheet, you’re going to wish to repeat Drupal Development Service current sheet and create your personal to do any customizations. When that is performed, you’ll get a url like this Drupal 10 Upkeep and Help Service https Drupal 10 Upkeep and Help Service//docs.google.com/spreadsheets/d/YourLongHashIDHere the place YourLongHashIDHere is your feed key. Now you’ll have to publish your new spreadsheet. That is an choice beneath “File” -> “Publish to Drupal Development Service internet” To confirm that your migration Drupal 10 module will be capable to see Drupal Development Service Google sheet, strive opening an nameless browser window and visiting Drupal Development Service Feed model of Drupal Development Service url, whose format is that this Drupal 10 Upkeep and Help Service https Drupal 10 Upkeep and Help Service//spreadsheets.google.com/feeds/record/YourLongHashIDHere/SHEET/public/values?alt=json If visiting that URL throws out a bunch of json, you’re prepared to start out migrating! However after all, your present set of migration recordsdata nonetheless level to Drupal Development Service previous feed. In Drupal Development Service my_migrations/config/set up folder, you’ll want to search out all cases of our feed string (1spS1BeUIzxR1KrGK2kKzAoiFZii6vBHyLx_SA0Sb89M) and substitute them along with your feed string. Step 3 Drupal 10 Upkeep and Help Service Determine Which Migrations to Maintain Drupal Developer Migrate Google Sheets Instance Drupal 10 module gives one Migration Group (games_example) and 6 Migrations. Relying in your web site configuration, a few of these is perhaps helpful, like Drupal Development Service menu_links and Drupal Development Service blocks migrations, and a few of them is not going to be so helpful (like Drupal Development Service node_game migration, possible). It is a good time to trim or modify any migrations that aren’t going to be helpful to your web site. That being mentioned, right here are some things that Drupal Development Service pattern migrations reveal Drupal 10 Upkeep and Help Service Block UUIDs Drupal 10 Upkeep and Help Service Once you place a block utilizing Drupal Development Service Block Format display screen, Drupal Development Service block’s UUID is saved in config. For those who’re working a migration again and again, your block’s ID will iterate by itself, however Drupal Development Service UUID can stay fixed if you add it to Drupal Development Service migration. In Drupal Development Service demo web site, this permits us to create a persistent CTA block in Drupal Development Service header. Menu Hyperlinks mother and father Drupal 10 Upkeep and Help Service You’ll be able to specify {that a} menu hyperlink merchandise has a father or mother from inside Drupal Development Service present migration. This lets us say /bohnanza and /hanabi are youngsters of /video games Web page and Recreation redirects Drupal 10 Upkeep and Help Service These sheets reveal how you can add Drupal Development Service redirect from Drupal Development Service url of content material on an previous web site to Drupal Development Service new house proper in Drupal Development Service content material sheet. Attempt going to https Drupal 10 Upkeep and Help Service//live-mgs-demo.pantheonsite.io/that-fireworks-game and see the place you find yourself. Associated content material as strings or ids Drupal 10 Upkeep and Help Service On Drupal Development Service Web page sheet, we have now a reference to Drupal Development Service “Associated video games” for Drupal Development Service given web page. That is an entity reference which we might fill with a few issues. We might consult with Drupal Development Service ID of Drupal Development Service associated video games, as they’re saved in Drupal Development Service Video games sheet, or we might do what we’ve performed right here and use Drupal Development Service migrate_plus plugin “entity_lookup” to seek for Drupal Development Service associated recreation node by identify. So long as there’s a Recreation node referred to as Bohnanza, we’ll all the time hyperlink to Drupal Development Service proper one. That is notably helpful with Time period references, the place Drupal Development Service identify of Drupal Development Service merchandise ideally stays fixed. Recreation downloadable file Drupal 10 Upkeep and Help Service Video games have related photographs, that are recordsdata hosted externally to Drupal Development Service spreadsheet. So as to relate my recreation content material to its picture, I have to obtain Drupal Development Service picture, get it into Drupal Development Service file_managed database desk (making a file entity) and THEN relate that entity to Drupal Development Service present node. That is performed with Drupal Development Service following traces in Drupal Development Service “node_games” migration Drupal 10 Upkeep and Help Service public_file_directory Drupal 10 Upkeep and Help Service plugin Drupal 10 Upkeep and Help Service default_value default_value Drupal 10 Upkeep and Help Service ‘public Drupal 10 Upkeep and Help Service//’ public_file_uri Drupal 10 Upkeep and Help Service plugin Drupal 10 Upkeep and Help Service concat delimiter Drupal 10 Upkeep and Help Service ” supply Drupal 10 Upkeep and Help Service – @public_file_directory – imagefilename field_image/target_id Drupal 10 Upkeep and Help Service – plugin Drupal 10 Upkeep and Help Service file_copy supply Drupal 10 Upkeep and Help Service – picture – @public_file_uri – plugin Drupal 10 Upkeep and Help Service entity_generate field_image/alt Drupal 10 Upkeep and Help Service imagealt field_image/title Drupal 10 Upkeep and Help Service imagetitle You’ll be able to hold as many or as few of Drupal Development Service migration recordsdata as you’d like. You may also create new ones. Step 4 Drupal 10 Upkeep and Help Service Inform About Your Adjustments 8 solely sees Drupal Development Service adjustments you’ve made to your migration yml recordsdata whenever you first set up Drupal Development Service Drupal 10 module. That signifies that it is advisable to uninstall and reinstall Drupal Development Service Drupal 10 module to make new adjustments present up. ThinkShout has a Robo script that does this, however Drupal Development Service identical factor may be performed in Drush Drupal 10 Upkeep and Help Service drush mr –all # Rolls again all migrations drush pmu my_migration -y # Disables my migration Drupal 10 module drush en my_migration -y # Allow my migration Drupal 10 module drush ms # Shows my present migration standing You may also string these collectively as one line Drupal 10 Upkeep and Help Service drush mr –all && drush pmu my_migration -y && drush pmu my_migration -y && drush ms Step 5 Drupal 10 Upkeep and Help Service Run your migrations This half is straightforward. To run all migrations, it’s a fast drush command Drupal 10 Upkeep and Help Service drush mi –all For those who’d like to search out out about all Drupal Development Service doable choices for Drupal Development Service migrate-import command, you may run drush assist mi You may also see your record of migration teams at /admin/construction/migrate, and you may evaluation your migrations by clicking “Checklist Migrations.” Drupal Developer ensuing web page provides you with Drupal Development Service identical output, roughly, that you just get from working a drush ms. These pages are useful to learn about, as they offer you a simple place to search out errors logged throughout Drupal Development Service migration course of. Nonetheless, you may’t presently run a migration from Drupal Development Service UI (though there is a matter for this). Gotchas However earlier than we shut, I do need to acknowledge some challenges we’ve seen on this strategy. Unhappy truth #1 Drupal 10 Upkeep and Help Service HTML in a spreadsheet is ugly. Google Spreadsheets don’t allow you to make your rows smaller than Drupal Development Service variety of line breaks in a cell. So if in case you have fairly html with a bunch of line breaks, your row is perhaps too tall to suit in your display screen. Folks have some intelligent workarounds for this, however up to now we’ve not carried out any. Unhappy truth #2 Drupal 10 Upkeep and Help Service Sheet order issues (proper now) Sustaining Drupal Development Service order of sheets isn’t prime on everybody’s minds as they’re making adjustments to a spreadsheet, particularly when duplicating tabs. Migrate Google Sheets asks for every sheet based mostly on tab order. If I make a replica of Drupal Development Service Web page tab, Drupal Development Service Recreation tab is now Drupal Development Service fourth tab as an alternative of Drupal Development Service third tab. Because it stands now, Drupal Development Service Drupal 10 module will fortunately request columns that don’t exist on Drupal Development Service third tab after which fail in puzzling methods. There may be presently just one subject in Drupal Development Service subject queue for Drupal Development Service Migrate Google Sheets Drupal 10 module, and it’s to repair this. Unhappy truth #3 Drupal 10 Upkeep and Help Service Google sheets should be publicly viewable to work (once more, proper now) As Drupal Development Service Drupal 10 module exists proper now, there’s no authentication concerned, so any migrated content material should be publicly viewable. Google authorization is feasible with Oauth2, however that isn’t presently carried out. Conclusion Thanks for following alongside! I hope you discovered this collection useful. And don’t neglect to go to Drupal Development Service Migrate Google Sheets subject queue if you happen to discover any bugs, have an concept for a function, or need assistance! Drupal 10 Growth and Help