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
#4 1077084.patch1.92 KBessbee
ansi_support.patch1.99 KBenboig

Comments

steven jones’s picture

steven jones commented
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

enboig commented

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

hvalentim commented

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

essbee commented
StatusFileSize
new 1077084.patch1.92 KB

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

tahiche commented

This was very helpful. Thanks a lot!!.

steven jones’s picture

steven jones commented
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

kupide commented
Status: Closed (fixed) » Active
StatusFileSize
new views_data_export_support_ANSI.patch2.29 KB

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

zkday commented
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

kupide commented
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

nwom commented
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

amoebanath commented
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.