Downloads and relational structure

[Robert Lutolf]

My question is based on my assumption the WI uses a relational db model. I have a download and wanted to import the .csv files into a relational db based on fields e.g. project_id and deployment_id for relationships. However I found that the deployments.csv had 6 records with the same deployment_id. The images to deployments relationship failed as many to many

So am I wrong about WI data having a relational structure ?or is there a problem that allowed duplicate  deployment_id s in the deployments ? or are there other hidden key fields? or?

Bob

[Wildlife Insights]

Hi Bob,

I'm not aware of any issue with duplicate deployment_ids in the deployments table, but I'd be happy to take a look into this issue. If you haven't already, can you invite the suppor...@wildlifeinsights.org user to the project with this issue so we can try to download the data?

Thanks,

Nicole

Wildlife Insights team

[Robert Lutolf]

Nicole,

I have requested the Project admin to invite support. As an example, deployment.id RBBC 04 05/15/2022 is in our project 5 times. You can also see that online, in our list of deployments.

Bob

[Wildlife Insights]

Hi Bob,

It looks like there are several deployments named RBBC 04 05/15/2022 in your project, which is why there are duplicates showing up in your download. We do have a restriction on deployment names within a project, so this appears to be a bug with that restriction. I'll have our team look into this issue, but in the mean time you can let me know the numeric deployment IDs that you'd like to delete and we can remove them for you.

Thanks,

Nicole

[Robert Lutolf]

Nicole, 

Thanks we will get working on the list.

Bob