topic Re: Extracting CSV Data Without Saving a File in ArcGIS JavaScript Maps SDK Questions

Extracting CSV Data Without Saving a File

WilliamMiller4 — Wed, 23 Nov 2016 20:58:26 GMT

Hello,

I'm trying to create mailing labels for selected parcels. I'd like to take values from the CSV that WAB can generate (in the Attribute Table widget), get a string from the result, parse it and add the results to a pdf generator. I found the CSVUtils.js, in particular the exports._createCSVStr function, but I'm having trouble implementing it. Has anyone else used this function? Please let me know how you got the parameters (datas, columns) to use in the function. Any help is much appreciated. Thank you for your time.

William

Re: Extracting CSV Data Without Saving a File

RobertScheitlin__GISP — Sat, 26 Nov 2016 02:13:56 GMT

William,

What part are you struggling with? The function take a datas object with is an array of objects with key and value (i.e. field1: "blah blah") and columns which is a array of strings that represent the column names.

Re: Extracting CSV Data Without Saving a File

WilliamMiller4 — Mon, 28 Nov 2016 17:39:42 GMT

Hi Robert,

I'm not sure how to create the arrays with the data I want to include.

William

Re: Extracting CSV Data Without Saving a File

RobertScheitlin__GISP — Sat, 11 Dec 2021 22:22:51 GMT

William,

I am struggling to see what you are struggling with. The datas object with is an array of objects with key and value (i.e. field1: "blah blah").

I guess I can provide a more detailed example:

var data = [
  {
    First: "William",
    Last: "Miller",
    Gender: "Male"
  }, {
    First: "Robert",
    Last: "Scheitlin",
    Gender: "Male"
  }
];‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Extracting CSV Data Without Saving a File

WilliamMiller4 — Mon, 28 Nov 2016 19:06:45 GMT

Hi Robert,

Sorry for being so vague. Say I use the By Shape tab of your Enhanced Search widget and create a circle that encompasses multiple properties. In the Results tab, I click the ellipses button and View in Attribute Table. How would I access the data that is now displayed in the table?

William

Re: Extracting CSV Data Without Saving a File

RobertScheitlin__GISP — Mon, 28 Nov 2016 19:10:50 GMT

William,

The table would just be displaying the attributes of the graphics associated with the search results. So you would get a reference to the search layer and loop through its graphics and get the attributes property of each graphic and add it to an array and that now becomes your datas array.

Re: Extracting CSV Data Without Saving a File

WilliamMiller4 — Mon, 28 Nov 2016 19:17:25 GMT

Hi Robert,

How do I get a reference to the search layer?

William

Re: Extracting CSV Data Without Saving a File

RobertScheitlin__GISP — Mon, 28 Nov 2016 19:35:26 GMT

this.map.getLayer("some layer id");

Re: Extracting CSV Data Without Saving a File

WilliamMiller4 — Mon, 28 Nov 2016 21:06:30 GMT

Hi Robert,

What would the "some layer id" be for the search layer?

William

Re: Extracting CSV Data Without Saving a File

RobertScheitlin__GISP — Mon, 28 Nov 2016 21:22:06 GMT

William,

It would be what you see in the attribute tables widgets tab title.

Re: Extracting CSV Data Without Saving a File

WilliamMiller4 — Sat, 11 Dec 2021 22:22:54 GMT

Hi Robert,

This is what I've been able to cobble together, but it doesn't like GraphicsLayer. I think I want the GraphicsLayer, but I looked at the API for it and don't know what to use.

        var myLayer = this.map.getLayer("Search Results: Mailing Labels");
        array.forEach(myLayer.GraphicsLayer, function(layerItem){
               // forEach code here
        });‍‍‍‍‍‍‍‍

Any suggestions are greatly appreciated. Thank you.

William

Re: Extracting CSV Data Without Saving a File

RobertScheitlin__GISP — Tue, 29 Nov 2016 20:51:44 GMT

William,

If you are trying to loop through the layer Graphics then use graphics not GraphicsLayer

Re: Extracting CSV Data Without Saving a File

WilliamMiller4 — Sat, 11 Dec 2021 22:22:56 GMT

Hi Robert,

When I try graphics (below), I get "Uncaught TypeError: Cannot read property 'graphics' of undefined."

var myLayer = this.map.getLayer("Search Results: Mailing Labels");
array.forEach(myLayer.graphics, function(layerItem){
   // forEach code here
});‍‍‍‍

William

Re: Extracting CSV Data Without Saving a File

RobertScheitlin__GISP — Tue, 29 Nov 2016 21:33:35 GMT

William,

Then that should tell you that your myLayer var is null then. When coding you can use console.info(myLayer); to check if your var is what you are expecting.