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


Recent Events
  • 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.

  • 14/04/2017 Happy Easter

    Wish a Happy Easter and give 30% discount for all our WordPress and Joomla! extensions. Use EASTER17 coupon code. The offer is valid till 17 April.


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 9 Months, 3 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 9 Months, 3 Weeks ago Karma: 667
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 8 Months, 3 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 8 Months, 3 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 8 Months, 3 Weeks ago Karma: 667
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 8 Months, 3 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