By Loupida on Tuesday, 06 August 2019
Posted in General Issues
Likes 0
Views 546
Votes 0
Hello there,

Could u denote me how i can enter more than 10.000 values in Dropdown field of easyblog in few steps?

Best Regards.
Hi Loupida,

Correct me if I am wrong here, do you mean that you want to create a dropdown custom field with 10 thousand (10K) of values inside? May I know what kind of value that you want to insert?
If it is correct, that you want insert 10K of values, unfortunately, it is impossible as there is limit for the options column (max length use is TEXT ) to store is up to 65,535 bytes
·
Tuesday, 06 August 2019 13:23
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Muhammad,

Actually, i want to enter range of numbers from 10 to 50000 with the intervaille of 10. So values will be: 10,20,30,40,...,50000. The total of entries will be 5 thousand. Is it possible? Please note that If i enter these values in .txt file to estimate the space, i get around 34,000 bytes.

If it is possible how i can enter all these values in few steps? May be by importing them in database?

Best regards.
·
Tuesday, 06 August 2019 15:58
·
0 Likes
·
0 Votes
·
0 Comments
·
Ah I see, I think a simple way that you do is, manually create a simple dropdown field (put a value) as example: https://take.ms/Vyqzf
Once you have save the custom field, it will add the custom field data in #__easyblog_fields table ( https://take.ms/pytVG )
As you see, the options column is where the values is store (in json format).
By here, you can alter your .txt file to have this format. example below:

[{"title":"10","value":"10"},{"title":"20","value":"20"}]

And you can change the options columns for that specific dropdown field in the #__easyblog_fields table ( https://take.ms/el6IN )

*p/s: you are suggested to backup your database, for precaution step
·
Tuesday, 06 August 2019 17:25
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Muhammad,

I applied your tip today and it works fine.

Thanks.
·
Saturday, 10 August 2019 12:00
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Loupida,

You are most welcome. Glad to hear that your issue has been resolved now.

Just for your information, I have locked and marked this thread as resolved to avoid confusions in the future. Please start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiries.

Thanks for understanding.
·
Saturday, 10 August 2019 17:36
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post