Title: Bulk adding avatars
Last modified: August 21, 2016

---

# Bulk adding avatars

 *  [pax](https://wordpress.org/support/users/u8ik/)
 * (@u8ik)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/bulk-adding-avatars/)
 * I am trying to bulk add avatars to users directly in the `wp_usermeta` table 
   by adding the following rows:
 *     ```
       <auto-increment>	<user-id>	simple_local_avatar	a:3:{s:8:"media_id";i:230;s:4:"full";s:78:"http://site-root/wp-content/uploads/2014/01/filename.jpg";i:96;s:84:"http://site-root/wp-content/uploads/2014/01/filename.jpg";}
       <auto-increment>	<user-id>	simple_local_avatar_rating	G
       ```
   
 * – for the sample above I haven’t updated the string length in the serialized 
   entry
 * if I do this nothing happens, though, if I manually choose the same picture from
   the Library the avatar works even though there’s the same row in the db. Is there
   somewhere else where I need to add/register something?
 * [http://wordpress.org/plugins/simple-local-avatars/](http://wordpress.org/plugins/simple-local-avatars/)

Viewing 1 replies (of 1 total)

 *  [Chris](https://wordpress.org/support/users/charlwood/)
 * (@charlwood)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/bulk-adding-avatars/#post-4531900)
 * This would be of interest to myself also. 🙂

Viewing 1 replies (of 1 total)

The topic ‘Bulk adding avatars’ is closed to new replies.

 * ![](https://ps.w.org/simple-local-avatars/assets/icon.svg?rev=2783752)
 * [Simple Local Avatars](https://wordpress.org/plugins/simple-local-avatars/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/simple-local-avatars/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/simple-local-avatars/)
 * [Active Topics](https://wordpress.org/support/plugin/simple-local-avatars/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/simple-local-avatars/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/simple-local-avatars/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [wp_usermeta](https://wordpress.org/support/topic-tag/wp_usermeta/)

 * 1 reply
 * 2 participants
 * Last reply from: [Chris](https://wordpress.org/support/users/charlwood/)
 * Last activity: [12 years, 3 months ago](https://wordpress.org/support/topic/bulk-adding-avatars/#post-4531900)
 * Status: not resolved