Title: User Meta Data/Values Last modified: August 10, 2020 --- # User Meta Data/Values * Resolved [mvarela](https://wordpress.org/support/users/mvarela/) * (@mvarela) * [5 years, 10 months ago](https://wordpress.org/support/topic/user-meta-data-values/) * Hello, I need to import historical prior/certifications (from another system) into LearnDash system. * Is it possible to create and import user meta data/values as follows: * Meta Key: _sfwd-quizzes * Meta Value: a:1:{i:0;a:19:{s:4:\quiz\”;i:16850;s:5:\”score\”;i:1;s:5:\”count\”; i:1;s:19:\”question_show_count\”;i:1;s:4:\”pass\”;i:1;s:4:\”rank\”;s:1:\”-\”; s:4:\”time\”;i:1593109865;s:10:\”pro_quizid\”;i:62;s:6:\”course\”;i:15905;s:6:\” lesson\”;i:0;s:5:\”topic\”;i:0;s:6:\”points\”;i:1;s:12:\”total_points\”;i:1;s: 10:\”percentage\”;i:100;s:9:\”timespent\”;d:2.537999999999999811706175023573450744152069091796875; s:10:\”has_graded\”;b:0;s:16:\”statistic_ref_id\”;i:0;s:7:\”started\”;i:1593109863; s:9:\”completed\”;i:1593109865;}}” * Meta Key: _badgeos_active_achievements * Meta Value: a:1:{i:18081;O:8:\stdClass\”:11:{s:2:\”ID\”;i:18081;s:5:\”title\”; s:25:\”C)PTC Certification Badge\”;s:11:\”the_trigger\”;s:0:\”\”;s:9:\”post_type\”; s:6:\”badges\”;s:5:\”image\”;s:0:\”\”;s:8:\”rec_type\”;s:6:\”normal\”;s:6:\”points\”; s:0:\”\”;s:10:\”point_type\”;s:1:\”0\”;s:7:\”trigger\”;s:0:\”\”;s:18:\”last_activity_date\”; i:1596732635;s:12:\”date_started\”;i:1595603200;}}” * If so, can you provide an example document to illustrate how to format the Meta Values in the Excel sheet? * Thanks, Manny Varela - This topic was modified 5 years, 10 months ago by [mvarela](https://wordpress.org/support/users/mvarela/). Viewing 3 replies - 1 through 3 (of 3 total) * Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/) * (@carazo) * [5 years, 10 months ago](https://wordpress.org/support/topic/user-meta-data-values/#post-13235867) * Good morning [@mvarela](https://wordpress.org/support/users/mvarela/), * Yes, as in documentation is explained you can import serialized data: * > Plugin can now import serialized data. You have to use the serialized string > directly in the CSV cell in order the plugin will be able to understand it > as an serialized data instead as any other string. * If the serialized data comes from an array, you also can do it: * > Plugin can now import lists an array. Use this separator: :: two colons, inside > the cell in order to split the string in a list of items. * But in this case, as you can see, some are created from stdClass. * Thread Starter [mvarela](https://wordpress.org/support/users/mvarela/) * (@mvarela) * [5 years, 9 months ago](https://wordpress.org/support/topic/user-meta-data-values/#post-13277021) * Hello Javier, * I was able to import a sample of the above mentioned, to a test user (mile2test). The ARRAY was successfully imported, however, the (mile2test) user password was destroyed. Same result 3 times. I had to manually reset the password each time to gain access as (mile2test). Any ideas how this is happening? Below is a sample of the import file. I have 9000 records to import for this task. * username,email,_sfwd-quizzes mile2test,mile2test@mile2.com,”a:1:{i:0;a:19:{s: 4:””quiz””;i:7876;s:5:””score””;i:1;s:5:””count””;i:1;s:19:””question_show_count””; i:1;s:4:””pass””;i:1;s:4:””rank””;s:1:””-“”;s:4:””time””;i:1502928001;s:10:”” pro_quizid””;i:20;s:6:””course””;i:17457;s:6:””lesson””;i:0;s:5:””topic””;i:0; s:6:””points””;i:1;s:12:””total_points””;i:1;s:10:””percentage””;i:100;s:9:”” timespent””;i:1;s:10:””has_graded””;b:0;s:16:””statistic_ref_id””;i:0;s:7:””started””; i:1502928001;s:9:””completed””;i:1502928001;}}” * Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/) * (@carazo) * [5 years, 9 months ago](https://wordpress.org/support/topic/user-meta-data-values/#post-13279138) * The problem is that you have not read in “Documentation” how the passwords are managed, please read it before doing an import. * > Passwords (column password) A string that contains user passwords. We have > different options for this case: > If you don’t create a column for passwords: > passwords will be generated automatically If you create a column for passwords: > if cell is empty, password won’t be updated; if cell has a value, it will be > used Viewing 3 replies - 1 through 3 (of 3 total) The topic ‘User Meta Data/Values’ is closed to new replies. * ![](https://ps.w.org/import-users-from-csv-with-meta/assets/icon-256x256.png? rev=1174343) * [Import and export users and customers](https://wordpress.org/plugins/import-users-from-csv-with-meta/) * [Frequently Asked Questions](https://wordpress.org/plugins/import-users-from-csv-with-meta/#faq) * [Support Threads](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/) * [Active Topics](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/unresolved/) * [Reviews](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/reviews/) * 3 replies * 2 participants * Last reply from: [Javier Carazo](https://wordpress.org/support/users/carazo/) * Last activity: [5 years, 9 months ago](https://wordpress.org/support/topic/user-meta-data-values/#post-13279138) * Status: resolved