ronbuchanan

For now I have commented out line 39 of fields/html/field.php.

//$('body').on('change', '<?php echo implode(',', $binds); ?>', htmltemplate<?php echo $field_id; ?>);

The ‘change’ listeners are causing a real stink. Works fine for now, but a more permanent fix is probably needed.

Thanks for the response and sorry for my delay in responding!

I have been working with the plugin and several extensions. So far everything is going very well. Neither the details or row grouping will solve my problem completely, so customization is in order. No big deal, that’s the wonderful part of OS.

Thanks so much for the help! Typically I would figure it out myself, but we are on a short timeline right now and you have saved us days of work. A donation is certainly in order for your plugin and especially support.

Cheers

I ended up shutting down my IIS site that was running on port 80 and set my new services up on localhost:80. Once I did that WP started getting the data.

Yes, it is definitely a PHP/WP issue, not TablePress. Thanks for the assistance!

Yes, it’s on my dev box. WordPress site is running inside WAMP on localhost and the IIS service is running on another port on localhost. The service works because I can open the browser and see the JSON. However, I am wondering if going between the 2 ports is the issue with WP? I think that is where I am sitting at the moment. I have aliased the service to eliminate its port, but it still fails. CORS perhaps?

Thanks! Will look at the extension.

To answer your earlier question, by “grouping” I am referring to grouping the data. Consider the following data:

Game    Player    Score
G1      Jim       10
G1      John       8
G2      Jim        2
G2      John      10
G3      Jim       10
G3      John       0

I would like to group on Player so the grid will display as follows:

Player    Score
> Jim       22
> John      18

And the ‘>’ will expand detail. Example

Got my debug logging working again…

I am getting an error. Here is the area of code I am looking at:

case 'url':
				if ( ! empty( $import['url'] ) && 'https://' != $import['url'] ) {
					$import_data['file_location'] = download_url( $import['url'] ); // download URL to local file
					$import_data['file_name'] = $import['url'];
					write_log($import);
					write_log($import_data);
					if ( ! is_wp_error( $import_data['file_location'] ) ) {
						$import_error = false;
					}
					$unlink_file = true;
				}
				break;

$import_data contains:

[21-May-2014 18:24:41 UTC] Array
(
    [file_location] => WP_Error Object
        (
            [errors] => Array
                (
                    [http_request_failed] => Array
                        (
                            [0] => A valid URL was not provided.
                        )

                )

            [error_data] => Array
                (
                )

        )

    [file_name] => https://localhost:8090/leaderboard/1
)

Hope this gives some insight.

Vielen Dank fuer Ihre Professionalitaet!

Thanks for the reference, I plan on using the auto update.

I added in some extra logging so that I could see what was going on and the data was being received, but there was an error that followed that I am researching. I believe it might be a plugin conflict, but not sure yet. The logging stopped working now so I have to get that back up. Once I find out I will post my results. Thanks again for your help, it is really a great plugin!

Another question, is there any AJAX related plugin that should be installed for this type of data retrieval?

Manual Input did work with the raw data returned, interesting. Unfortunately that method will not work since the grids must read updated data at these services.

Is there any way to do grouping with TablePress?

Thanks for the reply.

TablePress 1.4 is my current version. I just verified and WP is 3.9.1.

Does the URL require a JSON file?

Trying to create a new table with a JSON URL source. The service is changed and now returns a 2D array rather than object[] with column names in the first row. However, I keep getting an error that the data is in the wrong format. Right now it is:

[
[ “Column1”, “Column2”, “Column3” ],
[ “Value1”, “Value2”, “Value3” ],
…
]

Is there a problem that you see? For development purposes I am running the source service calls locally as localhost:port, does that make a difference?