VBulletin CSV Import

Discussion in 'Integration' started by lrsamuel, May 25, 2009.

  1. lrsamuel

    lrsamuel New Member

    Joined:
    Nov 20, 2008
    Messages:
    1
    I have my amember installation integrated with amember. However, I'm trying to import my vbulletin members into my amember installation. When I do a csv import, I get the following message: Import. Step 1 of 3 Error : Fields not found or number of fields < 3
    # Fields not found or number of fields < 3

    The format I'm using for the csv is john;my_password;email;John;Simpson

    However, I've tried a bunch of different combinations - all with no luck.

    My question is simple. What format should I have it in, and if the above is correct, what am I missing? I've literally spent all day trying to figure this out, so any help would be appreciated.
    Please note, although no boardcode and smiley buttons are shown, they are still useable
  2. skippybosco

    skippybosco CGI-Central Partner Staff Member

    Joined:
    Aug 22, 2006
    Messages:
    2,526
    Do you make it to the second screen where you map the fields?

    Unzip the attached .csv and give it a try. It worked fine on my side using your specifics.

    The other option is manually add a user into your system and then export it to a .csv. That should give you the correct format as well.
  3. powerkeys

    powerkeys Member

    Joined:
    Aug 29, 2006
    Messages:
    192
    As "CSV" suggests - COMMA delimited.

    Try replacing the semicolons with commas.
  4. skippybosco

    skippybosco CGI-Central Partner Staff Member

    Joined:
    Aug 22, 2006
    Messages:
    2,526
    Actually a semicolon is a standard means of delineating as an alternative for source records that may have commas in them. Many apps, such as excel for example, default to using a semicolon.

    The good news is that aMember supports both comma and semicolon in the export and import process (defaults to semicolon)

    [​IMG]

Share This Page