how to export contact form db to excel

Is there a “&start=<number>&end=<number>” in your URL? Post what is in your URL when you access the page.

localhost:8080/localsotcnew/wp-admin/admin-ajax.php?action=cfdb-export&form=Enquiry_copy&show=name%2Ccontactno%2Cemailaddress%2Ctourtype%2Ctraveldate%2CSubmitted&filter=submit_time%3E%3D%24_GET%28start%29%26%23038%3B%26%23038%3Bsubmit_time%3C%3D%24_GET%28end%29

It is giving empty results..

[No bumping. If it’s that urgent, consider hiring someone.]

When I run this thru URL decoding, it shows:

localhost:8080/localsotcnew/wp-admin/admin-ajax.php?action=cfdb-export&form=Enquiry_copy&show=name,contactno,emailaddress,tourtype,traveldate,Submitted&filter=submit_time>=$_GET(start)&&submit_time<=$_GET(end)

That is not what I meant. I meant the URL of the page that has the short code on it. You may be misunderstanding how $_GET works. It goes in a short code but not in a URL. The actual value goes in a URL.

Let’s say I create a post in WP, and the URL of that post is:
https://localhost:8080/?p=100

In that post, I place the short code:

[cfdb-export-link form=”Enquiry_copy” show=”submit_time,name,contactno,traveldate,Submitted” filter=”submit_time>$_GET(start)&&submit_time<$_GET(end)”]

for the $_GET to work, I have to give start and end values in the URL of the post. If I wanted “start=0” and end=today, I would put in the URL:

https://localhost:8080/?p=100&start=0&end=today

That is the URL I was asking about. If these parameters are not in the URL of the post, then $_GET in the short code finds no matches.

https://localhost:8080/localsotcnew/enquiry-report

In that page, i have done

<form action=”https://localhost:8080/localsotcnew/&#8221; method=”GET”><input type=”hidden” name=”page_id” value=”6849″ /> From Date :<input id=”datepicker” type=”text” name=”start” /> End Date :
<input id=”datepicker2″ type=”text” name=”end” /> <input type=”submit” value=”Submit” />
</form>

[cfdb-export-link form=”Enquiry_copy” show=”Submitted” filter=”submit_time>$_GET(start)&&submit_time<=$_GET(end)”]

[cfdb-datatable id=”myid” dt_options=”bJQueryUI:true” form=”Enquiry_copy” show=”name,contactno,emailaddress,tourtype,traveldate,Submitted”
filter=”submit_time>=$_GET(start)&&submit_time<=$_GET(end)”]

The datatable shortcode is working… but not export-link…

OK, I think I understand now. This is not going to work the way you want it. The [cfdb-export-link] short code doesn’t process the filter substitution for $_GET, it should turns all the parameters into a URL. But is should do it. I had not considered this scenario when coding it. I’ll put it on the list of things to fix.

then, now how to export the data ???? i need it now.

You can export the data by using the Short code builder page and creating an export link or export link short code. You can put in start and end time. You just can’t use the advanced feature of $_GET. From your comment, I suspect you may be confused in thinking that $_GET is needed when it is not.