Welcome, Guest
Username: Password: Remember me
If you expect answers you should describe your problem and give as much information's as possible. (SQL-Structure, Template Code, Joomla Version ...) Please read this before posting: joodb.feenders.de/support.html
  • Page:
  • 1

TOPIC: creating the first database

creating the first database 2 months 5 days ago #5238

  • nexturejohn
  • nexturejohn's Avatar Topic Author
  • Offline
  • Posts: 4
  • Thank you received: 0
Hi, I have just downloaded JooDatabase, and in trying to create a database for the first time, your instructions say: "Add Menuentry - Add a JooDB-Catalog-view to your menus".
Can you please explain in simple steps what this means?

thanks
John

Please Log in or Create an account to join the conversation.

creating the first database 2 months 4 days ago #5240

  • Dirk
  • Dirk's Avatar
  • Offline
  • Posts: 1083
  • Karma: 21
  • Thank you received: 196
Joodb does not create database tables. Only if you import Excel spreadsheets .

It just displays tables and let you layout the catalog and single item view with a template engine.

Please take a look at the example database and add a menu entry (katalog view).

You can use this table #_joodb_sample and add fields using a tool like PHPMyadmin.
The following user(s) said Thank You: nexturejohn

Please Log in or Create an account to join the conversation.

creating the first database 2 months 4 days ago #5241

  • nexturejohn
  • nexturejohn's Avatar Topic Author
  • Offline
  • Posts: 4
  • Thank you received: 0
Is it possible to import other table structures into Joodb, and then visualise them? That is, ones that don't have the exact structure of the sample database you provided.
thanks

Please Log in or Create an account to join the conversation.

creating the first database 2 months 2 days ago #5250

  • nexturejohn
  • nexturejohn's Avatar Topic Author
  • Offline
  • Posts: 4
  • Thank you received: 0
Can you tell me how I can display a simple table? The table is already in

the joomla database. In the example beow it has 10 rows. I wish to simply

display all the rows and columns.
When I look at your example database, I don't know what to change!
Also using that example it shows each row separately.
I just want to show the whole table! Can you tell me which parameters to set

to display this? It can't be difficult, but I really do not understand where

to start! Thanks!

DROP TABLE IF EXISTS `cs39_tbl_ASME`;

CREATE TABLE `cs39_tbl_ASME` (
`VOL` INTEGER NOT NULL,
`FOTO` TINYINT(1),
`PAG` INTEGER,
`POS` VARCHAR(50),
`TIPO` VARCHAR(50),
`CHIESA` VARCHAR(50),
`DA` INTEGER,
`A` INTEGER,
`NREC` INTEGER,
`NPAG` INTEGER,
`FOTOSTAT` VARCHAR(50),
`CONTEN` LONGTEXT
) ENGINE=myisam DEFAULT CHARSET=utf8;

SET autocommit=1;

#
# Dumping data for table 'tbl_ASME'
#

INSERT INTO `cs39_tbl_ASME` () VALUES (1, 0, 2, '1sup', 'Libro',

'S.Giuliano', 1695, 1720, NULL, NULL, NULL, 'Libro della venerabile

parrocchiale Chiesa di S. Giuliano');
INSERT INTO `cs39_tbl_ASME` () VALUES (2, 0, 2, '1sup', 'Admin',

'S.Giuliano', 1807, 1902, NULL, NULL, NULL, 'Atti vari relativi alla Chiesa

di S. Giuliano');
INSERT INTO `cs39_tbl_ASME` () VALUES (3, 0, 2, '1sup', 'Messe', 'S.Carlo',

1958, 1966, NULL, NULL, NULL, 'Registro di Messe - Istituto S. Carlo di

Erice');
INSERT INTO `cs39_tbl_ASME` () VALUES (4, 0, 2, '1sup', 'Messe', 'S.Carlo',

1951, 1956, NULL, NULL, NULL, 'Messe celebrate in S. Carlo di Erice');
INSERT INTO `cs39_tbl_ASME` () VALUES (5, 0, 2, '1sup', 'Admin', 'S.Carlo',

1872, 1897, NULL, NULL, NULL, 'Giornale di esito di S. Carlo');
INSERT INTO `cs39_tbl_ASME` () VALUES (6, 0, 2, '1sup', 'Libro',

'S.Giuliano', 1630, 1750, NULL, NULL, NULL, 'Intavolatura - Parrocchia di S.

Giuliano');
INSERT INTO `cs39_tbl_ASME` () VALUES (7, 0, 2, '1sup', 'Libro',

'S.Giuliano', 1722, 1771, NULL, NULL, NULL, 'Intavolatura - Parrocchia di S.

Giuliano');
INSERT INTO `cs39_tbl_ASME` () VALUES (8, 0, 2, '1sup', 'Admin',

'S.Giuliano', 1601, 1763, NULL, NULL, NULL, 'Atti di soggiogazione relativi

alla Parrocchia di S. Giuliano');
INSERT INTO `cs39_tbl_ASME` () VALUES (9, 0, 2, '1sup', 'Eredita\'',

'S.Giuliano', 1856, 1857, NULL, NULL, NULL, 'Amministrazione di eredita\'

diverse aggregate alla Chiesa di S.Giuliano');
INSERT INTO `cs39_tbl_ASME` () VALUES (10, 0, 2, '1sup', 'Admin',

'S.Giuliano', 1594, 1608, NULL, NULL, NULL, 'Libro di Introito ed esito

relativo alla Chiesa di S. Giuliano');
# 10 records

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Moderators: Dirkjoest