Great stuff!
We’re talking about 14 columns and hundreds of rows.
Next iteration, accessing a MySQL database table:
Only available if published (at the moment) i.e. doesn’t work in preview.
That’s interesting. About 10 years ago we had a Rapidweaver site using PHP which displayed MySQL data. I’m not quite sure what I’d use it for right now but a blog comes to mind.
Yes, but the data is coming from a CSV spreadsheet. And I’m using a CSV table stack.
OK, but you are posting to a thread called Elements > Custom Components, so I was making the assumption that you are interested how this might be achieved in Elements.
Stacks don’t work in Elements, for that you have to use Rapid Weaver.
Are you saying that you are reading the spreadsheet directly or are you exporting the spreadsheet to a csv file first?
Perhaps a link to your exiting website displaying the data (or a screenshot) would help people understand what you’re trying to do.
As Logrunner’s said, Stacks aren’t a part of Elements so referring to them doesn’t really help people understand what you want. There’s a million stacks out there and chances are most on here don’t have the specific one you’re using.
I am aware of that. That why I am answering the request for suggestions of components to create. Dan was asking for suggestions, and this is one of them. We’re basically mimicking stacks which okay if it is an improvement or an upgrade. But you’re going to need more than WYSIWYG to get people to abandon the thousands of dollars they have invested in the Stacks addon and the stacks collections. You are going to need to create or recreate the stacks that we use on a regular basis.
Not necessarily, they’re creating the tools to allow you to do it.
I’m sure the community will develop many useful components (if the beta list is any indication) and we have no idea what Realmac might release in the future.
At this stage all we know is you need 14 columns and lots of rows. We still don’t know if you need headers, sorting, colouring, summaries, sub-summaries or formatting or how you are accessing the file.
You haven’t answered the questions people have asked and have been critical of the samples people have presented to try to help.
Respectfully, giving more complete information would go a lot further towards getting a satisfactory answer than complaining your stack won’t work.
Alternatively, Rapidweaver Classic will continue, just keep using it.
The sad thing is, we’re losing elixir graphics, because the developer of the product has moved on because of the slow development of Stacks Pro. He had a real nice CSV stack. For some reason, he did not include a CSV stack with his new upgraded version Foundry 3. And I figured he would probably eventually add it, but now he’s left. So I’m probably going to have to revert back to foundry 2. Unless Rapid Weaver Elements can come up with a stack like that.
https://www.logicalreport.com/page-70/page-35/
Here is the link.
Thanks for the link.
I have replicated the page (more or less) in Elements, with a CSV file with data that looks similar, retrieved from here: Historical U.S. Federal Individual Income Tax Rates & Brackets, 1862-2021
The CSV file contains 2,500 rows.
The Elements output looks like this (which is similar to your page):
So in answer to your original question in the first post of this thread "Can you create something that will allow me to use a CSV spreadsheet?”, the answer is Yes.
So where is this element that does this? Maybe I should have been more specific. I should have asked if “I” can do it. Because I don’t know how to do this.
I am developing it but it isn’t ready yet as I am awaiting a future update to Elements that will allow me to package it up for distribution.
I was trying to show that it will be possible.
I would like learn how to create these myself. It would be great to not have to repurchase everything for elements.
Could you tell me how you did this?
Better than that, here is an Elements file for you to look at: CSV Table Elements App
The Custom Component uses PHP to read the CSV file and create the table. Somewhat unpolished at the moment but should give you some pointers.
Note that it only displays the table in Preview | Published, as the WYSIWYG Editor doesn’t support php.
Just drag your CSV file into Resources and alter the name of the CSV file in the properties and you should be good to go.