andyrayner
Forum Replies Created
-
Hello Peter,
Apologies for not replying earlier I’ve been working on something else and only just returned to this. By the time I’d checked your answer the plugin had already been updated to the latest version and I just tried it and can confirm that it is now working fine.Thanks for your help and for this amazingly useful plugin.
Andrew.- This reply was modified 4 years, 2 months ago by andyrayner.
- This reply was modified 4 years, 2 months ago by andyrayner.
Hello Peter,
Short version: It works!
Long version:
I tried that and at first it didn’t work – nothing was imported and no error message, so I went back to have a look at the SQL file and decided to do a search & replace on the first (randomly generated) part of the WP database name with the one from the target site and then tried the import again. That worked and its imported, but the frontend didn’t work because now all the IDs were wrong in the shortcodes (I think – it’s been a while since I did that bit!) so I exported the SQL file again from the test site and just did the search & replace again on the first bit of the table names, left the pub_id alone imported it and it works fine.Thanks for all your help and thanks for a great plugin.
Andrew.
Edit: Forgot to add: the {wp_schema} bit was already on the export so I didn’t need to change that bit
- This reply was modified 5 years, 7 months ago by andyrayner.
Hello Peter,
I deleted everything (tables, plugin, the lot) and reinstalled and then re-exported from the new version of the plugin on the test server. It still has the same error so I did a bit of digging and found that on the data publisher list page the database is listed as the test database for everything on the list, but when I click on the items and select the correct database and table I get the following error on save: ERROR: Wrong arguments [missing message text argument]I’m wondering if at this point I’d be better recreating the whole thing from scratch on the new server by just copying over the all the settings from the test server by hand and just importing the data in the tables. What do you think?
Andrew.
Hello Peter,
Thanks for the swift reply. Just to be sure though, here’s what I’ve done so far:- Uninstalled & reinstalled the latest version from your zip file (making sure to set the uninstall settings first) onto the test server (source)
- uninstalled & reinstalled as above on the live server
- Exported a new backup of all the tables
Now I’m ready to import the data backup into the live site, do I need to remove the old data first and maybe delete the plugin again making sure to delete the data & everything as well, and start afresh? or is there a better way?
Thanks,
Andrew.Afternoon Peter,
Many thanks for this. I can’t wait to try it out.Andrew.
Afternoon Peter,
That would be great yes. I only have the one table of data at the moment as the client is supplying it as an Excel sheet, but I’m sure the table name will be useful at some point, these things have a habit of expanding.Many thanks,
Andrew.(Original brief was ‘Can you put this info into a simple online database so we can share it?, needs a login & be searchable, and keep is as simple as possible.’ My initial stab was a simple WordPress site with a template page for each set of info to be dropped into. Next conversation was ‘Great, can I import it all from an Excel sheet?’ that’s when I looked at your plugin instead.)
Hello Peter, (great plugin btw!)
I can’t really share the link to the site as it is not really public and completely locked down behind a login page, but the relevant code I changed so far in wpda_datatables.js is:var data = jQuery.map( columns, function (col, i) { return '<tr>' + '<td class="' + col.title + '">' + col.title + '</td>' + '<td><strong>' + col.data + '</strong></td>' + '</tr>'; }I haven’t got as far as understanding what other data is available to substitute into the td class, but my first thought is that the actual database table names could be unique enough to be able to target them directly. I suppose I could even add a suffix to the class as well in the above code if necessary.
It’s pretty much so I can just add in some additional text & formatting rather than just straight rows of data (e.g add a row of blank space, add sub titles, make some of the rows red depending on content, etc.) Any help at this point would be appreciated.
Many thanks,
Andrew.- This reply was modified 6 years, 3 months ago by andyrayner.