Export Query Results Issues

  • Resolved PatJ

    (@patj)


    1 year, 2 months ago

    Running a SQL Query and selecting to export as CSV produces a file with text not delimited and comma as separator. This is useless with the average post as text is very likely to contain commas and quotes.
    Ideally a choice of delimiter (including none) and separator should be offered.
    Exporting the results as either a JSON or XML file also produces errors when trying to then import that file into Excel due to malformed JSON and XML.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    1 year, 2 months ago

    Hi @patj,

    Thanks a lot for the feedback!

    I’ll forward this to Peter and add this to his Feature Request list for him to consider.

    Let us know if you have additional suggestions or questions. 😊

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    1 year, 2 months ago

    Hi @patj

    The Query Builder CSV export complies with the CSV specs. Text is written between double quotes.

    Here is an example of an export containing strings:
    https://ibb.co/zW9RdTYc

    If your text is not written between double quotes, can you please share your create table script?

    Thanks,
    Peter

    Thread Starter PatJ

    (@patj)

    1 year, 2 months ago

    It’s rather strange because it is working now, though I have the previous csv export to prove that it wasn’t. There has been an update or two since which may have helped.

    I haven’t re-tested XML or json though.

    Plugin Contributor Kim L

    (@kimmyx)

    1 year, 2 months ago

    Hi @patj,

    Thanks for the response!

    We’re glad it’s working on your end now.

    If the issue reoccurs, please message us via Contact | WP Data Access so we can take a closer look.

    We’ll wait for your email! 🙏

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

The topic ‘Export Query Results Issues’ is closed to new replies.