Mass populate profile fields?

[momma_oz]

I may be stretching here, but is there a way or a mod that will allow you to import a spreadsheet or CSV or something to update the profile fields of the forum?

We switched from SMF to Vbulletin and while we are VERY pleased, we also managed to lose a bit of data in custom profile fields.

We have this info saved to a spreadsheet so I'm wondering how you would go about this (short of manually updating each and every profile as we have almost 700 members and ain't nobody got that kinda time)

any brilliance you'd care to share? Heck, brilliance not even required here...:o

[kh99]

I think I would create a new table in the database and inport the spreadsheet data to it (unfortunately, I can't give you details on that, it's the kind of thing I have to figure out every time I need to do it, which isn't often). When that's done, I think you can use an SQL query to move the data to the user table. Of course there has to be some field that matches between the two tables - I'd assume there's a username, which hopefully stayed exactly the same after the move.