I’m moving data from a live app (built & currently functional in Adalo) to a new app (not yet deployed with Adalo). And the import fails every time. I’ve tried in Chrome & Safari browsers, and get the same result.
The data is migrating because database relationships needed to change to meet user demands.
That’s a good question. In my case I specifically added the characters so I checked on a hunch and was right.
Sometimes, when copying and pasting, strings with apostrophes get messed up and you find weird looking characters in their place. These should stand out when looking through the database. MS Word and Excel can be a source as can copying and pasting from editors which support double bit fonts like Japanese and Chinese.
Where did the database content come from? Did you copy from a web page? Did you pass it through a word processor? Sometimes you can strip these Unicode characters out by pasting into a text editor first.
I mean about the original data. Where did it come from? Is it just users? It’s unlikely that the e-mail field has extended characters, unless Hide My EMail inserts the confounding data. Search around for that.
All of the data was user generated (Name, Email, Password, Profile pic, etc).
It seems like the issue is the hide my email & password fields. In the most recent attempt, I did not sync / carry over the passwords. Data for 193 Users successfully migrated over. And lost 7 Users. All of those Users whose data did not transfer had created accounts with Apple login, using the “Hide My Email” option.
Thank you for your help & leading me towards a solution!