call data from CSV import to populate Ratings

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: import, ratings

Author

Posts
September 17, 2018 at 2:38 pm #446735

Kyle Pittman
Expired Member

Post count: 3

Is there a way to populate the ratings star values and number of ratings by importing data through the CSV import? What are the field names to use as column names for this?

September 17, 2018 at 3:06 pm #446744

Alex Rollin
Moderator

Post count: 27815

Hello,

In V1 reviews cannot be imported.

In V2, ratings can be imported using a CSV format sheet.

In both cases the settings themselves are configured in the WP Backend, and then the ‘counts’ are generated automatically based on the individual reviews.

September 17, 2018 at 3:58 pm #446749

Kyle Pittman
Expired Member

Post count: 3

How do I know if I have V1 or V2?

September 17, 2018 at 5:48 pm #446757

Kyle Pittman
Expired Member

Post count: 3

When I look at the plugin it says Version 1.6.30

September 17, 2018 at 5:53 pm #446758

Kor
Moderator

Post count: 16516

Hi Kyle Pittman,

Thanks for your reply. We are referring to this addon https://wpgeodirectory.com/downloads/multiratings-and-reviews/ and the latest version is 1.4.1

Thanks!

September 17, 2018 at 6:15 pm #446762

Alex Rollin
Moderator

Post count: 27815

1.6.3 is GeoDirectory V1.
You can read about the new V2 here: https://wpgeodirectory.com/docs-v2/geodirectory/overview/

September 17, 2018 at 9:31 pm #446768

Kyle Pittman
Expired Member

Post count: 3

I am not sure I submitted my original question correctly.

I have a database of companies that I want to create a directory with. For each of the companies I also have corresponding data for reviews including: number of reviews, average rating, comment/review text. I want to populate that data in my directory so people will be able to sort the listings based on number of reviews or rating. Is there a way for me to import my data to populate those fields?

September 18, 2018 at 7:31 am #446799

Alex Rollin
Moderator

Post count: 27815

Ah, I see.

You can definitely import those values as custom fields.

The first step is to go to

GeoDirectory – Place Settings – Custom Fields

Add in a field for each of those values.

Then go to

GeoDirectory – General – Dummy Data

Add in some dummy data listings which will also populate those fields for you.

Then go to

GeoDirectory – Import / Export – Export Listings

Choose to export listings, and export the places

This will give you a CSV file. You can paste your data in there. Be careful to preserve spreadsheet columns and column names, and their order.

Then go back and import that sheet.

You can use the sorting options to allow your site visitors to sort listings by the values of the fields.
Author

Posts