Search & Near Functions not working

[Barry]

Is there any possibility this ticket could be escalated for faster response time since it’s taking so long to resolve?

I’m afraid not, we need to provide fair service to all of our users and we’re working as fast as we can, but we do have a large number of users to support.

I followed your instructions exactly and did not get any results.

OK, apologies for that – can you revise the snippet so it reads like this and try again? I’ll do my best to check in on this thread a couple of times today though I can’t give any guarantees of being able to do so.

Thanks for your patience.

[Barry]

PS – forgot to mention that my hosting is with Blue Host which is one of your recommended providers so not sure why hosting enviromment would be the issue.

I don’t want to derail things from the issue at hand, but where on our site did you see this recommendation?

[eastbayaa]

Ok, so I modified the code and now something has happened… you can see results here: http://69.195.124.167/~eastbbc2/member-services/?geocode_test

Regarding the hosting environment, sorry for confusion… Blue Host is a recommended WORDPRESS hosting service, which is what we are using. I am trying to integrate the Events Calendar into our WordPress site, but if we can’t get this working I’m going to have to look for another solution. Hoping we are close… thanks for your assistance.

[Barry]

Things for doing that – and please feel free to remove that code.

I’m unsure why the longitude/latitude were not captured first time round – but I think what’s happening is this: since querying for this information from Google is a comparatively costly operation we don’t want to do it unless it is necessary and there is a “safety mechanism” in place for just that reason.

In this case, I think that is stopping us from collecting the information about longitudes/latitudes that we need.

• Can I ask you to try editing a venue and change the street address slightly (ie, from 123 Any Street to 456 Any Street), save and – assuming there are some upcoming events at that venue – see if it now pops up in map view
• Initially you said you loaded a number of “test” events. For the avoidance of any doubt, can you confirm you did so via the CSV importer?

Thanks again for your support and patience.

[eastbayaa]

Hi Barry,
Ok, I did as you asked changing the street address for our test case “Triangle Fellowship” slightly. As you suspected it DOES show up in map view now. See here: http://69.195.124.167/~eastbbc2/meetings-directory/map/

To confirm, yes I imported my venues AND my events via the CSV importer. Now what?

[Barry]

So something seems to have gone wrong during the CSV import, yet that isn’t an issue I can recreate with well-formed addresses in my own tests. Editing the venues individually is obviously one way to trigger an update to the coordinate data – but with 500 events, as you plan to import, that is clearly going to be impractical.

• Can you share your venue CSV test data?
• Can you run a further test – create a new CSV file containing at least one well formed address, import it, assign an upcoming event to the resulting venue and test via map view to see if it worked as expected this time round

I can appreciate this must be frustrating and I sense you are keen to close in on a resolution to this problem. We are too, yet it isn’t something we’re seeing widespread reports of (venues imported by CSV lacking geolocation data, that is) … it also works well for me in my own tests and of course this feature was well covered by testing before release. So right now every indicator is that this issue is specific to your WordPress installation or else your test data. As you can appreciate, that does present a few obstacles to finding the answer.

If you can, let’s explore the above points and see what else we can uncover here.

 

[eastbayaa]

Hi, Yes I’m a bit frustrated by lag time in resolving this… wish we could just have a few back and forths in the span of a single day rather than having to wait 24 hours after each update.

In any case, here is a link to my CSV file (http://69.195.124.167/~eastbbc2/wp-content/uploads/2014/03/Venue-List.csv). It’s pretty simple, so I’m not sure what could possibly be wrong with it and I have no idea what you mean by creating a new CSV file with “one well formed address.” These all seem to be well formed to me.

So can you please be a bit more specific about what you’re wanting me to do? Thanks.

[Barry]

Hi:

wish we could just have a few back and forths in the span of a single day rather than having to wait 24 hours after each update.

That would be ideal and sometimes, like right now, that’s possible. But we do have a large number of customers to support and as per our stated target response times this isn’t something we can generally commit to.

Thanks for your patience so far, however, and for sharing your test data – it’s definitely appreciated.

• Your test data uses the ISO-8859-1 character set. As per the new user primer for the CSV importer, can you ensure it is saved as UTF-8 before importing it (how you will do this varies according to what application you used to put together the CSV file, but is usually an option presented within the save dialog)
• Most of your events (for me) imported successfully without making that conversion, but for some it resulted in malformatted characters in the address and longitude/latitude was not obtained

I have no idea what you mean by creating a new CSV file with “one well formed address.”

• Sorry for any confusion on the above point
• Your test data works well for me, especially when re-saved as UTF-8 – so I’d like to determine if this whole thing might have been a “one off” or if it will consistently be a problem for you
• Can you create some new test data in CSV format, saved as UTF-8 and avoiding remarks like (at Fountain) within the address data
• Try importing it … has longitude latitude data been generated this time?

One way to detect if it was correctly generated is by testing via map view. Alternatively, this plugin (though not an official Modern Tribe plugin) lets you view the longitude and latitude data from within the venue editor which may make this easier.

Thanks again for your support and patience as we work through this.

[eastbayaa]

Thank you!! Ok, I get it and I will try again with your recommendations. One question… I am using Excel for Mac and I don’t see the UTF-8 option upon saving. I see three CSV options. The first is the default (the one I used) and is listed under Common Formats. The second is called “Windows Comma Separated” and the third is called “MS-DOS Comma Separated” and these are both listed under Specialty Formats. Would one of these be UTF-8?

[Barry]

Hmm, not being a Mac user nor an Excel user I’m not sure I can easily answer that one.

However, if you have a plain text editor such as gEdit or Sublime Text available you should be able to open your CSV in that and re-save in the correct format – does that help? I would have thought it is possible to do it in a single step via Excel, but would need to leave it to you to look through their documentation on that one.

[eastbayaa]

Ok, thanks… I’ve got a text editor so I’ll resave there with correct format. I’d like to leave this thread open until I test it just to be sure that was the problem and will get to that a bit later today. THANK YOU for your attentiveness today… I really appreciate it.

[Barry]

Happy to help – hopefully this gets us on track but please don’t hesitate to let us know if you hit further problems.

[Barry]

This thread’s not seen much activity for the last couple of weeks so I’ll go ahead and close it. Of course if you still need help with this or any other issue please don’t hesitate to create a new thread (or threads) and one of the team will be only too happy to help. Thanks!

[Author]

Posts