#85 – The problem with Cascade fields

Joomla! version :3.7.5
PHP version :7.0
AdsManager version :3.1.11
The problem with Cascade fields. When adding new value, after saving, all the work done before is lost! I made a video screen. https://webmaster9909.tinytake.com/sf/MjA2NzUyNV82NTAxMzg2
It's weeks of work! What can I do to make the program work correctly? Which resource to increase on hosting?

Hello,

You have way to many value in that field to use the values storage of AdsManager.

You need to use the external table feature.

In the cascade field setting, just above the field values, you can choose what type of storage you wish to use for the field.
Choose 'Data stored in an external table', and then fill the following field.

You need to store the values directly in your database.

Best regards.

Thank you. Do you of course have a manual for setting up such a specific function? Guide step by step? I first time see this in Joomla.

Hello,

The documentation is currently being rewritten so it is not available.

You can ask if you need help with this feature.

Best regards.

It will be very good if you explain how I can use this function. On a simple example. I've never had to do this. Very unusual for the Joomla component.

Hello,

I will explain with a step by step process.

1. In your database create a new table with 4 columns:
- id - Primary key, auto increment
- label - The name that will be displayed on the screen, varchar(255)
- value - The name that will be used in the database, must be unique, varchar(255)
- parent - The value of the parent

Populate that table with your datas, you can use a import csv by using the phpmyadmin import feature.

2. Go to the backend of your website and edit the cascade field in components->adsManager->fields
At the end of the settings:
- Enter the name of the parent field in the 'Parent field name' parameter.
- Select 'Data stored in an external table'
- In 'Database table name', enter the name of the table you've created earlier
- In 'Column name for label', enter the name of the label column (label in my example)
- In 'Column name for value', enter the name of the value column (value in my example)
- In 'Column name for parent value', enter the name of the parent value column (parent in my example)

Save the fields and that it.

If it doesn't work, check that the parent value exist in the parent field.

Best regards.

Thank you. Everything is working. excellent manual.