Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#1 Bulk load survey takers

open
nobody
Admin (4)
5
2004-12-01
2004-12-01
Not me
No

Would be nice if it were possible to bulk load a large
number of survey takers into an invitation only survey.
I.e., upload a text file of email addresses then have the
invitations sent out.

Discussion

  • Bakkulf
    Bakkulf
    2005-01-09

    Logged In: YES
    user_id=1182667

    I managed this with simple SQL inserts, generated with an
    Excel-document. In column A i put the "Full Name", the
    e-mail for the user in col. B. In the C-column, I put a user
    ID, increasing by 1, starting with the current largest user
    ID (you get it from the table user_sequence).

    That is:
    A2: Nathan Newuser
    B2: nathan@user.com
    C2: 31 (formula: =C1+1)

    Then you need to know which sid your survey has; in my
    example 29. For normal users (just premitted to answer, the
    status will be 1, and the results_priv = 0).

    Use Excel to generate SQL like this:

    INSERT INTO users (uid, sid, name, email, status,
    results_priv) VALUES (31, 29, 'Nathan Newuser',
    'nathan@user.com', 1, 0);

    You can do this by inserting the followin formula into col. D2:
    ="INSERT INTO users (uid, sid, name, email, status,
    results_priv) VALUES (" & C2 & ", 29, '" & A2 & "', '" & B2
    & "', 1, 0);"

    Then you copy the ID-column (C) and the SQL-generating
    column (D) down as many rows as needed. Mark all data in
    col. D, copy and paste into your SQL manager/mysql-prompt.

    Then; at last update the sequence-table using:
    UPDATE users_sequence SET id=xx
    XX = the highest value from your col. C (user ID).

    Works very fine for me, hope it will work for you too :)
    Best regards,
    -Bakkulf