[DB2000_user_group] Missing Cell Phone Numbers - After DB2000 Update

[John R. Bradley]

The data was lost because the cell phone field became a field stored on the
national database.
Unfortunately, the data was lost because when an import was done, the
records at HQ didn't have any valid cell phone data and therefore your
records were overlaid.
The following procedure will restore your data and make sure that HQ has it.

1. Open the target database and make sure all tags are cleared.
            Menu "File\Clear all tags"
2. Open the most recent backup database that contains the cell phone data.
            Menu "File\Open Backup Database"
3. Clear all tags and then tag every record that contains cell phone data.
            In Comm grid click the "CA" button.
            Highlight the "Cellphone" column and click the "C2T" button.
4. From the main screen menu select "File \ Copy Tagged Records to Another
DB"
5. From the resulting dialog screen select:
            a. The database to copy to, the primary database.
            b. Copy Options to "Overwrite existing"
            c. Click the "Copy" button
            d. After transfer click the "Close" button
6. Open the primary database
            "File\ Restore Primary"
7. Check that the records were copied and are tagged. They already should
be.
8. From the main screen menu select "Export \ Roster \ Review/Send Current
Changes"
9. Send the cell phone data to HQ. From the Upload grid:
            a. Click the "AT" button to add tagged records.
            b. Upload the data to HQ.
10. Update the database to restore any recent changes in the BDU. 


-----Original Message-----
From: db2000_user_group-bounces at usps.org
[mailto:db2000_user_group-bounces at usps.org] On Behalf Of RHolub
Sent: Monday, February 23, 2009 10:41 PM
To: Lawrence E. Inguagiato, Jr.; db2000_user_group at usps.org
Subject: Re: [DB2000_user_group] Missing Cell Phone Numbers - After DB2000
Update

Hi,

No, I did not take out the data. Their are very few cell phone numbers in
the data base. Most squadrons have not put them in. In the case before, he
did not realize that most of the cell phone numbers were ever put in. My
cell number has switched over every time I update my squadron and district
data.

Bob Holub
C/C Aide to the NEXO
rholub at optonline.net

-----Original Message-----
From: db2000_user_group-bounces at usps.org
[mailto:db2000_user_group-bounces at usps.org]On Behalf Of Lawrence E.
Inguagiato, Jr.
Sent: Monday, February 23, 2009 10:10 PM
To: db2000_user_group at usps.org
Subject: [DB2000_user_group] Missing Cell Phone Numbers - After DB2000
Update


Hi

How did the DB2000 administrators handle the conversion when "Cell
Phone" numbers began to be stored on the national database in lieu of
just being stored on an individuals database?  I believe when I
undated to version 9.4.0 from a previous version and downloaded a new
roster file (prior to uploading my database), the download over wrote
my cell phone numbers with null data.  Is this a likely scenario?  I
do not remember seeing any instructions to first upload the user
database after the new install - but I can't be certain of that.

Please confirm whether I will have to reenter the cell phone numbers
for our squadron members?


Thanks
Larry Inguagiato

inguagiato at earthlink.net
LEI Cell:  419.819.0484
MKI Cell: 419.509.8521








_______________________________________________
DB2000_user_group mailing list
DB2000_user_group at usps.org
http://www.usps.org/mailman/listinfo/db2000_user_group

_______________________________________________
DB2000_user_group mailing list
DB2000_user_group at usps.org
http://www.usps.org/mailman/listinfo/db2000_user_group