That is it. I need update dsts from my database. I receive a .xls file from client with the new position of consumers. With your lesson i can update my database. THANK YOU VERY MUCH, and congratulation for this job.
doing foreach column and updating or inserting results many queries when working with thousands of records, :( is there a cleaner and optimized version for this?
Great video, thank you so much... If i would want to add and edit some rows at the same time.. is it possible? for example could I export the file, add a new row and import back? I'm waiting for your answer.. thanks!!!
Hello and thank you very much for this tutorial but I have a concern most of the time we import and export with the HeadingRow I would like to know how to do the same with the Update of the EXCEL file
The video is very clear, thank you. When I try this using SQL Server I get this error: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error converting data type nvarchar to bigint. (SQL: select top 1 * from [schedules] where [schedules].[id] = import) No matter what I do, cannot pass it. It is an issue with the Database? Thanks for the help.
That is it. I need update dsts from my database. I receive a .xls file from client with the new position of consumers. With your lesson i can update my database. THANK YOU VERY MUCH, and congratulation for this job.
Большое спасибо! У Вас чудесные уроки!
Its posible to get the columns from the excel and add them to a model as a column too dinamcally? They're about 200+ columns
thanks , i love Master
doing foreach column and updating or inserting results many queries when working with thousands of records,
:(
is there a cleaner and optimized version for this?
great video! thank you a lot!
Thank you so much, I have done this in my project and it works fine.
Great video, thank you so much... If i would want to add and edit some rows at the same time.. is it possible? for example could I export the file, add a new row and import back? I'm waiting for your answer.. thanks!!!
Your question was "is it possible"? Yes, possible. But sorry, I won't this write code for you, it would be a big separate tutorial.
Hello and thank you very much for this tutorial but I have a concern most of the time we import and export with the HeadingRow I would like to know how to do the same with the Update of the EXCEL file
I have to write to existing xlsx file
Thanks so much for the video...but if i want to import more rows in database it's not importing can u guide me for that
How pass foreign key id, if I want for example import certain company's projects? Or export certain company projects.
thank u for this videos sir...question though how to export with search query params. hope you noticed my comment 🙂
I want example for importing excel data to update the foreign key value in table while importing
Sir how to import 2 column merged heading in excel.
Hi sir I followed your video but i always get this error when I want to import "File could not be read".Thank you
can we upload images from excel file to laravel local storage?
The video is very clear, thank you. When I try this using SQL Server I get this error: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error converting data type nvarchar to bigint. (SQL: select top 1 * from [schedules] where [schedules].[id] = import)
No matter what I do, cannot pass it. It is an issue with the Database? Thanks for the help.
Already figured it out. Was a routing issue.
very nice
Hello, I can not do this! Can you help me? I realize that this is your job, and time is money, I would pay for work, I'm waiting for an answer.
what is the bugs. send here and i'll fix it for you (free)
what text editor didyou use on this video?
PhpStorm
Amazing, Is there coupon code available?
Just generated a friendly 10% code for you: SAMI10 (or someone can use it if they see it first) :)
@@LaravelDaily Thank you :) i win it :)
You could use the method updateOrCreate from laravel.com/docs/5.7/eloquent#updates right?
Yes, if you want to create new entries in your Excel and import them back, then this method would be very useful.
But how to export in csv
just change the extension
Somebody here work this with mondb?