Table to database

[FrankA2]

Hi,

I currently have an HTML table displayed in a wrapper, it is too big (soon will be ten times the present size)  to be a single item of content and cannot be split as it will grow dynamically...

I tried the Table Manager extension but that specifies joomla 1.0.5 and has SQL errors in 1.0.11. So much for the claim user does not need to understand SQL    Not been updated for a long time either.

Can anyone suggest an alternative way of converting this table to Joomla! that will allow it to be edited and expanded? The ability to sort on different columns is not vital, as scrolling by date or searching within the table would be the normal way of using it.

I have read the description to every extension but perhaps it got lost in technical language, as surely this is a most basic type of list is needed by many websites?

[entrecon]

Can you post a link to the existing data?

it might spark some ideas if we can see what you are currently working with.

[FrankA2]

Hi thanks for reacting, sorry thought I had posted a link.

http://www.scotlandsglass.co.uk/cms/ind ... &Itemid=37

Note references at the end are mentioned per record and of course will expand too.

[FrankA2]

Had contact with the Table Manager author and am now trying out the 'Unstable'  version, which seems to work at basic level. But I am a bit nervous of putting a lot of data in, on the other hand, the data is at least in a file instead of a document. But I am still open to any other suggestions.

Is anyone working on a nice easy relational database front end?

[entrecon]

I have been looking for something too and found something that might work. I am actually using a combination of two tools. The first is one for managing databases (nice tool even if you don't need tables!) and the second is a basic tool to display the data in any table.

PU Database Admin : http://extensions.joomla.org/component/ ... Itemid,35/
It will help you create and manage the database without having to mess with teh MySQL stuff. I don't mind doing it, this just lets me do it all from admin.

Archaic Binary Tables: http://extensions.joomla.org/component/ ... Itemid,35/
This actually displays the database. I have only tried it with one record on a page. The template I tried it with really squeezed thins together and it wasn't real pretty. I have not had a chance to look at the code to see if there is a way to clean up the formatting.

[heritage]

Hi, can somebody send me Table Manager file. I registered at the author's site and sent many emails but got no reply.

thanks.

[FrankA2]

Did you want the unstable second version? 370k, need an email address

[FrankA2]

I would like it (Table Manager) to be updateable from the front end, any suggestions on how this can be done?

[heritage]

Yes, I will be happy with any working version.
my email: [email protected]

thanks.

[TaskyZZ]

I would also like a copy of the Table Manager software if someone would be so kind as to email it to me.

I have been unable to get anywhere with the site.  It is in Italian and I cannot seem to get an account setup.

Thanks.

[email protected]

[FrankA2]

OK, I can send it to you too.

[FrankA2]

Sent... if you can figure out how to get updates done from the front end, please let us know :-)

[TaskyZZ]

Thanks for sending.  Will take a look at it this weekend...

[FrankA2]

Did any of you get anywhere with this. A big problem is that it puts all the fields on top of each other and url's in a field do not work.

I am surprised that this is the only user controlled database extension on Joomla, presumably they are difficult to develop.

[DanBollinger]

This is new:

http://extensions.joomla.org/component/option,com_mtree/task,viewlink/link_id,2130/Itemid,35/

[FrankA2]

That appears to be a formatting tool for content created in another editor whereas this thread is about a table that the users defines fields and can then enter data, a simple version of Access but with no means to format the output. Or am I misunderstanding the discussion on that extension? If your tool is providing a formatting feature for this simple table tool that would be useful. I suppose a bit like the report feature in Access?

[DanBollinger]

I have no idea! It SEEMED to address your concern, and is similar to mine:  How to display tabular data within an article.  Dan

[FrankA2]

OK, I assumed you were the developer. No my problem is displaying the table itself:

My original data was built as a single html table but managing this is tough now, when it gets to thousands of entries... murder and it shows  in a wrapper HERE

So I installed the database and put in a few trial records, the db does have a url type but if I put in a typical joomla url, look what happens, second line. The first line shows what happens if you try and put in an html link  , only the text is left with a random link
Example database test

If you look through the table, virtually any field can contain one or more hyperlinks, it is a real problem as I cannot really work on the list in Joomla at the moment at all and I really need other people to be able to edit the entries from the front end.

[DanBollinger]

Frank, No, not a developer, a user, like you. I think this would be a good plugin. Something that you could 'call' from an article and it would read a database and then display the contents. Users could then access an admin side to edit/upload/append records to the database. Hopefully, a developer will read this and see some possibilities.

Dan