search

kjac / FormEditor

A form builder editor for Umbraco 7 - let your editors build forms easily with this free package.
MIT License
99 stars 42 forks source link

Should be comma separated not semi-colon separated. #154

Closed dbardi closed 7 years ago

dbardi commented 7 years ago

https://github.com/kjac/FormEditor/blob/600c91b22bab6d9b04b5ec8d8d45bacb8760cb99/Source/Solution/FormEditor/Api/CsvExport.cs#L115

dbardi commented 7 years ago

Maybe an option in the FormEditor.config or the datatype to set the delimiter.

uniquelau commented 7 years ago

Excel struggles with reading the export, examples below:

excel screenshot

Form data 2017-11-08 12-34.xlsx

kjac commented 7 years ago

@uniquelau @dbardi I meant to address this issue earlier today but got distracted.

As of version 1.3 the delimiter is configurable in the Form Editor config file; check the docs for more insight.

@dbardi please note that the config syntax is a little bit different from your original PR.

uniquelau commented 7 years ago

Set to comma, and Excel is happy 👍

kjac commented 7 years ago

I'm beginning to suspect that my Excel is the only one in the whole wide world that likes semicolons better... :P

Den 8. nov. 2017 4.12 PM skrev "Laurence Gillian" <notifications@github.com

:

Set to comma, and Excel is happy 👍

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/kjac/FormEditor/issues/154#issuecomment-342847265, or mute the thread https://github.com/notifications/unsubscribe-auth/AHD_Cp-wzpaqh5czpRPe3SNzBnSMGGkgks5s0cTbgaJpZM4QDe46 .

kjac commented 7 years ago

Closing this now :)

uniquelau commented 6 years ago

For future reference, I think this issue is a regional/windows issue, as I noticed UI-O-Matic is working in the same way, using a semi colon.

https://github.com/TimGeyssens/UIOMatic-Addons-Export https://github.com/TimGeyssens/UIOMatic-Addons-Export/issues/3

More details here: https://stackoverflow.com/questions/10140999/csv-with-comma-or-semicolon