Meta Field for Import?

Hi,

The avatars are stored in the usermeta table with the key ‘user_avatar’ prefixed with the current blog prefix.

For a non-multisite installation with the default ‘wp_’ prefix the key would be ‘wp_user_avatar’. You can check to see which key your website uses by performing this query:

SELECT * FROM `wp_usermeta` WHERE `meta_key` LIKE '%user_avatar'

I hope this helps.

Thanks for that. My prefix is ryj_

I gave it a try but it’s not working for me.

I’m trying to use WPAllImport plugin but I am feeling it a column full of absolute URLs for images that aren’t in the media library yet.

Maybe it would make a difference if I upload them all and then sanitize the column so only the image name and extension remain in each row rather than the full URL? Do you think that would be enough to attach the image to this meta field?

The meta field is supposed to store the image ID and not the URL. Avatars are just like any other attachment images, so try importing your attachments first. The plugin would expect them to have the same IDs so doing this on a fresh install would be ideal.

Hi Daniel,

Ah! Okay thank you for explaining, I didn’t think of that.

Okay so I think my only option would be to upload the 291 attachments, then write down all 291 ID’s and paste them one by one into the spreadsheet.

Trying to see if there’s a way of doing that without me having to do it all manually one by one as that defeats the point of using the import spreadsheet to save time.

At that point I may as well just work through all 291 users in the dashboard and add the images manually one by one.

I will contact the WP All Import guys and see if they can find a way to streamline this process.

I appreciate you.