Duplicates with two sources

[mrman486]

The bug

If I import via FR24 and App in the Air for example, some of the imports have the same data so there is duplicates in the final result in AirTrail.

Is there an easy way to clean out duplicates?

Operating System that is running AirTrail

docker

AirTrail Version

Latest

Your docker-compose.yml content

No response

Your .env content

No response

Reproduction steps

1.Import FR24
2.Import App in the Air
3. View results
...

Relevant log output

No response

Additional information

No response

[johanohly]

I've actually never considered the use-case of importing from multiple sources.

I don't think there is a need to check for duplicates when importing, as that is a very niche use-case, but I could see a kind of like tools page that lets you delete duplicates according to your specification. For your use-case, is matching the airports and date and time enough?

Another option you have, if you are comfortable with SQL databases, is accessing the AirTrail database outside of AirTrail, and execute a raw SQL query to delete duplicates.

[mrman486]

If there was an option to filter dupes in the list then have an option to select all etc to delete would work very well. Matching dates and airports would be perfect.

I know there have been times going back I have entered data twice by mistake after forgetting I have already entered the flights.

Cheers

[vnl]

I can confirm the duplicate bug when importing from 2 sources. I have AppInTheAir and MFR24
It would be nice to have that in the UI as a tool to delete duplicates. :) Not sure if it is a priority anyway.
The SQL is hosted on Synology, so I am completely blank on accessing it outside Airtrail.