Okay
  Public Ticket #3408790
wpDataTables & Master-Details - Table Maintenance
Closed

Comments

  • ampagi started the conversation

    Hello everyone,

    Heres the description of my problem :

    I am creating a table with over 800 rows.

    The table is created from excel/csv file that comes from a 3rd party software .

    [specific rows/columns].

    I use master details to make every row on the table clickable .

    When a row is clicked i get a popup window with more information about the specific row.{Description/image / etc...}.

    The images that show on the pop up are not included on the table that i export from the 3rd party software and i created a new column on that table so i can include them in the final product.

    When the time comes for me to update the table i will have to get the excel/csv file that the 3rd party exports and import it into wpDataTables. However, there will be new data(rows) on the table and updated data(in the old rows).

    Q1 : How do i do the matching of the rows/images without going one by one and adding it again?

    Q2: What is the best practice to implement this?


    Thanks for your time!

  •  1,877
    Miloš replied


    Hi, ampagi.

    Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

    -

    If i understood, the main issue is that when you import or link the source data from your Excel/CSV file,

    our plugin does not render the images?

    The images need to be set in a specific format in order for our Plugin to read them from the source.

    “Image” link columns are used to render images in the table, either in full size, or as a link from a thumbnail to a full size image.

    • Rendering rules: If the content of the cells contains a combination of “two sticks” – || – everything to the left of this combination is used as a link to the thumbnail, and everything to the right as a link to the full image size:
    http://domain.com/thumb.png||http://domain.com/fullsize.png
    

    • If the “||” combination is not found in the content, the entire content will be used as a link to a full-size image.
    • Sorting rules: alphabetical.
    • Applicable filter types: text.
    • Editor input type: One-line edit, Attachment
    • Issues to note:
      • Sometimes some issues may appear when you’re sorting on image columns, since it’s done alphabetically, and alphabetic sorting of HTML typically doesn’t make sense.
      • Please note that the plugin does not create thumbnails (at least for the moment), so you will need to take care of this yourself.
      • If you would like to open full-size images in lightbox, you can use a plugin for that, e.g. WP Lightbox 2  (please note that this is available for tables that aren’t editable)

    Please check more about using Image Columns here.

    -

    Alternatively, you can use a String Column in our Plugin, but then you have to use Custom HTML and wrap each image inside a HTML img tag to have our table render images for you.


    Let me know if that helps?

    If not, can you record a Video or show me screenshots how does your source data look exactly,

    how are your source images formatted, etc?

    Thank you.


    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables