Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Datatables Excel export issue
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: Datatables Excel export issue
#59294
Datatables Excel export issue 7 Years, 10 Months ago Karma: 0
Hi

I use CSV export my table, some Chinese words display incorrectly;

I change to Excel format to export, it still save as csv file. what happened?

thanks
The administrator has disabled public write access.
 
#59296
Re:Datatables Excel export issue 7 Years, 10 Months ago Karma: 760
Hello,

The extension uses "DataTables" jQuery plugin and it generates CSV report (even if "Excel" is selected, it means the file can be opened in MS Excel application) and currently it works with English characters only.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#59451
Re:Datatables Excel export issue 7 Years, 9 Months ago Karma: 0
I too have an issue with this.

Standard CSV export includes unwanted data in one column

Excel CSV export contains unwanted data in many columns

I am using SQL import from one table in my dB using the following SQL

Code:

SELECT `created`, `name`, `email`, `message`, `phone` FROM `j25_chronoengine_chronoforms_datatable_site_main_contact` WHERE  `name` IS NOT NULL 
LIMIT 0 , 30



The table display correctly from the module and no unwanted data is displayed.

Attached are two exports which display the unwanted data.

I can give site access if required.

Regards

Chas.
The administrator has disabled public write access.
 
#59452
Re:Datatables Excel export issue 7 Years, 9 Months ago Karma: 0
Files didn't upload, attached is a zip with files in.
File Attachment:
File Name: two_CSV_files.zip
File Size: 1497
The administrator has disabled public write access.
 
#59454
Re:Datatables Excel export issue 7 Years, 9 Months ago Karma: 760
Hello,

It seems this is a problem with email cloak plugin.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#59460
Re:Datatables Excel export issue 7 Years, 9 Months ago Karma: 0
OK, as that's a default part of Joomla, will you investigate a fix for it please?
The administrator has disabled public write access.
 
Go to topPage: 12