×
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 Anni 8 Mesi fa #777
da AdamSki
Default content, pre defined table records è stato creato da 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?
Ringraziano per il messaggio: Yves Blatti
Si prega Accedi o Crea un account a partecipare alla conversazione.
Walt Sorensen
Senior Member
Posts: 54
9 Anni 7 Mesi fa #781
da Walt Sorensen
Risposta da Walt Sorensen al 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
Si prega Accedi o Crea un account a partecipare alla conversazione.
Randy Carey
Junior Member
Posts: 23
9 Anni 7 Mesi fa - 9 Anni 7 Mesi fa #783
da Randy Carey
Risposta da Randy Carey al 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.
Ultima Modifica 9 Anni 7 Mesi fa da Randy Carey.
Si prega Accedi o Crea un account a partecipare alla conversazione.
Yves Blatti
New Member
Posts: 3
8 Anni 4 Mesi fa - 8 Anni 4 Mesi fa #1395
da Yves Blatti
Risposta da Yves Blatti al 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
Ultima Modifica 8 Anni 4 Mesi fa da Yves Blatti.
Si prega Accedi o Crea un account a partecipare alla conversazione.
Tempo creazione pagina: 0.064 secondi