CSV import mapping doesn’t show any table fields

  • Resolved snyggapa

    (@snyggapa)


    5 years, 6 months ago

    Hi Peter, thank you for your work on this plugin and I hope that you can help me with a query.

    I am using the CSV import to load up a CSV into a custom table. The wordpress database I am working on is a dev one so has been restored from another site, but this used to work. I am not sure of the trigger to make it stop working, it may be the creation of another custom table which I created with “copy” from an existing custom table.

    I create a new CSV import, upload the CSV, the click mapping. I get a list of columns in the file but the “database” columns do not populate. I can select the destination table in the dropdown but nothing happens to populate the columns under the “table” heading.

    Any help would be appreciated.

    Thanks

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years, 6 months ago

    Hi @snyggapa,

    The plugin uses an ajax call to select the columns to prepare the mapping. Can you please check if the ajax call is returning a valid response? To check this, open the inspector, activate the network tab and check the ajax response. What do you get?

    Let me know if you need help…

    Thanks,
    Peter

    Thread Starter snyggapa

    (@snyggapa)

    5 years, 6 months ago

    Thanks Peter, that has given me something interesting. I can see the call to
    https://lexi2.penguinit.co.uk/wp-admin/admin.php?action=wpda_get_columns

    but the response looks odd as it ha a could of “php close” tags in front of the json – I assume this is not normal? I will try and disable plugins/change themes etc and report back.

    —

    ?>

    ?>
    [{“column_name”:”id”},{“column_name”:”Sport”},{“column_name”:”SubSport”},{“column_name”:”ImpairmentGroup”},{“column_name”:”Type”},{“column_name”:”Category”},{“column_name”:”Script”},{“column_name”:”ButtonColour”},{“column_name”:”Image1″},{“column_name”:”Image2″},{“column_name”:”Image3″},{“column_name”:”Image4″},{“column_name”:”Image5″},{“column_name”:”Image6″},{“column_name”:”Image7″},{“column_name”:”Image8″},{“column_name”:”Image9″},{“column_name”:”Image10″},{“column_name”:”VideoLink”},{“column_name”:”url”},{“column_name”:”summerwinter”},{“column_name”:”displaygroup”},{“column_name”:”videolink2″},{“column_name”:”displaystyle”},{“column_name”:”teamsize”},{“column_name”:”teampoints”},{“column_name”:”teamexample1″},{“column_name”:”teamexample2″},{“column_name”:”teamgroups1″},{“column_name”:”teamgroups2″}]

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years, 6 months ago

    Hi @snyggapa,

    This usually happens when a plugin or theme writes some text to the response stream. Is there any code added to the functions.php?

    Please keep me posted,
    Peter

    Thread Starter snyggapa

    (@snyggapa)

    5 years, 6 months ago

    yep, hands up, it is a plugin doing something odd – probably one that I am chopping about – I didn’t realise that the plugin code was run as part of every interaction with everything – a valuable lesson learned.

    Thanks for your quick and accurate assistance

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years, 6 months ago

    Great you solved it! 🙂

    Thread Starter snyggapa

    (@snyggapa)

    5 years, 6 months ago

    the cause was two extra close tags at the very end of a plugin file:

    ?>

    ?>

    I took them out and still had a slightly odd issue, but that may have been carriage returns or whitespace after the correct ?> closing tag which I have now removed.

    Anyhow – all sorted now, thank you. An another valuable lesson about PHP and wordpress.

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

The topic ‘CSV import mapping doesn’t show any table fields’ is closed to new replies.