Esri Business Analyst Online

Bug: Business Analyst Online imports only 100 records for geocoding from an Excel workbook

【相关信息】
Article ID: 40504
Bug Id: NIM083581
Software:
Esri Business Analyst Online Current
Platforms: N/A

【BUG描述】
When importing records from an Excel workbook only 100 records are geocoded.

The provided workflow shows how to create new Excel workbooks with only 100 records in each so that all locations can be imported.

【BUG原因】
Business Analyst Online has a limitation of importing only 100 records per Excel workbook.

1 个回复

EsriSupport

【解决方案】
The following workaround shows how to make multiple workbooks and copy the remaining records in increments of 100 into each new workbook. Business Analyst Online then imports the individual workbooks to reflect all geocoded sites.

Take the original Excel table, which contains more than 100 records, and open enough new workbooks to handle all records in increments of 100.
Copy the headers from the original Excel table, and paste them into each new individual workbook.
Copy the second set of 100 records from the original Excel table and paste them into one of the new workbooks.
Repeat this for the remaining records in sets of 100 until all records have been copied to new workbooks.
Save each of the new workbooks with new names in .xls format.
Import the new workbooks into Business Analyst Online. Browse to each Excel workbook and import the records before proceeding to add rings, drive times or donuts.
All records are shown in Business Analyst Online on the same map.