How do I import from CSV to an existing Profile field

[ukcobra]

My Vbulletin forum has a field in the Profile to store a Club Membership number. It's a freeform text field , however, I would like to take the details stored in the Club's separate Membership database and periodically update the field.

Our CSV file would contain the new details and have the VB Forum ID name / number.

How do I go about merging this automatically on a regular basis ?

I have spent some time searching this forum and google, and not found anything suitable.

Thanks in advance

Mark

[Dave]

There are multiple ways you can do this.
For example, one way to do this is to make a new script in the ACP which allows you to upload a CSV file. Then you just parse it with PHP its CSV parsing functions and update the profile fields.

[ukcobra]

Thanks for that, I've had a look in the ACP, but cannot see anything where I could do this.
Are you aware of any online guide or manual I can refer to ?
Thanks
Mark

[Dave]

Well obviously you have to create the script yourself and to create a menu item in the ACP, you have to create a cpnav_*.xml file which can be found in the includes/xml/ folder on your server.

If you can't do this yourself, you should create a thread here (https://vborg.vbsupport.ru/forumdisplay.php?f=112) or here (https://vborg.vbsupport.ru/forumdisplay.php?f=30).

[ukcobra]

Thanks, I feel confident to create the script when following some instructions, just find it strange that it's not out there and documented.

I don't believe I am the first person to want to do this. So I need to dig a bit deeper with my searching I guess.

[tbworld]

This might help you out:

http://www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-impex-import-system/318880-csv-file-import-users-into-vbulletin

Read through the thread, as the original poster is requesting something similar.

:)