Import falied

[vidierre]

I have a student table named for_studenti with 2 unique keys:
- The first is a GUID
- the second is a concatenation of fields firstname, lastname, email, region, city, fiscalcode (this is an Italian unique code for each citizen)

There are no triggers.

I'm trying to import some student whit the same EXCEL I used before and the students I am importing are all new. It was working until some days ago, now I get this message:

Imported Table:

• for_studenti 
  No records were imported. 47 records failed.
  • Error(s) when inserting row. Number of errors: 47.

regardless the number of students. I tryed also using one new student only but I got the same msg (obviously referring to one record).

How can understand which is the error?

[kpcollier]

3 hours ago, innov2e said:

As far as I know Caspio do not provide any further details about the error he got.

This has been my experience as well. As far as I know, there isn't any way to find out more about the error besides the initial error message you get.

[Kurumi]

Hi @innov2e - what type of import “Action” (append, replace, or update) are you using? Are you doing a manual or scheduled importing? Do you have unique fields on your table?

[vidierre]

Hi @Meekeee I am doing a manual append in the same way I did before to the for_student table. And yes I have the unique fields I described before: one is a GUID and the other is a concatenation of fields I checked and there are non duplications because one of such fields is unique for each person in our country.

[IamNatoyThatLovesYou]

Hello @innov2e, I also received this error and resaving the file may help.

- Natoy

[RuisiHansamu]

6 hours ago, IamNatoyThatLovesYou said:

Hello @innov2e, I also received this error and resaving the file may help.

- Natoy

Following up on Natoy's comment, that is true. I tried to save the file and it helped me. Also, wanted to share this best practices as well for anyone's convenient. https://howto.caspio.com/tables-and-views/scheduled-import-and-export/scheduled-tasks-datahub/

[vidierre]

Thank to all of you for sharing suggestions and references. But I was proposing a more wide question: when Caspio shows Error when inserting rows there is any place or tool to see which error Caspio has detected? The msg could be arised for duplicated unique fields, or missing fields to be used in formulas, or constrains in relationships.

As far as I know Caspio do not provide any further details about the error he got.