By Cheryl Viirand on Thursday, 18 May 2017
Posted in General
Replies 5
Likes 0
Views 764
Votes 0
Hi -

I've been excited about your introduction of Extra Fields for EasyBlog posts - that's perfect for my application. However, I have 2 issues/questions before I can implement it on my site:

1) Currently, I have about 1000 EasyBlog posts, each of them with between 4-10 tags. Since there wasn't a way to "lock" the tags, there's a tremendous amount of duplication here, making it impossible to create one menu item displaying all relevant tags. Thus, I'm excited to move to a more structured database format. However, the question is how to convert all the old tags over? A few ideas:
a) Do you have a script for combining multiple tags into one? (For instance, automatically replace "gluten free," "gluten-free," "Gluten-Free" and "glutenfree" with "gluten-free"?)
b) Is there a way to assign extra field values in bulk, at least manually? Thus, I could search for each of the above variations on "glutenfree" and then auto-assign the 'gluten-free' extra field value.

2) As a related question, how can content be displayed based on its extra field values? For instance, EasyBlog ships with the ability to set a 'menu item' for a particular tag; do you have plans to add similar functionality to display content based on a particular extra field value? Ideally, one would be able to select a combination of parameters to display. It would be even more important to be able to do this for a content display module - currently, a number of third party providers offer content sliders that support EasyBlog tags (RokSprocket from RocketTheme and SmartSlider 3 from Nextend come to mind). Setting a combination of parameters to display EasyBlog posts is an absolute necessity for my site. I'd really appreciate hearing what your plans are in this regard.

Thanks,
Cheryl
1) Currently, I have about 1000 EasyBlog posts, each of them with between 4-10 tags. Since there wasn't a way to "lock" the tags, there's a tremendous amount of duplication here, making it impossible to create one menu item displaying all relevant tags. Thus, I'm excited to move to a more structured database format. However, the question is how to convert all the old tags over? A few ideas:
a) Do you have a script for combining multiple tags into one? (For instance, automatically replace "gluten free," "gluten-free," "Gluten-Free" and "glutenfree" with "gluten-free"?)
b) Is there a way to assign extra field values in bulk, at least manually? Thus, I could search for each of the above variations on "glutenfree" and then auto-assign the 'gluten-free' extra field value.

Currently we do not have any script for combining multiple tags into one, it actually need to use PHP script and SQL query to update into database existing value, and it quite difficult to use PHP to check it unless all the tag like what you mention at above all tag contain 'free' specific word, so can be use PHP to check it.

"gluten free," => "gluten-free,"
"Gluten-Free" and "glutenfree" => "gluten-free


Regarding with your second point, actually what do you mean for the "extra field value"? Are you referring tag value or inside the blog content custom field value?


2) As a related question, how can content be displayed based on its extra field values? For instance, EasyBlog ships with the ability to set a 'menu item' for a particular tag; do you have plans to add similar functionality to display content based on a particular extra field value? Ideally, one would be able to select a combination of parameters to display. It would be even more important to be able to do this for a content display module - currently, a number of third party providers offer content sliders that support EasyBlog tags (RokSprocket from RocketTheme and SmartSlider 3 from Nextend come to mind). Setting a combination of parameters to display EasyBlog posts is an absolute necessity for my site. I'd really appreciate hearing what your plans are in this regard.

Currently we do not have plan for allow user add multiple tag in the menu item yet.
Perhaps you can add a feature request regarding this at https://stackideas.com/forums/easyblog/feature-requests so we will see if there a lot of user request this feature as well, we will definitely consider to implement this in the future.
·
Thursday, 18 May 2017 15:38
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi, Arlex!

Thanks for your note - and I'm sorry if my question was unclear. A couple of points to clarify - using the same numbers as above to make it easier to follow:

1) On combining the "tags":

a) I see how complicated it would be to do it with a script. Is there a way to export blog posts' data such as title, author, tags and custom fields into a .csv file where I could edit them more quickly, and then upload them again?

b) yes - by "extra fields" I meant "custom fields." Basically, I am trying to offer my community a common database of content that they can filter to find what's relevant to them. Open tags are a very poor way to do this - they've created hundreds of tags already, with tons of overlap, making it impossible for me to construct a page showing them what they're looking for - namely, all relevant content. So I want to replace the tagging system with the custom fields system, and give a defined set of options within each of 3 different categories. But for this to be useful, I need the ability to display the content as well. That means I need a module, or a menu item, to pull content together that has a certain combination of custom field values. [I don't care about this for multiple TAGS, for the reasons described above].

I think this just realizes the value in your 'custom fields,' making EasyBlog match all the functionality my users already have in my companion K2 database (which I use for a different, but also structured, purpose).

Thanks,
Cheryl
·
Thursday, 18 May 2017 18:47
·
0 Likes
·
0 Votes
·
0 Comments
·
1a.) Actually you can do it from the PHPMYADMIN and click on export function, so you can select what format you want. (screenshot : https://www.screencast.com/t/2pKUuZDV ), but unfortunately not all the data is under same table for example tag.

All the blog post will store in this table #__easyblog _posts but the tag is store in these 2 table `#__easyblog_tag` , `#__easyblog_post_tag`.

I can provide you a SQL query to update 'gluten_free','Gluten Free','gluten free','glutenfree' to 'gluten-free' but the thing is, it will show the duplicate tag on the page (screenshot : http://take.ms/rcJej ).


// Replace #__ to your table prefix
update `#__easyblog_tag` set `title` = 'gluten-free', `alias` = 'gluten-free' where `title` in ('gluten_free','Gluten Free','gluten free','glutenfree');


Regarding this, you have to manually correct it on this table `#__easyblog_post_tag`, what this table is store the post id which associated with the tag id.

If you would like to try this, it would be best is setup a development site so whatever you did, it will not affect with your live site.

b.) Basically you would like to have a menu item which can filter by custom field value so it will display a list of blog post on the listing page base on the custom field value?
·
Friday, 19 May 2017 17:54
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for your response, Arlex.

On a), consolidating the tags sounds complicated. Is there a way to export the database and apply values to extra fields in bulk? For instance, to check the "gluten-free" box in a "diets" extra field to all blog posts already in our database that have been given the tag "gluten-free".

On b), yes: a menu item that allows me to set the 'rules' for which blog posts to display based on their extra fields (for instance, all blog posts with "a" in extra field 1, "b" in extra field 2 and not containing "c" in extra field 3), AND also a module that will allow me to do the same thing (so that I can also embed the display within other menu items).

It would be even more powerful if it were also possible if users could set their own combination of extra field criteria through an advanced search panel. But for starters, the module and menu item would be wonderful!

Thanks!
Cheryl
·
Tuesday, 23 May 2017 12:08
·
0 Likes
·
0 Votes
·
0 Comments
·
You're welcome.

a.) Perhaps you can try this method but you have to modify single word of this.
1. Go to your database > find this table `#__easyblog_tag` > click export table button > select SQL format > Click Go
2. After it downloaded, open that sql dump file, you can modify those tag from the file.
3. After you save it, you have to backup your existing this table `#__easyblog_tag` from your database and rename this table `#__easyblog_tag` to another name e.g. `#__easyblog_tag_backup`
4. Once you backup already, you can import back what you modified that sql dump file into your database.
Note : I would suggest you do it from your development site, if everything work fine, then only do it on your live site.

b.) I understood what is your current requirement now regarding this point, but currently we do not have this feature which allow user to filter by custom field value from the menu item and module yet. Perhaps you can start a new thread request this feature in this page https://stackideas.com/forums/easyblog/feature-requests so we will see if there a lot of user request this as well, we will definitely consider this in the future.
·
Tuesday, 23 May 2017 14:04
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post