rc169's Replies | WordPress.org

Forum Replies Created

Viewing 15 replies - 1 through 15 (of 40 total)

1 2 3 →

Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Code Manager: publication search form in new version of WPDA

Thread Starter rc169
(@rc169)

5 days, 12 hours ago

Hi Kim,

Thanks for your prompt response. It works perfectly!

Nigel

Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Linking to tables in dbase from another site (same hosting)

Thread Starter rc169
(@rc169)

2 months, 2 weeks ago

Hello Kim,

Further to my message above, this is the text that is displayed under “Manage Databases” in the new “Data Explorer” when I test the connection:-

Preparing connection…
Establishing connection…

Connection established…
Counting tables…
Found 0 tables on remote host…

Remote database connection valid!

Thanks in advance, Nigel

Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Linking to tables in dbase from another site (same hosting)

Thread Starter rc169
(@rc169)

2 months, 2 weeks ago

Hello Kim,

Thanks for your message. I have responded as per your suggestion.

The linked database (from the original version of the site) appears in the WPDA Data Explorer as an additional (remote) database, identified as “rdb:<dbase_name>”, but no tables, views, etc, are visible.

Both sites are on the same hosting package, but as far as I could see from your documentation, the linking as a remote database is the recommended approach.

Thanks in advance for your help.

Nigel

Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Linking to tables in dbase from another site (same hosting)

Thread Starter rc169
(@rc169)

2 months, 2 weeks ago

Hello,

I have been trying to make progress with this update, but have encountered further problems.

I have tried to check that queries to the database can be run, with a query to extract one row and four columns from a table in the current database, but the query in WPDA generates no results (the timer rotates but nothing happens). This happens regardless of whether I use the old or the new Query Builder. If I run the same query in phpMyAdmin, then I get the correct result almost instantaneously:-

“Showing rows 0 – 0 (1 total, Query took 0.0004 seconds.)”

Can you offer any suggestions to resolve these problems?

Thanks in advance for your help.

Nigel

Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Application Builder
rc169
(@rc169)

1 year, 3 months ago
Hi Kim,

To avoid the complication of catering for possibly empty fields in the “publication-search-form”, I have added a default “%” sign as a value parameter to the <input> line(s) of the code – e.g.:-
```
<input type="text" id="wp_owner_name" name="wp_owner_name" value="%" />
```
The “default where” is then quite simple:-

owner_name like httpGet[‘wp_owner_name’]

The behaviour is then correct, regardless of whether the user enters a value in the box to replace the % sign, enters additional text beside the %, or leaves it untouched. Of course, if the user removes the % sign, but doesn’t enter anything to replace it, then I suppose it will fail – but that’s not a very sensible choice!

However, the outstanding question is how to cater for multiple entry fields on the publication-search-form? I have not yet found the appropriate “where” clause for that requirement – but it is handled very satisfactorily on the old version.

Any suggestions gratefully received!

Thanks,

Nigel
Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Application Builder

rc169
(@rc169)

1 year, 4 months ago

Hi Kim,

Thanks for your message and the video. I have tested that setting on my site, and it now functions correctly.

I presume that the same configuration can be used for multiple input fields, which may or may not be populated, with a suitably amended “where” clause? I will do some more testing to see if I can generate a suitable clause.

The only outstanding issue is the question of whether the URL field functions as a link – should I raise a separate topic, as I realise that it is not quite the same question that Charles raised?

Thanks again for your help.

Nigel

Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Application Builder
rc169
(@rc169)

1 year, 4 months ago
```
Hello Peter,

Thanks for your help.

I am trying to implement the approach that you described, based on the pages that I have already created.

Firstly, I have a page "Search for owners" which uses the publication-search-form model to populate the fields, and submit the query. This has four fields, but I am only using the owner_name field for this test. In the "old" publication-search-form this is defined as "wpda_search_column_owner_name".

In the App Builder, I have an app named "Owner list". I run this app in the App Builder, and select "Table Builder". I have tried various versions in the "Default where" clause setting, but without success

If I use  "where owner_name = $wpda_search_column_owner_name" in the "Default where" clause,  then I see this message on the results page:-

"Unknown column '$wpda_search_column_owner_name' in 'where clause'"

I have also tried this clause, but similarly without success:-


owner_name like httpGet['owner_name']

I have also tried various combinations, as shown in the explanatory notes, but without success. The only version that gives correct results is one such as this:-

owner_name like "Frampton"
OR owner_name like "Red%"

This one does show the correct results, but the URL field is still not clickable.

Please note that the dev.bristol-re.... site is password-protected - please let me know if you need to run any tests.

Thanks in advance for your help.

Nigel
```
Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Application Builder

rc169
(@rc169)

1 year, 4 months ago

Hello,

I have a question which is ( I think! ) related to the issue that Charles has raised.

I have a page with a tabular view of the contents of an SQL view from one table, with a field which contains a URL link to a detail view of the corresponding data record. The format is :-

https://dev.bristol-re.co.uk/owner-details/?wpda_search_column_owner_id=1

I have tested it in the new App Builder and Data Explorer ( also new ), the link functions correctly, and opens the relevant page. However, in the browser, the URL is displayed as plain text, and does not function as a link.

The link field is set to plain text, not hyperlink – this generally functions correctly ( in the old Data Explorer, etc, )

Thanks in advance for your help.

Nigel

Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Green “plus” button to display more table columns failing

Thread Starter rc169
(@rc169)

1 year, 4 months ago

Hello Kim,

Thanks for your message. At the moment I have added a message to the affected sites, that users may need to switch to a different browser.

I understand the point about legacy tools, but I cannot move my tables to the App Builder since I make use of the “publication-search-form” on some of my sites. Peter advised me that it would be replaced by a new version on this topic:-

https://wordpress.org/support/topic/demo-app-display-strange-behaviour/

I am therefore waiting for the new version before moving the tables to the App Builder.

Thanks for your help.

Nigel

Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Green “plus” button to display more table columns failing

Thread Starter rc169
(@rc169)

1 year, 4 months ago

Hello,

…and further follow-up info: I have been advised that the problem does not appear in Microsoft Edge. I don’t know about Safari, but it would seem that the problem is probably specific to Firefox.

Nigel

Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Green “plus” button to display more table columns failing

Thread Starter rc169
(@rc169)

1 year, 4 months ago

Hello,

Further follow-up information: this problem seems to be specific to certain browsers. I have tested the behaviour in Firefox, Chromium, Google Chrome and Opera this morning – and only Firefox is affected. The green “plus” buttons function correctly in the other three browsers.

Thanks again,

Nigel

Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Green “plus” button to display more table columns failing

Thread Starter rc169
(@rc169)

1 year, 4 months ago

Hello,

I have subsequently tested the behaviour on another site, where I have used a different theme. The behaviour is the same, so that the problem would seem not to be related to the theme used on the site.

Thanks in advance for your help.

Nigel

Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Demo App display – strange behaviour

Thread Starter rc169
(@rc169)

1 year, 5 months ago

Thanks Peter. Glad to have been of assistance.

That is good news about the “publication-search-form”. I will keep an eye open for more news on that topic.

Regards,

Nigel

Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Demo App display – strange behaviour

Thread Starter rc169
(@rc169)

1 year, 5 months ago

Hi Kim,

Thank you. I have sent the message via the Contact | WP Data Access page, as requested.

Apart from straightforward display of data in tables and SQL Views, my usual approach has been to setup a page containing an input page using the “publication-search-form” script ( id = 64 ) from your Code Manager app as a basis ( https://code-manager.com/code/ ). In other words, as per the demo at https://wpdataaccess.com/publication-search-form-demo/ . On that page, I have a shortcode, such as [cmruncode name=”publication-search-for-objects”].

When the user submits the data that they have entered as search criteria, the next page shows the list of filtered results, derived from another shortcode, for example, [wpdataaccess pub_id=”1″]. These elements were listed on the “Tables” section of WP Data Access – the page with the listing is entitled “Data Tables”.

I presume that I can continue to use the “publication-search-form” script from Code Manager as before, but I am not sure how to get to the next step. I presume that I need to use a “Data Table” from the new App Builder – so do I just substitute the Front-end access short code in place of the earlier type with the “pub_id”?

Thanks in advance for your help.

Nigel

Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Cannot access stored query for editing

Thread Starter rc169
(@rc169)

1 year, 5 months ago

Hi Peter,

I have now enabled debug mode (on the Settings -> WP DataAccess page in the WordPress console), and I have tested the application. I tried to switch to page 2 of the list of entries in the table (there are 300 records in total in the table), but the system has clearly crashed, although the moving black line at the top of the table on the page is still “rotating”. The other WordPress sites on my hosting account are also now unavailable (this also happened yesterday). Eventually I get a “connection has timed out” message in the browser.

There are three files in the /logs folder of my hosting account – access_ssl_log; error_log and access_log. I presume these are the files that you need, so I will download them and send them via the contact page of the plugin website, together with the details of the page that causes the error.

Thanks for your help,

Nigel

Viewing 15 replies - 1 through 15 (of 40 total)

1 2 3 →