Not adding data

  • Resolved blastiu17

    (@blastiu17)


    7 years, 10 months ago

    We are using your plugin for a school website and have included two additional columns for building and website for our teachers listing. When we run the import, it creates the new columns but doesn’t populate with the data.

    I’ll attach a screen shot of the plugin page after the import.

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author ERA404

    (@era404)

    Hello @blastiu17,

    Could you make your CSV available to us for testing?

    Thread Starter blastiu17

    (@blastiu17)

    Sure thing. Test CSV

    Plugin Author ERA404

    (@era404)

    Hello @blastiu17,

    Please update StaffList to v2.2.1 to see if your issue is resolved.

    We were able to reproduce your issue immediately with the help of your CSV and decided to rewrite the insert queries using:
    $wpdb->query($wpdb->prepare()) replacing $wpdb->Insert().

    Hope this helps

    • This reply was modified 7 years, 9 months ago by ERA404.
    Thread Starter blastiu17

    (@blastiu17)

    Yes! It allowed the import and population of the fields. Would there be any reason why a longer webpage address hyperlink would cause an issue as a field for an additional column? Is there a maximum character length for the add-on fields.

    Plugin Author ERA404

    (@era404)

    Hello @blastiu17,

    The current column width is 64 characters (stafflist/stafflist_setup.php).
    We can increase this if it’s not sufficient, but it seems suitable for most common uses.

    Best

    Thread Starter blastiu17

    (@blastiu17)

    Perfect! I increased that to 128 and it works great. Some of the school’s nested page addresses can get a bit lengthy (district/school/grade/department/etc…). Thank you so much for your help.

    Plugin Author ERA404

    (@era404)

    Hello @blastiu17,

    That’s good to hear.
    We’ll make that change in the next release so that you can upgrade the plugin without having data truncated. Please leave us a review if you feel so inclined. We rely on feedback from users like you to qualify the time we put into these plugins. Thank you for using StaffList.

    Best

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Not adding data’ is closed to new replies.