Free Contact Management Software for your Business | BitFaster

If you are one of those people who is still using Microsoft Excel to maintain your Customer Contacts, it's time to switch to BitFaster. You no longer have to struggle with CTRL+F to find that Contact you need to quickly call up.

Just download BitFaster Professional from our website www.bitfaster.com and you can get started in less than 5 minutes!

Watch this video below and you can get to understand how BitFaster works.

Import Contacts From Excel using BitFaster Alerts

In the article, we will take a look at how we can automate the process of importing Contacts from an Excel file to a BitFaster Group using a BitFaster Alert. It is assumed that you have already updated the Customer ID and Pin in the Options window. If you don't have this information, please contact us to get a trial account.

The example will use 7 fields that will be mapped to the Contact_Master table in BitFaster. We will need to make a note of the Group ID to which we will have to import the data (make sure the Groups are created in BitFaster before you start).

View Group ID on Mouse Over

We will import the Contacts to the group named "Import Test" which has an ID 4. The sample data is shown below with the first row as Column Headers:

Sample Excel Data

Now that we have our import data ready, let's create a Connection String (from File > New > Connection String) which tells BitFaster details about the Excel file we should connect to (make sure the Excel file is closed before you do this). You will need to change the file name and path after "Data Source" to suit your requirements. Click on the Test button to make sure there are no errors and then Add the Connection String.

New Connection String to Excel file

Also make sure you create a Connection String for the BitFaster Database (check for the path in "Data Source" to suit your requirements). Click on the Test button to make sure there are no errors and then Add the Connection String.

New Connection String to BitFaster Database

You are now set to create an Alert. From the File menu choose New and then click on Alert. Under the Details tab, choose Data Transformation. Comments are optional.

Create New Alert - Step 1

Now click on the Data Source tab, pick the Connection String from the drop down menu and then enter the SQL Statement as shown in the screenshot below. Replace Sheet1$ with the name of the Excel Sheet in case you have renamed it in Excel.

Create New Alert - Step 2

Now you have to click on the Run Query button. You should see all your data from the Excel file as below.

Run Query

The last step is to specify a Schedule. This tells BitFaster as to when it should execute the Alert. You can run the Alert once a day or at regular intervals (like every 5 minutes) as required.

Create New Alert - Step 3

Now click on the Add button to create the Alert. So far we have seen how we can read the records from Excel. We will now see how we can insert this data into the Contact_Master table in BitFaster.

Now double click on the Alert name (in the BitFaster main window tree view click on Alerts under Automation) to edit it. In the Edit window, choose the Data Source tab and then click on the New button under Post Alert Action.

Make sure you choose the Connection String for the BitFaster database from the drop down and enter the SQL statement as shown below. All field values are enclosed in square brackets. Field names should be in all CAPS.

Insert into contact_master (salutation, firstname, lastname, company, defaultemail, defaultmobileno, comments, groupid) values ('[TITLE]', '[FIRST NAME]', '[LAST NAME]', '[COMPANY NAME]', '[EMAIL]', '[MOBILE]', '[COMMENTS]', 4 )

New Post Alert Action

Click on the Add button to create the Post Alert Action. You can have BitFaster execute multiple Post Alert Actions by adding more and then sequencing them as per your requirement. You are now ready to run the Alerts Manager. It is accessible from Tools > Alerts Manager.

BitFaster runs the Alerts based on your configuration. The Alerts Manager is updated every second to reflect the latest status.

Alerts Manager

Once the Alert is executed, you can check the Contact_Master table in BitFaster to verify if the records have been added as shown below:

Contacts Imported

Personalize an Email Campaign

Personalization plays an important role in getting the attention of your users. They should feel that the email is addressed to them and not have generic text such as "Dear Sir/Madam".

To make your communication even more effective, it's best to personalize even the Subject line. For example. the subject line "Thank you for your recent purchase John" has a higher impact when compared to the subject "Thank you for your recent purchase".

BitFaster makes it extremely simple to implement personalization in your campaigns. You can use any of the 66 System Variables to do this in your HTML code. Only a couple of rules you need to remember:

1. System variables are always enclosed in [...] brackets
2. System variables are case sensitive and have no space characters

Example:

[FullName]

For a complete list of variables supported, select System Variables from the View menu. You can repeat the variables any number of times in your HTML code.

SMS Response Codes

It is already known to you that running an SMS campaign on BitFaster, requires an SMS Gateway to be configured on it. We have discussed the procedure for doing, so in our previous blogpost on Configuring SMS Gateways on BitFaster. In the same post, we also mentioned that BitFaster supports only HTTP and HTTPS protocols. Generally, every response of a protocol has a certain code associated with it, based on which it is described; the erroneous responses or simply errors are no exception to this.

Errors are of special interest to us in matters like these, as any one of them could kill our primary motive of creating and running a successful SMS campaign. There could be various errors and in the event of a campaign not reaching the targeted person, it is necessary for us to identify the error at the earliest, so as to correct it at the earliest. Any non-technical user of BitFaster, who faces an error should be able to figure out an error and report the same to the appropriate team to initiate the necessary action. The error codes and their brief description can be provided by the gateway service provider. BitFaster can only be configured to report the error issued by the gateway.

In this post, we shall examine the simple procedure to configure BitFaster to alert you on the errors issued by the gateway.

1. Open BitFaster and click on Tools at the top. Doing so would open up a menu screen as shown below.





2. Select SMS Response / Error Codes, which opens up a window shown below :





3. This window shows the list of errors that have already been added in the List of Names field and the error codes corresponding to them in the SMS Response / Error Code field. The above window conveys that when the gateway issues an error with the code 001, BitFaster alerts the user as ‘Authentication Failed’.


• In order to configure a new error, click on Add in the above window. Doing so would open a new window, as shown below.





• In the Response Name / Status field, enter the description of the error and the corresponding error code in the SMS Response / Error Code field.


• Any general comment can be inserted in the Comments field.


• By checking in the box, Mark Message as Not Sent, the user gets to know of the messages that have been not been sent by the gateway.


• After completing the above steps, click Add. It updates the list of errors and the codes corresponding to them.

Configuring SMS Gateways on BitFaster

In this post, we assume that you have a good insight into the features that our tool – BitFaster has. Therefore, at this juncture, it is perhaps needless for us to mention that apart from email, BitFaster also allows you to run campaigns through SMS. Email campaigns require a local mail server to be configured on BitFaster. Equally well, in order to run campaigns through SMS, it is necessary that BitFaster gets to access an SMS gateway through which it can route all the messages / campaigns.

What is a Gateway?

It is basically a device or a piece of software that routes a message from the base station to the receiver through the telecom networks. In a broad sense, it functions in the same way as the SMTP server. Although it is of different types, a direct-to-SMS gateway is the one we shall concern ourselves with; this is because, a direct-to-SMS gateway allows one to switch between protocols. Although there are different protocols that can be used to govern the process of message transfer; BitFaster supports only http and https protocols. There are several benefits of using https protocol as it is fast, efficient, scalable and secure.

Configuring an SMS Gateway on BitFaster

So now that we’ve realized the role and need of an SMS gateway in our business, let us steer our focus towards configuring one on BitFaster. You will need to follow the steps mentioned below to set up an SMS gateway.

• First click on SMS Gateways in the tree view, that appears on the left of your BitFaster page. Once you are inside, right click and select New SMS Gateway. Doing so, leads to the window shown below.

• In the field Gateway Name, enter the name you wish to identify the gateway with.
• All SMS Gateways require an Application Program Interface (API) to function. This can be obtained from the gateway service providers themselves (usually from their websites).

As an example, let us consider configuring a Clickatell gateway on BitFaster (Please note that you could opt for any gateway service provider and obtain the details accordingly)

• Open Clickatell website and go to the page that shows the API for HTTP/S protocol.
• Copy the API in the URL text field. Typically a HTTP API looks something like this :
  
  https://api.clickatell.com/http/sendmsg?user=xxxxx&password=xxxxx&api_id=xxxxx&to=[MobileNo]&text= [SMS Message]
  

  The following fields need to be populated appropriately in the API for the gateway to function appropriately:

• The API username and password as provided by the service provider.
• API ID is a string that identifies the application to which the gateway has been interfaced. This is generally provided to all registered users.
• To refers to the mobile number (along with the country code) to which the message is being sent. It is absolutely necessary to use the variable [MobileNo] in the field without which the mobile number of the contact is not sent to the gateway.
• Text is the message that needs to be sent in the SMS.

Once all these parameters are entered, click Add in the window. This creates a new SMS gateway for BitFaster and you are ready to create and run your SMS campaigns.

Points to Note

Only one number can be entered in the To field at a time. This means that BitFaster connects to the gateway as many times as the number of contacts to which the message is sent. Credits maintained by you in the gateway, decrease accordingly.

The user need not enter the mobile number of the intended recipient each time; BitFaster automates this process.

BitFaster and the Social Media

The phrase “Email Marketing” is perhaps self-explanatory. However, it is not as easy as it sounds, for there are several aspects that need to be taken care of, in order to generate and execute a successful campaign, through mail. While most pioneers in the field of marketing, do acknowledge that email marketing is irreplaceable, it is a fact that they are looking at the social media route as well, to reach out to the customers and quite rightly so. The approaches adopted by the two are different and therefore the results are not surprisingly, different as well. We hope, this quells any doubts about social media having dealt a blow to email marketing. A smart marketing strategy would be to use both, so as to build a more robust customer base.

When we decide to use what we called a smart marketing strategy, a natural query that arises is regarding the possibility of an interface between the social media application and the email marketing tool. We have addressed this aspect in BitFaster – our successful email marketing tool. BitFaster allows the users to tweet the latest updates on their company profile (on Twitter), through Twitter applications; these applications can be integrated with BitFaster software through a set of codes generated during the creation of the application.

Those of you who are not very familiar with how to go about this, please read the next section of this blogpost.

Creating an application and integrating it with BitFaster

1. Open dev.twitter.com
2. Scroll down to the bottom and under the ‘Tools’ section, click Manage Your Apps.

3. Clicking Manage Your Apps leads you to the page shown below, where you click Create New App. If you have apps created for other purposes, they would be present on the left. In our case, we already have BF11Test and BFTester.

4. Clicking Create New App, opens up a page where one is required to enter the basic details of the intended application.

• The Name refers to the name of the application and has to be unique.


• The app can be described briefly in the Description field.


• The website would be www.bitfaster.com or any other web address with which the application would be interfaced.


• The callback URL field can be generally left blank.

After making the relevant entries in these fields, scroll down to accept the developer agreement and click Create my application. This opens up a new page as shown in the next diagram.

Now click on Keys and Access Tokens tab and scroll down to the bottom of the page. Click on Create my Access Token. Doing so generates a status update reflected on the top of the page. The status is update is as shown below :
----------------------------------------------------------------- Your application access token has been successfully generated. It may take a moment for changes you've made to reflect. Refresh if your changes are not yet indicated. ------------------------------------------------------------------ At this time click on Test OAuth at the right side of the page on the top to see the codes generated as indicated in fig 6. 5. At this time open your BitFaster software and to the left of the page click on Twitter Applications. Right click and select New Twitter Application. Copy all the keys generated on Twitter accordingly. Username could be that of the profile or that of the proposed application.

After populating all the fields, click Add. The new application would appear on the list of other Twitter applications, if any.

Tweeting through BitFaster

Well, we’ve seen how to create an application that lets us tweet. But how actually do we use it? It’s fairly simple. Once you know that your Twitter application ready, click on Twitter Applications in the tree view in BitFaster. You can then right click on the right window pane and choose New Twitter Application.

First we select the application or username that we wish to use and then type the message. Clicking Tweet, ensures that the post appears on the timeline immediately.

Auto Tweeting

BitFaster allows us to automate the whole process of tweeting! We can compose a series of tweets and set the exact date and time at which it needs to be posted on the twitter wall. The only 2 conditions are – One, there has to be a minimum time interval of 2 minutes between composing the message and the time set for posting it on the timeline. Two, BitFaster Live has to be kept open.

On the menu bar at the top, click on the Twitter icon. You will see the window shown below opening. Type the text that you wish to tweet and select Auto Tweet atoption before setting the date and time at which you wish the tweet to appear on your Twitter page.

BitFaster and Facebook

As of now, we do not have a mechanism to interface Facebook with BitFaster. However, the updates posted on Twitter can be shared directly on Facebook using the in-built features of Twitter. It is just a matter of time before we update this feature on BitFaster.

Configuring a local mail server for BitFaster

In our previous blogposts, help files and other relevant documents, we have spoken sufficiently on the benefits of email marketing; the benefits that BitFaster offers in terms of its user-friendly features, have also been dealt with. In this post, we seek to present briefly, the procedure to configure a local email server on your BitFaster software. This feature is of significant importance as it lets you send mails without a web browser.

As most of you would be knowing, email works on the Simple Mail Transfer Protocol (SMTP). The sequence of steps would be :

1. A sender generates the content of the mail using a Mail User Agent (MUA).

2. The MUA contacts the local mail server, which in turn contacts the destination mail server using the destination MUA as the basis. If the destination MUA is the same as that of the sender, then the mail transfer is said to be expedited locally.

3. The destination server maintains an inbox to which the mail is transferred after the destination address is verified.

4. The intended recipient gets to access his inbox on the server and is able to view the mail using the POP3 protocol.

Gaining access to the local server requires you to create a login account in it. Once you do so, you would be able to route your mails through it. However, the scenario here is slightly different; you already have access to your local server but need to tell BitFaster about it. In other words, you need to provide access to the local mail server of your organization to BitFaster so as to be able to create and run email campaigns or other general mails.

So how do we configure a local mail server with BitFaster?

1. In the tree view of your BitFaster page (on the left side), click SMTP Servers.

2. The window shown below opens up.

3. Server Name could be the name you wish to give the server. Eg, if you wish to dedicate server for email campaigns, then you could consider calling it Campaign Server.

4. Host Address would be the address of your local mail server. This invariably takes the form smtp.companyname.com. You could always contact the IT department of your organization to get details about your local email server.

5. Username and Password would be the ones provided to the company to the user (who would send out mails).

6. SMTP Port shall always be 25. This is because SMTP Servers use port number 25 on the TCP socket to expedite mail transfer from the client to server.

7. In the event of a client not being able to establish a connection with the server, then the server usually ‘times out’ or stops sending signals. The connection could be kept active for a certain duration entered in the Server Timeout field. This value is usually restricted to 20 or 30 seconds.

8. Confidential information being circulated through mail could be secured through encryption. BitFaster allows the user to choose between SSL and TSL standards of encryption.

9. If required, an active server can be deactivated by clicking the appropriate checkbox. BitFaster even allows the temporary deactivation of the server settings. The settings of one server could also be reproduced in another or even deleted completely.

If you’ve done all the above, then you are through!! You could start off with your first email right away!