Re: [U2] [AD] - U2] Uniobjects - What Is It?
U2WebLink includes our JavaScript and UniBasic API software for Universe or Unidata with the PHP connection at the price $750.00 per connection per year. UniObjects for Java is the mechanism for communicating with the databases. One connection can handle between 5 and 20 users depending on the application.. At $150.00 to $37.50 per user this is very economical and robust software. Regards, Doug www.u2logic.com "First with Eclipsed based tools for U2" On Fri, May 20, 2011 at 9:29 AM, wrote: > In a message dated 5/20/2011 7:04:01 AM Pacific Daylight Time, > dave...@gmail.com writes: > > > > [ad] > > We built a middle-ware connection using open source JavaPHP bridge after > > seeing Kevin do this hodge podge connection scheme using a COM UniObject > > at > > a CMUG meeting in Denver in 2009. Our middle-ware software is called > > U2WebLink and it manages the connections with Unidata or Universe using > > Apache Tomcat. U2WebLink comes with logging and monitor software to > > figure > > out what you web site is doing using graphs and user displayed grids. > > > > You'd might as well tell us how much. > > So how much? > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multi char delimiter in DICT item
I agree with you, John. There has been many times that I've done exactly that and exactly for the reasons you state. If the need would have been something that could have been used in other situations then I would have used a subroutine this time. This need, though, was extremely narrow in scope and by keeping it as an I-desc formula, it was totally self contained, self documented, and is not in danger of, six months from now, having the calculations modified, potentially, inadvertently, changing the net results. This group has so much deep knowledge that when I ask a question, I know that my thought processes are going to be either confirmed or expanded. Thanks to everyone for sharing your expertise. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Friday, May 20, 2011 9:01 AM To: 'U2 Users List' Subject: Re: [U2] Multi char delimiter in DICT item It is for this pain in the butt type of situation that I often call a subroutine to do my work. I understand that part of the requirement was to try to avoid this, but I have had far too many situations where the I-Desc keeps getting more and more complicated to get the job done, only to find out that in the end, I need to do it with a subroutine any way. When this happens, I try to be pro-active enough to anticipate that I will want to expand upon it later (maybe do different types of manipulations for the same data). Thus, I pass the arguments that I know I need, plus several other that I do not need at them time, but can be used in the future as other uses or flavors are needed. A complicated I-Desc can often be written as a simple subroutine. Hours have been spent going back and forth on a solution to the original thread, where 10 minute would likely have solved it by a subroutine. Also, once the subroutine is written for the I-Desc, it can ALSO be called by normal program. Imagine that. 1 piece of code that consistently returns a desired calculation throughout the system. If a change is ever needed, fix it in the one subroutine, and it is solved everywhere. Unless it is a REALLY simple I-Desc, go with a subroutine. Just my 2 cents... John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Friday, May 20, 2011 11:33 AM To: dgr...@dagconsulting.com; U2 Users List Subject: Re: [U2] Multi char delimiter in DICT item Hi David, > Bob is right. Lets enhance the FIELD function to accept a string > delimiter > and not just a single character. A nice idea but it has to be a new function because FIELD() is defined as using only the first character of the supplied delimiter. Because an enhancement such as this is unlikely to appear in time to resolve the original poster's problem, it should be possible to work around the issue by replacing all of the multi-character delimiters with some single character that would never appear in the data and then using FIELD() with this as the delimiter. I cannot remember whether Unidata supports CHANGE() in I-types. For some strange reason UniVerse does not. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multi char delimiter in DICT item
It is for this pain in the butt type of situation that I often call a subroutine to do my work. I understand that part of the requirement was to try to avoid this, but I have had far too many situations where the I-Desc keeps getting more and more complicated to get the job done, only to find out that in the end, I need to do it with a subroutine any way. When this happens, I try to be pro-active enough to anticipate that I will want to expand upon it later (maybe do different types of manipulations for the same data). Thus, I pass the arguments that I know I need, plus several other that I do not need at them time, but can be used in the future as other uses or flavors are needed. A complicated I-Desc can often be written as a simple subroutine. Hours have been spent going back and forth on a solution to the original thread, where 10 minute would likely have solved it by a subroutine. Also, once the subroutine is written for the I-Desc, it can ALSO be called by normal program. Imagine that. 1 piece of code that consistently returns a desired calculation throughout the system. If a change is ever needed, fix it in the one subroutine, and it is solved everywhere. Unless it is a REALLY simple I-Desc, go with a subroutine. Just my 2 cents... John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Friday, May 20, 2011 11:33 AM To: dgr...@dagconsulting.com; U2 Users List Subject: Re: [U2] Multi char delimiter in DICT item Hi David, > Bob is right. Lets enhance the FIELD function to accept a string > delimiter > and not just a single character. A nice idea but it has to be a new function because FIELD() is defined as using only the first character of the supplied delimiter. Because an enhancement such as this is unlikely to appear in time to resolve the original poster's problem, it should be possible to work around the issue by replacing all of the multi-character delimiters with some single character that would never appear in the data and then using FIELD() with this as the delimiter. I cannot remember whether Unidata supports CHANGE() in I-types. For some strange reason UniVerse does not. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multi char delimiter in DICT item
I'm not sure I would want a compile time error. I can think of a couple of situations where, though the use of a variable, the length of the delimiter wouldn't be known until run time. If there was a run time message when the delimiter was multi-character, and an option to suppress that message... Maybe even an option to force the first character usage like it does now... Yeah, for my money that would be my first choice. I'm just glad you folks are smarter than I am and figured out a couple of solutions that work! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, May 20, 2011 8:30 AM To: dgr...@dagconsulting.com; U2 Users List Subject: Re: [U2] Multi char delimiter in DICT item or at least gripe about it at compile time. I got bit on this one in the past because I didn't realize it was only looking at the first character. > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of David A. Green > Sent: Friday, May 20, 2011 11:23 AM > To: 'U2 Users List' > Subject: Re: [U2] Multi char delimiter in DICT item > > Bob is right. Lets enhance the FIELD function to accept a string > delimiter > and not just a single character. > > David A. Green > (480) 813-1725 > DAG Consulting > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
In a message dated 5/19/2011 9:43:16 PM Pacific Daylight Time, dmc...@imb.com.au writes: > Have you seen the PHP PDO driver article on u2devzone.com? Although it > is a 'build it yourself article', it does come with the source code so > you should be able to just compile and use it. > Head + Wall + Beating ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multi char delimiter in DICT item
Hi David, Bob is right. Lets enhance the FIELD function to accept a string delimiter and not just a single character. A nice idea but it has to be a new function because FIELD() is defined as using only the first character of the supplied delimiter. Because an enhancement such as this is unlikely to appear in time to resolve the original poster's problem, it should be possible to work around the issue by replacing all of the multi-character delimiters with some single character that would never appear in the data and then using FIELD() with this as the delimiter. I cannot remember whether Unidata supports CHANGE() in I-types. For some strange reason UniVerse does not. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multi char delimiter in DICT item
or at least gripe about it at compile time. I got bit on this one in the past because I didn't realize it was only looking at the first character. > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of David A. Green > Sent: Friday, May 20, 2011 11:23 AM > To: 'U2 Users List' > Subject: Re: [U2] Multi char delimiter in DICT item > > Bob is right. Lets enhance the FIELD function to accept a string > delimiter > and not just a single character. > > David A. Green > (480) 813-1725 > DAG Consulting > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [AD] - U2] Uniobjects - What Is It?
In a message dated 5/20/2011 7:04:01 AM Pacific Daylight Time, dave...@gmail.com writes: > [ad] > We built a middle-ware connection using open source JavaPHP bridge after > seeing Kevin do this hodge podge connection scheme using a COM UniObject > at > a CMUG meeting in Denver in 2009. Our middle-ware software is called > U2WebLink and it manages the connections with Unidata or Universe using > Apache Tomcat. U2WebLink comes with logging and monitor software to > figure > out what you web site is doing using graphs and user displayed grids. > You'd might as well tell us how much. So how much? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multi char delimiter in DICT item
Bob is right. Lets enhance the FIELD function to accept a string delimiter and not just a single character. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Woodward Sent: Thursday, May 19, 2011 11:11 AM To: U2 Users List Subject: [U2] Multi char delimiter in DICT item Hi folks, I'm in Unidata 6.1 and I'm trying to find a way to use a multi character value as a delimiter for a parsing function in an I-desc dict item. I'm working with Bartender label data records and I'm trying to parse the first line on the "/PRN=" value, without the quote marks. FIELD only lets me use a single character. What I have so far in the DICT item is: 001: I 002: F1;FIELD(@1,'PRN=',2);FIELD(@2,'"',2) 003: 004: PRN 005: 15L 006: S This works great until a capital P is in the label name before the PRN. Field is taking the first character and ignoring the RN=. I do NOT want to make a subroutine if I can avoid it. I've tried using CHANGE to swap out PRN= with a single character but apparently that's not an allowed command in the DICT items. Thanks for any help you can offer. BobW ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
[ad]
We built a middle-ware connection using open source JavaPHP bridge after
seeing Kevin do this hodge podge connection scheme using a COM UniObject at
a CMUG meeting in Denver in 2009. Our middle-ware software is called
U2WebLink and it manages the connections with Unidata or Universe using
Apache Tomcat. U2WebLink comes with logging and monitor software to figure
out what you web site is doing using graphs and user displayed grids.
You need this line of code to start:
getHttpServletRequest();
$requestedsessionid = $request->getRequestedSessionId();
$requestsession = $request->getSession();
$requestsessionid = java_values($requestsession->getId());
?>
Register your session with U2WebLink™ using our java function XLr8SharedSub:
getAttribute("XLr8SharedSub"));
?>
To call any of your previously developed UniBasic subroutines:
$args = $sharedsub->getArrayListForSubroutineArgs();
$args->add("param1");
$args->add("param2");
$args->add("param3");
$results = $sharedsub->subroutine($request, "0", "MySubroutine", $args);
$retargs = print_r(java_values($args), true);
Regards,
Doug
www.u2logic.com/php.html
[/ad]
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
Kevin,
At the time I set this up here, there was no PDO for U2 in PHP, so I
looked into the UOJ libraries. Using them requires a bridge. There is a
SourceForge project that works well. I am currently using Zend Server CE.
No cost and it does the job, in fact it optimizes the PHP code.
I build a Java class for each project and include it in a java archive
that I put in the same directory as the UOJ includes. The java object
uses Uniobjects for Java to access Unidata. Although, Uniobjects has a
rich command set, I have come to the conclusion that the Java layer should
be minimized as much as possible. I just use the java to run UniBasic
subroutines. It passes in the parameters and returns the result. This is
partly to reduce traffic, but mostly because I want to push the database
logic to the database.
It would be better if there was a PDO for U2, but this approach works.
Here is a example.
In the javascript function make a request object call to PHP on the
webserver
var XHR = GetXHR();
var urlstr = "getNextId.php";
urlstr += "?sid=" + Math.random();
XHR.onreadystatechange = function() {
if(XHR.readyState === 4) {
// Process the results in XHR.responseText
}
};
XHR.open("GET",urlstr,true);
XHR.send(null);
return;
*
In PHP create an object from the java archive for the project and call the
java function. Must be cataloged.
$cnU2 = new Java('com.ntnbower.webutil.u2ProjectName');
$cnU2->setAccount("PRODUCTION");
echo $cnU2->getNextId(); // This is returned to javascript as reponseText
return;
*
In java
public String getNextId() {
OpenU2Session();
UniSubroutine uSub = uSession.subroutine("getNextId", 1);
uSub.call();
return uSub.getArg(0);
}
**
In UniBasic. Get the requested data and return it in RESULT
SUBROUTINE getNextId(RESULT)
OPEN 'FILENAME' TO F.NSH THEN
READU R.NSH FROM F.NSH, 'NEXT_ID' THEN
RESULT = R.NSH<1>
R.NSH<1> += 1
WRITE R.NSH TO F.NSH, 'NEXT_ID'
END
CLOSE F.NSH
END ELSE
RESULT = "-1"
END
END
RETURN
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
Kevin King
Sent by: u2-users-boun...@listserver.u2ug.org
05/19/2011 11:26 PM
Please respond to U2 Users List
To: U2 Users List
cc:
Subject:Re: [U2] Uniobjects - What Is It?
I'm interested to know more about how folks are using UOJ with PHP. I've
tried making that connection numerous times but .. just haven't been
successful yet. Big fan of PHP but using the UO connection on Windows is
... less than optimal for my needs.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pondering recent thread on compact framework
Well what a conversation I think u2 has as much to do with mobile apps as sql server does. Completely divorced. As programmers we should take an interest in all sorts of technology , I don't call myself a picky i am a programmer, what language shall i use today ? For mobile dev i think the way forward for many is html5 and css3 - there are many frameworks to make compelling ui's for the phone distributed by the browser, - sencha touch, jqtouch are two great examples. I have recently used sencha for a couple of apps, one on sql server the other for some system admin functions internally. It would be no harder to sit it in front of a u2 database as it would any other, so long as you have the web services in place. As for real apps - well yes i am in the process of writing a number of apps, android and windows phone are fairly easy as they are java and .net based so that comes naturally to me. Iphone a bit harder as you need to dev on a mac (urgghh) and it is in c, and it is a while since i did any c tbh. These are just hobby projects. I will let you into a secret here - i have dealt with a number of phone app development companies recently - they were all rubbish, none of them understood enterprise technology, software release cycles etc all the stuff we live and breathe as seasoned developers. But they are all writing stupid little apps that get downloaded by thousands of kids at 50p a go. So use your enormous brains and get out there and write some apps !! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pondering recent thread on compact framework
We have started using an App called Citrix Receiver: http://www.citrix.com/English/ps2/products/product.asp?contentID=1689163 Have just started evaluating it. It seems to work well. Brett "David Jordan" wrote in message news:<6F91EB9F76538448AB0D1D84E19424D1199316A04D@DACONOSBSERVER2.daconosbs.local>... > Hi George > > I use a Windows phone 7. With a web page there is a cost of time for > downloading a web page and a performance issue with screen loading. With an > app, I conform to the user interface of the phone which are more intuitive to > a phone user. The app loads quicker and runs quicker. However if you have > users using android, blackberry, iphone, etc then you need to create a > separate app for each phone. With the new phones you need to load the app > from the marketplace which is difficult for an enterprise application. > Hence the decision to use an app vs web is related to performance and > intuitive interface vs portable and easier to load. > > Remember also that most phones have no virus protection and are a potential > risk area for Trojans and viruses for web interfaces. An app is a bit more > secure. > > Again there are other features I can use on the phone such as sending a > spreadsheet of KPIs to the phone rather than having an application to access > KPIs. There are just too many ways to skin a cat. > > David Jordan > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > This message contains information that may be privileged or confidential and is the property of GPM Development Ltd. It is intended only for the person to whom it is addressed. If you are not the intended recipient ,you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. This e-mail was sent to you by GPM Development Ltd. We are incorporated under the laws of England and Wales (company no. 2292156 and VAT registration no. 523 5622 63). Our registered office is 6th Floor, AMP House, Croydon, Surrey CR0 2LX. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pondering recent thread on compact framework
> However, with mobile apps, you would need to have a different program, or at > least end-drivers for > each type of phone - and then you need to know which phone it's going to. ... >That's what I'm looking for.what are those really good apps that have been >developed out there > that would make it worth the effort. ... > Capturing signatures or GPS data , that I see as useful, and a potential > reason for development. > I could see devloping an app that would just accept data, then using the > phones User interface make displays that would > be difficult using a > browser.but that again, it would need to be something worth the > development. We do something like that using Windows Mobile and Windows XP on UMPCs. We have a product for "in the field" workers (I don't think I can go into actual detail here) which runs in .Net / .NetCF. Given signal availability issues, though, we don't use UO directly from the device - that's handled by a service on the server listening for MSMQ responses and a RedBack web service. This is used as a proof of delivery / proof of location mechanism, and includes signature capture (although that will need to disappear with Phone 7). GPS has been discussed / tested, too as a replacement for signatures. We don't currently support Android or iOS though, which makes maintenance a little easier. This electronic message contains information from CACI International Inc or subsidiary companies, which may be confidential, proprietary, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named above. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify us immediately at postmas...@caci.co.uk Viruses: Although we have taken steps to ensure that this e-mail and attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free. CACI Limited. Registered in England & Wales. Registration No. 1649776. CACI House, Avonmore Road, London, W14 8TS. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
