56 comments found.
Hello
We buy the item (Export/Import – MySQL Data ) from 06-03-2021. It was working fine for all our export/import till date.
From today we face issues for getting it work. We can not Import/Export the Excel file. It is always 0KB.
So what we want to know, is it a any version issue or something more. As it is a Regular license, so there does not need any upgrade.
Please let us know ASAP.
Are you upgrade php version?
I’m interested. I use php 8.1, but I saw only php_gd module, I didn’t see php_gd2. What should I do?
Is it possible to create a football table with the image of the logos?
Hi, how do I use version 2.6 for php 7.4. Is there a new download to do for this version? If yes, how can I proceed? Thank you
Hi,
Please give me your mail address. I will send 2.6 old version project.
Thank you
Hi, is it possible to use your software in a php version lower than 8? eg. 7.4.21? If yes, how can I proceed to modify the code, because at the moment it gives me an error. Best regards, Matteo
You can use old version 2.6 for php 7.4 version.
Thank you
Hi … i want to purchase this but the demo doesnt seem to work to import excel. Would love to see a working demo. PLs check and advise. Thanks
Demo site is working. Please try again. Thank you
Still not working … when importing an excel (xls) file, i get the following error:
SQLSTATE22007: Invalid datetime format: 1366 Incorrect integer value: ‘Irelan’ for column `themepos_exportimport_db`.`imported_data`.`Price` at row 1
OR do we need to follow a certain format for the excel file? since the error seems to be related to a format?
Hello!, i just want to know if there is an option to update if key exist. So if an existing key is already in the table just update the fields. if the key is not existing proceed to insert the full row. To avoid data duplication. Thank you!
Hello,
I made an array from excel file. You can use everything whatever you want to do.
Thank you so much
Greetings. I didn’t notice when I was demoing the script…but now that I have it it doesn’t seem like it supports drag/drop of files for importing. Is that right? The way the pages are designed it would suggest you can drag/drop, but it isn’t working for me on any browser type. Please advise.
My item is not supported drag/drop option. I will include drag/drop option in future.
Thank you so much
I found that first 4 rows of the excel file are not uploaded to database table. Can you please confirm on it?
Please send your excel file and php code. Via mail tspprt7@gmail.com
Thank you so much
I would like to extract random data from a spreadsheet
hi i buy the script but i have question i dont want to save imported file to db i just want to make for loop for excel rows how can i do it
Hello,
You can use ‘DataList’ variable in ‘ps-excel-import-server.php’ page. Please see the screenshot https://ibb.co/YNCh9nq
Thank you so much
hello im still leering php i face many errors because i dont have mysql can you please share script with me for only import then print html table without mysql like example 1 page only import and print table in same page
Hello,
Not possible excel import and print html table without MySQL database.
Hi , I have purchased your script. As shown in demo i am not able to find search option in export excel. Can you please help me
Hi, I am not understand your question. Please tall me details and share screenshot or link. Via mail tspprt7@gmail.com
Thank you so much
I would like to TRUNCATE TABLE before inserting the new data. I’m having trouble adding the TRUNCATE TABLE command can you please let me know the code and where to add it so it will do this?
Please see the screenshot link https://ibb.co/8DXxqQ7
Thank you so much
That worked thank you!
puedo exportar en una misma hoja varias tablas con distintos formatos? y lo otro que me interesa es saber si puedo generar un codigo para cada fila y aunque no este en mysql se muestre igual el titulo de dicha fila
Hello team
We need particular customization of this script, is it possible?
Hello,
Yes, It’s possible
Thank you so much
Thanks, how can we contact you?
We need to import 2 files (CSV) and compare the data in these files (such a data reconciliation) to find possible match data in the 2 files.
Please tell us how to contact you
how to import my database?
Hello,
Please see the documentation link: https://www.themeposh.xyz/demo/export-import/documentation/#installation
Thank you so much
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
Hi, I bought this app thinking I can use it to import a CSV into an existing DB. The CSV and the DB have the same fields exactly.
In the dbconnection.php I entered my db credentials. Then when clicking on export, I get Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘a6b7efb2_crud.excelexport’ doesn’t exist in html/sqlimportexport/ps-excel-export-data-list.php:78 Stack trace: #0
So this suggests I need a special table in my DB ?
The documentation only talks about a demo db, not anything else.
Please help, I need this working asap.
Regards, Tal
Hello,
Please check your insert sql. Are you insert sql table name and database table name same. Info ps-csv-import-server.php page.
Please see the screenshot https://ibb.co/Db0YWH9
Thank you so much
I don’t understand.
First of all the documentation does not say anything about it. 2nd I am trying to export so why do I need the import file ?
also I do not understand what I need to change in the screenshot ?
Hello,
Please send your ftp access and site link. I will try this problem solve. My mail address tspprt7@gmail.com
Thanks
By reading your sales page in codecanyon I can’t get quite enough for the use case of this app. I see it says “import/export – MYSQL Data” and I also bought it but I feel something is missing.. specially documentation is not clear. Work on showing the use case of this tool to your prospective buyers and try to improve documentation to get more sales. Share some use case in short at least please. What’s the difference of these demo1/ demo 2/demo 3/.. ?
Hello,
Demo 1, Demo 2, Demo 3, Demo 4, Demo 5, Demo 6 difference frontend design but backend all activities are same. Sorry for my mistake, i did not notice it here used some extra ‘use case’. I will correction it next update. You can use “use PhpOffice\PhpSpreadsheet\IOFactory;” i think it will work properly.
Thank you so much.
Thanks for your reply. I couldn’t follow what you are trying to say but I found this “PhpSpreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/IOFactory(.php)” What to do with this?
Hello,
Please send your ftp access and link. I will try this problem solve. My mail address tspprt7@gmail.com
Thanks
I have purchased an installed with success. I have a question, when I import how can I change the table name other than “imported_data”. For example Mysql table name is “purchase_no” and have 3 fields (no, po_no, invoice_no) and I want to import data from my excel file.
Hello,
Please send your excel file and ftp access. I will try this problem solve. My mail address tspprt7@gmail.com
Thanks