For many of my row headers, I will have long blocks of text, and perhaps text and links. I can make this happen in a variety of more complex tools, but wanted to see what the capabilities are with wpTableData and Wordpress. If I can build it easy, it will take less time.
The data source is expected to be MySQL, but it is a small enough database, that we can put it into another format if it will make the job easier.
We have questions, the longest being 158 characters, and then we have site names and URL's, which might be 150 characters. There is a maximum of 70 questions. The answers are currently T or F, which makes the actual core data fairly easy to deal with. I can certainly transpose the database, so that we can have rows of the questions, with the URL's as the columns, or vice versa. Then the answers appear as the remainder of the table data.
Based on the dimensions, I will certainly have to allow horizontal scrolling, and word wrap in the columns.
I can certainly do this in a ROR or js based site, but there will be other commentary by some experts, regarding the data, and I was hoping to use Wordpress so that I can allow easy CMS. Also, I prefer the lazy and inexpensive way if I can make the tools do what I need.
Thank you for your explanation but could you please tell me, or better show me some example of what is desirable output in the table.
If I understood you correctly you have problem with number of characters in column headers? If you show it in current state it will make table really wide and unusable?
If this is true could you please tell me if you want to present it in a way that CSS rule "text-overflow: ellipsis;" allows you to or you want to break it in multiple lines?
If I didn't understood the problem please try to explain it to me in little more details.
Although "text-overflow: ellipsis might not work for my application, I think I know a way to work around it.
Do you think I can make hover effects the same way? Is there an element ID that will be unique for each column? That way I can present a shortened question in the column, and the user can hover to see the question in full.
For many of my row headers, I will have long blocks of text, and perhaps text and links. I can make this happen in a variety of more complex tools, but wanted to see what the capabilities are with wpTableData and Wordpress. If I can build it easy, it will take less time.
Hi CLIFF,
Thank you for your inquire.
Could you please tell me what is the data source for your tables? Is it Excel, CSV, MySQL...?
Hi Milijko,
The data source is expected to be MySQL, but it is a small enough database, that we can put it into another format if it will make the job easier.
We have questions, the longest being 158 characters, and then we have site names and URL's, which might be 150 characters. There is a maximum of 70 questions. The answers are currently T or F, which makes the actual core data fairly easy to deal with. I can certainly transpose the database, so that we can have rows of the questions, with the URL's as the columns, or vice versa. Then the answers appear as the remainder of the table data.
Based on the dimensions, I will certainly have to allow horizontal scrolling, and word wrap in the columns.
I can certainly do this in a ROR or js based site, but there will be other commentary by some experts, regarding the data, and I was hoping to use Wordpress so that I can allow easy CMS. Also, I prefer the lazy and inexpensive way if I can make the tools do what I need.
Thanks for the help!
C
Hi CLIFF,
Thank you for your explanation but could you please tell me, or better show me some example of what is desirable output in the table.
If I understood you correctly you have problem with number of characters in column headers? If you show it in current state it will make table really wide and unusable?
If this is true could you please tell me if you want to present it in a way that CSS rule "text-overflow: ellipsis;" allows you to or you want to break it in multiple lines?
If I didn't understood the problem please try to explain it to me in little more details.
Hi Milijko,
Although "text-overflow: ellipsis might not work for my application, I think I know a way to work around it.
Do you think I can make hover effects the same way? Is there an element ID that will be unique for each column? That way I can present a shortened question in the column, and the user can hover to see the question in full.
C
Hi CLIFF,
We do not have tooltip built-in by default but we do have it in our TO-DO list for some time now as it was multiple time requested.
For column element we do have unique CSS class for each column and also you have option to add additional CSS class for every column