Import maximum upload.

đź’¬ General Discussion
1

I have local installed SuiteCRM (Bitnami) 7.6.4 working fine. No Need for Cloud.
I have made Backups, to be safe.

My Problem:

For a new fresh IMPORT,I deleted all Account and Contacts data, so to keep the field-names as they were.
I started to import, a CSV file , some 48.000 KB size , (what I see from the file-size in the directory.

I did the mapping and after waiting some 30-40 minutes it still is "waiting"or anyhow no bar coming up import 100,200-300 of the 55.000 Accounts
I did a test CSV, extracted from the same CSV, for only a small 35 Accounts, an that is working.

Upon importing the big CSV files, I got error …Max_upload_file" too big , or similar expression.

I checked in PHP.INI, and there I see, the original value Max Upload Size = 40K

I tried 100K and even 1000K, but no show of increasing Import bar importing 100,200,300…

What is wrong.? What is the K meaning 40.000 ?? or should I write there in the INI 60000 or such high value.
I can create of course a complete new,fresh SuiteCRM 7.6.4 , then creating new field names etc etc, but a lot of work…

The deleting of Accounts was easy, but deleting Contacts, costs me 4 hours, to do it with each Country filters…,maybe an OTHER WAY ?..?
Like to keep the other Modules I made, being preserved.

Thanks for help.

William…

2

Hi Petrovlis,

There are a few things going wrong here but I’m happy to throw some suggestions your way. The first thing ill bring up is that 7.6.4 is a very outdated version of our codebase and has lots of issues the newer version don’t. I would definitely suggest upgrading your instance to at least 7.10 which I would be happy to guide you through if you want to give that a try.

I’m assuming you mean after a fresh install? If so during the installation process you can choose to not include demo data. This will leave you with an empty “production” ready CRM.

[quote]I started to import, a CSV file , some size , (what I see from the file-size in the directory.
I did the mapping and after waiting some 30-40 minutes it still is "waiting"or anyhow no bar coming up import 100,200-300 of the 55.000 Accounts[/quote]
To confirm you’re attempting to import 55000 records with a CSV file with the size 48000KB (48MB)?

[quote]Upon importing the big CSV files, I got error …Max_upload_file" too big , or similar expression.
I checked in PHP.INI, and there I see, the original value Max Upload Size = 40K
I tried 100K and even 1000K, but no show of increasing Import bar importing 100,200,300…[/quote]
Have you tried restarting your apache or other hosting services after making the change? On the command line run

service apache2 restart

You may also need to increase the following values;

Set post_max_size to at least 60MB
Set upload_max_filesize to at least 60MB
Set max_input_time to a larger number
Set memory_limit to 256MB
Set max_execution_time to a larger number

Side Note: I believe K in this meaning is standing for thousand, is shorting meaning 40 thousand bytes

Let me know if any of the above works and again I suggest looking at upgrading or starting off with a fresh instance of our current LTS 7.10.x