Code

Discussion on Export/Import - Laravel

Discussion on Export/Import - Laravel

Cart 27 sales

themeposh supports this item

Supported

This author's response time can be up to 1 business day.

24 comments found.

Hello! Does your script support column mapping? In which the columns of the CSV file are matched with the columns of the database table.

This option is not available. You will need to customize it.

Hello!

Help-me!

$hostname = “localhost”; $username = “futex_xlsx”; $password = “Excel-999”; $dbname = “futex_exportimport_db”;

Hi, looks nice, do you also offer installation support on existing project when i buy this script?

You can try to install. If you can’t install it then i will help you. Please see documentation https://export-import-laravel.themeposh.net/documentation

Thank you so much

hello, how can we use this with react JS admin panel? the back-end is node JS and mango db.? we just want to upload people’s details and it goes to our application can any of your scripts support this?

My script support laravel, php and mysql. Not support react js and node js.

Thank you

Hey – wondering if their is any “field mapping” from the import. drop down by column to select “first name”,”last name”, “email” and also “not import” for when either extra fields or different order of items in the fields?

Hi Team, the tool looks pretty good. Could be possible to automate an import to MySQL from a folder. Every time a new excel is received then will be imported

Yes, It’s possible. You have to customize and cron setup.

demo does seem to be working

is this project still working and what laravel 8 or 9 also does it import the excel and display the tables

Sorry for late reply.

Yes, Laravel 8, 9 and 10 version also working. I recently upgrading to 10.0 from 7.x.

Thank you so much

Can this be customized to use as a plugin inside a Laravel readymade CMS that lacks import/export feature?

Any response?

Hello,
I am working on a WordPress directory, would like to know if your script can retrieve the number of comments every listing has?
Thank you so much.
Anna

Hello,

My script not support in WordPress.

Thank you so much

Online demo doesn’t work, I choose a csv file and when I hit ‘upload’, nothing happens.

Domi

Hi,

thanks for your fast reply ! it’s working now like a charm … :-)

Sincerly, Domi.

Welcome

I mean that if everything in this is included in this product: https://codecanyon.net/item/mysql-data-to-excel-export-laravel/25779191 thanks

Hi,

Not included these feature in this item https://codecanyon.net/item/mysql-data-to-excel-export-laravel/25779191

Thank you so much.

Thank you, I already acquired only the excel one, leave you some comments, I will take your help, for several things, if I need to pay you support, let me know. I am very interested. Thank you

Hello, this project includes for export to excel, the same as the one that is only for exporting excel that you now have in $ 20 dlls. Thank you

hello! before the purchase i hace two questions, does it check for duplicate entries? if it finds duplicate then does it skip or update?

Hi,

Question 1. does it check for duplicate entries?

Answer: I did not check for duplicate entries.

Question 2. if it finds duplicate then does it skip or update?

Answer: I did not used php condition but you can used php condition.

Thanks

Pre-sale question : What is the maximum file size I can upload and how long does it take to upload? does it check for duplicate entries? if it finds duplicate then does it skip or update?

i want one page for search in my all data by user or email.

Hi,

You can easily use field add or remove in export/import pages.

Thanks for comment.

Hi this is a cool project, we recently worked with a client who had a big excel spreadsheet it was so huge that it would often crash when opening on Google sheets or local excel.

We could use this tool but it only lacks one feature (from what I see in your screenshot) – building custom report based on data imported. So we will be able to build visualized data (ie selection of charts)

Is it something you might consider?

Hi! When I import an excel table, if a cell has link, is it imported too?

Thanks!

Hi,

Sorry for the late reply. Just add the code

”$spreadsheet->getActiveSheet()->setCellValue(‘E26’, ‘www.phpexcel.net’); $spreadsheet->getActiveSheet()>getCell(‘E26’)>getHyperlink()->setUrl(‘https://www.example.com');".

You can easily import hyperlinks of cells.

See the link: https://phpspreadsheet.readthedocs.io/en/latest/topics/recipes/#change-a-cell-into-a-clickable-url

Thank you so much

Hi! I want buy your plugin. A cuestion: Whe i import xls, too import hyperlinks of cells? Thanks!

Hi,

Sorry for the late reply. Just add the code

”$spreadsheet->getActiveSheet()->setCellValue(‘E26’, ‘www.phpexcel.net’); $spreadsheet->getActiveSheet()>getCell(‘E26’)>getHyperlink()->setUrl(‘https://www.example.com');".

You can easily import hyperlinks of cells.

See the link: https://phpspreadsheet.readthedocs.io/en/latest/topics/recipes/#change-a-cell-into-a-clickable-url

Thank you so much

Don’t working for me. Error message:

SQLSTATE01000: Warning: 1265 Data truncated for column ‘Price’ at row 1 (SQL: insert into `imported_data` (`ItemName`, `ItemCode`, `Date`, `Price`, `Quantity`, `EItype`, `libType`) values (AUDI, A1 Sportback , 1970-01-01, 8XA, CAYC, excel, PhpSpreadsheet))

Hi,

Now you can try, i think is ok.

Thanks

by
by
by
by
by
by

Tell us what you think!

We'd like to ask you a few questions to help improve CodeCanyon.

Sure, take me to the survey