Change CSV list separator in Attribute Widget

JosVroegop · ‎03-14-2013

Hello all,

I can't seem to change the list separator for the csv export in the attribute widget.
It's now "," and i would like to change it to ";" Does anyone know where to look?

I'm working with the 3.1 sourcecode. Thanks in advance.

Jos

BjornSvensson · ‎04-01-2013

FYI: In the next release (3.3), we're planning to add a "exportColumnDelimiter" option to both the API and Viewer for exporting with non-comma separators.

Thank you for your feedback.

View solution in original post

LucBourbousson · ‎03-21-2013

Same problem here. We use ";" as standard separation in csv so extracted csv are not displaying in columns.
It would nice to have csv list separator as a config tag in the widget.
Thx for your help

RhettZufelt · ‎03-21-2013

Wouldn't that, by definition, make it a SSV?

R_

Sorry, couldn't resist 🙂

JosVroegop · ‎03-21-2013

The default delimiter can vary by country. For example, in the Netherlands, he standard delimiter is a ";"

Although the name would suggest otherwise, a csv file is then expected to have this default delimiter to display correctly in for instance MS Excel .

Of course this could all be easily changed in your system settings but then all your users would have to do so as well.

LucBourbousson · ‎03-27-2013

I think it would be much easier and less intrusive to change the separating character at the source: the attribute widget.
Has someone tried?
Thx

RobertScheitlin__GISP · ‎03-27-2013

Guys,

You need to call tech support and log this as an enhancement request to the AttributeTable class in the API. This is not something that you can change in the code anywhere.

LucBourbousson · ‎03-27-2013

Ok, do you think posting an Arcgis idea would be appropriate for this kind of enhancement ?
Thx

RobertScheitlin__GISP · ‎03-27-2013

Luc,

That is also an area where you can do it, but I prefer to use tech support so tht they can decide if it is a bug or an enhancement request.

BjornSvensson · ‎03-28-2013

This should already be working in both API and Viewer.

The API has a columnDelimiter:
http://resources.arcgis.com/en/help/flex-api/apiref/com/esri/ags/layers/CSVLayer.html#columnDelimite...

And viewer has columndelimiter:
https://github.com/Esri/arcgis-viewer-flex/blob/master/src/com/esri/viewer/managers/ConfigManager.as...

olivierthomas · ‎03-28-2013

Hi Bjorn,

What is CSVLyr ?
Do you mean we can modify the default delimiter in the Flex Viewer (source code or config.xml)?

I am not sure to understand when you said "This should already be working in both API and Viewer."

Regards,

Olivier.