User Meta Data/Values

  • Resolved mvarela

    (@mvarela)


    4 years, 3 months ago

    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 4 years, 3 months ago by mvarela.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Javier Carazo

    (@carazo)

    Good morning @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

    (@mvarela)

    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,[email protected],”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

    (@carazo)

    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.