Add Data From Excel Using

Publié le: 19 décembre 2022
sur la chaîne: Watch and Learn

5,077

In this episode I'm going to show you how you can add large number of data to your Directus database using #Excel and Flows.

Ok, let's do one more Directus Flow, well actually two flows that are going to work in conjunction with one another.

So imagine you have a movie database type of website, and you want to add a large number of movies to it. Currently, you have those movies stored in a Google Sheets or an Excel Document. Of course, you don't wanna do that by hand, because it will take a long time to do it.

We can use Flows for this type of scenario, we will first save our Google Sheets or Excel document to a CSV file. We are going to parse that file on the front end and create a JSON object which we will send to a Directus Webhook, that will in turn trigger our first Flow. Since we are receiving an array of objects we can create a kind of for each loop by triggering another Flow for every object in that array. That other Flow is just simply going to add the data from the object it receives to the Movie collection.

Ok, so let's do this.

Code used in this video

https://bit.ly/3G4hW87

You can support my work on Patreon

/ watchlearn

Follow me on Social Media

Github: https://github.com/ivandoric
Twitter: / ivan_doric

Sur cette page du site, vous pouvez voir la vidéo en ligne Add Data From Excel Using durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Watch and Learn 19 décembre 2022, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 5,077 fois et il a aimé 88 téléspectateurs. Bon visionnage!

701