Bulk Import Members to your SolidWeb Site | Scribe

    Bulk Import Members to your SolidWeb Site

    • Chris Skelly |
    • 35 steps |
    • 2 minutes
    • Local6000Local6000
    alert ordinal icon
    Alert! You can only upload one type of member at a time. For this example we'll be uploading our Active Membership list. You can use this guide for any type, including Retired Membership or Leadership.
    alert ordinal icon
    Alert! It's important that the data in LUIS is up to date with the latest email address the members have. If it's been 6+ months since the last LUIS update, you may want to consider taking a month reach out to the membership to update the membership data. There are a number of ways to do this, including creating an "Update your information with your Local" form in Action Network. Here's a tutorial on doing that. It includes a flyer with boilerplate information that you can use to distribute to your membership after you fill in the details.
    1
    Format your member data from LUIS in Excel. LUIS stores the first name and last name separately, but SolidWeb wants them combined in one field. The simplest way to do this is as follows
    2
    In Excel: delete all fields except for First Name, Last Name, and Email Address
    3
    Select the entire "First Name" column
    4
    Right click on the selection > select "CUT" (CTRL + X)
    5
    Right click on the "Last Name" column > select "Insert Cut Cells"
    6
    Now your data in excel should be "First Name", "Last Name" "Email Address"
    7
    Select all of the values in the "First Name" and "Last Name" column, but not the column headers and right click "COPY" (CTRL + C)
    8
    Open Microsoft Word or Text Edit
    9
    In a new document, paste in the values only. In Microsoft Word: Paste Special - Values only/Text Only. If you use Text Edit, then it will automatically strip out formatting.
    10
    Now you will have the first name and last name combined. The next step is to remove the tab between the names.
    11
    Select the space or tab that is between one of the names. Right click "Copy" (CTRL + C)
    12
    Go to the menu and select "Find" > "Replace"
    13
    Paste the space/tab you just copied in the "Find" field
    14
    In the "Replace" field, press the spacebar.
    15
    Click "Replace All"
    16
    Select all of the text > Right click > "Copy" (CTRL + C)
    17
    Paste the values in a new excel document and it should paste in one column with the combined first and last name in each cell in the column. Save the file as "combined.csv". We will come back to this file later. Keep the file open in Excel and open your web browser.
    18
    Navigate to your SolidWeb site