nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Change CSV list separator in Attribute Widget

JosVroegop

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

Vind meer berichten getagd met

Accepted answers

BjornSvensson

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.

All comments

marcostenorio

Bjorn, thank you very much

BjornSvensson

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

marcostenorio

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

KenCarrier

Thanks Robert my fault.

RobertScheitlin__GISP

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.

KenCarrier

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;

olivierthomas

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.

JosVroegop

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.

BjornSvensson

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.

BjornSvensson

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?

olivierthomas

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.

BjornSvensson

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

RobertScheitlin__GISP

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.

LucBourbousson

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

RobertScheitlin__GISP

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

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

JosVroegop

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.

rzufelt

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

R_

Sorry, couldn't resist 🙂

LucBourbousson

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

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.