Load Data Behavior
This topic contains 10 replies, has 4 voices, and was last updated by 
Kai Liu 6 years, 2 months ago.
We have moved to a support ticketing system and our forums are now closed.
Open Support Ticket-
AuthorPosts
-
January 5, 2019 at 4:09 am #461636
In GD V2, while importing listings, is auto correction feature intact for location fields such as city, state and country?
for example, if data set containing country name USA and US, or if country name is England rather than UK, etc. will GD import handle this automatically or we have to handle this ourselves manually before import?
If GD could not find matching country name, how GD handle this in V2? set to default location? what if I did not specify default location?
There are many country names like this. When working in V1, causing me lot of trouble to clean them after importing. For Guam, GDV1 convert all Guam listing to Australia, several hundreds. I have to edit them one by one manually. If I use phpadmin to correct those, what happened to related data, eg SEO meta links etc.?
Thanks
January 5, 2019 at 4:16 am #461637I found that there is a country table in all WP sites. Is GD country name identical to this table or GD has its own country name standard?
January 5, 2019 at 4:32 am #461640I’ll get a developer to have a look at your question too, but the best idea would be to add a listing in Guam using the frontend, and then export to see how the API has treated the location.
Thanks
January 5, 2019 at 6:03 pm #461711GDV2 also has a country database. You can check it to match, just as you did with V1
https://github.com/AyeCode/geodirectory/blob/605b03059ca237672216226a1cf891a3ef86115f/vendor/ayecode/wp-country-database/wp-country-database-data.phpJanuary 7, 2019 at 2:04 pm #461948That country table in WP is not a default WP thing, we add that, its a country class we wrote.
You should validate the locations as much as u can before import, the import check for location names only checks they are not empty, we do have checks to fill in the lat/lon if missing but not to correct the address if wrong, that could really slow down import times.
Stiofan
January 7, 2019 at 3:48 pm #461976hi stiofan,
Thanks for your info. Please re-confirm if importing process will fill lat/lon automatically as I remove some records without lat/lon.
Another question, when GD compares country name, is it looking for exact match or not. In my last project, GD set some countries with default location causing me lot of time to clean that up. Now i clean source data manually to ensure city rdgion and country are correct.
We had script to auto correct and standardize address using google api in other non wp projects. It will be good if GD incorporate this, use it or not subject to user setting, as it costs money to call google api. For us, I would rather pay api calls to auto correct and standardize address using google api, save lot of time and labor.
I did suggest about country issue in other post that it wojld be good if GD treate country name like region or city, save as per source file. And we can easily adjust via phpadmin or location manager in batch. With a wronf default, we have to clean it up one by one.
Coupke of data protection questions,
1.for email field, can we hide it from expoaing to visitors, but visitor can email message to business via our own messaging system?
2. Good if we can specify number of records to show per search per, to avoid data scraping. When user reach last page, force user to re-enter searching criteria and search again. This also help directory operator to make some advertising income because imoression spaces are limited.
Cheers
Sam
January 7, 2019 at 8:24 pm #462038GDV2 will attempt to geocode, that is, derive the lat lon from the address info present.
For country name, yes it is looking in https://github.com/AyeCode/geodirectory/blob/605b03059ca237672216226a1cf891a3ef86115f/vendor/ayecode/wp-country-database/wp-country-database-data.php
1. Yes, to hide email, simply don’t “Show in what locations” and make sure it is not included in a gd_post_meta in any of the templates. Even if it is not displayed (unless hidden by a package) the GD > Ninja Form -> Contact form will still work. The NF integration stores the submission then sends an email to the listing email address. For your “own messaging system” you could put together a similar integration.
2. In GDV1 this was accomplished in part by the default search radius and the near me radius. We are still planning to implement some form of limit for advanced search, but it is not yet in place. Coming soon! Your goal can also be accomplished partially with search pagination, controlled by the WP Setting (Reading) Post per page. I have created a task to consider specifically a max results returned setting.January 8, 2019 at 3:54 am #462104Thanks alex for the detail reply
Regarding geocode, apart from filling up missing lat/lon, it would be better to correct address to standard format as well, eg google api call will return google standard and correct address, city name, post code, region according to google map records. This is very useful for less cleaned data or some legacy data with address in a string consisting address+city+region+postcode. Google api can return correct address formt, city, postcode region (good for case like mis-match city and postcode, address with unit number) and country name(good for case like Congo, also standardize country name for US, UK, etc those with many kinds of format). With this, country table is no longer required too.
Which forum is appropriate for discussion of performance of GD. I have built projects on V1 and V2, study quite a lot in improving homepage loading performance.
Cheers
Sam
January 8, 2019 at 8:17 am #462126Alex,
For your suggestion:
1. Yes, to hide email, simply don’t “Show in what locations” and make sure it is not included in a gd_post_meta in any of the templates. Even if it is not displayed (unless hidden by a package) the GD > Ninja Form -> Contact form will still work. The NF integration stores the submission then sends an email to the listing email address. For your “own messaging system” you could put together a similar integration.
If not showing email, how NF recognize which email to send to? NF produce shortcode with form number. Do we just add this code to the detail page some where, NF will know which email to send to? Or if any integration setting required?
Thanks
Sam
January 8, 2019 at 8:43 pm #462222The integration makes the field accessible, even if it is not shown publicly. The package settings control whether the contact form is visible. If email is included in the package, then the contact form is visible.
You can follow the docs here to add the contact form:
https://wpgeodirectory.com/docs-v2/integrations/ninja-forms/#contactJanuary 9, 2019 at 7:31 am #462295Great alex. Thanks. I wl try it out later. Now fixing the GD home. I make a custom home page without map to speed up loading speed which indeed drop from 15 sec to 6 sec. And i have made GD home as Map View page as option for user. However, it worked the first day, next day the GD home page becomes blank. Not sure why, i am rebuilding it by adding the widgets back on. Strange
-
AuthorPosts
We have moved to a support ticketing system and our forums are now closed.
Open Support Ticket