Code

Discussion on Export/Import - MySQL Data

Discussion on Export/Import - MySQL Data

Cart 198 sales
Recently Updated

themeposh supports this item

Supported

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

62 comments found.

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

Hello,

Please contact with me, my mail address tspprt7@gmail.com

Thank you so much

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

It would be nice to set date. What if I have a 15 years database and I want to pull just the last month. Can you do that with the current plugin? or is this something you can add?

Hello,

You can export 4000 rows, Please try it demo link https://www.themeposh.xyz/data_export_limit/

Thanks

Any plan to run a sale in near future?

I mean, developers occasionally run offers like 50% limit period discount sale.I would like to purchase it during sale, if any with such offer. Thanks

If you want buy it then i will added limit offer for some time.

Thanks

You can buy it

This is script is fantastic it helped me import xml data into my MySQL server

Thanks for your good appreciation. It’s help me very much for my works.

Hi, The script isn’t working for me. I downloaded the script and followed documentation, but when tried to import excel file, nothing happened at all. I have installed it on wamp

Hello,

Please give me your ftp access. I will try this problem solve. My mail address tspprt7@gmail.com

Thanks

Ji, I need to convert a csv / xlsx file to MySql. Does your product do that?

Hi,

Yes, you can excel or csv file easily upload,you just database table field and excel or csv column same structure. Please try it.

http://themeposh.com/demo/export-import/export.php http://themeposh.com/demo/export-import/import.php

Thanks

Hello, although I already bought, I am reviewing and I think that your demos to import are not working.

what is the limitation on row and column data

Hello,
I am interested in your item, just sent you an email at tspprt7@gmail.com
Regards.

Hi,

Please check in your mail.

Thanks

The demo is throwing an error for the Excel Import

Your demo import don’t work!!!!

Thank you for your reference. But of course I had already tried this. The message that you will receive is (with an uppercase extension): Sorry, only .csv file are allowed.

After a closer look with debug It appears that the extension can only be .csv and that .CSV is being rejected (there are many applications that make no difference between upper or lower case)

So the demo works but then you have to state that the extension must be .csv (lower case).

Hi,

Yes, .CSV extension file import problem. I will import problem solve the extension .CSV file next update.

Thanks.

Hello, I have a question about your CSV Import & CSV Export application. Frist, I want to say that I don’t have a lot of experience with Import/ Export from SQL. I want to buy this script https://www.phpjabbers.com/vacation-rental-script/ The problem with this script is that it has no import or export feature. My question is this app can help me import property lists? Thank you

Hi,

You can easily export and import if you don’t used any framework in your project. My item is developed in raw PHP.

Thanks

Hi again Thank you on your answer. What do you mean by any framework. The script should only be based on php? Thanks again

Hi,

Yes, It is php. It will be good if will do it. My item not supported framework(As like: Laravel, Codelgniter, CakePHP etc..).

Thanks

Hi, How do we get the sum of one field?

Hi

Please see the documentation.

For PHPExcel:

1. http://themeposh.com/demo/export-import/documentation/assets/PHPExcel-developer-documentation.doc

2. See the point “5.Performing formula calculations”.

For phpspreadsheet:

3. https://phpspreadsheet.readthedocs.io/en/latest/topics/calculation-engine/#performing-formula-calculations

Thank you

why you do not combine with laravel

I will combine with laravel soon.

Thanks a lot for advice

Good afternoon, tell me your script does not export from format YML to any of these formats .mxl .txt .xls??

Hi Dear,

My script mysql database to excel, csv formats can export but can not export format YML to formats .mxl .txt .xls

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