Problem loading data from CSV

  • Resolved rob1951

    (@rob1951)


    5 years, 7 months ago

    I have 3 marker categories red, green, yellow. An individual marker may be in any or all categories i.e. any of g,r,y,rg,ry,gy,rgy
    When I export markers I get these columns marker_group_id,marker_group_ids.0,marker_group_ids.1,marker_group_ids.2
    id 0/1/2 appear to represent the categories so a marker in categories gry will show 1,2,3 in columns 0/1/2.

    When I import that file marker_group_ids.1 & marker_group_ids.2 get dropped so when I select to just show markers in one category many markers are missing (and re exporting shows only marker_group_id,marker_group_ids.0)
    For example green is the first category, selecting to show just that one the result is correct, it shows all those that include green: g,rg,gy,rgy That is the correct result
    But selecting red only shows r (not ry, rg or rgy) and selecting yellow only shows y and ry (not gy or rgy)

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter rob1951

    (@rob1951)

    5 years, 7 months ago

    Loading the markers CSV doesn’t update table wp_gmp_marker_groups_relation correctly. A fix for the “save and re-import” issue might be to dump that table when doing the save and re-import that manually too. (wp_gmp_markers may need the same)

    Plugin Support Support Ole

    (@trsupsys)

    5 years, 6 months ago

    Hi, @rob1951
    Please contact us through our
    internal support.
    We will help you to solve the problem.

    Best regards,
    Ole

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

The topic ‘Problem loading data from CSV’ is closed to new replies.

Tags