Hello Everyone,
We are using PC+ v9. It has just been brought to my attention that our personal profiles & family profiles have names entered that have a mixture of poor capitialization. We have everthing from all caps to all lower case spelling in the data base. Is there a solution other than to manually correct the entries, one by one?
If there is no solution within PC+, can I export the database & use some other tool such as Excel or word to correct the problem & then import the data back to PC+?
I am hoping that someone can show me how to do this thru the data manager or can the PC+ support (conversion) staff "work" my data for a fee?
If someone knows how to do it using the data mgr. would you give me instructions? I am not knowledgable about the data manager!!
Thanks,
Tom
Proper Capitalization of Names
Moderators: Moderators, Tech Support
-
SBCTrustee
- Posts: 99
- Joined: Sun Aug 22, 2004 3:52 pm
- Location: Second Baptist Church
- Contact:
I don't believe there'st an easy way of doing this programmatically from within PC+, even using the data manager. Of course, the guys and gals at PowerChurch may have some tricks up their sleeves.
Again, it all boils down to training, training, training. Anyone who uses PC+ within our church is taught that the use of all CAPS is 'SHOUTING' the person's name and address. We basically say, enter the date the way you would write their name, with a captial at the beginning, and lower case through the word.
It didn't take that long to get everyone trained, and on board.
Again, it all boils down to training, training, training. Anyone who uses PC+ within our church is taught that the use of all CAPS is 'SHOUTING' the person's name and address. We basically say, enter the date the way you would write their name, with a captial at the beginning, and lower case through the word.
It didn't take that long to get everyone trained, and on board.
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.
Just spoke to Tech Support re this issue. Here is what they suggest. Works great. Of course, if you don't feel comfortable performing these steps, contact Tech Support.
Now at the onset, this may seem like a lot but its really quite simple. Just follow the steps as they are. It's sort of like programming a remote control for different TVs. Once you do it once, you'll become an instant PRO. It's that simple.
1. Perform a "FULL" backup.
2. Perform another "FULL" backup to a different location.
Really.
3. Navigate to the Database Manager under Utilities.
NOTE: Run the following commands on the Family List (filename - MA) and the Personal Profile List (filename - ME). So you'll run these commands twice.
4. In the small window appearing at the bottom right of your screen type the following command(s) exactly as they appear below:
command:
a. For the family mailist list you'll type: use ma
b. For the personal profiles you'll type: use me
This will open each of the files for manipulation. Please note that once you're completed with all steps below on the ma file, you would then need to start again at step 4 with the me file.
5. Now press <ENTER> or click the Run Command button. The command will/should disappear.
6. Now you need to determine which fields in this file to apply the changes to. So type one of the following commands to either list the fields on the screen or to print the list of fields from your printer.
command:
list stru
or
list stru to print
I suggest using the second command and printing this information for use the next time you'll need to perform this type of cleanup.
7. Once you identify your list of fields to change, you'll have to run the following command on each of the TEXT fields you wish to convert to UPPER, lower, or Proper case.
command:
replace all field_name with proper(field_name)
Here is an actual example: replace all alt_city with proper(alt_city)
8. Press <ENTER> or click the Run Command button.
9. NOW guess what! Yes, repeat steps 4 - 8 using the me file.
10. When you're all completed, click Exit on the database manager window to return to Power Church.
11. Perform another "FULL" backup.
12. Verify your changes took place.
One final NOTE: If you want to convert to all UPPER or lower case, you simply replace the word proper with either upper or lower.
Now at the onset, this may seem like a lot but its really quite simple. Just follow the steps as they are. It's sort of like programming a remote control for different TVs. Once you do it once, you'll become an instant PRO. It's that simple.
1. Perform a "FULL" backup.
2. Perform another "FULL" backup to a different location.
Really.3. Navigate to the Database Manager under Utilities.
NOTE: Run the following commands on the Family List (filename - MA) and the Personal Profile List (filename - ME). So you'll run these commands twice.
4. In the small window appearing at the bottom right of your screen type the following command(s) exactly as they appear below:
command:
a. For the family mailist list you'll type: use ma
b. For the personal profiles you'll type: use me
This will open each of the files for manipulation. Please note that once you're completed with all steps below on the ma file, you would then need to start again at step 4 with the me file.
5. Now press <ENTER> or click the Run Command button. The command will/should disappear.
6. Now you need to determine which fields in this file to apply the changes to. So type one of the following commands to either list the fields on the screen or to print the list of fields from your printer.
command:
list stru
or
list stru to print
I suggest using the second command and printing this information for use the next time you'll need to perform this type of cleanup.
7. Once you identify your list of fields to change, you'll have to run the following command on each of the TEXT fields you wish to convert to UPPER, lower, or Proper case.
command:
replace all field_name with proper(field_name)
Here is an actual example: replace all alt_city with proper(alt_city)
8. Press <ENTER> or click the Run Command button.
9. NOW guess what! Yes, repeat steps 4 - 8 using the me file.
10. When you're all completed, click Exit on the database manager window to return to Power Church.
11. Perform another "FULL" backup.
12. Verify your changes took place.
One final NOTE: If you want to convert to all UPPER or lower case, you simply replace the word proper with either upper or lower.