FONT Q - Without having programmatic access to make any changes, wow can one force what is printed to print in all UPPERER case characters (in all caps)? [modified]
-
**NOTE:**I don't think this is technically a programming question but if it is please advise and I will re-post elsewhere. THE GOAL: The accounting software that prints checks needs to print the payee names in UPPER CASE characters only even though those names are stored (in the database the app uses) as proper case. THE LIMITATIONS and PROBLEM(s): No programmatic access to application so any solution must be done outside the application such as using an all caps only font. POSSIBLE IDEA(S): (What I have so far) 1) FONT – Use a font that auto converts all characters to their upper case equivelant. This would allow for storing in any case but printing in all caps. The problem is does such a font exists and if yes can it produce commonly used business fonts like ARIAL or courier? 2) OTHER??? NOTE: We can't just change the source data to all caps to solve this because that would result in the payee names appering in Upper case everywhere and we only need the upper case when printing checks. The name should alway be in proper case except when printing on checks. This Upper case requirement is something the bank is requiring and thats why we need to do it only for check printing. Thoughts? Suggestions?
modified on Monday, May 23, 2011 11:50 AM
How about simply changing it in the database - that doesn't require any interference with the program????
Why can't I be applicable like John? - Me, April 2011
-----
Beidh ceol, caint agus craic againn - Seán Bán Breathnach
-----
Da mihi sis crustum Etruscum cum omnibus in eo!
-----
Just because a thing is new don’t mean that it’s better - Will Rogers, September 4, 1932 -
**NOTE:**I don't think this is technically a programming question but if it is please advise and I will re-post elsewhere. THE GOAL: The accounting software that prints checks needs to print the payee names in UPPER CASE characters only even though those names are stored (in the database the app uses) as proper case. THE LIMITATIONS and PROBLEM(s): No programmatic access to application so any solution must be done outside the application such as using an all caps only font. POSSIBLE IDEA(S): (What I have so far) 1) FONT – Use a font that auto converts all characters to their upper case equivelant. This would allow for storing in any case but printing in all caps. The problem is does such a font exists and if yes can it produce commonly used business fonts like ARIAL or courier? 2) OTHER??? NOTE: We can't just change the source data to all caps to solve this because that would result in the payee names appering in Upper case everywhere and we only need the upper case when printing checks. The name should alway be in proper case except when printing on checks. This Upper case requirement is something the bank is requiring and thats why we need to do it only for check printing. Thoughts? Suggestions?
modified on Monday, May 23, 2011 11:50 AM
YSLGuru wrote:
The accounting software that prints checks needs to print the payee names in UPPER CASE characters
Is this proprietary software? If so, then why wasn't it designed to meet this need? If not, then train the users to enter data in all caps...this will most likely not work but I really can't think of another way. If you are able to get a font file that only has caps then that might work.
-- ** You don't hire a handyman to build a house, you hire a carpenter. ** Jack of all trades and master of none.
-
**NOTE:**I don't think this is technically a programming question but if it is please advise and I will re-post elsewhere. THE GOAL: The accounting software that prints checks needs to print the payee names in UPPER CASE characters only even though those names are stored (in the database the app uses) as proper case. THE LIMITATIONS and PROBLEM(s): No programmatic access to application so any solution must be done outside the application such as using an all caps only font. POSSIBLE IDEA(S): (What I have so far) 1) FONT – Use a font that auto converts all characters to their upper case equivelant. This would allow for storing in any case but printing in all caps. The problem is does such a font exists and if yes can it produce commonly used business fonts like ARIAL or courier? 2) OTHER??? NOTE: We can't just change the source data to all caps to solve this because that would result in the payee names appering in Upper case everywhere and we only need the upper case when printing checks. The name should alway be in proper case except when printing on checks. This Upper case requirement is something the bank is requiring and thats why we need to do it only for check printing. Thoughts? Suggestions?
modified on Monday, May 23, 2011 11:50 AM
Do you have access to the data in the database? Does the database support triggers? If so, simply update the data using a trigger - the no programmatic access rule doesn't make too much sense.
Forgive your enemies - it messes with their heads
My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility
-
How about simply changing it in the database - that doesn't require any interference with the program????
Why can't I be applicable like John? - Me, April 2011
-----
Beidh ceol, caint agus craic againn - Seán Bán Breathnach
-----
Da mihi sis crustum Etruscum cum omnibus in eo!
-----
Just because a thing is new don’t mean that it’s better - Will Rogers, September 4, 1932We could change the source data however that would affect all output of the payee names and that woudl then raise probelms elsewhere since the payee name is suppose to show in proper case in every case expcet for when printing the name on a check. Thansk for replying.
-
YSLGuru wrote:
The accounting software that prints checks needs to print the payee names in UPPER CASE characters
Is this proprietary software? If so, then why wasn't it designed to meet this need? If not, then train the users to enter data in all caps...this will most likely not work but I really can't think of another way. If you are able to get a font file that only has caps then that might work.
-- ** You don't hire a handyman to build a house, you hire a carpenter. ** Jack of all trades and master of none.
"Is this proprietary software? If so, then why wasn't it designed to meet this need?" Great question and one that the software vendor is highly unlikely to provide a good answer too. As for entering the data in all caps that woudl cause other problems as the name should always appear in proper case except when printing checks. Thanks for replying
-
Do you have access to the data in the database? Does the database support triggers? If so, simply update the data using a trigger - the no programmatic access rule doesn't make too much sense.
Forgive your enemies - it messes with their heads
My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility
"Do you have access to the data in the database? Does the database support triggers? If so, simply update the data using a trigger - the no programmatic access rule doesn't make too much sense." We can't change the source data because the names should always appear in proper case except when printing on a cehck and that upper case requirement is one of the bank and not our own. I am curious as to why you say the "no programmatic access rule" does not make much sense. The application is from a vendor and not something we've done in house and so any attenpt to force change it would at best violate our support agreement. Thanks for replying.
-
**NOTE:**I don't think this is technically a programming question but if it is please advise and I will re-post elsewhere. THE GOAL: The accounting software that prints checks needs to print the payee names in UPPER CASE characters only even though those names are stored (in the database the app uses) as proper case. THE LIMITATIONS and PROBLEM(s): No programmatic access to application so any solution must be done outside the application such as using an all caps only font. POSSIBLE IDEA(S): (What I have so far) 1) FONT – Use a font that auto converts all characters to their upper case equivelant. This would allow for storing in any case but printing in all caps. The problem is does such a font exists and if yes can it produce commonly used business fonts like ARIAL or courier? 2) OTHER??? NOTE: We can't just change the source data to all caps to solve this because that would result in the payee names appering in Upper case everywhere and we only need the upper case when printing checks. The name should alway be in proper case except when printing on checks. This Upper case requirement is something the bank is requiring and thats why we need to do it only for check printing. Thoughts? Suggestions?
modified on Monday, May 23, 2011 11:50 AM
Yes, all-upper fonts do exist. I recently was reading an article, it's title seemed all-upper-case, however a simple copy-paste towards one of my apps resulted in a title-cased string. And no, I don't have any such font available. :)
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
-
**NOTE:**I don't think this is technically a programming question but if it is please advise and I will re-post elsewhere. THE GOAL: The accounting software that prints checks needs to print the payee names in UPPER CASE characters only even though those names are stored (in the database the app uses) as proper case. THE LIMITATIONS and PROBLEM(s): No programmatic access to application so any solution must be done outside the application such as using an all caps only font. POSSIBLE IDEA(S): (What I have so far) 1) FONT – Use a font that auto converts all characters to their upper case equivelant. This would allow for storing in any case but printing in all caps. The problem is does such a font exists and if yes can it produce commonly used business fonts like ARIAL or courier? 2) OTHER??? NOTE: We can't just change the source data to all caps to solve this because that would result in the payee names appering in Upper case everywhere and we only need the upper case when printing checks. The name should alway be in proper case except when printing on checks. This Upper case requirement is something the bank is requiring and thats why we need to do it only for check printing. Thoughts? Suggestions?
modified on Monday, May 23, 2011 11:50 AM
I think simply changing the font is your best bet. There are lots of all-upper-case fonts. Here's[^] a link to MyFonts where you can buy one. I've simply selected "All Caps" using the tag search. Make sure you check the full character set, though, because some that look great at first may have one or two letters that aren't quite what you expect. Cheers, Drew.
-
**NOTE:**I don't think this is technically a programming question but if it is please advise and I will re-post elsewhere. THE GOAL: The accounting software that prints checks needs to print the payee names in UPPER CASE characters only even though those names are stored (in the database the app uses) as proper case. THE LIMITATIONS and PROBLEM(s): No programmatic access to application so any solution must be done outside the application such as using an all caps only font. POSSIBLE IDEA(S): (What I have so far) 1) FONT – Use a font that auto converts all characters to their upper case equivelant. This would allow for storing in any case but printing in all caps. The problem is does such a font exists and if yes can it produce commonly used business fonts like ARIAL or courier? 2) OTHER??? NOTE: We can't just change the source data to all caps to solve this because that would result in the payee names appering in Upper case everywhere and we only need the upper case when printing checks. The name should alway be in proper case except when printing on checks. This Upper case requirement is something the bank is requiring and thats why we need to do it only for check printing. Thoughts? Suggestions?
modified on Monday, May 23, 2011 11:50 AM
YSLGuru wrote:
NOTE: We can't just change the source data to all caps to solve this because that would result in the payee names appering in Upper case everywhere and we only need the upper case when printing checks. The name should alway be in proper case except when printing on checks. This Upper case requirement is something the bank is requiring and thats why we need to do it only for check printing.
Run a SQL profile to see how the app is pulling the data out from the database, if your lucky its using a Stored Proceedure or View that is not shared with anything else. Modify that object to return UPPER().
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
-
YSLGuru wrote:
NOTE: We can't just change the source data to all caps to solve this because that would result in the payee names appering in Upper case everywhere and we only need the upper case when printing checks. The name should alway be in proper case except when printing on checks. This Upper case requirement is something the bank is requiring and thats why we need to do it only for check printing.
Run a SQL profile to see how the app is pulling the data out from the database, if your lucky its using a Stored Proceedure or View that is not shared with anything else. Modify that object to return UPPER().
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
-
I think simply changing the font is your best bet. There are lots of all-upper-case fonts. Here's[^] a link to MyFonts where you can buy one. I've simply selected "All Caps" using the tag search. Make sure you check the full character set, though, because some that look great at first may have one or two letters that aren't quite what you expect. Cheers, Drew.
I think so to but I wanted to solicit input in case I had no thought of another option and more importantly to get susggestions on where to fiund a font likie this. I ahev contacted the poeple at the site you recomeneded. Now I just hope they have a font like this that prints like ARIAL or COURIER NEW and my problems are solved. Thanks
-
I think so to but I wanted to solicit input in case I had no thought of another option and more importantly to get susggestions on where to fiund a font likie this. I ahev contacted the poeple at the site you recomeneded. Now I just hope they have a font like this that prints like ARIAL or COURIER NEW and my problems are solved. Thanks
-
**NOTE:**I don't think this is technically a programming question but if it is please advise and I will re-post elsewhere. THE GOAL: The accounting software that prints checks needs to print the payee names in UPPER CASE characters only even though those names are stored (in the database the app uses) as proper case. THE LIMITATIONS and PROBLEM(s): No programmatic access to application so any solution must be done outside the application such as using an all caps only font. POSSIBLE IDEA(S): (What I have so far) 1) FONT – Use a font that auto converts all characters to their upper case equivelant. This would allow for storing in any case but printing in all caps. The problem is does such a font exists and if yes can it produce commonly used business fonts like ARIAL or courier? 2) OTHER??? NOTE: We can't just change the source data to all caps to solve this because that would result in the payee names appering in Upper case everywhere and we only need the upper case when printing checks. The name should alway be in proper case except when printing on checks. This Upper case requirement is something the bank is requiring and thats why we need to do it only for check printing. Thoughts? Suggestions?
modified on Monday, May 23, 2011 11:50 AM
-
YSLGuru wrote:
Thoughts?
Examine the requirement itself. What drives the need that the checks must be upper case?
-
jschell wrote:
Examine the requirement itself.
What drives the need that the checks must be upper case?The Bank that manages the acct(s) that the checks are written from requires all Caps for the Payee name.
YSLGuru wrote:
The Bank that manages the acct(s) that the checks are written from requires all Caps for the Payee name.
Then presumably they have access to their code and should easily be able to modify it to force payee to upper case.
Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” I wouldn't let CG touch my Abacus! When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.
-
YSLGuru wrote:
The Bank that manages the acct(s) that the checks are written from requires all Caps for the Payee name.
Then presumably they have access to their code and should easily be able to modify it to force payee to upper case.
Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” I wouldn't let CG touch my Abacus! When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.
Henry Minute wrote:
Then presumably they have access to their code and should easily be able to modify it to force payee to upper case.
If by "they" you mean the Bank then no they don't have that kind of access. We use an accounting software application to manage financials with and we deal with hundreads of banks, each with 1 or more acounts. One of thes banks is saying the Payee Name must be in all caps if we are going to sue a certain feature th ebank offers. Not every bank we deal wioth has this All Caps requirement. As far as the sofwtare vendor making teh change, that woudl be an expensive change at best assuminmg they'd consider it. Hopefully the custom font will work out. Thanks
-
**NOTE:**I don't think this is technically a programming question but if it is please advise and I will re-post elsewhere. THE GOAL: The accounting software that prints checks needs to print the payee names in UPPER CASE characters only even though those names are stored (in the database the app uses) as proper case. THE LIMITATIONS and PROBLEM(s): No programmatic access to application so any solution must be done outside the application such as using an all caps only font. POSSIBLE IDEA(S): (What I have so far) 1) FONT – Use a font that auto converts all characters to their upper case equivelant. This would allow for storing in any case but printing in all caps. The problem is does such a font exists and if yes can it produce commonly used business fonts like ARIAL or courier? 2) OTHER??? NOTE: We can't just change the source data to all caps to solve this because that would result in the payee names appering in Upper case everywhere and we only need the upper case when printing checks. The name should alway be in proper case except when printing on checks. This Upper case requirement is something the bank is requiring and thats why we need to do it only for check printing. Thoughts? Suggestions?
modified on Monday, May 23, 2011 11:50 AM
Use a different daisy wheel. Use
set term/perm/nolowercaseon the printer. Well, those used to work. :~ I think you should contact the vendor and see whether or not there's a built-in way to do that. -
**NOTE:**I don't think this is technically a programming question but if it is please advise and I will re-post elsewhere. THE GOAL: The accounting software that prints checks needs to print the payee names in UPPER CASE characters only even though those names are stored (in the database the app uses) as proper case. THE LIMITATIONS and PROBLEM(s): No programmatic access to application so any solution must be done outside the application such as using an all caps only font. POSSIBLE IDEA(S): (What I have so far) 1) FONT – Use a font that auto converts all characters to their upper case equivelant. This would allow for storing in any case but printing in all caps. The problem is does such a font exists and if yes can it produce commonly used business fonts like ARIAL or courier? 2) OTHER??? NOTE: We can't just change the source data to all caps to solve this because that would result in the payee names appering in Upper case everywhere and we only need the upper case when printing checks. The name should alway be in proper case except when printing on checks. This Upper case requirement is something the bank is requiring and thats why we need to do it only for check printing. Thoughts? Suggestions?
modified on Monday, May 23, 2011 11:50 AM