What will the Salomon Smith Barney
import do
for me?
»» The Salomon Smith Barney import will import client names
and addresses, account numbers, initial
holdings, daily transactions, and
prices.
How
do I do the INITIAL IMPORT?
»» Download the necessary
file from Salomon Smith Barney
for an initial
download. Create a folder on your
C drive called "genwin2," and
create a folder within genwin2 called
"files." Save this new
file from SSB in
"C:\genwin2\files\".
»» Double-click on the
Import Program icon.
If you have used the Import
Program before, it will ask you, “Do
you want the Status Log contents
deleted?”
Click Yes twice.
»» Select Import Data from
Your Firm (Initial) and put a
checkmark by Setup Before Import.
Click OK.
»» In the Firm(s) to Import
dialog box, if there is a firm name in
the Firms box, highlight that firm name
and click Delete. Then click Add.
Choose Smith
Barney.
Click OK.
Highlight Smith Barney in Firm(s)
to Import dialog box, and click View.
»»
Click on Update Setup (wrench
icon).
In the Database Update
Configuration dialog box, put checkmarks
by Client & Account, Products, and Initial
Holdings. Also put checkmarks by the four “Update These Product
Parameters” options (Description,
Product Type, Dividend Frequency, and
Asset Class) and by the two options at
bottom (Convert Upper Case to Upper and
Lower Case and Prevent duplicate clients
by comparing the Last Name, Full Name,
and SSN Fields).
Click OK.
»»
It should default to your newly-created
C:\genwin2\files\ path, and your new
file will be called "na######.inf,"
where the number symbols are replaced by
that day's date. A "Pick Data
File to Process" dialog box pops
up, which will ask you to locate this na######.inf
file.
»»
Click OK in Initial Download
Configuration File Setup dialog box.
Click OK in the Firm(s) to
Import dialog box.
»»
Once the Initial import is complete, it
will take you to the Status Log screen
(white background).
»»
Close
out the Import Program by clicking on
the X at upper-right, or by selecting ActionsàExit.
You can now enter the main
program and confirm the success of the
Initial import.
How
do I do the DAILY IMPORT?
»»
Download the necessary file from Salomon
Smith Barney for a daily download.
»» Double-click on the
Import Program icon.
It will ask you, “Do you want
the Status Log contents deleted?”
Click Yes twice.
»» Select Import Data from
Your Firm (Daily). If you have done
Daily imports before, do NOT put a
checkmark by Setup Before Import.
Click OK, and skip
to THE IMPORT RUNS (below).
(Four
steps for first-time daily imports
ONLY.)
»»
If this is your first time doing a Daily import, put a
checkmark by Setup Before Import.
Click OK.
»»
In the Firm(s) to Import dialog box, if
there is a firm name in the Firms box,
highlight that firm name and click Delete.
Then
click Add.
Choose Smith Barney.
Click OK.
Highlight Smith Barney in Firm(s)
to Import dialog box, and click View.
»» Click
on Update Setup (wrench icon).
In the Database Update
Configuration dialog box, put checkmarks by
Price and Transaction.
Leave the checkmarks by Client
& Account, Products, and Initial
Holdings.
Also
leave the checkmarks by the four
“Update These Product Parameters”
options (Description, Product Type,
Dividend Frequency, and Asset Class) and
by the two options at bottom (Convert
Upper Case to Upper and Lower Case and
Prevent duplicate clients by comparing
the Last Name, Full Name, and SSN
Fields).
Click OK.
»» Click
OK in the Daily Download Configuration
File Setup dialog box.
Click OK in the Firm(s) to Import
dialog box.
»» THE
IMPORT RUNS:
Once the Daily import is
complete, it will take you to the Status
Log screen (white background).
»» If
there are bad transactions, the Bad
Transactions report will appear.
You can print this report by
selecting Print à Bad Transactions.
You will see what information is missing
or incorrect.
Once you correct/reconcile the
position in the main program, you can
return to the Import Program (WGIAPP).
This time, after clicking Yes
twice to delete the Status Log, click
Cancel in the Select Action to Begin
dialog box.
Select Actions à
Post Bad Transactions.
»» Close
out the Import Program by clicking on
the X at upper-right, or by selecting
ActionsàExit.
You can now enter the main
program and confirm the success of the
Daily import.
Helpful Hint for Daily import only
(NOT for Initial import)
»» The Status Log keeps
track of all activity in the Import
Program.
If there was a problem with the
Import for a particular day, this Status
Log will help the tech support staff at
North American Software resolve your
problem.
Do not delete the Status Log if
the Import for a certain day is in
question.
There may be Product Symbols that
have changed, which you will need to
adjust manually.
»» Salomon Smith Barney offers an Account
Reconciliation process, which
compares trade information between
Salomon Smith Barney’s in-house facilities and
your Helper Series data.
You can run this reconciliation
as often as you want.
To do this:
(1) Download the “SBSACCT.dat” file from Salomon Smith
Barney;
(2) Open the Import Program;
(3) Choose Account
Reconciliation, and put a checkmark by
Setup Before Import;
(4) Click Add, choose Smith
Barney,
and click OK;
(5) Click OK again to begin the
process. In front of your Status Log, the Account Reconciliation will
appear.
It will list the account name and
number, the product symbol, cusip, and
name, and the two quantities (the amount
that the Helper Series says you have,
and the amount that Salomon Smith Barney
says you
should have).
go to Helper Help index page
