This is one thing I always wondered how to do. My general approach was to not store the data in the database temporarily, but use arrays in code to output the data... This is a much more elegant way of performing this, so much so, it'll work great on a current project I am currently working on. Thank you for your continued hard work and effort - It's absolutely appreciated.
Cool! It would be nice to optimize this for bigger files (million rows for example) without building an array in memory. Using fgetcsv or SplFileObject with a generator
I'm trying of run your project and I got this error mybd.people' doesn't exist (SQL: select count(*) as aggregate from `people`) when I'm tried to acces to / endpoint ? what could be?
Okay, so I have a Countries, States and Cities CSV file with 4,3 million entries and the file is about 1gb. I want to divide it into countries, states and cities table, and making pivot table that will organize everything. Is this the right place to start? Or would the best idea be to hire someone who can do this for me? Or is there a way just generating a database seeder from the file?
When is good idea to switch from saving many settings like JSON object in one column(I saw this for csv_data column) instead of making new table with all the column needed respectively?
Hello, I would like to see how to export data from database into csv file. I have status fields and etc in database as integers. The main problem I am facing, how to cast values for users to understand values. I can cast data in models, but how transform data only when calling csv export?
Hello Povilas! I have been following your channel for some time now, thank you for providing us with quality materials :). I got a question and I hope you can give me your opinion on this one: I started working recently for a new company and I got a project, its about making a tender platform for a client with a lot of background functionality (accounting stuff, service books etc.) This first client is in hospitality/service business. But my boss has an idea to make this platform very flexible, so that it can be used by other businesses too (next client is from leasing/transportation branch with their specific requirements). I don't see any intersecting areas between these business domains, except that they need similar platform for their tenders. How would you approach such problem? I am not sure how to even create Models for this project (my boss has an idea of "on-the-fly" Models - to be honest I never heard something like that). Thank you, your opinion would be very appreciated.
honestly I dislike the new Laravel Excel, it makes everything way more complicated than needed and lacks docs about doing more complex things, had to fall back directly to phpspreadsheet to get things done
![SahBabii - Viking [Official Music Video]](http://i.ytimg.com/vi/D37cL92JX0I/mqdefault.jpg)
Wow this morning I woke up with the idea of providing an importing tool to my company, and you just read my mind and paved my way. Thank you so much.
This is one thing I always wondered how to do. My general approach was to not store the data in the database temporarily, but use arrays in code to output the data... This is a much more elegant way of performing this, so much so, it'll work great on a current project I am currently working on.
Thank you for your continued hard work and effort - It's absolutely appreciated.
Another gem video from my favorite channel.
Thanks
Cool! It would be nice to optimize this for bigger files (million rows for example) without building an array in memory. Using fgetcsv or SplFileObject with a generator
I use fgetcsv, yield, lazy collection then chunk to do bulk insert
Does it work with a 1GB file?
I'm trying of run your project and I got this error mybd.people' doesn't exist (SQL: select count(*) as aggregate from `people`) when I'm tried to acces to / endpoint ? what could be?
Hi, how would we go about applying the Import CSV function to multiple different datatables? Thanks!
I don't get why do we need whole table for some temporary data, and what if multiple people use this tool almost simultaneously?
For multiple people you can put some identifier like user id in that exact table
Okay, so I have a Countries, States and Cities CSV file with 4,3 million entries and the file is about 1gb. I want to divide it into countries, states and cities table, and making pivot table that will organize everything. Is this the right place to start? Or would the best idea be to hire someone who can do this for me? Or is there a way just generating a database seeder from the file?
When is good idea to switch from saving many settings like JSON object in one column(I saw this for csv_data column) instead of making new table with all the column needed respectively?
Nevermind, found your video about this. ruclips.net/video/9uhXI4nDpOQ/видео.html
Hello, I would like to see how to export data from database into csv file. I have status fields and etc in database as integers.
The main problem I am facing, how to cast values for users to understand values. I can cast data in models, but how transform data only when calling csv export?
with that package, you can export the data as you want like full customization before export it
Thanks
Hello Povilas! I have been following your channel for some time now, thank you for providing us with quality materials :).
I got a question and I hope you can give me your opinion on this one: I started working recently for a new company and I got a project, its about making a tender platform for a client with a lot of background functionality (accounting stuff, service books etc.) This first client is in hospitality/service business. But my boss has an idea to make this platform very flexible, so that it can be used by other businesses too (next client is from leasing/transportation branch with their specific requirements). I don't see any intersecting areas between these business domains, except that they need similar platform for their tenders. How would you approach such problem? I am not sure how to even create Models for this project (my boss has an idea of "on-the-fly" Models - to be honest I never heard something like that). Thank you, your opinion would be very appreciated.
I can't answer this in a short RUclips comment, sorry, would need to analyze the situation deeper.
@@LaravelDaily I understand... Hopefully, I'll find a way out. Thank you for the reply though :)
honestly I dislike the new Laravel Excel, it makes everything way more complicated than needed and lacks docs about doing more complex things, had to fall back directly to phpspreadsheet to get things done
Does it have to be Laravel 8 for this package to work? I am using laravel 9 for my current project
Or was this upgraded to laravel 9?