The import of data in test works but it no longer works when we publish and the application becomes Current

Maxo42

When my application is in test and I import the data, it works and I can see in my application the 28,000 records that the database represents. On the other hand, when I publish the application and it becomes current. The Records disapear. So I re-import my data the same way as in test and I get this error message when I try to view my recordings.
Capture d’écran 2023-05-03 163732.png
Capture d’écran 2023-05-03 164012.png

Thanks for your help.

customaware

How do you Import?
Did you create an Import Template?
If so, did you Export your Import Template from your test machine and Import it onto your Server?

joben

Make sure there is no faulty or weirdly formatted data in your production database table.
You should do a "SELECT * FROM tablename" on the test database table and compare it to the production database table.

We screwed up an import once, and one row prevented the query from displaying anything. I think the conclusion was that we accidentally imported an .xlsx file (which there is no support for), and we got the same result as your error messages when trying to display the query.

Jaymer

yep, importing excel by accident is a PITA

Had another user import a Excel file instead of CSV, trashed the grid

Maxo42

joben wrote
Make sure there is no faulty or weirdly formatted data in your production database table.
You should do a "SELECT * FROM tablename" on the test database table and compare it to the production database table.

We screwed up an import once, and one row prevented the query from displaying anything. I think the conclusion was that we accidentally imported an .xlsx file (which there is no support for), and we got the same result as your error messages when trying to display the query.

Exactly, I was no longer able to download my database, because my project had been corrupted by downloading the .xls file that I had done by mistake before downloading the .csv file. Luckily I had made a backup. So I started a new project by downloading a .csv file without having downloaded the .xls file just before and now everything works. Thank you Joben 🙂

lueu

Is there really no support for importing excel-files? I would like to make it possible for users to import an excel file instaed of having to punch one line after the other..