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


Recent Events
  • 18/11/2017 Black Friday is coming

    Don't wait BLACK FRIDAY, use FRIDAY17 coupon code to get 35% discount for all our extensions right now.

  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.


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 11 Months, 2 Weeks 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 11 Months, 2 Weeks ago Karma: 670
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 10 Months, 2 Weeks 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 10 Months, 2 Weeks 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 10 Months, 2 Weeks ago Karma: 670
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 10 Months, 2 Weeks 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