Import Annual Members

while most filmbot customers only need to import annual members into our system once when they're switching from a different membership platform, there may be other situations where you might need to import additional annual members, including issuing comp memberships you would do this via the annual member import spreadsheet annual member import template the annual member import template allows you to take memberships created and paid for outside of filmbot and import them into our system , as well as issuing comped memberships if your organization does not yet have an annual member import template link, please contact mailto\ support\@filmbot com and we'd be happy to provide you with one fill out the annual membership with the following fields for each member true 220,220,221 unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type performing the import if you are a new customer, filmbot will perform the initial import as part of your onboarding in addition, please mailto\ support\@filmbot com if you have more than 200 members to import however, if you are an existing customer with fewer than 200 members to import, you can do the following go to tools > import click on "run importer" under google sheets annual memberships add the url for your annual member import template and click continue click continue if there are no errors, click on start import if there are errors that need to be addresses, either correct them if possible, or mailto\ support\@filmbot com with questions please make sure the permissions on the google sheet are set to either general access > "anyone with the link" > viewer people with access > filmbot import\@filmbot import iam gserviceaccount com > viewer (this option is more secure) faqs do i need to delete any previously imported members from the spreadsheet? no as long as each imported member has a unique member id compared with previously imported members, you can either leave previously imported members in the spreadsheet (they will be ignored), or you can remove previously imported members we find that it is generally easier to leave previously imported members in the spreadsheet so long as there are not an especially large number of members in the spreadsheet can i update existing members via the spreadsheet? no, while the importer can create new memberships, it can't modify any existing memberships is there a way to identify members who were imported? yes, there's a column in the https //support filmbot com/cinema/w2xz memberships titled "imported?" that willl contain a lower case x if the associated membership was added via the import spreadsheet