×
This forum has been locked. Please submit new Feature Requests on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
Default content, pre defined table records
AdamSki
New Member
Posts: 2
9 years 8 months ago #777
by AdamSki
Default content, pre defined table records was created by AdamSki
Few common examples:
-Countries,
-Payment types,
-Honorific (titles)
When shipping Joomla component I would like to have ability to attach default table values so further users
don't have to enter country by country (however they may still add or edit one).
Now when I click "Import SQL +" only table structure is imported whereas records are not... or maybe am I missing something?
-Countries,
-Payment types,
-Honorific (titles)
When shipping Joomla component I would like to have ability to attach default table values so further users
don't have to enter country by country (however they may still add or edit one).
Now when I click "Import SQL +" only table structure is imported whereas records are not... or maybe am I missing something?
The following user(s) said Thank You: Yves Blatti
Please Log in or Create an account to join the conversation.
Walt Sorensen
Senior Member
Posts: 54
9 years 7 months ago #781
by Walt Sorensen
Replied by Walt Sorensen on topic Default content, pre defined table records
I would say not just countries, but also include a state/providence table.
Zip/postal Codes is another good "table look up" for default table options which would include predefined data.
State/providence and Zip/postal can be filtered by countries or can reverse fill (enter a zip code and auto fill the city/state/country)
It would be nice from a component building stand point to choose to include all data, a select set, or a select set + a custom set
Zip/postal Codes is another good "table look up" for default table options which would include predefined data.
State/providence and Zip/postal can be filtered by countries or can reverse fill (enter a zip code and auto fill the city/state/country)
It would be nice from a component building stand point to choose to include all data, a select set, or a select set + a custom set
Please Log in or Create an account to join the conversation.
Randy Carey
Junior Member
Posts: 23
9 years 7 months ago - 9 years 7 months ago #783
by Randy Carey
Replied by Randy Carey on topic Default content, pre defined table records
(responding as a fellow user of CC...)
Joomla allows us to add a script to the installation that performs additional actions - such as initializing a table with values or enabling a plugin or adding one or more modules to the db. Since every person's needs are different, you have to code this yourself and add it to the installation package.
As for countries/states, I suggested this a while back. I think the best way is to create a custom field type that comes preloaded with all the valid options, and the user can only select one (or more) from this list. Once you create and debug such a field, you should be able to add it quickly to any component. Here is how I'd add the field: I would create the country or state field within the component, install the component, drop that new field-type file into the /models/fields folder, and then change the country or state fields to the new type. This isn't too hard (once you create the reusable field type). My original suggestion to CC is to establish a library where users can submit their own custom field types for others to reuse. This might be asking too much of CC, but for each of us, we can build our own custom field types to reuse between projects. ...and don't forget, we can do this only because Joomla is so rich and flexible - we just need to learn it well to know what all we can do with it.
Joomla allows us to add a script to the installation that performs additional actions - such as initializing a table with values or enabling a plugin or adding one or more modules to the db. Since every person's needs are different, you have to code this yourself and add it to the installation package.
As for countries/states, I suggested this a while back. I think the best way is to create a custom field type that comes preloaded with all the valid options, and the user can only select one (or more) from this list. Once you create and debug such a field, you should be able to add it quickly to any component. Here is how I'd add the field: I would create the country or state field within the component, install the component, drop that new field-type file into the /models/fields folder, and then change the country or state fields to the new type. This isn't too hard (once you create the reusable field type). My original suggestion to CC is to establish a library where users can submit their own custom field types for others to reuse. This might be asking too much of CC, but for each of us, we can build our own custom field types to reuse between projects. ...and don't forget, we can do this only because Joomla is so rich and flexible - we just need to learn it well to know what all we can do with it.
Last edit: 9 years 7 months ago by Randy Carey.
Please Log in or Create an account to join the conversation.
Yves Blatti
New Member
Posts: 3
8 years 4 months ago - 8 years 4 months ago #1395
by Yves Blatti
Replied by Yves Blatti on topic Default content, pre defined table records
I would LOVE to be able to insert default values in tables !!
Can be used for :
* demo / default records for future users
* ease the tests of the result created by component creator once installed (dont' have to populate everything)
* "system" tables of the component, with predefined lists etc.
(Bonus) We then could have default values on foreign keys fields
Can be used for :
* demo / default records for future users
* ease the tests of the result created by component creator once installed (dont' have to populate everything)
* "system" tables of the component, with predefined lists etc.
(Bonus) We then could have default values on foreign keys fields
Last edit: 8 years 4 months ago by Yves Blatti.
Please Log in or Create an account to join the conversation.
Time to create page: 0.053 seconds