IGDB CSV import: some games are not imported which are not duplicates but the next in the series.

[Ardakilic]

Hello,

First of all, thank you for implementing IGDB import. This helped me a lot!

I've tried igdb game importing today, but I have encountered some errors:

This is my uploaded CSV: Edit: Removed

This is the error I get after I import:

[
    {
        "lot": "VIDEO_GAME",
        "step": "MEDIA_DETAILS_FROM_PROVIDER",
        "identifier": "Guild Wars 2",
        "error": "Query Error: error returned from database: duplicate key value violates unique constraint \"metadata-identifier-source-lot__unique-index\""
    },
    {
        "lot": "VIDEO_GAME",
        "step": "MEDIA_DETAILS_FROM_PROVIDER",
        "identifier": "Medal of Honor: Allied Assault",
        "error": "Query Error: error returned from database: duplicate key value violates unique constraint \"metadata-identifier-source-lot__unique-index\""
    },
    {
        "lot": "VIDEO_GAME",
        "step": "MEDIA_DETAILS_FROM_PROVIDER",
        "identifier": "Middle'-earth: Shadow of War",
        "error": "Query Error: error returned from database: duplicate key value violates unique constraint \"metadata-identifier-source-lot__unique-index\""
    },
    {
        "lot": "VIDEO_GAME",
        "step": "MEDIA_DETAILS_FROM_PROVIDER",
        "identifier": "Red Faction II",
        "error": "Query Error: error returned from database: duplicate key value violates unique constraint \"metadata-identifier-source-lot__unique-index\""
    },
    {
        "lot": "VIDEO_GAME",
        "step": "MEDIA_DETAILS_FROM_PROVIDER",
        "identifier": "Atelier Rorona: The Alchemist of Arland",
        "error": "Query Error: error returned from database: duplicate key value violates unique constraint \"metadata-identifier-source-lot__unique-index\""
    },
    {
        "lot": "VIDEO_GAME",
        "step": "MEDIA_DETAILS_FROM_PROVIDER",
        "identifier": "Atelier Sophie: The Alchemist of the Mysterious Book DX",
        "error": "Query Error: error returned from database: duplicate key value violates unique constraint \"metadata-identifier-source-lot__unique-index\""
    }
]

Iy says some games are duplicates, but they are not actually:

For example, "Guild Wars" and "Guild Wars 2", and "Middle Earth: Shadow of Mordor" and "Middle Earth: Shadow of War" are different games:

Could you check please? I can understand Atelier Rorona's case, which the base game and plus being identified as duplicates, but some of the games that are marked as duplicates are totally different games.

Thanks in advance!

[IgnisDa]

Thanks for reporting. Will take a look.

[IgnisDa]

@Ardakilic I am unable to find the root cause for this problem. I recommend you to just add this to your history manually.

Since this is a one time thing, I don't really see any reason to prioritize it.

[Ardakilic]

@IgnisDa thank you, no worries. I could import the rest without issues.

Thank you for implementing IGDB, and investigating the issue, much appreciated!