<p>You can use an <a href="https://straightupcraft.com/craft-plugins/feed-me" rel="nofollow">existing</a> <a href="https://straightupcraft.com/craft-plugins/import" rel="nofollow">import</a>/<a href="https://github.com/boboldehampsink/export" rel="nofollow">export</a> plugin that supports handling users, or you can write your own plugin that calls Craft's <a href="http://buildwithcraft.com/classreference/services/UsersService#saveUser-detail" rel="nofollow">UsersService->saveUser()</a>, which takes care of saving the right data into the right tables in the database.</p>

CC BY-SA 3.0
2015-05-28T11:46:57.127Z
cheers @Brad tried using the import plugin but the csv file I am importing is large. The whole database comes in at 38mb. We've stripped the csv down to only include user related tables. (not sure on what needs to be included here any advice welcome) which still comes in at 7.5mb and I get this error: 

Fatal error: Out of memory (allocated 34078720) (tried to allocate 107 bytes) in crafttest/craft/plugins/import/services/ImportService.php on line 725

Is there a way to increase the limit?
Lettie
CC BY-SA 3.0
2015-05-28T15:40:48.490Z
I have now managed to add the users to the database along with the elements table and elements_i18nl table. Without the plugin due to above.  I have emailed Bob to look into this. My problem now is that the users show in the database as enabled and I can login with a user. However in the CP none of the users are showing except the original 3 users I set up. What am I missing? Another table that needs to be imported?
Lettie
CC BY-SA 3.0
2015-05-27T18:04:39.613Z
2015-05-27T18:04:39.613Z
Brad Bell
<p>Ok this is now a general question as I managed to import the user table to the database.</p>

<p>Unfortunately it appears that whilst the users all show in the database they do not show in the CMS. Digging a bit deeper it seems they are related to the elements table as each appear to have an entry with a type User.</p>

<p>So my question now is how can you import your existing user list into a new craft set up without breaking it or anything else. With over 10000 users this is not one to be done manually.</p>

<p>Any help appreciated.</p>

CC BY-SA 3.0
2015-05-27T16:42:17.107Z
This isn't super helpful, but did you try the [Export plugin](https://github.com/boboldehampsink/export)? Pretty sure it can handle User export/import.
Mats Mikkel Rummelhoff
<users><database>
How to import existing users into database
# How to import existing users into database

(Asked by: username_0 on 2015-05-27)

Ok this is now a general question as I managed to import the user table to the database.

Unfortunately it appears that whilst the users all show in the database they do not show in the CMS. Digging a bit deeper it seems they are related to the elements table as each appear to have an entry with a type User.

So my question now is how can you import your existing user list into a new craft set up without breaking it or anything else. With over 10000 users this is not one to be done manually.

Any help appreciated.

**Tags:** users, database
> **Comments:**
> **username_1**: This isn't super helpful, but did you try the [Export plugin](https://github.com/boboldehampsink/export)? Pretty sure it can handle User export/import.  

---

## 1 answers

### Answer by username_2 on 2015-05-27. Score: 1

You can use an [existing](https://straightupcraft.com/craft-plugins/feed-me) [import](https://straightupcraft.com/craft-plugins/import)/[export](https://github.com/boboldehampsink/export) plugin that supports handling users, or you can write your own plugin that calls Craft's [UsersService->saveUser()](http://buildwithcraft.com/classreference/services/UsersService#saveUser-detail), which takes care of saving the right data into the right tables in the database.

> **Comments:**
> **username_0**: cheers @Brad tried using the import plugin but the csv file I am importing is large. The whole database comes in at 38mb. We've stripped the csv down to only include user related tables. (not sure on what needs to be included here any advice welcome) which still comes in at 7.5mb and I get this error:   Fatal error: Out of memory (allocated 34078720) (tried to allocate 107 bytes) in crafttest/craft/plugins/import/services/ImportService.php on line 725  Is there a way to increase the limit?  
> **username_0**: I have now managed to add the users to the database along with the elements table and elements_i18nl table. Without the plugin due to above.  I have emailed Bob to look into this. My problem now is that the users show in the database as enabled and I can login with a user. However in the CP none of the users are showing except the original 3 users I set up. What am I missing? Another table that needs to be imported?  

---

