Tuesday, April 19, 2011

Streamserve: Utilizing Its Strengths

One of my favorite things about being a Streamserve Consultant is sometimes I get to do short, high-value projects. Most often, these mini-projects—which take less than a day to complete—involve implementing a formatting remedy for the sloppiness of the earlier design work. So aside from being able to fix these issues from the comfort of my office chair, the greatest aspect is the high customer satisfaction achieved.

The one I just finished is a prime example. Using a function in the PageOut, I concatenated multiple lines pulled from a StreamIN input which comprised the Terms and Conditions text. Then when it is output in an field configured as "Auto-wrap", it looks like someone typed it in using Microsoft Word rather than piped it in from a legacy ERP. That was how it looked before because basically the implementer pulled it in a pushed it out "as-is". Here's the short StreamServe scripting statement I used to make it look professional:
$t_and_c_fmt = subStrRepl($t_and_c, HexStr("<0A>"), " ");

I set the variable $t_and_c_fmt up and suppressed the output of the one which had been pulled in ($t_and_c). The subStrRepl function substitutes a space for newline characters. And that is pretty much all it takes, other than resizing the box correctly which was another part of the request.

In the midst of this project, I was asked a common question by the client. "Should we change the formatting of the text as we are sending it?" My answer was emphatically negative. Always use StreamServe for what it does best! You paid for it, and chances are that at least one person in upper management groaned at the price tag. Must people don't use StreamServe for even one fourth of what it is capable of doing. A good example of that will probably be my next project which involves Streamserve SMS implementation. You did know Streamserve did text messages, didn't you?

Contact us for all your StreamServe Consulting needs.
Email: paul.fry@flexresourcing.com
Phone: 216-496-9915

Monday, February 07, 2011

Point of Sale Systems Integration

I've often wanted to do systems integration work on Point of Sale (POS) systems and I've finally been given a chance on a short term project. A common POS system used by a bistro chain needs to be wired for a third-party program and, since the system is Progress-based, I was chosen to do the work.

So far there have been a number of challenges appear, but nothing entirely prohibitive. The POS uses Progress's cheapest product available, Personal Database, which is the bare-bones Progress run-time engine. This product alone doesn't allow compilation of normal Progress 4GL code, a development license is required to do that. I don't have a version 9 license, but fortunately there is a "trick" which I'll explain.

You can use a Run-time version of the prowin32.exe executable to compile code encrypted using Progress's source encryption program. This program is not probably not going to be included in a Progress Personal Database install, so you are going to have to find it somewhere else. I have it as a holder of a Progress OpenEdge OE Studio 10.0A license, so that's how I get stuff to compile. The logic hasn't changed between versions 9 and 10 and has never been altered since its inception as far as I know.

This is 100% legal in terms of Progress licensing and has been used as a backdoor for developers since I learned it back in 1994 using Progress RDBMS Version 6. It even works across platforms, and a file encrypted on a Windows PC will compile on an AIX, Linux or other Unix system with a run-time version of the Progress executable (_progres). Just remember that wherever you encrypt your code, the ensuing file is binary so you don't want to use ASCII mode when transferring it using FTP. That's usually trouble-shooting tip #1 in my experience when the code won't compile.

If you would like to know more about how to accomplish POS system integration with Progress when source is not available, please contact us for a quote. We can handle all your Progress DBA and Progress Programming needs.
Email: paul.fry@flexresourcing.com
Phone: 216-496-9915

Monday, January 17, 2011

Some thoughts on Local Splash

If you are dying to know what Local Splash is all about, start a company and create a website for it. They will have one of their telemarketers call you within hours. They have called me about 5 times in the last month peddling a subscription SEO service which is pricier than most, and most likely no better than the garden variety one-time optimizers with much humbler operations.

Most of the calls I received from their Orange County HQ number, 949-436-7240, went dead when I answered, obviously owing to an efficient predictive dialer. This is somewhat annoying to most people, and was even more annoying to me after I heard their pitch--I'll explain why further on. I did pick up two of the calls before the robot shunned me for the next company in line, and that was good since it gave me a chance to get a feel for the face of the company and their strategy.

Both agents began their spiel with flattery which, though judging by their success must work on the newbies, the web-initiated will recognize immediately as nonsensical. The first agent, an older-sounding gentleman, informed me that when he "googled" my company that it came up on the second page. He congratulated me for this amazing feat. I asked him what search terms he used and he told me "I said I googled your company, sir." Uhhh... no, actually if you search for Flexible Resourcing it comes up as the first entry just like if you "google" a much bigger company like United Airlines. But that is not the point of SEO, is it? The man should be trying to sell me the trick of having my company at the top of the list for cleveland ohio computer services just like United comes up on the first page for "airlines". But as I started to ask him about what search terms he would suggest he was already trying to get me to commit with a credit card number. The call ended soon afterward.

This morning I received another call from a younger denizen of the call-center. He had a much groovier style and after announcing that he was from Local Splash, a Google Partner, he immediately confessed that the reason for his call was that my company was one of the "more relevant companies out there." Relevant to what? Please. I was born at night, but I wasn't born last night.

This second call ended even more abruptly, and one of the reasons is that I was eager to put up this post. Both callers claimed to have checked out my website, but how could they have had the time? A predictive dialer connects an agent to a cold prospect within a matter of seconds, and although it's possible that they know I have a website, the detailed knowledge of its contents insinuated by the telemarketer seems to me to be feigned. So now if I do receive another call from one of them who claims to have visited, I'll ask them what they think of my post about their company's marketing strategy.

If you want to know more about Local Splash, just google them. Their website comes up on the first page!

Or, if you are less than amused by Local Splash's marketing tactics, you can report them to Google here to attempt to get their partnership revoked.

UPDATE: After receiving 3 or 4 more robocalls, I finally called the corporate office and talked to someone who doesn't have a call quota. He explained that I should never have been contacted in this manner and promised to have my name removed from the cold-call predictive dialing machine. I told him that it might be a good idea to have the marketers use a different name than Local Splash to avoid stains on the company's reputation. He agreed and even said that he had suggested that to upper management in the past. It was an interesting conversation, and I have stopped getting the calls.