Separating a cell into single cells

  • Resolved morpheusxeno

    (@morpheusxeno)


    6 years ago

    I have a program that stores information for statistics in mysql , I want to diplay that information with this plugin if possible.

    By the way love the plugin, absolutely fantastic!!

    The information from the SQL is stored in a single row, and it is separated by commas, is it possible with this plugin to display the information that is separated by commas as information in separate rows? For example, Information appears like this in the data table in SQL

    {
  "LastUpdate": 1589436819,
  "var1": 2,
  "var2": 2,
  "var3": 0,
  "var4": 0,
  "var5": 0,
  "var6": 0,
  "var7": 0,
  "var8": 0,
  "var9": 0,
  "var0": 0,
  "NamesChecks": [
    "abc"
  ],
  "Sent": [
  ],
  "Pickups": {},
  "Plants": {},
  "Delivered": {}
}

    I would like to display the following information in a normal and easy to read table. Is this possible ?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    6 years ago

    Welcome Morpheus! 🙂

    Can you give me a little more background information?

    – Is your JSON stored in a MySQL table column? Or does this JSON represent a table record? Or other?
    – Can you share your table structure? (please use the contactform on the plugin website if you want to send it in private)
    – What do want to be displayed? On your website? Or in teh dashboard?
    – Should the data be read-only or editable?
    – Is it possible to create a remote connection to the data?

    Thanks,
    Peter

    Thread Starter morpheusxeno

    (@morpheusxeno)

    6 years ago

    I just wanted to say thanks for the quick reply you give support for the plugin like its something premium! I honestly didnt even expect a reply lol, So thank you.

    It is like JSON that is stored in MySQL Table. There is information stored for each personal ID, each ID will store the same information for each user all in JSON information. Im not very code savvy but I know enough to get me into trouble.

    I would like the information to be stored on a website. The information is viewed by staff members and it would make it much more simple if the program which was written to store the data in separate MySQL cells, but there is no more support for it anymore.

    The data should be Read-Only, I do not want the table in the SQL Database to be modified by anything other than the program that stores it. I would like your WordPress Plugin only to read the data.

    Your plugin looks directly at the data stored on the table currently but it doesnt appear correctly on the website.

    I will send you the way the table is structured and any other personal information you need.

    Again, Thanks for your help.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Separating a cell into single cells’ is closed to new replies.