I have a Joomla site www.reportsolutions.com and I myself and a small team of others work with Crystal Reports Developer, MS Access Reports and SQL Reporting Services and their related scheduling and distribution products out there. I have done this for 12 years.
The goal is to have a page like the one seen below that has embedded blob and longblob fields in a relatively generic modular page layout. As we add all the different products we have worked with ie( QuickBooks Peachtree, Lawson, Great Plains, MAS 90, MAS 200, Navision etc. ) We would like the pages to fill in automatically the content we need seen in the "ApplicationPage..Image" I assume we could do single words up to paragraphs of information?
One thing I need to know is what to do first? Is it ....
1.) Create database with fields I need first I use MySQL
2.) Then point a tool like Joomla forms or Fabrik to the fields I created in the database to be accessed by admins on the Joomla site?They will use the Joomla forms or fabrik to input new application software we will take on frequently.
3.) Then embed those blob fields and longblob fields into those Modules, Articles or Categories on a web page? See image below.
I have never embedded database fields into websites before. So I would need examples or sample code to show how one would place a blob field into a Modules, Articles or Category on a web page. Any thing you could show me as I think this question will get some traction....?
Many of the embedded fields will be in articles and categories in the form of sentences and individual words like QuickBooks that I will change periodically.
Finally it might be good to know how I might go into the database or Joomla form ( if possible ) to change content periodically for updates and or changes to the application software. Any suggestions on editing tools like that is appreciated. Unless you happen to know if this can be done in a Joomla form or Fabrik. I think I may have to get an editing toll for that.....but not sure?
Thank you for being here. This site has renewed my faith in human kindness and generosity.