Welcome, Guest
Username: Password: Remember me

TOPIC: Lost Newbie

Lost Newbie 20 Oct 2017 22:10 #15418

  • taoh
  • taoh's Avatar
  • Offline
  • New Member
  • Posts: 3
  • Karma: 0
Hi All
I'm a complete newbie to Joomla and creating components. For the first component I have a table

CREATE TABLE `#_anesfhs_indentures` (
`id` int(11) UNSIGNED NOT NULL,
`i_date` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`i_sdate` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`i_apprentice` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`i_parent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`i_master` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`i_gros` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`ordering` int(11) NOT NULL,
`state` tinyint(1) NOT NULL,
`checked_out` int(11) NOT NULL,
`checked_out_time` datetime NOT NULL,
`created_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `qrk6m_anesfhs_indentures`
--

INSERT INTO `qrk6m_anesfhs_indentures` (`id`, `i_date`, `i_sdate`, `i_apprentice`, `i_parent`, `i_master`, `i_gros`, `ordering`, `state`, `checked_out`, `checked_out_time`, `created_by`) VALUES
(50, '2029-04-10 00:00:00', '', 'Robert Falconer', 'on of William Falconer, merchant burgess of Elgin', 'Andrew Aberdeen, merchant burgess of Aberdeen - merchandising', 'RD11/308', 1, 1, 0, '0000-00-00 00:00:00', 309),
(51, '2026-04-21 00:00:00', '1659', 'Magnus Taylor', 'son of John Taylor', 'Alexr Webster, tailor, lawful son to John Webster in Pittendrum', 'SC1/60/24', 2, 1, 0, '0000-00-00 00:00:00', 309),
(52, '28 February 1671', 'NLS/Ms 21178', '1659', 'Mr Alexander Crawford', 'son of James Crawfurd at Mill of Strichen', 'Mr James Crawford, Writer to the Signet', 10, 1, 0, '0000-00-00 00:00:00', 309);

The six i_* are used by me the rest by joomla. The table has 2,000 odd records. All I want the component to do is :-
ADMIN
Add,change, delete Records which will require list with search and form.
USER
List with search leading to form with printout.
The List view will also have an explanation at top about data set and the data from field i_gros (possible popup from i_gros to expanded explanation.)

My problem is that I'm on a steep learning curve 'cos I'm terminal Cancer and I can't figure out how to go about Cook's Pro
Maybe if I can get thru this one I can get on with the others waiting in the queue.

Cheers
Niall
The administrator has disabled public write access.

Lost Newbie 21 Oct 2017 09:14 #15419

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3697
  • Thank you received: 971
  • Karma: 140
Hi Niall,

I would need to know what is blocking to you.
Cook has no proper documentation, that's effectively true, but the learning curve is quite fast.
Once you have create a new component, try to import this SQL dump into the builder.
You can also create a sample component from the menu, and play with it
Coding is now a piece of cake
The administrator has disabled public write access.
Time to create page: 0.058 seconds

Get Started