It looks like some of our data didn’t load when we imported Customers and Vendors. Can you delete all of the data in Businesses tables so I can re-run? I’m guessing that because we had to run the import several times due to errors that it didn’t get all the data loaded.
Here is a quick video on how to delete your business so you can start over with the import.
https://www.screencast.com/t/XYBlLZZnNB
| Code Block |
|---|
DELETE Business WHERE ID > 1 |
One follow-up: if I right-click in the address field or check “Use Abbrev” then the name and address appear. Is that what we need to do on each row?
There was a change in the code recently that is causing this issue. Here are the steps to perform in Crows Nest to fix:Using the excel import template to add businesses causes the address not to show in the business form.
This article will show you how to get the addresses to show for these imported businesses.
...
Click on Data in the top left of the screen.
Click on Queries
Click on the Immediate tab.
Paste in the code below.
Click Execute
...