Changing the export values

Discuss MySQL Ajax Table Editor

Changing the export values

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

Hello

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

Thanks
Humer Johannes
a-glas
 
Posts: 4
Joined: Sun Jun 30, 2019 8:01 pm

Re: Changing the export values

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

HI

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"

karel

BTW exporting with spaces and no quotes only works if you are absolutely sure there are no spaces in your data.
KarelB
 
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

Hello

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
a-glas
 
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 2 guests

cron