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; } } }

Export attributes to CSV to NOT include Lat Long fields?

vscott1

I am using the basic select tool to populate the Attribute Table with the desired fields I want for a mailing list. When I export the data, a latitude and longitude field are also included. I don't want them. Where can I configure the exclusion of them?

[ATTACH=CONFIG]27959[/ATTACH]

export.png

Snapping_Geom.JPG

StevenTemmermand_0-1780444467882.png

Find more posts tagged with

Accepted answers

vscott1

Well it turns out the Layer name is not the problem either.

The issue is that I am excluding all layers as defined in the "Layout" tab in the "Attribute Table" widget:

[ATTACH=CONFIG]28018[/ATTACH]

and only using the temporary table data from the "Search" widget!

In the "Search" widget I selected the option to "Add result as operational layer" and this is why the <exportlocation>false</exportlocation> tag in the AttributeTableWidget.xml file does not work. My only solution is to remove the fields in the .csv file.

I've asked that this be an enhancement to ArcGIS Viewer for Flex. #NIM095483

sel03.png

ArcGIS.LocationField.DocLibFix.zip

All comments

vscott1

sel03.png

ArcGIS.LocationField.DocLibFix.zip

vscott1

Hmm? Same result even it I put a layer name in it?

<?xml version="1.0" ?>
<configuration>
    <excludelayer>Council Districts and Members</excludelayer>
    <excludelayer>County Parcels</excludelayer>
    <excludelayer>Address Points</excludelayer>
    <excludelayer>SON Business</excludelayer>
    <excludelayer>SON/1</excludelayer>
    <excludelayer>SON/2</excludelayer>
    <excludelayer>SON/3</excludelayer>
    <excludelayer>SON/4</excludelayer>
    <excludelayer>SON/5</excludelayer>
    <excludelayer>SON/6</excludelayer>
    <excludelayer>SON/10</excludelayer>
    <excludelayer>SON/9</excludelayer>
    <excludelayer>SON/8</excludelayer>
    <excludelayer>SON/7</excludelayer>
    <excludelayer>Neighborhood Associations</excludelayer>
    <excludelayer>Council Districts and Members/0</excludelayer>
    <excludelayer>Council Districts and Members/1</excludelayer>

    <layersettings>
<layer name="Address Locations - 5 miles">
     <exportlocation>false</exportlocation>
</layer>
    </layersettings>
</configuration>

Could the layer name be the issue since it has a hyphen in it?

AntGiles

Venus,

You need to provide a layer name in your layer tag and you only need to use the sublayer tag if your layers are coming from a single mapservice and you are not adding your layers in as individual feature services:

<layersettings>
<layer name="layer name">
<exportlocation>false</exportlocation>
</layer>
</layersettings>

Regards

Anthony

vscott1

This is good information. However it is still not working. In my viewer, the only data I want to see is from the basic "search/selection" tool.
[ATTACH=CONFIG]27978[/ATTACH]

Here is my modified AttributeTableWidget.xml file:
<?xml version="1.0" ?>
<configuration>
    <excludelayer>Council Districts and Members</excludelayer>
    <excludelayer>County Parcels</excludelayer>
    <excludelayer>Address Points</excludelayer>
    <excludelayer>SON Business</excludelayer>
    <excludelayer>SON/1</excludelayer>
    <excludelayer>SON/2</excludelayer>
    <excludelayer>SON/3</excludelayer>
    <excludelayer>SON/4</excludelayer>
    <excludelayer>SON/5</excludelayer>
    <excludelayer>SON/6</excludelayer>
    <excludelayer>SON/10</excludelayer>
    <excludelayer>SON/9</excludelayer>
    <excludelayer>SON/8</excludelayer>
    <excludelayer>SON/7</excludelayer>
    <excludelayer>Neighborhood Associations</excludelayer>
    <excludelayer>Council Districts and Members/0</excludelayer>
    <excludelayer>Council Districts and Members/1</excludelayer>

    <layersettings>
<layer>
     <sublayer>
         <exportlocation>false</exportlocation>
     </sublayer>
</layer>
    </layersettings>
</configuration>

I'm still getting the exported lat/long values?

[ATTACH=CONFIG]27979[/ATTACH]

I'm thinking it's because of using the "selected" data as opposed to an actual "layers's" fields?

Open to any thoughts or suggestions!

Thanks!

sel01.png

sel02.png

shapeflip2.png

shapeflip.png

AntGiles

Venus,

The exportlocation tag needs setting to false in the layer settings of your attribute table config file, see:

http://resources.arcgis.com/en/help/flex-viewer/concepts/index.html#/Attribute_Table_widget_tags/01m30000004t000000/

E.g:

<layer name="PoolPermits">
             <fields>
                 <field name="objectid" alias="ObjectID"/>
                 <field name="apn" alias="APN"/>s
                 <field name="pool_permit" alias="Pool_Permit"/>                    
             </fields>
             <showobjectid>false</showobjectid>
             <showglobalid>false</showglobalid>
             <exportlocation>false</exportlocation>          
             <showattachments>true</showattachments>
             <showrelatedrecords>true</showrelatedrecords>
             <columnsorder>alphabetical</columnsorder>
</layer>

Regards

Anthony

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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