0

Import not seeing all data

Hi all -

I'm testing out a manual restore of my DB and encountered an issue where Ninox doesn't see the data in the csv.

I've made a small replica of the DB, attached.

If you look at the Book1(Sheet1).csv you will see that there is data under Team.

 

But if you go through the Import data... for the TeamName table (child of Teams), you will see that no data shows up under Teams. Set Id = Id and Teams = Teams (Id).

 And the relationship field is not linked for those with empty Teams.

I've included the full dataset as well so you can see that all the other TeamName records import and link just fine.

What could be the cause of it?

Thanks

3 replies

null
    • Rafael Sanchis
    • Rafael_Sanchis
    • 8 days ago
    • Reported - view

    Hi Fred, I have some similar problem, when import a csv all records are imported ok, but when modify something in the table and save it, all field imported desappear.

    • John_Halls
    • 7 days ago
    • Reported - view

    Hi Fred

    Worked for me, so not sure what was going on.

    Odd to see an Id of 44 in there for KPF with yours.

    Regards John

      • Fred
      • 7 days ago
      • Reported - view

      Thanks for trying it out. That is weird. I also see this happening in the v3.14.2 MacOS app. Just tried it with a local DB and the same thing. I've emailed support so I'll let you call know what they say.