Import

  • Resolved sousouch

    (@sousouch)


    5 years, 4 months ago

    Hi,

    I’m trying to import articles (post and rating (one rating per post)) in csv via really simple csv importer.

    I tried both solutions found here (including the csv file suggested here), but it doesn’t work.

    For the first solution (this one) In particular, I have errors of this type:

    Site Reviews no longer stores the “content” review value as meta data. Please use the glsr_get_review() helper function instead

    I also tried with the import tool, but despite having a csv file with a header row and columns indicated, it skips every time.

    Moreover, I imagine that via this solution it is not possible to import the post and the evaluation.

    Do you know how to do it ?

    Thanks in advance

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author Gemini Labs

    (@geminilabs)

    5 years, 4 months ago

    1. That pastebin link will only work for Site Reviews v4. I probably should go through the pastebin account and remove all outdated snippets.

    2. Site Reviews v5 only supports two import methods:

    METHOD 1: Use the official WordPress Import tool to import an export file from the official WordPress Export tool.

    METHOD 2: Use the “Import Third Party Reviews” tool to import a CSV file. This will only work (as the instructions say), if the CSV includes a header column, uses a comma as the delimiter, and includes the “rating”, “date” and “content” columns at a minimum.

    Additionally, the date must be in the yyyy-mm-dd format as shown in the instructions (i.e. using a forward slash will not work).

    If the format of the date is incorrect, or if you are missing one of the required columns, the reviews will be skipped.

    Plugin Author Gemini Labs

    (@geminilabs)

    5 years, 4 months ago

    Moreover, I imagine that via this solution it is not possible to import the post and the evaluation.

    Not with the “Import Third Party Reviews” tool.

    You will need to use the WordPress Export/Import tools to do this.

    Thread Starter sousouch

    (@sousouch)

    5 years, 4 months ago

    Thanks, i will try with this information

    You will need to use the WordPress Export/Import tools to do this.

    How to import evaluation at the same time as post? What are the required columns and what names to give them?

    • This reply was modified 5 years, 4 months ago by sousouch.
    • This reply was modified 5 years, 4 months ago by sousouch.
    • This reply was modified 5 years, 4 months ago by sousouch.
    • This reply was modified 5 years, 4 months ago by sousouch.
    Plugin Author Gemini Labs

    (@geminilabs)

    5 years, 4 months ago

    Go to WordPress Admin > Tools > Export and export all. If you don’t want to export all, then export posts, then export reviews.

    Go to your other site and go to WordPress Admin > Tools > Import and import the file you exported. If you exported your posts and reviews separately, import the posts file first and the reviews file last.

    Thread Starter sousouch

    (@sousouch)

    5 years, 4 months ago

    For the import tool, it works with the correct date format.
    What is the name to give to the header to assign to a post?

    Plugin Author Gemini Labs

    (@geminilabs)

    5 years, 4 months ago

    The import tool does not currently support assigning reviews on import.

    Thread Starter sousouch

    (@sousouch)

    5 years, 4 months ago

    Are there any plans to add this functionality ?

    Otherwise, with the import via really simple csv importer, I tried adding an average to the posts with _glsr_average, but it doesn’t work.

    Do you know how to add an average rating to a post during csv import?

    Thanks in advance

    Plugin Author Gemini Labs

    (@geminilabs)

    5 years, 4 months ago

    It’s not possible to import reviews using the Really Simple CSV Importer plugin as Site Reviews stores the review information in a custom database table, and the review assignments in custom pivot tables. The only way to do it is as explained above.

    If importing from CSV using the provided tool, you will need to manually assign your reviews to the posts after importing them. When reviews are assigned to a post, the _glsr_average value will automatically be calculated and added to the assigned post.

    • This reply was modified 5 years, 4 months ago by Gemini Labs.
    Plugin Author Gemini Labs

    (@geminilabs)

    5 years, 4 months ago

    Are there any plans to add this functionality?

    Not without rewriting the existing importer to import reviews asynchronously, as assigning reviews requires additional database transactions and doing it with the current implementation would decrease performance and be unreliable when importing thousands of reviews.

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Import’ is closed to new replies.