wp-table-reloaded – Importing data into the table

  • I am sourcing data from several cells in each row of a (csv) spreadsheet, concatenating that data into two cells per row and importing those two cells into the table. The concatenated data in each cell was manually edited to add a soft return between each of the bits of concatenated data. (This is the time-consuming part of the exercise.)

    The outcome is a “test” table at: https://wherekidsgo.ca/attractions/example-3/. Is there a simpler way to do this? Thanks. Boyd

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi Boyd,

    thanks for your question.

    I’m not sure if I understand this process completely.
    I can see how your table looks like now, but I’m not really getting how your original data source looks like. Can you maybe show an example for that (e.g. with a screenshot)?

    Regards,
    Tobias

    Thread Starter bocarter

    (@bocarter)

    Hello Tobias, thanks for your quick response.

    I found the solution to the soft return problem so I can now do it automatically; that kills the time-consuming part of the problem. Sorry for asking before I had exhausted all possibilities. (The solution was to put a “char(10)” in the concatenation formula wherever I wanted a soft return.)

    However, I would still like another solution to the import/load challenge. I would like to set up a “record” template in the table development area and have the table software do a scan of a database and create the table from each record in the database. It may already be able to do this, but I can’t find any documentation that would tell me how. Is this possible?

    Thanks. Boyd

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    yes, the adding the line breaks sounds like a good idea. Great that you were able to reduce the necessary amount of work with that.

    For that second idea: Unfortunately, that is not possible. WP-Table Reloaded does not offer such ways to dynamically fill tables with content.
    It can only work with existing data from CSV or HTML files, which need to be imported manually.

    Best wishes,
    Tobias

    Hi Tobias,

    do you think you will ever add this functionality?
    I am still using my old spaghetti-HTML site because I can not use some data. In the HTML/PHP site I used (PhpMy Edit, which even a noob like me can use to get data in and out of a MySql dbase and show it on a php page ??

    It is great, with sortable headers and as it queries the dbase you do not have to export the dbase every time you add a record.

    Is there any chance tables-reloaded will offer this functionality?

    Thanks!

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    I assume that you are refering to a connectivity to a database with your question?
    To be honest, I doubt that something like that will be added to the plugin in the future, as that simply goes beyond the intended use case.
    The plugin was designed to make it easier for the average user to show and maintain HTML tables on his site.
    Anything beyond that, like database integration, can usually be done better and more easily with some custom programming.

    Regards,
    Tobias

    That was fast ??

    Yes, correct. I can see that it might be out of this cope, but it is weird that WordPress, which is one big dBase query itself, has no easy way to get user data in and out a database.

    It would be great to have a combined plugin: some kind of form/ data entering combined with a query/table plugin to actually show the data again on a blog.
    This way users without programming knowledge could show all kinds of data/tables, whether entered by them, visitors etc.

    Thanks again.

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    well, actually WordPress offers a functionality to have userdata, it is just more specialized on what exactly you want your data to resemble.
    One of those things for example are “Custom Fields”, which you can add to posts or pages.

    Best wishes,
    Tobias

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘wp-table-reloaded – Importing data into the table’ is closed to new replies.