CSV Export for checkbox and multi-select fields

  • Resolved andreaskes

    (@andreaskes)


    5 years, 7 months ago

    Hy,
    my Problem is that when i want to export user data with the help of “All Export” to a csv file, all multi-select or checkbox fields have unusable data like this:

    “a:3:{i:0;s:7:””Banking””;i:1;s:9:””Stock””;i:2;s:18:””Financial Services””;}”

    What i need is only the listing of the pure values (like Baking, Stock, Financial Services). But in the csv file there is a lot of additional information.

    What am i missing?
    What can i do to strip these data from checkbox or multi-select fields?

    Thx a lot
    Best regards
    Andreas

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor Champ Camba

    (@champsupertramp)

    5 years, 7 months ago

    Hi @andreaskes

    Could you please link me to the All Export plugin that you’re talking about? I’ll see if I can create a code to make those select/checkbox field data unserialized.

    Regards,

    Diabolo

    (@cebuss)

    5 years, 7 months ago

    @champsupertramp

    Likely, but not definite, this plugin: https://en-au.ww.wp.xz.cn/plugins/import-users-from-csv-with-meta/. Even if not the specific plugin it would affect all similar.

    Used it to set up a test site (exported to get an idea of the fields then used it to import a few hundred “members” from generated data). For my use case it wasn’t an issue but I could see it being a bit of a pain if I was exporting to manipulate the data externally.

    Thread Starter andreaskes

    (@andreaskes)

    5 years, 7 months ago

    The Plugin is WP All Import. (https://www.wpallimport.com/)
    Thx for offering your help.
    But i recently found a solution by myself and wrote a function to clean the output.

    function clean ($cle) {
    $lol = unserialize($cle);
    $comma_separated = implode(“, “, $lol);
    return $comma_separated;
    }

    Works very well.

    Regards,
    Andreas

    Plugin Contributor Champ Camba

    (@champsupertramp)

    5 years, 7 months ago

    Hi @andreaskes

    Thanks for letting us know how you resolve the issue. Others might find it helpful.

    I am closing this thread now.

    Regards,

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘CSV Export for checkbox and multi-select fields’ is closed to new replies.