Click the Picture to watch the 14 minute video on how you can use an Excel Spreadsheet to Control Online Directories, this can be for any membership organization. Also scroll down for detailed procedures on how this service works and can help your organization.
To View a sample online directory, CLICK HERE.
To View a clients actual directory, CLICK HERE.
1 - Download MemList.zip, Unzip to C:\MemberDirectory
2 - Fill in the information for your members, if you have an existing file, copy / paste columns
3 - Contact us at 352-258-2594 or firstname.lastname@example.org to provide your City / State / Organization Name and we will then send you files needed to upload your Excel File to your secure ftp folder. Simple double click a batch file to upload the file.
4 - We will also provide you with 1 simple line of code that you insert on your website Member Directory Page. Once inserted and published your directory will be live
We offer your members an opportunity to post a photo/picture/logo on their listing for only $20/year, we ask the organization to collect this fee and we will bill the organization every 10 pictures each year, if the member does not renew, that $20 is not due. We limit our income to the first 40 pictures, any pictures after that are additional revenue for the organization. In order to continue the service we offer, BAAC requires a minimum of 20 photo's within 6 months.
You send the picture to email@example.com be it a jpg, gif, pdf, png, doc, docs etc. BAAC then formats the picture to a .jpg and adjusts the size for your directly, we then name the file, upload to your picture folder and send a return email to you with the picture file name (i.e. abc.jpg), you then just enter that file name in the MemList.xlsx file and run the batch file to upload your directory. The picture will now appear on the members directory listing. NOTE, members can also provide a different URL then their home page so that if a visitor clicks the picture it will go that URL.
It is programmed that all your members can have their contact information, website URL and map links. However, in order to have a business description and social media URLs (Facebook, twitter, linked in, Instagram, or a blog) the member MUST have a picture posted to their listing. If not then those fields are blank. The data can be in the spreadsheet, it simply will not upload to the directory with no photo/pic/logo.
If after trying our directory and deciding to keep it, we will also offer a free MS Access database application program that is an in office program. It offers over 95% of what cloud based apps provide for thousands per year.