gatestar

I am not sure what the source should be as it’s people typing in foldingslidingdoirs.com and that is being forwarded to nu-scene.com. this has been done without permission and want to stop.

I have tried htaccess and not working so thought I would try your plugin.

Thanks 

Hi can you help me as I cant see to get it working. So if I type foldingslidingdoors.com it’s forwarded to nu-scene.com (a domain forward I think) I want this to be redirect to a 404?

Hi I am on the Pro version. I used the Data Tables as thought this was the only way to connect to my WordPress DB. How do I do this with Data Forms?

Thanks

Hi is there no way to get the filters currently applied and pass to a function that does the export?

Or change the page length dynamically to all – run the csv export and then change back.

I ask as not sure what the limit is for client side records, have seen 50,000 somewhere and if that is the case I am fine.

Thanks

Ok I figured out the date is not working on client side because my WordPress is converting date to full date Eg “october 5 2022” and not the 2022-10-05 which is in the SQL and the date picker is asking for.

I would still prefer this to be done on server side in case these tables get large.

I have been looking on internet at ones like this
https://datatables.net/forums/discussion/54994/csv-export-with-server-side but maybe a little over my head but will look and have a go.

Thanks

Thanks

I have turned off server side processing and works ok but the filtering for week commencing date field does not work as no records returned no matter what filter I try.

Thanks

When you say custom button, do I need to write a custom function as I assume the default csv function only gets the loaded records.

If you could point me in the right direction that would be helpfull.

Thanks

I will have a look at the server side.

I have tried with server side switched off and this seems to make it work, but breaks the filtering, so if I do between on a date the records are not found.

That’s great thanks.

Hi I still can only see down to Wed and no further is yours different?

Thanks

Ok sorted the font awesome and loaded version 6.

One more small issue is as I have a large amount of columns when I use the column button it shows the columns down so I can turn columns on and off, but I cant get to the bottom as it seems to be confined to the length of the page and doesn’t extend it.

I can add picture if you want or go to https://timesheet.sykesit.co.uk/timesheet-entries/ and click the column button.

Thanks

Hi I have also figured out if I turn on the option to search while typing this resolves the issue with the date as like you said the enter key is not being recognised.

I assumed it was font awesome and probably the theme I am using is probably loading this as default. I will load the font awesome v6.

I did used the services premium extensions but nothing appeared so I was looking for an alternative. I will put the extension manager back on so you can see it does not load the pane.

Thanks for your help just ironing out these few issue.

Try filtering on the week commencing date and doing equals. This is a date field.

Hi Thanks for the Reply, I am really close to everything being perfect.

I will respond to your responses.

>>> The between function works fine but if I put equal and select a date nothing happens.

Your date column is a datetime column. The value you select is of type date. This results in a comparison like:
October 1, 2022 12:02 am === October 1, 2022
which is not true.

>>>>>> The field is a date field not date time.

Do you need the time in your table? If not you could create a view and convert the datatime to date. This allows you to search for specific dates while maintained the time.

>>> Also when I have added a search pane for one of my fields which is a text field the search pane does not appear.

>>>>>>> I have configured the search pane and added the column but will not show the front end. 

https://timesheet.sykesit.co.uk/pictures/search-pane-1.jpg

Did you add anhy columns? Please use the Config button behind the search panes checkbox. This is documented here:
https://wpdataaccess.com/docs/data-publisher/premium-extensions/

>>> Also just noticed the export csv icon is flashing with a question mark and exclamation mark.

Sorry, I don’t understand what you mean. Can you please clarify this? Maybe add a screenshot?

>>>>>>>>>> I have added a screen shot. First button should be a CSV icon.
https://timesheet.sykesit.co.uk/pictures/csv.jpg

Also just noticed the export csv icon is flashing with a question mark and exclamation mark.

Thanks sorry for all the things.