Mass publish/unpublish items

Hello

I need to publish/unpublish over 2000 articles..how can i do that for all necesary items at once?

Thank you

.
The easiest way would be to run a query on the database to change the published setting.


.

Slightly related to this, it would be interesting if FLEXI had a "Mass Content" way to add new Categories and (sub) Categories en masse on one screen, rather than one at a time. Is that already possible?

Here's a link to the Mass Content for Joomla 1.5, for
example:

www.baticore.com/Mass-content/View-category.html

Ahah! Now I see the question you had, and I have the same issue. I imported my 500+ articles into Flexi, and they are all currently unpublished.

1. I can't click-to-publish one article at a time; rather, I am forced to open the article, and select "publish" once in the View Item mode.

2. I CAN select multiple articles, however I can NOT figure out how to choose to publish them all at once. There is no apparent button to toggle "Publish" or "unpublish."

Am I missing something?

It looks like one can change the publishing status of items when copying them in groups. I haven't tried this yet, however, because I don't really understand all the implications. Also, I'm not sure it's the most elegant solution.

I have the same issue, with more than 3,000 stories to publish.

.
This SQL code will set ALL Joomla articles to Published. That means ALL articles/items.
Including archived, un-published, or other states.

You can also limit the SQL to processing only particular "states."
The Joomla core states (that I have found) are:

1 = published
0 = un-published
-1 = archived
-2 = delete/trashed
I have not found specific documentation so this list may or may not be correct or complete.

Since FLEXIcontent has more/different item states there are other numbers/settings which may be found in that field.
I found these FLEXIcontent states in items.php (around line 329-346):
joomla_root\administrator\components\com_flexicontent\controllers\items.php

1 = published
0 = un-published
-1 = archived
-3 = pending
-4 = draft
-5 = in progress

I do not know what default state setting is on your imported items.
The FLEXIcontent default state is Draft (state = -4).
What is the state on your imported articles/items?


To limit the SQL to process only un-published items (state=0):
I tested this SQL to publish just draft items (state = -4): This published the one item I had in Draft state in that database.


HAVE CURRENT BACK-UPS BEFORE YOU TRY ANYTHING!
You may expect laughing and pointing if you do not heed this advice.


.