Problem when importing a csv File

SuiteCRM Forum - English Language
1

Hello,
i want to import a csv file from Excel into SuiteCRM but only the first 2 lines are imported and the file contains more than 400 lines.
I don’t think it is a problem with SuiteCRm because the system settings allows the import of more than 400 lines.
Can someone help find a solution?
Thanks

2

Hi Jordan, is there anything on your suitecrm.log or in the PHP error_log?
Which SuiteCRM version are you on?

3

i am literally new at suiteCRM, so i don’t know how to check my suitecrm.log or PHP error_log
the suitecrm version is 7.11.18

4

Have you got FTP access to your instance or is it on your locall machine?

You can also check your suitecrm.log in Admin > System Settings
image

and down the page:

image
image727×639 25.3 KB

5

yes after this step it shows me box(search box)
what should i do next?

6

Click on the “All” button please

7

yes i did
i can see many lines of texts

8

Hi @jordan
Please look at this thread you might get your answer here:-

1 Like
9

What errors do you see in the Import web page - after the import.
Can you share that screenshot here - that usually gives feedback about which records had errors.

A good trouble-shooting practise, that might help you here -is to ‘bifurcate’ -ie ‘try half at a time’

eg you wrote:

i want to import a csv file from Excel into SuiteCRM but only the first 2 lines are imported and the file contains more than 400 lines.

So - do the test again but with a file of only 200 line… then 100, then 50.
Or work up from other end - try with 10 lines, and if it works, with 20… etc

1 Like