Hi

When  tables are created from files (php serialized, json, csv, etc) wpdatatables use a direct link to the file (http://www.example.com/data.csv). In order to let wpdatatables access the file, public access has to be granted.

I tryed using a php script but of course I would have to do some kind of session or login system.

Any way to do it in a secure manner?

Thanks in advance.

Hi Bogdan

I need to pass some statistics from a crm database to wordpress. The easiest way I thought about was to create a script that generates a php serialized file. This content will be uptated in regular basis. 

Since PHP Serialized way is not server side processed, I have to make the file completely public, don't I? If I do that, anyone on the internet with the file url could download it even if they are not members of my site. 

Is there any other way?

It would be nice if I could access crm database directly but it MSSQL so... next option would be to create a script to sync MSQL to MySQL but things would start to get complicated.  There's an app to sync mssql to mysql but it's really expensive. I mean really...

I could do any of those things but my time is a little limited lately. I'm asking you because may be I missed something in the documentation that could make things easier for me.

Thanks

Hi Raul,

I did something like this where I wanted the content of the table only available to users logged in to the WordPress site. For your application, is the data in the table supposed to be available to users that are not logged in?

I used the JSON input method described here: https://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-json-input/

This method requires a URL which will generate the JSON format as output. The URL could be a PHP file on your WordPress site that was only accessible to logged in users. 

Here's instructions for generating JSON output from WordPress:

http://www.codechewing.com/library/output-wp-post-as-json-in-new-page/

You could modify this example to output the JSON required by wpDataTables.

Regards,

Jon

Thanks a million Jonathan

I'll try it out.

Best regards

Hi Bogdan, 

any luck with Raul last message? I'm after pretty much the same thing. I haven't bought the plugin yet but wouldn't mind paying a little extra for the feature.