joomla/Component-Builder
joomla/Component-Builder
39
23
Fork 11
Code Issues 82 Pull Requests Projects 4 Wiki Activity
Page: 021 Tweaking MySQL Demo Data
Pages
001 Hello World with Joomla Component Builder 002 Intro to JCB 003 Installation of JCB 004 General Planning 005 Field Types 006 Basic Fields 007 Admin Views 008 Advanced Fields 009 Adding Admin Views to a Component 010 Component Settings 011 Component Scripts 012 Component FTP and more 013 dynamicGet 014 Adding dynamicGet to a Site View 015 Adding Templates and Layouts to a Site View 016 Template Setup 017 Layout Setup 018 Custom Admin Views 019 Adding Site Views to a Component 020 Adding Custom Admin Views to a Component 021 Tweaking MySQL Demo Data 022 Global Settings of Component Builder 023 Adding a custom time field 024 How to integrate the Create User Helper Method in your Components 025 How to use email helper in your components 026 How to setup a store message method along side the email helper class 027 How to ensure that a field is not escaped when added to list views 028 How to change exported values and setup custom import options 029 How to overwrite the custom fields 030 How to filter a list field based on association with another field 031 Automatic import of custom code during compilation in JCB 032 JCB manual custom code implementation 033 Export Import of fully mapped components 034 How to add Custom Buttons in JCB to your component Admin Area 035 Translation Mananger in JCB explained 036 Setting Site View Permission 037 Auto create SQL updates for Componets in JCB 038 Setup Site Edit View in JCB 039 Automated backup system in JCB 040 Adding Helper Structures to any JCB component 041 Upgrade to JCB v2.5.8 and using the new Admin View and Admin Fields 042 How to setup tabs after upgrade to v2.5.8 in JCB 043 Major Release of JCB v2.6.0 044 Hello World Component with Joomla Component Builder Creator Extended 045 Adding your own rule validation to a field in JCB 046 General overview of how community snippets work 047 Tutorial on forking JCB snippets so you can share your snippets with the rest of the Community 048 Tutorial on making a pull request at Joomla Component Builder Snippets 049 The New Library Manager Area 050 Easy Translation via excel 051 Dynamic Router Implementation Explained 052 Automated database updates in Joomla during development of a component 053 Quick Subform Demonstration 054 VDM Package Import Option 055 Dynamic File and Folder Inclusion concept 056 How to use the file field type to upload a file in JCB 057 Drag and Drop Upload functionality in JCB 058 The Quick Hello Word with JCB 059 Adding none database fields to an admin view 060 The custom dashboard option in JCB 061 Add or Remove Prefix to Component Name in Joomla Menu 062 Add your own JCB packages to the JCB Communty Directory 063 Proposed Collaborative Workflow in JCB 064 How to install jcb packages 065 JAB18 Using Joomla Component Builder 066 The new fields Area to make things easier 067 Adding Language String to your Component and get the Language Placeholder for dynamic use 068 Library Manager Anticipated Functionality 069 Join Fields in the admin list view with field relations 070 How to change the License Template in JCB 071 Reuse Custom Code 072 Setup Local Development Environment with Bitnami 073 JCB Fields Type Extended 074 How to add Joomla Custom Fields 075 Expand Custom Field Type Beyond The Default 076 A Quick Demonstration to Load a List of Items in a Site View 077 Run Expansion Explained 078 How to Add a Form to a Site View 079 Update the Site Form Field via URL Parameter 080 How to Add More Helper Methods to Your Components Helper Class 081 Easy Validation Rules for Fields in JCB 082 New Placeholders Feature 083 Manage a Components Global Config Option Field in Relation With Menu Params 084 Default Database Values can be set per Field Type Beta Testing Component Settings Develop a Joomla Component Guide to use the Component Builder Developing with Joomla Component Builder Home PHP Settings TIPS: Custom Code Using the JCB Demo Component While Building Your Local Development System
15 021 Tweaking MySQL Demo Data
Amigo edited this page 2019-08-15 16:14:58 +02:00
Table of Contents

TWEAKING MySQL DEMO DATA

MySQL tweaking in the component area

00:00:00 (Click on these time links to see Youtube video)

Open a component (in this instance, 'Editting a component'). Go to 'settings', and you'll find a 'MySQL' tweak. What is its function? If you have multiple versions of a component and partly demo relating to a certain version of it and implementation of items and you do not want those items included in another version, there is the 'MySQL' tweak area where a specific view can be selected. 00:00:43

Note: This feature may only be used if you're using this area where we added database connection between the view 'dummy data' and 'view' itself. 00:01:07

If 'Field types', one of Component Builders own views, is opened and connected to the database through 'MySQL'; if 'yes' is added and table selected, then Field types are selected in the database and allows it all to be taken into the 'Build' file. (See video.)

Tweaking Feature

00:01:33

Some of the versions distributed with Component Builder does not have all the field types. They are limited to a certain few field types. To explain what has been done, return to the tweaking feature. With Component Builder open, go to settings. 00:01:57 In this tweak feature, added values may be seen; certain of them, like Custom Admin, had been set to 'no'. Do not include the add MySQL (to view table) if it is set in the view. 00:02:19 If 'MySQL' was selected in the view it can be controlled which item's actual 'ids' should be included through this feature. As in the Admin View, these two 'ids' (33,42) had been included from the database. They are the 'ids' in the Admin View table. It is ID based. There is the feature including all. (See video.)

ID Based

00:02:46

It is a function used to indicate what is needed here. (See video.) If 'ids' between 1 and 50 are used, this arrow notation with an equals open bracket (=>) can be used to notate that between 1 and 500 you want to add. 00:03:15 Here, 1,2,3,4or1=>4, a comma is placed, 20, another comma and 40=>90, so in the same comma-delimited list, this notation can be added to show that 1 to 4 has to be included, after 20 is added and all the ids will be grabbed. 00:03:41 It eliminate any other ids and only use the ones that had been notated. Here is another example of using 1,4,23,199: it goes on from 597=>604,682=>684. (See video.) 00:04:08 It is in the same comma-delimited list, id based; include these by clicking 'yes'. That is what it can be used for. If dummy data or example data had not been included in the component build structure, this area is redundant and not necessary to use it at all. 00:04:46 Ignore it if there aren't any data selected.

This feature helps with the management of dummy data between versions in your applications.