× 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

9 年 8 个月 前 #777 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? :-)
The following user(s) said Thank You: Yves Blatti

Please 登录注册一个帐号 to join the conversation.

9 年 7 个月 前 #781 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

Please 登录注册一个帐号 to join the conversation.

9 年 7 个月 前 - 9 年 7 个月 前 #783 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.
Last edit: 9 年 7 个月 前 by Randy Carey.

Please 登录注册一个帐号 to join the conversation.

8 年 4 个月 前 - 8 年 4 个月 前 #1395 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
Last edit: 8 年 4 个月 前 by Yves Blatti.

Please 登录注册一个帐号 to join the conversation.

创建页面时间:0.052秒
核心: Kunena 论坛

We use cookies so that you can place orders and we can provide a better service. You can control the use of cookies at the individual browser level. If you reject cookies, you may still use our website, but your ability to use some features or areas of our website may be limited.