topic Re: Change CSV list separator in Attribute Widget in ArcGIS Viewer for Flex Questions

Change CSV list separator in Attribute Widget

JosVroegop — Thu, 14 Mar 2013 14:15:14 GMT

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

Re: Change CSV list separator in Attribute Widget

LucBourbousson — Thu, 21 Mar 2013 14:54:05 GMT

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

Re: Change CSV list separator in Attribute Widget

RhettZufelt — Thu, 21 Mar 2013 16:50:15 GMT

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

R_

Sorry, couldn't resist 🙂

Re: Change CSV list separator in Attribute Widget

JosVroegop — Thu, 21 Mar 2013 19:41:11 GMT

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.

Re: Change CSV list separator in Attribute Widget

LucBourbousson — Wed, 27 Mar 2013 13:03:20 GMT

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

Re: Change CSV list separator in Attribute Widget

RobertScheitlin__GISP — Wed, 27 Mar 2013 13:15:26 GMT

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.

Re: Change CSV list separator in Attribute Widget

LucBourbousson — Wed, 27 Mar 2013 13:35:11 GMT

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

Re: Change CSV list separator in Attribute Widget

RobertScheitlin__GISP — Wed, 27 Mar 2013 13:43:00 GMT

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.

Re: Change CSV list separator in Attribute Widget

BjornSvensson — Thu, 28 Mar 2013 13:42:21 GMT

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#columnDelimiter

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

Re: Change CSV list separator in Attribute Widget

olivierthomas — Thu, 28 Mar 2013 15:46:46 GMT

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.

Re: Change CSV list separator in Attribute Widget

BjornSvensson — Fri, 29 Mar 2013 20:54:17 GMT

Sorry, I did not read the question properly. I thought you were asking about supporting (incoming) CSV files that didn't use commas. Reading it again, it is clear that you are asking about EXPORT with semicolon. This isn't possible to do currently.

In order to support this in the API, I have some questions:

Do you think this should be decided by the person setting up the applications (with a tag in the attributetable config file)?
Or do you think it would be something that the end-user would have an option to pick?

Re: Change CSV list separator in Attribute Widget

BjornSvensson — Mon, 01 Apr 2013 18:44:52 GMT

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.

Re: Change CSV list separator in Attribute Widget

JosVroegop — Tue, 02 Apr 2013 10:32:19 GMT

Hello Bjorn,

Many thanks for adding the option to set the csv delimiter in version 3.3. About your question,

"Do you think this should be decided by the person setting up the applications (with a tag in the attributetable config file)?
Or do you think it would be something that the end-user would have an option to pick? "

I think the person setting up the application knows wich delimiter should be used, much less confusion for the user.
This would be enough for me anyways.

Re: Change CSV list separator in Attribute Widget

olivierthomas — Thu, 11 Apr 2013 11:46:41 GMT

Hi Bjorn,

Thanks for the feed back.
It will be great if the Flex Viewer release 3.3 lets the end user define its own separator for csv.

Regards,

Olivier T.

Re: Change CSV list separator in Attribute Widget

KenCarrier — Fri, 12 Apr 2013 17:44:44 GMT

I am sure I am doing something wrong here but is anyone else having problems with 3.2 and line 910 of the AttributeTableWidget?

I am getting an error during the building of the workspace.

1119: Access of possibly undefined property exportColumnDelimiter through a reference with static type com.esri.ags.components:AttributeTable. AttributeTableWidget.mxml /FlexViewer/src/widgets/AttributeTable line 910 Flex Problem

Is this a known issue or is there a workaround.

Here is the line of code, I just downloaded everything from the resource center, have a call into tech support waiting on a call back.

attributeTable.exportColumnDelimiter = settings.exportColumnDelimiter;

Re: Change CSV list separator in Attribute Widget

RobertScheitlin__GISP — Fri, 12 Apr 2013 17:53:08 GMT

Ken,

You are unintentionally using the develop branch of the Flex Viewer GitHub repository with essentially is 3.3 Beta. You need to switch to the Master branch and re-download the viewers source.

Re: Change CSV list separator in Attribute Widget

KenCarrier — Fri, 12 Apr 2013 17:54:15 GMT

Thanks Robert my fault.

Re: Change CSV list separator in Attribute Widget

marcostenorio — Fri, 25 Jul 2014 17:38:49 GMT

Hello Bjorn,

how to add new item on the menu option in the attribute table?

I'm trying to add an option to export to excel.

I already have the api as3xls and function, but do not know where to insert.

could indicate which file mxml I change?

thank you very much.

Tenorio

Re: Change CSV list separator in Attribute Widget

BjornSvensson — Fri, 25 Jul 2014 17:53:03 GMT

Tenorio, I responded on the specific discussion you created - see https://community.esri.com/message/390859#390859‌

Re: Change CSV list separator in Attribute Widget

marcostenorio — Mon, 28 Jul 2014 11:47:25 GMT

Bjorn, thank you very much