Error importing data to database

❓ Ask Anything
1

Hello, I’m trying to import some dummy data to the database, in my case the “Posts” database.

image
image1350×1214 44.9 KB

Here is the excel sheet I’m trying to upload:

https://drive.google.com/drive/folders/1120HLXd3eloTF-THepf56eRgtqJU3wqL?usp=sharing

For table mapping, i select Posts.

For fields mapping, i select relevant fields in the excel sheet.

For relation mapping, i select ignore on all.

Then i get this error when trying to preview. Any ideas?

2

Yeah, we are revamping the import/export feature. It’s a shit show at the moment.
But anyhow, the rand() is causing the problem. Copy and paste value.

1 Like
3

That worked, thank you!