My excel file contains 1500 records,I tried to import data via toolkit but only 199 records are inse

Ranapratap Bhopale asked on July 6, 2018 14:59

My excel file contains 1500 records,I tried to import data via toolkit but only 199 records are inserted.why its only inserting 199 records instead of 1500?

Correct Answer

Ranapratap Bhopale answered on July 9, 2018 09:24

Got it. I resolved!!! Actually I deleted 1 row from excel and no data in that row,kentico toolkit check for 1st blank row and if the row is blank it consider as excel is finished. So the solution is keep records continuously and make sure that not a single row in records is blank.all are continuous.

0 votesVote for this answer Unmark Correct answer

Recent Answers

vasu yerramsetti answered on July 6, 2018 16:19

@Ranapratap

Check in Event log for errors if any to further troubleshooting and find the root cause.

Please confirm, what is the Kentico Version? and What type of object(Pages, Attachment, Objects etc.,) you used to import into Kentico?

1 votesVote for this answer Mark as a Correct answer

Ranapratap Bhopale answered on July 9, 2018 08:46

@vasu - There is no error in event log. kentico version : 11 object Pages Import toolkit 11.0

I tried with new excel sheet but its not entering data more than 199 records

0 votesVote for this answer Mark as a Correct answer

vasu yerramsetti answered on July 9, 2018 09:26

@Ranapratap

  1. How many fields you imported into Kentico from Excel as a Page type?
  2. Is field size equal to excel data length for each field?

Please confirm.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.