FAQ datastore fails import after 390 rows

[johnvw1967]

Hi, 

I have tried to import a CSV file with aprox 700 FAQs, but so far without succes. The import stops after aprox. 390 rows. I tried to split the main file into 7 sub files, but then it will import to about 500 FAQs and after this it wil only import ~25 rows from the remaining files. The import procudure does not gererate any faults, it just starts saying "busy importing 700 rows", after a while it says "import 390 rows succeeded"... The succeeded rows appear in the Documents Tab.

I even tried to use a BiqQuery table where I importerd all the FAQs, but without succes, the import stops after ~530 rows. 

I checked the file size, this is well within the limits: 140kB for 700 FAQs. The succeeded imported FAQs do work well. The scheme is question,answer,title,url.

Can anyone advise?

[caryna · Accepted solution]

Hi @johnvw1967,

Welcome to Google Cloud Community!

As outlined in the import limitation, the following must not be included:

• Extra space character after, causes an error.
• Blank lines (even at the end of the file) cause an error.

You can review the affected rows if it doesn't include the following limitations above. Additionally, ensure that these rows don’t have any special characters and are formatted in UTF-8. 

Was this helpful? If so, please accept this answer as “Solution”. If you need additional assistance, reply here within 2 business days and I’ll be happy to help.

[caryna · Accepted solution]

Hi @johnvw1967,

Welcome to Google Cloud Community!

As outlined in the import limitation, the following must not be included:

• Extra space character after, causes an error.
• Blank lines (even at the end of the file) cause an error.

You can review the affected rows if it doesn't include the following limitations above. Additionally, ensure that these rows don’t have any special characters and are formatted in UTF-8. 

Was this helpful? If so, please accept this answer as “Solution”. If you need additional assistance, reply here within 2 business days and I’ll be happy to help.

[johnvw1967 · Accepted solution]

Hi @caryna ,

Thanks for your reply!

I checked all this and it turns out that there are no extra spaces or blank lines. The funny thing is when I create a new FAQ CSV with random text, over a 1000 lines, it works well. So my gues is that the original CSV file contains some special characters which the import process doesn't like. The file is formatted in UTF-8. 

At least I am sure now that the import process is  working like it should and have to focus on the file.

Thanks again, have a great day!