Changing the export values

Discuss MySQL Ajax Table Editor

Changing the export values

Postby a-glas » Sun Jun 30, 2019 8:32 pm


Im new by AJAX Table editor. This Software is great and almost easy to understand, but i have some problems to formate the Export.
I have in my Database serveral colums for : name,Number, ... ( Testuser, Testnumber,Teststreet,..)
i like to export der Colums Name, Number,.. that i have filtered by the searchconsole to a .csv with this format:
Testuser Testnumber Teststreet

so no " quotation marks and else are required. the text should only be seperated by one blank space

i hope someone can help me

Humer Johannes
Posts: 4
Joined: Sun Jun 30, 2019 8:01 pm

Re: Changing the export values

Postby KarelB » Tue Jul 09, 2019 10:48 am


You can set the delimiter but you cannot control the quotes.
But you can override the class and define our own local export function "exportInfo"


BTW exporting with spaces and no quotes only works if you are absolutely sure there are no spaces in your data.
Posts: 458
Joined: Mon Dec 01, 2008 11:49 pm
Location: The Netherlands

Re: Changing the export values

Postby a-glas » Tue Jul 23, 2019 7:31 pm


Thanks for showing the right direktion :-)
i only have to change the export values under:
$exportRow[] = ''.str_replace(array("\r", "\n", '"'),array('','','"'),$value).'';

in the AjaxTableEditor.php file.

and i have changed the exportDelimiter from ',' to ' '

now it works that i can import the Adresses from thor exportet file in Gmaps

Best Regars

Humer JOhannes
Posts: 4
Joined: Sun Jun 30, 2019 8:01 pm

Return to Open Discussion

Who is online

Users browsing this forum: No registered users and 4 guests