Bulk Blog postings

Hello

I would like to post or upload blog postings in bulk in Dolphin 7.2

Any idea how to do that would be appreciated.

Also any idea how to do he similar with Articles would be appreciated.

Look to possibility to add posts directly via phpMyAdmin as example.

Thank you for your reply.

can you show me the steps how i need to do this

i just want to upload some articles in dolphin 7 in bulk. as one article or blog posting at a time takes a lot of time...

so if you can help me in telling how to do that. Even a help regarding the various tables getting updated with each blog post and a article post would be appreciated.

Claudia

Try to post 1-2 blog posts using ordinary way.

after goto phpMyAdmin

after make dump of data of `bx_blogs_posts` table.

and you will see how post text storing here.

so you can (as result) prepare SQL with all following posts and upload it once as bulk

(but commonly, this is not easy method too, but as bulk)

Thanks Andrew,

You got a point for this.

But will this upadate all the tables as normall doen when a blog post or a article post is done.

What articles and forums and pictures.

Claudia

I have tried this . but hwat i have seen in phpmyadmin is that the  BX blog tables have many tables like comments, forums,reviews,files,videos,etc.

Do i need to update all the tables or is it not require even if their is no entry .

The blogs have the following tables.

bx_blogs_main which stores only the name of the blog and it ID for reference by everything else.

bx_blogs_cmts stores the blogs comments.

bx_blogs_posts Stores the actual posts of the blog.

bx_blogs_rating stores the blogs rating.

bx_blogs_views_track tracking of blog views

bx_blogs_voting_track tracking of blog votes.

To post bulk to the blog the only one you need is bx_blogs_posts if you're posting to a blog ID that exists in the bx_blogs_main table. Thats why andrew suggested you post the normal way first as it creates a field in bx_blogs_posts that already contains the ID of the blog being posted to.