Importing & recounting items in custom databases (CMS)

[DReffects2]

Hey Guys,

so I am moving my very very old PERL driven database with news articles stored in a sort of CSV file to the invisionpower cms

While I figured that i simply could import a CSV with all the necessary fields via phpmyadmin to the cms_custom_database_x table directly I am wondering how to recount the items to have the categories display the correct numbers.

Or is there a better way altogether?

Thanks

-DR

[opentype]

Make any change to it, like adding a temporary record.

[DReffects2]

Cool, thanks! Will this update the statistics for members as well? The imported posts are linked to existing members.

[Daniel F]

Keep in mind to also:

1. Rebuild the search index
2. Rebuild the content count for the member who’s going to be the content creator of the new content

[DReffects2]

2 hours ago, Daniel F said:

Keep in mind to also:

1. Rebuild the search index
2. Rebuild the content count for the member who’s going to be the content creator of the new content

Hey Daniel,

could you please point me to the right direction in terms of the search index rebuild?

As for the content count: I only know about the 'recount' link within the ACP in each members' profile. Unfortunately I do have too many to do this by hand. Is there a way to globally rebuild everything like after the IPS 3->4 upgrade?

Thanks,
Daniel