Answers.Body: <p>The size limit that is an issue is on your webserver php configuration, usually under /etc/php5 on linux</p>
  
  <p>However and by experience, importing a lot of contacts via the web interface is painful. it will time out, you will need to restart and do the mapping of columns->fields, go through the wizard, wonder where it got stuck, see that civi expects "GB" and not "UK" or whatever...</p>
  
  <p>It's much better to write a simple cli script that uses the api to import them, it's going to be easier to run again if needed and way faster.</p>
  
  <p>importing 1.5 million organisations is definitely something you want to do from the cli if you value your time, and care about your mental health.</p>
  
  <p>check out the api explorer, it will generate you the code needed to import a contact</p>
  
  <pre><code>$result = civicrm_api3('Contact', 'create', array(
    'sequential' =&gt; 1,
    'contact_type' =&gt; "Organization",
    'organization_name' =&gt; "bla",
    'api.Address.create' =&gt; array('country' =&gt; "FR", 'city' =&gt; "Paris"),
  ));
  </code></pre>
  
  <p>wrap that with your loop reading your csv and you're good to go ;)</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-30T12:16:57.947Z
Answers.Text: Hi Xavier, Bonjour Xavier !
Answers.UserDisplayName: Michel GREGOIRE
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-30T12:25:08.693Z
Answers.Text: Hi Xavier, Bonjour Xavier !
  
  I think we are both french ! But lets continue in English, it will maybe help someone !
  
  I confirm to you: import though the CiviCRM procedure is really painful. My import timeout only authorize me a 8 000 import at each time. It means, this way, near 200 files to cut and import ! A titan work !
  
  You have to know that I'm a real newbie with this kind of import, hosting management, and command line mode. Could you explain to me very precisely how to import my files through the CLI procedure you're talking about !
  
  Many thanks bye advance !
  
  Michel
Answers.UserDisplayName: Michel GREGOIRE
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-30T13:00:07.903Z
Answers.Text: hi, I was suggesting to write a program to run the import. This isn't a complex one, but this needs a bit of coding. Do you have the skills or inhouse skills? you might want to look at bin/csv/import.php https://civicrm.org/blog/xavier/new-tools-to-automate-the-configuration-and-stagingproduction-migration
Answers.UserDisplayName: Xavier
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-30T14:00:33.087Z
Answers.Text: I'm sorry but your explanations are not enough clear for my little skills !
  
  At this time, the CSV look like : see here : All the contacts are "Organization", with Tag "Entreprise"[link](http://convergencecitoyenne.org/sites/default/files/exemple_import_CSV_comma_utf-8_CiviCRM.csv)
Answers.UserDisplayName: Michel GREGOIRE
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-31T08:47:33.153Z
Answers.Text: Hi ! I've tried to export /tmp/tagall.csvas you explain in your post. I use (like in Cron : username : Username, Password : Userpassword, site : CiviCRM-SiteKey. Is the followin command the good one ? Do I left the -u, -p -s before the credentials ? Command done  : php bin/csv/export.php -uUsername -pUserpassword -sCiviCRM-SiteKey Tag > /tmp/tagall.csv
Answers.UserDisplayName: Michel GREGOIRE
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-31T09:09:08.930Z
Answers.Text: I'vre made a search on tagall.csv and don't find any file :-(
Answers.UserDisplayName: Michel GREGOIRE
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-26T09:03:19.353Z
Answers.LastActivityDate: 2016-12-26T09:03:19.353Z
Answers.UserDisplayName: Xavier
Answers.Body: <p>I'm guessing 3Mo in some non-English language means 3MB...</p>
  
  <p>The upload limit is under Administer > System Settings > Misc.  That cannot be larger than the maximum file size in your php.ini so you will need to increase that as well.</p>
  
  <p>But whatever file sizes you configure there, things are unlikely to work well trying to import a single 150MB file.</p>
  
  <p>Does your 150MB figure relate just to name/address/email/phone information, or is that other data as well?</p>
  
  <p>If it has other data, you will need to prepare separate files for importing basic contact data, contributions, memberships, activities etc so your actual import files will be smaller.</p>
  
  <p>You can import multiple files of each type - it does not need to be a single import.</p>
  
  <p>Importing via the web pages works well enough for small data sets but there are other approaches that you might want to look at it if the data is large.  How many contacts do you have?</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-25T13:06:24.177Z
Answers.Text: Many thanks for the help ! The file only contains data regarding only orgaizations (Name, email address, and certain custom dats like Activity sector...)
Answers.UserDisplayName: Michel GREGOIRE
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-25T13:10:04.030Z
Answers.Text: The number of contact is approximately 1.5 millions organizations (split in 3 csv files)
Answers.UserDisplayName: Michel GREGOIRE
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-24T15:28:29.833Z
Answers.LastActivityDate: 2016-12-24T15:28:29.833Z
Answers.UserDisplayName: Aidan
Answers.Body: <p>First, change file upload size to 150 MB in the php.ini file and then, try to increase upload size through the CiviCRM(The upload limit is under Administer > System Settings > Misc > Maximum File Size (in MB)).</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-05-23T11:07:12.187Z
Answers.LastActivityDate: 2019-05-23T11:07:12.187Z
Answers.UserDisplayName: Abdul Samad
Body: <p>I have a great quantity of Contact to import in CiviCRM and I absolutely need to increase the actual 3MB limit to, at least, 150 MB, with a view to fit my needs.</p>
  
  <p>Many thanks for the help!</p>
  
  <p>Regards</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-10-13T18:45:12.350Z
Comments.Text: how do you change the file upload size in the php.ini file?
  Thanks for the help!
Comments.UserDisplayName: Stanley Tzankov
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-10-13T18:52:28.253Z
Comments.Text: Welcome to StackExchange. It looks like you are asking a question but you have posted this as an answer.
Comments.UserDisplayName: William Mortada
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-10-13T19:06:58.393Z
Comments.Text: It's also not really about CiviCRM. There's an answer here: https://stackoverflow.com/questions/2184513/change-the-maximum-upload-file-size
Comments.UserDisplayName: William Mortada
Tags: <contacts>
Title: Increase the import limit (3MB) for Contact import
ThreadText: # Increase the import limit (3MB) for Contact import
  
  (Asked by: username_0 on 2016-12-24)
  
  I have a great quantity of Contact to import in CiviCRM and I absolutely need to increase the actual 3MB limit to, at least, 150 MB, with a view to fit my needs.
  
  Many thanks for the help!
  
  Regards
  
  **Tags:** contacts
  
  > **Comments:**
  > **username_1**: how do you change the file upload size in the php.ini file? Thanks for the help!  
  > **username_2**: Welcome to StackExchange. It looks like you are asking a question but you have posted this as an answer.  
  > **username_2**: It's also not really about CiviCRM. There's an answer here: https://stackoverflow.com/questions/2184513/change-the-maximum-upload-file-size  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_3 on 2016-12-26. Score: 5
  
  The size limit that is an issue is on your webserver php configuration, usually under /etc/php5 on linux
  
  However and by experience, importing a lot of contacts via the web interface is painful. it will time out, you will need to restart and do the mapping of columns->fields, go through the wizard, wonder where it got stuck, see that civi expects "GB" and not "UK" or whatever...
  
  It's much better to write a simple cli script that uses the api to import them, it's going to be easier to run again if needed and way faster.
  
  importing 1.5 million organisations is definitely something you want to do from the cli if you value your time, and care about your mental health.
  
  check out the api explorer, it will generate you the code needed to import a contact
  
  ```
  $result = civicrm_api3('Contact', 'create', array(
    'sequential' => 1,
    'contact_type' => "Organization",
    'organization_name' => "bla",
    'api.Address.create' => array('country' => "FR", 'city' => "Paris"),
  ));
  
  ```
  
  wrap that with your loop reading your csv and you're good to go ;)
  
  > **Comments:**
  > **username_0**: Hi username_3, Bonjour username_3 !  
  > **username_0**: Hi username_3, Bonjour username_3 !  I think we are both french ! But lets continue in English, it will maybe help someone !  I confirm to you: import though the CiviCRM procedure is really painful. My import timeout only authorize me a 8 000 import at each time. It means, this way, near 200 files to cut and import ! A titan work !  You have to know that I'm a real newbie with this kind of import, hosting management, and command line mode. Could you explain to me very precisely how to import my files through the CLI procedure you're talking about !  Many thanks bye advance !  username_0  
  > **username_3**: hi, I was suggesting to write a program to run the import. This isn't a complex one, but this needs a bit of coding. Do you have the skills or inhouse skills? you might want to look at bin/csv/import.php https://civicrm.org/blog/username_3/new-tools-to-automate-the-configuration-and-stagingproduction-migration  
  > **username_0**: I'm sorry but your explanations are not enough clear for my little skills !  At this time, the CSV look like : see here : All the contacts are "Organization", with Tag "Entreprise"[link](http://convergencecitoyenne.org/sites/default/files/exemple_import_CSV_comma_utf-8_CiviCRM.csv)  
  > **username_0**: Hi ! I've tried to export /tmp/tagall.csvas you explain in your post. I use (like in Cron : username : Username, Password : Userpassword, site : CiviCRM-SiteKey. Is the followin command the good one ? Do I left the -u, -p -s before the credentials ? Command done  : php bin/csv/export.php -uUsername -pUserpassword -sCiviCRM-SiteKey Tag > /tmp/tagall.csv  
  > **username_0**: I'vre made a search on tagall.csv and don't find any file :-(  
  
  ---
  
  ### Answer by username_4 on 2016-12-24. Score: 2
  
  I'm guessing 3Mo in some non-English language means 3MB...
  
  The upload limit is under Administer > System Settings > Misc. That cannot be larger than the maximum file size in your php.ini so you will need to increase that as well.
  
  But whatever file sizes you configure there, things are unlikely to work well trying to import a single 150MB file.
  
  Does your 150MB figure relate just to name/address/email/phone information, or is that other data as well?
  
  If it has other data, you will need to prepare separate files for importing basic contact data, contributions, memberships, activities etc so your actual import files will be smaller.
  
  You can import multiple files of each type - it does not need to be a single import.
  
  Importing via the web pages works well enough for small data sets but there are other approaches that you might want to look at it if the data is large. How many contacts do you have?
  
  > **Comments:**
  > **username_0**: Many thanks for the help ! The file only contains data regarding only orgaizations (Name, email address, and certain custom dats like Activity sector...)  
  > **username_0**: The number of contact is approximately 1.5 millions organizations (split in 3 csv files)  
  
  ---
  
  ### Answer by username_5 on 2019-05-23. Score: 1
  
  First, change file upload size to 150 MB in the php.ini file and then, try to increase upload size through the CiviCRM(The upload limit is under Administer > System Settings > Misc > Maximum File Size (in MB)).
  
  
  ---
  
  