Hi There, got derailed with a broken pelvis, trying to get back on track on seblod projects now that I'm healing a bit.
i need a fieldt ype where I can easily upload a formatted table of data. The table will be created my end users in excel.
I'm thinking excel save as html, then upload the html file into a field.
Users will manage the table of data and specific row colors/formatting in excel. Submit their file to content mgr. Content manager will upload the entire file into a field to update the website.
the result will be a search type to select and show a preformatted table of data.
Any suggestions or words of wisdom here.
There will be about 50 records with each record showing a table of prices from a country. The manager for that country will manage the values in excel and send in his updates when required via excel file. Looking for a process with the minimum of editing and fromatting by the content manager. Update intervals will vary based on a variety of conditions but approx once/month.
Thanks!!!
html as described is one way to go if there will be just few lines/few tables and there is no need to work with those tables like sorting, calculating so values etc.
Otherwise you could create a content type with fields corresponding to table columns and import data using Seblod importer. Excell can export to csv required by importer. Then you can insert search&list type searching on this new content type into your parent articles (either using seblod field or list module) to show this tables.