topic import csv file as a Trailayer in Search Widget in ArcGIS JavaScript Maps SDK Questions

import csv file as a Trailayer in Search Widget

Henryobaseki — Thu, 27 Jul 2017 14:49:02 GMT

Hi All,

I have spent a lot of time trying to figure this out in excel. The issue is my Number column in excel displays scientific number;

1.00091E+11

I have used the format cells to numbers but when I save and reopens the scientific numbers comes back.

This is an issue when using the csv as a search layer. It gives random numbers.

I want the unique numbers to be displayed as it is..

100090429674

100090429671

100091440630

200004639203.

this is my code;

// Add the layer to the map
  var trailsLayer2 = new FeatureLayer({
    url: "https://services1.arcgis.com/BZNs0xaSHDSi4V6G/arcgis/rest/services/Addresses_A/FeatureServer/0",
  });
 map.add(trailsLayer2); // Optionally add layer to map

At the moment my info table displays 100090429671 as 1000000000000.

Re: import csv file as a Trailayer in Search Widget

SteveCole — Thu, 27 Jul 2017 14:59:54 GMT

In Excel, you should format that column as TEXT instead of numbers. That will eliminate the 1.0E+11 issue, and hopefully the issue you have inside the JS API as well. You should especially do this if any of your values have leading zeros (in my County, the tax account numbers sometimes have two leading zeros).

Re: import csv file as a Trailayer in Search Widget

Henryobaseki — Thu, 27 Jul 2017 20:25:08 GMT

hi steve,

I have changed the format to TEXT. this is what I get

100090429674 changes to 100090000000

Re: import csv file as a Trailayer in Search Widget

Henryobaseki — Fri, 28 Jul 2017 13:25:09 GMT

Hi All,

Finally resolved the issue. Did save as numbers in excel and then resave as a string in ArcGIS Online. The numbers are exactly the same as it is on the spreadsheet.