Solved

Joomla tables

Posted on 2011-02-11
14
479 Views
Last Modified: 2012-05-11
Hi Experts,
I have a joomla installation.
Now I want to create a table like in excel.
But how can I create a table in joomla ?

Do you know a way to program a site, which is calculating itself ?
For instance you have a excel sheet and you use formulas to calculate your profit.
Can I do it in joomla,too ?
0
Comment
Question by:Eprs_Admin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 3
  • 2
  • +1
14 Comments
 
LVL 13

Accepted Solution

by:
darren-w- earned 167 total points
ID: 34869017
At the simplest level you can display a html table and populate cells with static data from a database, if you want the content to be dynamic you can use a combination of JavaScript and AJAX, or another option would be to embed a Google Spreadsheet on a page.

So yes its possible in Joomla but it depends on how your coding skills are?
0
 

Author Comment

by:Eprs_Admin
ID: 34869035
ok,
how can I fill the data from a database ? Can I do it with excel aa a reference ?
My skills are not very good. I know some html.
I want an easy way to automate it a little bit.

0
 
LVL 13

Assisted Solution

by:darren-w-
darren-w- earned 167 total points
ID: 34869079
Humm, this will be using some server side code a bit beyond HTML.

Here is some code to extract info from a sql database and output a page, though you will need to design a new template page to embed the info into first I think:

http://www.w3schools.com/PHP/php_mysql_select.asp

With excel you could try parsing a csv file.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 12

Assisted Solution

by:Panagiotis S
Panagiotis S earned 250 total points
ID: 34869239
you can use extensions or modules to do what you want

there is no such an easy way
0
 
LVL 11

Assisted Solution

by:Amanda Watson
Amanda Watson earned 83 total points
ID: 34869243
I think you might find something in the extensions list here
http://extensions.joomla.org/extensions/news-display/tables-a-lists

This one looks good
http://extensions.joomla.org/extensions/405/details

You can look at something like fabrik which will let you create a table. I'm not sure but I think you could make it editable. It will let you export as csv.

Another thing would be to play with the google apps api so that your users would have access to a gspreadsheet.

Also, depending what you want to do, you might just want to use a document management system where they could check out the spreadsheet to work on and then put it back when they are done.
Docman could handle this kind of thing
0
 

Author Comment

by:Eprs_Admin
ID: 34869367
ok this sounds good.
But when I want to fetch some data from a database, then I need a database filled with data.
Can I create beside joomla another database on the webspace of my provider ?
How to send data to it and configure it ?

Can you explain parsing a csv file ?
0
 

Author Comment

by:Eprs_Admin
ID: 34869768
To panagiotiss:

can you tell me which extension and modules ?
0
 

Author Comment

by:Eprs_Admin
ID: 34869809
I try to explain, what I want to do.
I have a betting system running, which is very profitable.
The matches and the results I want to put on my site.
I can do it just in a table and edit all manually every day. But I want it more flexible and the profit calculation should be automatic like in excel with formulas.
Of course I have to enter the matches and the results to a database or excelsheet or what ever.

What is the best solution ?
0
 
LVL 12

Assisted Solution

by:Panagiotis S
Panagiotis S earned 250 total points
ID: 34869824
you have to write code

try jumi which is an extension for that
0
 

Author Comment

by:Eprs_Admin
ID: 34869873
to snowball77:
I don't like the legacy mode.
But I will check some other tools.
Or do you have some other tipps ?
0
 

Author Comment

by:Eprs_Admin
ID: 34870114
Maybe there is a way like this, Lets say my db is a csv file or excel file.
Can I use this file a source db ?
And with an extension or module I can load this data if needed ?
0
 
LVL 12

Assisted Solution

by:Panagiotis S
Panagiotis S earned 250 total points
ID: 34870165
i did what you want with artData

look at it, its a commercial component
0
 

Author Comment

by:Eprs_Admin
ID: 34983141
ok I take a look into it
0
 

Author Closing Comment

by:Eprs_Admin
ID: 37467280
thanks
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Search Item in Table 2 43
Clear input text 15 27
Use "if not" in a condition 2 19
Anyone familiar with PhotoSwipe? 3 19
When it comes to write a Context Sensitive Help (an online help that is obtained from a specific point in state of software to provide help with that state) ,  first we need to make the file that contains all topics, which are given exclusive IDs. …
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question