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.

Files: 

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

StatusFileSize
new1.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
StatusFileSize
new2.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

#8: views_data_export_support_ANSI.patch queued for re-testing.

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.