Publish many imports at once

[Sforzando87]

My imported posts (over 500) are not published after import, but I cannot sit and go through 500+ items one by one to publish them if the dates are already there. Please advise how to do it faster?

[mjauvin]

You could run the following code using php artisan tinker:

\RainLab\Blog\Models\Post::all()->each(function ($item) { 
   $item->update(['published'=>1]);
 });

[mjauvin]

But I agree that the "published" property should be added to the import/export models columns.

[Sforzando87]

I get the following error:

[mjauvin]

It's probably because you are using the 1.0 branch...

try monkey patching the RainLab.Blog Post Model like this:

file: /plugins/rainlab/blog/models/Post.php:

public $fillable = ['published'];

[Sforzando87]

Thank you for your assistance - I now get 'The slug has already been taken'

[LukeTowers]

use this code instead: php artisan tinker

\RainLab\Blog\Models\Post::where('published', false)->update(['published' => true, 'published_at' => now()->toDateTimeString()]);

[LukeTowers]

For your initial import did you include the published_at column?

[Sforzando87]

I kind of got this to work - not the ideal solution but I used the following code in tinker:
\RainLab\Blog\Models\Post::where('published', false)->update(['published' => true, 'published_at' => now()->toDateTimeString()]);

I then re-imported the csv and updated the original post publish dates and all seems to be ok. Thanks for your help guys.