TMS-Plugins

Comments

ampagi started the conversation
July 7, 2023 at 5:27am
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,847
Miloš replied
July 11, 2023 at 9:27am
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 | Instagram | Front-end and back-end demo | Docs

Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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