I need to export my data in CSV using ANSI. I modified the module to allow this, as an option when creating the view. Any comment is welcome.

CommentFileSizeAuthor
#8 views_data_export_support_ANSI.patch2.29 KBkupide
FAILED: [[SimpleTest]]: [MySQL] Unable to apply patch views_data_export_support_ANSI.patch. Unable to apply patch. See the log in the details link for more information. View
#4 1077084.patch1.92 KBessbee
FAILED: [[SimpleTest]]: [MySQL] Unable to apply patch 1077084.patch. Unable to apply patch. See the log in the details link for more information. View
ansi_support.patch1.99 KBenboig
FAILED: [[SimpleTest]]: [MySQL] Unable to apply patch ansi_support.patch. Unable to apply patch. See the log in the details link for more information. View
Members fund testing for the Drupal project. Drupal Association Learn more

Comments

Steven Jones’s picture

Version: 6.x-2.x-dev » 7.x-3.x-dev
Assigned: enboig » Unassigned
Status: Needs review » Needs work

Thanks for the patch, this is actually encoding into the ISO-8859-1 standard, more commonly known as Latin 1, not 'ANSI'. Not sure how I feel about adding character conversion to the export options however.

Could the patch be re-rolled for the 7.x-3.x branch, and we can integrate there please?

enboig’s picture

I just use drupal6, I don't know how to port it to D7.

I modified the module because some users wanted to open files in microsoft excel, which have problems with utf8 encoding; and it is really useful to me.

hvalentim’s picture

Thanks a bunch!
I needed this myself. A lot of formats - say of location coordinates - are variations of CSV. One can use CSV to export to them but many programs - say OziExplorer - expect ANSI, not UTF8.

essbee’s picture

FileSize
1.92 KB
FAILED: [[SimpleTest]]: [MySQL] Unable to apply patch 1077084.patch. Unable to apply patch. See the log in the details link for more information. View

Have rolled against the Latest 7.x dev.

I think this is valuable, in a similar vein to hvalentim some programs are very specific about the input file format.
I would also like to see control over line endings. I'll post a follow up patch if I get something useable on that front.

tahiche’s picture

This was very helpful. Thanks a lot!!.

Steven Jones’s picture

Status: Needs work » Fixed

Pushed to all branches, thanks!

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

kupide’s picture

Status: Closed (fixed) » Active
FileSize
2.29 KB
FAILED: [[SimpleTest]]: [MySQL] Unable to apply patch views_data_export_support_ANSI.patch. Unable to apply patch. See the log in the details link for more information. View

Hi

Why the ANSI format is no longer supported ?

I have created a patch for the version 7.x-3.0-beta6

zkday’s picture

Status: Active » Needs review

Patch #8 worked for me.

Thanks,
zkday

Status: Needs review » Needs work

The last submitted patch, views_data_export_support_ANSI.patch, failed testing.

kupide’s picture

Status: Needs work » Needs review

Status: Needs review » Needs work

The last submitted patch, views_data_export_support_ANSI.patch, failed testing.

NWOM’s picture

Issue summary: View changes

This patch needs to be rerolled again it seems. Would love for this support as well.

  • Steven Jones committed b6025ff on 7.x-4.x
    #1077084 by essbee, enboig, Steven Jones: Added Added support for ansi...
amoebanath’s picture

Version: 7.x-3.x-dev » 7.x-4.x-dev
Status: Needs work » Fixed

The new exporters in 7.x-4.x happily export to a wide range of encodings. 'ANSI' is not a valid encoding name input for Iconv, however - you need to use Windows-1252. This will be specifically mentioned this in the option's helper comment.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.