topic Re: Problem with Import Locations function in Business Questions

Problem with Import Locations function

ErinGunyan — Mon, 24 Sep 2012 19:00:54 GMT

I am using having issues importing locations via an Excel spreadsheet in BAO.

I am on the tab "Research Section" > "Import Locations."

When I import a spreadsheet (which has less than 4,000 records, and is smaller than 5 MB), the website will freeze. It usually freezes right before uploading all of the locations (after I have corrected duplicate and/or incorrect addresses). This has happened 5 times now, and is very inconvenient.

Can anyone offer any solutions for this?

Thanks.

Re: Problem with Import Locations function

Jason_RobinsonRobinson — Tue, 25 Sep 2012 15:40:05 GMT

I am using having issues importing locations via an Excel spreadsheet in BAO.

I am on the tab "Research Section" > "Import Locations."

When I import a spreadsheet (which has less than 4,000 records, and is smaller than 5 MB), the website will freeze. It usually freezes right before uploading all of the locations (after I have corrected duplicate and/or incorrect addresses). This has happened 5 times now, and is very inconvenient.

Can anyone offer any solutions for this?

Thanks.

David,

Generally the most issues I have seen with Import Locations is with the Excel file itself. Do you have a field that has a unique numerical identifier? Also what internet browser are you using? How long have you let it go when it appears to freeze?

Regards,
Jason R.

Re: Problem with Import Locations function

ErinGunyan — Mon, 12 Nov 2012 16:47:18 GMT

The excel file has one unique field, which is Site Name. I'm using Internet Explorer, and I've let the page sit for at least 10 minutes before cancelling.

Re: Problem with Import Locations function

Jason_RobinsonRobinson — Mon, 12 Nov 2012 17:02:12 GMT

The excel file has one unique field, which is Site Name. I'm using Internet Explorer, and I've let the page sit for at least 10 minutes before cancelling.

David,

Try adding an additional numerical column and name it ID enter a 0 or 1 as the value. Let me know if that does the trick here.

Regards,
Jason R.

Re: Problem with Import Locations function

ErinGunyan — Tue, 13 Nov 2012 16:32:22 GMT

That worked. Thanks.

Re: Problem with Import Locations function

Jason_RobinsonRobinson — Tue, 13 Nov 2012 16:54:32 GMT

That worked. Thanks.

David,

Glad to hear!

Cheers,
Jason R.

Re: Problem with Import Locations function

ErinGunyan — Tue, 13 Nov 2012 18:33:42 GMT

I was able to load a file with around 400 records. However, I've just tried to load a file with about 1,500 records, and it is freezing again.