Jump to content
  • 0

Import falied


innov2e
 Share

Question

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?

Link to comment
Share on other sites

6 answers to this question

Recommended Posts

  • 0
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.

Link to comment
Share on other sites

  • 0

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.

Link to comment
Share on other sites

  • 0
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/

Link to comment
Share on other sites

  • 0

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...