This episode is for members only
Sign up to access "Build a Livewire CSV Importer/Exporter" right now.
Get started
Already a member? Sign in to continue
Playing
10. Marking the export as complete
Episodes
01. Introduction and demo
2m 43s
0%
02. Fresh project with Breeze
2m 1s
0%
03. Creating and seeding transactions
5m 4s
0%
04. Building a basic datatable
20m 2s
0%
05. Casting money
2m 2s
0%
06. Launching the export modal
9m 10s
0%
07. Creating an export record
7m 33s
0%
08. Exporting with Laravel Excel
12m 55s
0%
09. Queuing the export
7m 32s
0%
10. Marking the export as complete
2m 24s
0%
11. Notifying the user
5m 18s
0%
12. Showing all exports
6m 44s
0%
13. Securely downloading exports
6m 11s
0%
14. Launching the import modal
2m 44s
0%
15. Handling CSV file upload
8m 59s
0%
16. Creating an import record
2m 44s
0%
17. Handling the import
11m 56s
0%
18. Showing all imports
3m 46s
0%
19. Marking an import as complete
3m 30s
0%
20. Storing exports per user
3m 16s
0%
21. Adding drag and drop uploading
8m 10s
0%
22. Expiring downloads
3m 19s
0%
Transcript
00:00
Because we are queuing our export now, what we can do is add on to the export chain. By that I mean we can just push on any new jobs that we want to follow on from the export process. To do this we use the chain method and we just pass an array of any jobs that we want to push on.
00:20
So let's go ahead and add in a job to mark this export as complete, which we know over in the database is this complete at that column. I'm just going to get rid of what we have in here so far. And just to keep things nice and tidy let's get rid of both of these as well.
00:37
Okay so what do we want to do here? Well we want to create out a new job, so our own custom job now that we can push. And we're going to call this mark export complete. We'll create one for imports as well a little bit later.
00:52
Okay so let's new this up, so new mark export complete. And what do we want to pass into here? Well we want to pass the export itself because that's what we need this to be aware of. And of course we need to actually update this model.
01:05
So over in the constructor for this job let's go ahead and put in that export. And there we go, so under handle all we really need to do here now is say this export and touch completed at. That will push the current timestamp, current date and time to that column.
01:26
And before we forget let's go over to our export model and let's just make sure we have the completed at cast here to a date time. And we should be good. Okay let's go ahead and just export out 10 or so of these records just to check this out.
01:48
And we know that over here completed at should be filled once this export process has finished. So let's go over to the database and yeah sure enough completed at has finished and it has been filled in. Now obviously this was very quick but the longer the process the longer this is going to take.
02:06
And we can actually use this completed at column a little bit later to show a status when we list out all of the exports that we're waiting for. Let's head over to the next episode though and create out another thing that we can push into this chain which is alerting the user by email when the export is complete.
22 episodes•2 hrs 18 mins•1 month ago
Overview
Let's build a powerful CSV importer and exporter with Livewire, completely from scratch.
This can handle millions of rows, be reused for multiple models, and by using queues, doesn't require the browser to be open.
This course is for you if:
- You need a robust drop-in importer and exporter component for your models that you have full control over
- You want to brush up on some advanced Livewire concepts
- You want to learn about queues in Laravel
Alex Garrett-Smith
Hey, I'm the founder of Codecourse!
Episode discussion
No comments, yet. Be the first!