Re: [U2] New Rocket U2 website!
Looks good and well organised A new addition to the Rocket U2 team, I see! Totally RAD! :) http://u2.rocketsoftware.com/images/minihome/sbxa/sbxa_rad.png The learn more icons the rolling animation are all a bit too large...and the text in the footer section too small...but looks good - nice and clean look. But those big parts are perfect for us U2 old timers with our multi-focal specs anyways! :0 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, 26 October 2012 2:52 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] New Rocket U2 website! why are you using that odd mask? http://u2.rocketsoftware.com/ -Original Message- From: Daniel McGrath dmcgr...@rocketsoftware.com To: U2 Users List (u2-users@listserver.u2ug.org) u2-users@listserver.u2ug.org Sent: Thu, Oct 25, 2012 1:59 pm Subject: [U2] New Rocket U2 website! For anyone who wants to check it out, we have launched a new website today: http://goo.gl/ON5qL Let's know what you think! Cheers, Dan ___ 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 ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [BDT] A giant leap forward
Yes, it is a vastly improved beast over earlier versions. Like others, I not a fan of the timeout of the UniObject session. BDT has features the competition has yet to add. I especially like being able to expand the inserts and see the BASIC Labels easily accessible. I still haven't been to get to SSH to our hosts, but I have never had the time to dig in the whys, etc. It is still worthwhile looking at U2Logic XLR8Editor and Brian Leach's freeware Windows thick-client MVDeveloper. I don't use any of these tools myself (occasionally fire up BDT)... but have trialled an early version of XLR8Editor...and trialled MVDeveloper. www.u2logic.com/tools.html (the links to download the documentation seem to have gone AWOL) http://www.brianleach.co.uk/pages/mvdeveloper.htm Each has unique features which means you choose the one the suits your needs. Or use all of them! I'm not a big fan of Eclipsed based products. I loathe the wealth of non-functional menus, menu-items that they all seem to have. Its weird shoving your specific tool into some else's generic tool framework. In general dedicated software tool vendors tend to much more responsive to feedback and bug fixes, etc. They have a short lead time / development cycle so are able to be more 'agile'. For us 'dabblers', this isn't such a big thing. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Thursday, 25 October 2012 9:17 AM To: U2 Users List Subject: Re: [U2] [BDT] A giant leap forward Thank you, it's always great to hear when we've hit the mark. I've sent this off to the team members responsible. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, October 24, 2012 3:55 PM To: u2-users@listserver.u2ug.org Subject: [U2] [BDT] A giant leap forward I would like to *commend*, yes commend, the developers of the Basic Developers Toolkit for recent changes. In particular, the ability to *install updates* from within the Eclipse package. In conjunction with the *detailed release notes* highlighting changes in each version, for example July's here: http://updates.rocketsoftware.com/u2/July2012_ReleaseNotes.htm It's quite useful to be able to read the release notes and try out the fixed features ___ 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 ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [BDT] A giant leap forward
Hi Dan: XLr8Editor has a code completion piece that reads all of your code in your local work space and indexes it. So, if you cannot remember a local include does you just start typing and hit control space. The XLr8Editor then brings up those variables matching what you have already typed. This is very helpful when trying to remember what you called dynamic array position in the include. Additionally, both BDT and XLr8Editor support hitting the function key F3 when you are on the include to open it a separate tab. I find this more helpful when I have an include that is more than 10 lines long. Regards, Doug www.u2logic.com/tools.html XLr8Tools for the discerning programmer On Fri, Oct 26, 2012 at 3:17 AM, Hona, David david.h...@cba.com.au wrote: Yes, it is a vastly improved beast over earlier versions. Like others, I not a fan of the timeout of the UniObject session. BDT has features the competition has yet to add. I especially like being able to expand the inserts and see the BASIC Labels easily accessible. I still haven't been to get to SSH to our hosts, but I have never had the time to dig in the whys, etc. It is still worthwhile looking at U2Logic XLR8Editor and Brian Leach's freeware Windows thick-client MVDeveloper. I don't use any of these tools myself (occasionally fire up BDT)... but have trialled an early version of XLR8Editor...and trialled MVDeveloper. www.u2logic.com/tools.html (the links to download the documentation seem to have gone AWOL) http://www.brianleach.co.uk/pages/mvdeveloper.htm Each has unique features which means you choose the one the suits your needs. Or use all of them! I'm not a big fan of Eclipsed based products. I loathe the wealth of non-functional menus, menu-items that they all seem to have. Its weird shoving your specific tool into some else's generic tool framework. In general dedicated software tool vendors tend to much more responsive to feedback and bug fixes, etc. They have a short lead time / development cycle so are able to be more 'agile'. For us 'dabblers', this isn't such a big thing. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Thursday, 25 October 2012 9:17 AM To: U2 Users List Subject: Re: [U2] [BDT] A giant leap forward Thank you, it's always great to hear when we've hit the mark. I've sent this off to the team members responsible. Regards, Dan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] New Rocket U2 website!
NICE! Fairly intuitive, I can get the info I want quickly, it is visually pleasing w/o being overwhelming, etc. Well done. Just a thought: should there be a link at the bottom for the U2UG? It is not part of Rocket, but I think it makes sense. Maybe the U2 link at Linkedin too. John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Thursday, October 25, 2012 4:59 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] New Rocket U2 website! For anyone who wants to check it out, we have launched a new website today: http://goo.gl/ON5qL Let's know what you think! Cheers, Dan ___ 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] New Rocket U2 website!
I posted to twitter first where I'm set up to use the Google's link shortener. Just happened to be what was in my clipboard buffer. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, October 25, 2012 9:52 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] New Rocket U2 website! why are you using that odd mask? http://u2.rocketsoftware.com/ -Original Message- From: Daniel McGrath dmcgr...@rocketsoftware.com To: U2 Users List (u2-users@listserver.u2ug.org) u2-users@listserver.u2ug.org Sent: Thu, Oct 25, 2012 1:59 pm Subject: [U2] New Rocket U2 website! For anyone who wants to check it out, we have launched a new website today: http://goo.gl/ON5qL Let's know what you think! Cheers, Dan ___ 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
[U2] Unidebugger
Hi U2 geniuses. Can anyone help me get the full picture of unidebugger? I thought it was part of wintegrate, but maybe not. I saw something indicating that it will be replaced by bdt - is that just on universe? What is unidebugger, how is it used and is it going away? TIA! Susan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidebugger
It is/was a windows based (thick client) editor for UniData and UniVerse. It has a number of standard editor features like syntax highlighting etc. It is/was included on the clients package. It integrated with dynamic connect which allowed a telnet window in your editor screen. It could use direct disk access, ftp, or UniObjects connections to edit source code. Using UniObjects gave the benefit of locking any items you were editing as well allowing you to debug programs. It allows you to step through programs and watch variables. It's a little flakey when debugging but otherwise works well. I'm pretty sure it's been deprecated in favour of the new BDT editor. hth Colin -Original Message- From: Susan Joslyn Sent: October 26, 2012 9:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidebugger Hi U2 geniuses. Can anyone help me get the full picture of unidebugger? I thought it was part of wintegrate, but maybe not. I saw something indicating that it will be replaced by bdt - is that just on universe? What is unidebugger, how is it used and is it going away? TIA! Susan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UPLOAD not DOWNLOAD
Does anyone have a robust ETL routine for loading data *into* Universe (not out from it). Something like Cedarville's DOWNLOAD but in reverse ? Before I roll my own. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UPLOAD not DOWNLOAD
From: Wjhonson Does anyone have a robust ETL routine for loading data *into* Universe (not out from it). Something like Cedarville's DOWNLOAD but in reverse ? Before I roll my own. A solution starts with a good definition of a problem - and that means something a little more specific than data. Are you looking for a general purpose import from SQL Server? Oracle? MySQL? CSV? Outlook? Excel? A web service? Your cell phone contacts? I've written import/export routines for all of these and more. But they're all a little different. What's common is that I pull the data from a source into a middle tier and then push the data to whatever the target is. That's your ETL concept. Most people think of data movement to/from MV in terms of direct access between environments, the Extraction and Loading part with little consideration for Transformation. To me, the U2 box is just one end of the equation, it's not the middle tier. The U2 side of things uses just grunt code or dict items that any of us here can write. The only thing new about any such ETL project is the other side, which just requires some knowledge about how to integrate with whatever that other side is. Once someone internalizes that, the rest is fairly easy with Any remote endpoint - and most of these how do I ETL with 'ProductX' questions become unnecessary. You probably also want to clarify that you want something free. There are commercial offerings from FusionWare, BlueFinity, and others. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms/about ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UPLOAD not DOWNLOAD
The nature Tony of code 8sharing8 between users of this group, is Free. I share my code, others share their code. No one puts everything they've written on pickwiki So it's entirely possible someone has written a general purpose ETL to go into Universe I'm confused about your mention of Dict items because I don't see how you use Dict items for Uploading. I see how you use them for Downloading. Maybe you could give an example of why you would read the Dict for an upload. -Original Message- From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Oct 26, 2012 4:13 pm Subject: Re: [U2] UPLOAD not DOWNLOAD From: Wjhonson Does anyone have a robust ETL routine for loading data *into* Universe (not out from it). Something like Cedarville's DOWNLOAD but in reverse ? Before I roll my own. A solution starts with a good definition of a problem - and that means something a little more specific than data. Are you looking for a general purpose import from SQL Server? Oracle? MySQL? CSV? Outlook? Excel? A web service? Your cell phone contacts? I've written import/export routines for all of these and more. But they're all a little different. What's common is that I pull the data from a source into a middle tier and then push the data to whatever the target is. That's your ETL concept. Most people think of data movement to/from MV in terms of direct access between environments, the Extraction and Loading part with little consideration for Transformation. To me, the U2 box is just one end of the equation, it's not the middle tier. The U2 side of things uses just grunt code or dict items that any of us here can write. The only thing new about any such ETL project is the other side, which just requires some knowledge about how to integrate with whatever that other side is. Once someone internalizes that, the rest is fairly easy with Any remote endpoint - and most of these how do I ETL with 'ProductX' questions become unnecessary. You probably also want to clarify that you want something free. There are commercial offerings from FusionWare, BlueFinity, and others. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms/about ___ 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] UPLOAD not DOWNLOAD
From: Tony Gravagno
...To me, the U2 box is just one end of the equation,
it's not the middle tier. The U2 side of things uses just grunt
code or
dict items that any of us here can write.
From: Wjhonson
The nature Tony of code 8sharing8 between users of this group, is
Free.
I share my code, others share their code.
No one puts everything they've written on pickwiki So it's entirely
possible someone has written a general purpose ETL to go into
Universe
I'm confused about your mention of Dict items because I don't see
how you use Dict items for Uploading. I see how you use them for
Downloading. Maybe you could give an example of why you would
read the Dict for an upload.
In a public forum we discuss options. That doesn't necessarily mean
you're going to get a complete solution, or a completely free one. The
irony of your inquiries is that even when people give you complete and
completely free solutions, you tend to argue with them and change the
scope of the request. So my approach with you is simply to provide a
fishing line and point to where the fishing is good, and leave it to
you to catch your own fish. We've discussed this many times over the
years...
Anyway, to answer your question, depending on what the remote source
is you can use local dict items as a schema for validating data. Part
of the ETL process often involves data validation and/or cleansing. In
a homegrown solution you can provide the exact same data that is
required for a relational database, the table, key, and field names,
and loop to process inbound data. For a simple solution just read the
dict items, get the attribute number, and you now know where to put
the data. The point here is that the external interface doesn't need
to know that the CustomerName data is in attribute 2, it just
provides a column name and the data and your code works out where it
goes.
Since you asked, I'll also hop into my salesman shoes with an [AD]:
mv.NET includes a feature called Solution Objects where strongly typed
class libraries (DAL and BAL) are generated using U2 file
dictionaries. If the ETL code is abstracted to a middle tier, you can
use a class like this to load your data using simple object instances:
var sourceData = GetDataFromWherever(mySpecs);
for(var rnum =0; rnum+=1; rnumsourceData.Count) {
var source = sourceData[rnum];
var toU2 = new Customer() {
Name = source.CustName,
Balance = source.AccountBal,
LastPaymentDate = source.LDate, ...
}
toU2.Save();
}
The Customer class and properties were generated from dict items, and
an exception will be thrown if the data is bad, thus providing some
level of data integrity. The data can be saved directly into the file,
or the Save method can be configured to execute a BASIC program which
further processes the data into the right format and locations. I will
be happy to consult with developers toward creation of solutions as
described here.
[/AD]
Once again, the solution depends on a proper definition of the problem
to be solved. The above code pattern can be used to move data from
_anywhere_ into U2, which is a valid response to your general query.
Now, as usual, feel free to change the scope of the problem to
completely invalidate the responses provided thus far.
Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
Nebula RD sells mv.NET worldwide
and provides related development services
http://Nebula-RnD.com/blog
Visit http://PickWiki.com! Contribute!
http://Twitter.com/TonyGravagno
http://groups.google.com/group/mvdbms/about
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UPLOAD not DOWNLOAD
That goes the wrong way. Download does not depend on knowing who is consuming what to create it's results. So Upload should not need to have interactive consumption details either. That's my take. It's reads a source and decides on its own without the sources assistance where to put what. You're coming at it more from a point of view of both sides *agreeing* on what data is in what position. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UPLOAD not DOWNLOAD
You could modify Brian Leach's freeware BCI.IMPORT tool which is designed for SQL / BCI imports. But looks relatively easy to modify for what you want ! ;-) With his permission, of course ! I just downloaded to have a peek... as I have been looking at his other tools lately... There is also provision for multivalues so that's great! Check out Brian's website... http://www.brianleach.co.uk/pages/freebies.htm -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Saturday, 27 October 2012 2:40 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UPLOAD not DOWNLOAD That goes the wrong way. Download does not depend on knowing who is consuming what to create it's results. So Upload should not need to have interactive consumption details either. That's my take. It's reads a source and decides on its own without the sources assistance where to put what. You're coming at it more from a point of view of both sides *agreeing* on what data is in what position. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UPLOAD not DOWNLOAD
Interesting. I'm just reading the documentation and it addresses a few nagging things that were floating around in my head about how this wouldn't work. Brian gives me a framework I can work in, I probably won't use his code, but just the skeleton of the ideas and write my own parser to work in a similar way to how he explains his. -Original Message- From: Hona, David david.h...@cba.com.au To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Oct 26, 2012 10:23 pm Subject: Re: [U2] UPLOAD not DOWNLOAD You could modify Brian Leach's freeware BCI.IMPORT tool which is designed for SQL / BCI imports. But looks relatively easy to modify for what you want ! ;-) With his permission, of course ! I just downloaded to have a peek... as I have been looking at his other tools lately... There is also provision for multivalues so that's great! Check out Brian's website... http://www.brianleach.co.uk/pages/freebies.htm -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Saturday, 27 October 2012 2:40 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UPLOAD not DOWNLOAD That goes the wrong way. Download does not depend on knowing who is consuming what to create it's results. So Upload should not need to have interactive consumption details either. That's my take. It's reads a source and decides on its own without the sources assistance where to put what. You're coming at it more from a point of view of both sides *agreeing* on what data is in what position. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ 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
