About Resources Education Directory Meetings Technical Foundation

Questions about logging in

I'm entering the correct user name and password, and I see the page which says "You are now logged in." but then I'm asked to log in again.

This site uses cookies to determine whether you have logged in with a valid subscription or not. Make sure you have cookies enabled in your web browser or Internet Options. The Medium-High "privacy" setting (or a lower setting) in Microsoft Windows should allow our cookies to be set. This site has been tested to work with Microsoft Internet Explorer 6 or higher, Firefox and Safari.

About cookies

This site uses "first-party" cookies which can only be retrieved by our web server, and does not store any personally identifiable information in those cookies, so there are no privacy or identity risks involved in allowing these cookies to be set.
No credit card or financial data is stored on our web server, so there is no risk of this type of data being lost or exposed.

My account is locked out. I'm paid up. What gives?

Please call (815) 455-8240 from 8:30am to 4:00pm Central time, Monday through Friday. Have your account information ready.

Questions about subscriptions

Can I let other people use my subscription?

We expect that users will use the online Directory much like a printed directory, with some sharing within the users' company expected. All subscription usage is logged; should we determine that an account has become compromised then we will lock out that account.

I want to use the online Directory to generate mailing lists or prospect lists; can I get access to the data files?

We offer an "Enhanced" subscription which allows you to download mailing/prospect lists in .csv format. See our subscription form, and the section on Questions about downloading and using lists, below.

Questions about downloading and using lists

How do I download a mailing or prospect list?

This feature is only available with an "Enhanced" subscription. Mailing/prospect lists can be created and downloaded from the results of three different types of searches - the main criteria search, the search by U.S. State, and the search by SFSA USA Division. Users with "Enhanced" subscriptions will see a form like this:

near the top of the search results. Clicking the "Download .csv file" button will begin the downloading of a .csv file of the information you have selected. You can limit the data in the file to include companies in all countries, only those in North America, or only those in the USA. You can also elect to include contact information (names and job titles) for three different types of contact personnel - management, sales, and technical, in any combination.

When you download a .csv file, depending on your OS and web browser, a dialog box may appear asking you whether you want to save the file or open it in an application. Most of the time, you would probably want to save the file so you can refer back to it and use it to create mailing labels or prospect lists, etc.

What is a .csv file?

CSV stands for "Comma Seperated Value". It is also known as "Comma Delimited ASCII". Most office applications, such as Excel, Word, Access, Quattro Pro, etc. can import this type of file. Due to the wide variety of systems and software available, SFSA can offer only very limited help with problems that may come up when using .csv files in your software.

I can't find the .csv file I downloaded

On some systems, the files get saved with a ".php" extension after the filename and ".csv" extension - "myfile.csv.php", for example. Your software may not see the file with the ".php" extension or may not handle it correctly. To correct this rename the file, removing the ".php" extension. For example, you would rename "myfile.csv.php" to "myfile.csv".

What is the format of the .csv files?

The .csv files consist of ASCII text fields surrounded by double quotes and seperated by commas, one line per contact person or company, depending on the options you select. The first line of text in each file is a header row which identifies the data fields in the following lines. Here are some examples of .csv file contents:

A .csv file with Management and Sales contacts at all companies might look like this:

"MS","Bert","A.","Smith","Managing Director","A Foundry Company Ltd","PO Box 000","Northallerton, South Yorkshire","","S1 1AA","ENGLAND","44 111 222 3333","44 111 555 7777"
"S","Jeff","","Hammond","Director - Sales & Marketing","Joe's Castings Inc.","4321 Fluid Drive","Townsville","PA","12341","","111/222-3344","111/222-4433"
"S","William","","Hammsmith","Sales/Marketing  Manager","Good Cast Products, Inc.","PO Box 9999","Metropolis","MA","00111-9999","","777/111-0000","777/111-0001"
"MTS","Joe","","Smithamm","President","A Global Corporation","123 W Business Pkwy","Houstonville","LA","76543","","444/555-5555","444/555-5556"

Note: files with contact personnel data also include a "contacttype" field - this field identifies the type of contact. An "M" indicates that this person is the designated management contact, "S" indicates this is a sales contact, and "T" indicates a technical contact.

A .csv file with no contacts selected at companies in the USA only might look like this:

"A Foundry Inc.","100 E. South Street","Anytown","PA","12345","","111/555-3346","111/555-8269"
"B Corporation","PO Box 11111","Townsville","OR","99999-1111","","111-555-6366","111-555-6328"
"C Industries","PO Box 1234","Genericville","TX","75555-1234","","111-555-3560","111-555-3597"