Okay
  Public Ticket #3029709
CSV Separator when export
Closed

Comments

  • Adrian Ghio started the conversation

    How do I change the comma separator when export table data to csv?

    I need change "," to ";".

    I already changed on setting -> Main Configuration, but when export table data to CSV, still get "," as separator.

  •  1,851
    Miloš replied



    Hi, Adrian

    Firstly i want to apologise for the delayed response time.

    We celebrated our Orthodox Easter, which has slowed down our working pace.

    Thank you very much for your patience.

    -

    These functionalities are based on a 3rd party HTML5 library. There are some limitations in this library we will emphasize for your awareness:

    • Generated PDF, XLS, CSV are not customizable. Unfortunately, the library allows very little “fine-tuning” of the generated files, so font, size, and other properties cannot be changed (but the title can – see below).
    • Conditional formatting is not reflected in any of generated export files.


    The “CSV” button generates a new file that can be opened in a browser or third party spreadsheet editing software, like Libre office. If it is opened in a browser, the file will be in the “Comma-Separated-Values” format out of the table and calls the browser’s “Save as …” dialog so you can choose a path for your file. All the values from your table will be exported including the headers. The cells will be separated by commas, and rows will be separated by line breaks:

    6563200165.png

    This setting that you changed, is only being set for importing CSV to create a table, or linking a table to CSV file source.

    5171167155.jpg

    -

    Our developers will work to improve the Export  functionalities, but I can't say an ETA on it.

    You can suggest this as a built-in feature on this page and our developers would place it on their "TO-DO" list.

    As more customers request a feature, it gets pushed quicker on the list. We always strive to make our product better and deliver the most value to our end users, so we carefully review each suggestion.

    And you can follow our changeLog page, where we always state new features/changes on each Update.


    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables