What
will the UBS/PaineWebber import do for
me?
»» The UBSPW 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 UBSPW for an initial download.
»»
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
PaineWebber.
Click OK.
Highlight PaineWebber 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,
Account/Balance, Products, Price, 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.
»»
Click OK in Initial Download
Configuration File Setup dialog box.
Click OK in the Firm(s) to
Import dialog box.
»»
In the PaineWebber Initial Download File
dialog box, select the drive and
directory where the UBSPW download file
was saved.
Once the correct path is chosen,
click OK.
»»
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 UBSPW
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, click OK, and skip to
THE IMPORT RUNS (below).
(The following four steps are only
necessary during your FIRST time doing
the daily download.)
»»
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 PaineWebber.
Click OK.
Highlight PaineWebber in Firm(s)
to Import dialog box, and click View.
»»
Click
on Update Setup (wrench icon).
In the Database Update
Configuration dialog box, remove the
checkmark from Client & Account, and
leave the checkmarks by Account/Balance,
Products, Price, and Initial Holdings.
(Note: the option to Prevent
duplicate clients will be greyed out.)
Leave the checkmarks by the four
“Update These Product Parameters”
options (Description, Product Type,
Dividend Frequency, and Asset Class). Click OK.
»»
Click
OK in the Daily Download Configuration
File Setup dialog box.
Click OK in the Firm(s) to Import
dialog box.
»»
In
the PaineWebber Daily Download File
dialog box, select the drive and
directory where the UBSPW download file
was saved.
Once the correct path is chosen,
click OK.
»»
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
Hints 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.
We
recommend that you do NOT put a
checkmark by “Clients &
Accounts” in the Database Update
Configuration dialog box.
If you follow our recommendation,
you will need to manually enter new
Client & Account records.
If you have forgotten to enter
the new Client & Account
information, the Bad Transactions report
and the “Post Bad Transactions”
option will assist you in fixing the
problem.
If you have put a checkmark by “Clients & Accounts” in
the Database Update Configuration dialog
box, you will get new Client &
Account records.
However, if you have made any
address or phone number changes in the
UBSPW system, you will duplicate all
Client & Account records.
You will have to delete these
duplicate records manually.
go to Helper Help index page
