Re: [U2] Wintegrate 3 on Windows 7 issues
It may not run on win7. Use the xp mode and run it in there. Works fine in there. Sent from my iPhone On Nov 8, 2011, at 17:57, iggch...@comcast.net wrote: Hi All, Before I begin let me state that I know that I have an old version and should look into a better way. However, I'm stuck using the Wintegrate version that I have for the time being. That being said... Can anyone tell me a way of determining what is interfering with my Wintegrate application firing up? I just began experiencing the problem l ast night. I attempt to open the application and it never shows itself. I can see it in task manager. Image NameUser NameCPUMemory Description MSOSYNC.EXE THOMPSC 00 3364K Microsoft Office Document Cache w integ.exeTHOMPSC 00 wowexec.exe THOMPSC 00 It looks odd to me for winteg.exe to be a child of MSOSYNC.EXE. Maybe that's not the case but it looks that way in task manager. After quite a long time, the application will suddenly appear without rhyme or reason. My initial thought was that it was a communication issue with my host. However, I can ping without any loss whatsoever. Any advice would be greatly appreciated. Thanks Scott ___ 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] BCI
Symeon, The data type is 'date'. I have not tried any other data type. Maybe I should change the sql data type to 'datetime'? Rudy Message: 9 Date: Sat, 5 Nov 2011 11:31:29 - From: Symeon Breen syme...@gmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: Re: [U2] BCI Message-ID: 022c01cc9bae$7784abe0$668e03a0$@gmail.com Content-Type: text/plain; charset=us-ascii 1st problem - - the data type - is a date or datetime - have you tried the other - or even a timespan. Learn more about SAGE Research Methods Online (SRMO) - the essential tool for researchers http://www.srmo.sagepub.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cooper, Rudy Sent: 04 November 2011 22:02 To: 'u2-users@listserver.u2ug.org' Subject: [U2] BCI Need some help on using a bci function with sql server. We are running UV 10.3.3 on windows 2003 server sp2. We've been using bci to run sprocs in sql server. A couple of things came up that we're having problems with which we have never used before and thought this list might be of help to us. ... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Wintegrate 3 on Windows 7 issues
Thanks for the help everyone. I found a rundll.exe in task manager that was running some program/trojan. I ran malware bytes and it fixed everything. Not sure how I got the application... Anyway, thanks a bunch for the suggestions! - Original Message - From: Martin Braid mbr...@epicor.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wednesday, November 9, 2011 2:56:30 AM Subject: Re: [U2] Wintegrate 3 on Windows 7 issues VMWare also interferes with Wintegrate. Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Scott Richardson Sent: 09 November 2011 02:34 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Wintegrate 3 on Windows 7 issues On 11/8/2011 9:01 PM, iggch...@comcast.net wrote: Thanks Scott. I'll try turning off UAC and see if that does the trick. - Original Message - From: Scott Richardsoncheetah...@comcast.net To: u2-users@listserver.u2ug.org Sent: Tuesday, November 8, 2011 8:40:52 PM Subject: Re: [U2] Wintegrate 3 on Windows 7 issues On 11/8/2011 8:19 PM, Jeff Butera wrote: Slight tangent that may shed light. Back when Datatel was based on wIntegrate, we would occasionally see this behavior for some machines deployed on campus. In short, another process (often TSR) would somehow block wIntegrate. In some cases it was MS Office Taskbar, in others it was been antivirus. As you point out, once the offending program was terminated, wIntegrate fired up like nothing was wrong. On 11/08/2011 07:57 PM, iggch...@comcast.net wrote: Hi All, Before I begin let me state that I know that I have an old version and should look into a better way. However, I'm stuck using the Wintegrate version that I have for the time being. That being said... Can anyone tell me a way of determining what is interfering with my Wintegrate application firing up? I just began experiencing the problem l ast night. I attempt to open the application and it never shows itself. I can see it in task manager. Image Name User Name CPU Memory Description MSOSYNC.EXE THOMPSC 00 3364K Microsoft Office Document Cache w integ.exe THOMPSC 00 wowexec.exe THOMPSC 00 It looks odd to me for winteg.exe to be a child of MSOSYNC.EXE. Maybe that's not the case but it looks that way in task manager. After quite a long time, the application will suddenly appear without rhyme or reason. My initial thought was that it was a communication issue with my host. However, I can ping without any loss whatsoever. Any advice would be greatly appreciated. Thanks Scott ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users UAC on Windows 7 is infamous for such behavior ? ___ 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 UAC being turned off requires a reboot for it to take affect - another poster seems to have another solid idea as well. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== 7cQu3yEMwy9WBR61CE7HAf3a54hJhFMuZ2DEGNPdlyNkQ== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Wintegrate 3 on Windows 7 issues
Scott, wIntegrate 3.0.03 runs on windows 7 32 bit, but I don't believe it runs on 64 bit. On windows 7, when I run my old wInteg 3, it shows as a child process of NTVDM and parallel with WOWEXEC. I'm not running it with any UAC, admin or other custom settings. We had the same thing happen where it would not appear for a long time, and we never traced the cause. Perhaps it was the licensing routine, I'm not sure, but it was quite annoying when it happened. We've since updated to 6.2 so that we could use 64bit workstations. -Troy _ Scanned by IBM Email Security Management Services powered by MessageLabs. For more information please visit http://www.ers.ibm.com This email is intended only for the use of the party to which it is addressed and may contain information that is privileged, confidential, or protected by law. If you are not the intended recipient you are hereby notified that any dissemination, copying or distribution of the email or its contents is strictly prohibited. If you have received this message in error, please notify us immediately, by replying to the message and deleting it from your computer. WARNING: Internet communications are not assured to be secure or clear of inaccuracies as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Therefore, we do not accept responsibility for any errors or omissions that are present in this email, or any attachment, that have arisen as a result of e-mail transmission. _ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Suggestions for flattening Multivalues...
I'm in the process of creating/updating a MySQL database for external applications to analyze some of the data. My initial method of dealing with a multivalued field, is to create it's own table, keyed to the master table (1:n) But this gets a little tedious if you have a bunch of multivalued fields - and creates really bulky SQL statements with all the joins. What other ways are people using to work with 1:n relationships? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Suggestions for flattening Multivalues... [AD]
[AD]Hi George, Our 2SQL product allows you to map graphically, then automatically creates all the tables for multivalues and subvalues. This youtube video shows how we mapped the table: http://youtu.be/-blc5rE1_CM and this one shows how we used the mapped view to create SQL Server tables (or Oracle, DB2, Progress, MySQL...) http://youtu.be/aI9TcMfCRDg -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: November-09-11 10:34 AM To: U2 Users Subject: [U2] Suggestions for flattening Multivalues... I'm in the process of creating/updating a MySQL database for external applications to analyze some of the data. My initial method of dealing with a multivalued field, is to create it's own table, keyed to the master table (1:n) But this gets a little tedious if you have a bunch of multivalued fields - and creates really bulky SQL statements with all the joins. What other ways are people using to work with 1:n relationships? ___ 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] Suggestions for flattening Multivalues...
It might be worth doing some of this work with an ORM (Object Relation Mapper). Almost all higher level languages have them. Once you get things configured, the messiness of the joins is hidden behind syntactic sugar. Here is a comparison of a lot of them from wikipedia. http://en.wikipedia.org/wiki/Comparison_of_object-relational_mapping_software SQLAlchemy is a market leader for python. If you are a microsoft shop, I understand LINQ us really nice. http://en.wikipedia.org/wiki/Language_Integrated_Query#LINQ_to_SQL On Wed, Nov 9, 2011 at 1:34 PM, George Gallen ggal...@wyanokegroup.com wrote: I'm in the process of creating/updating a MySQL database for external applications to analyze some of the data. My initial method of dealing with a multivalued field, is to create it's own table, keyed to the master table (1:n) But this gets a little tedious if you have a bunch of multivalued fields - and creates really bulky SQL statements with all the joins. What other ways are people using to work with 1:n relationships? ___ 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] Extracting XML attributes
Does anyone have an example of an XPath definition to extract an attribute from an XML element? The universe documentation for 10.3 and 11.1 doesn't cover this. I am trying to get the value of ProductId from the following XML example: pr:Feed xmlns:pr=urn:someurl Data Products Product ProductId=ABC ... /Product Product ProductId=123 ... /Product Product ProductId=XYZ ... /Product /Products /Data /pr Using the this extraction file: U2XML_extraction xmlns:USxml=http://www.rocketU2.com/U2-xml; file_extraction start=/Data dictionary=XMLTESTFILE null=EMPTY / field_extraction field=@ID path=Products/Product/@ProductId ,/ /U2XML_extraction I get the following error: LIST XMLDATA EDGENET_XML XML/test.ext Open XML data file failed. XMLParser error message: Fatal error at file '/Volume1/MIS/XML/test.ext', line 3, column 69. Message: Expected an attribute name Open XML data file failed. XMLParser error message: Fatal error at file '/Volume1/MIS/XML/test.ext', line 3, column 69. Message: Expected an attribute name Unable to open XMLDATA:EDGENET_XML,XML/test.ext file. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Extracting XML attributes
It would look like this: /*/Data/Products/Product/@ProductId Note that the document element has a namespace attached so if you assigned the namespace-uri urn_someurl to the prefix pr you could make that: /pr:Feed/Data/Products/Product/@ProductId The '@' specifies an attribute as opposed to an element. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: November-09-11 10:45 AM To: U2 Users List Subject: [U2] Extracting XML attributes Does anyone have an example of an XPath definition to extract an attribute from an XML element? The universe documentation for 10.3 and 11.1 doesn't cover this. I am trying to get the value of ProductId from the following XML example: pr:Feed xmlns:pr=urn:someurl Data Products Product ProductId=ABC ... /Product Product ProductId=123 ... /Product Product ProductId=XYZ ... /Product /Products /Data /pr Using the this extraction file: U2XML_extraction xmlns:USxml=http://www.rocketU2.com/U2-xml; file_extraction start=/Data dictionary=XMLTESTFILE null=EMPTY / field_extraction field=@ID path=Products/Product/@ProductId ,/ /U2XML_extraction I get the following error: LIST XMLDATA EDGENET_XML XML/test.ext Open XML data file failed. XMLParser error message: Fatal error at file '/Volume1/MIS/XML/test.ext', line 3, column 69. Message: Expected an attribute name Open XML data file failed. XMLParser error message: Fatal error at file '/Volume1/MIS/XML/test.ext', line 3, column 69. Message: Expected an attribute name Unable to open XMLDATA:EDGENET_XML,XML/test.ext file. ___ 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] Suggestions for flattening Multivalues...
I was looking more for ideas on how to setup the database structure to handle the 1:n other than the Sidebar tables joined to the master table. Right now, the scope of the data being moved off is fairly small, I didn't want to involve any other apps The querying app would be custom in itself (most likely php or something) Just this one file we are moving contains about 20 different multivalued fields, and it seemed a little Overkill to have to create 21 tables to contain the data in a form MySQL can handle. I guess that what Happens when you've been raised on multivalue database structure, and are forced to work with one that Does not handle it natively! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Wednesday, November 09, 2011 1:41 PM To: U2 Users List Subject: Re: [U2] Suggestions for flattening Multivalues... It might be worth doing some of this work with an ORM (Object Relation Mapper). Almost all higher level languages have them. Once you get things configured, the messiness of the joins is hidden behind syntactic sugar. Here is a comparison of a lot of them from wikipedia. http://en.wikipedia.org/wiki/Comparison_of_object-relational_mapping_software SQLAlchemy is a market leader for python. If you are a microsoft shop, I understand LINQ us really nice. http://en.wikipedia.org/wiki/Language_Integrated_Query#LINQ_to_SQL On Wed, Nov 9, 2011 at 1:34 PM, George Gallen ggal...@wyanokegroup.com wrote: I'm in the process of creating/updating a MySQL database for external applications to analyze some of the data. My initial method of dealing with a multivalued field, is to create it's own table, keyed to the master table (1:n) But this gets a little tedious if you have a bunch of multivalued fields - and creates really bulky SQL statements with all the joins. What other ways are people using to work with 1:n relationships? ___ 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] Suggestions for flattening Multivalues...
Welcome to Hell! -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Nov 9, 2011 10:57 am Subject: Re: [U2] Suggestions for flattening Multivalues... I was looking more for ideas on how to setup the database structure to handle he 1:n other than the Sidebar tables joined to the master table. Right now, the scope of the data being moved off is fairly small, I didn't want o involve any other apps The querying app would be custom in itself (most likely php or something) Just this one file we are moving contains about 20 different multivalued fields, nd it seemed a little verkill to have to create 21 tables to contain the data in a form MySQL can andle. I guess that what appens when you've been raised on multivalue database structure, and are forced o work with one that oes not handle it natively! -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Steve Romanow ent: Wednesday, November 09, 2011 1:41 PM o: U2 Users List ubject: Re: [U2] Suggestions for flattening Multivalues... It might be worth doing some of this work with an ORM (Object Relation apper). Almost all higher level languages have them. Once you get hings configured, the messiness of the joins is hidden behind yntactic sugar. Here is a comparison of a lot of them from wikipedia. ttp://en.wikipedia.org/wiki/Comparison_of_object-relational_mapping_software SQLAlchemy is a market leader for python. If you are a microsoft hop, I understand LINQ us really nice. ttp://en.wikipedia.org/wiki/Language_Integrated_Query#LINQ_to_SQL On Wed, Nov 9, 2011 at 1:34 PM, George Gallen ggal...@wyanokegroup.com wrote: I'm in the process of creating/updating a MySQL database for external pplications to analyze some of the data. My initial method of dealing with a multivalued field, is to create it's own able, keyed to the master table (1:n) But this gets a little tedious if you have a bunch of multivalued fields - and reates really bulky SQL statements with all the joins. What other ways are people using to work with 1:n relationships? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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] Suggestions for flattening Multivalues...
Whenever the fields are related (an association) the related fields can all make a single table. The only other thing you can do is to explode the single values to match the multivalues, but with different multivalue counts, you wind up with lots of null values. To make it really useful, I'm not aware of any other simple options. Relational databases really work best with normalized data... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: November-09-11 10:57 AM To: U2 Users List Subject: Re: [U2] Suggestions for flattening Multivalues... I was looking more for ideas on how to setup the database structure to handle the 1:n other than the Sidebar tables joined to the master table. Right now, the scope of the data being moved off is fairly small, I didn't want to involve any other apps The querying app would be custom in itself (most likely php or something) Just this one file we are moving contains about 20 different multivalued fields, and it seemed a little Overkill to have to create 21 tables to contain the data in a form MySQL can handle. I guess that what Happens when you've been raised on multivalue database structure, and are forced to work with one that Does not handle it natively! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Wednesday, November 09, 2011 1:41 PM To: U2 Users List Subject: Re: [U2] Suggestions for flattening Multivalues... It might be worth doing some of this work with an ORM (Object Relation Mapper). Almost all higher level languages have them. Once you get things configured, the messiness of the joins is hidden behind syntactic sugar. Here is a comparison of a lot of them from wikipedia. http://en.wikipedia.org/wiki/Comparison_of_object-relational_mapping_software SQLAlchemy is a market leader for python. If you are a microsoft shop, I understand LINQ us really nice. http://en.wikipedia.org/wiki/Language_Integrated_Query#LINQ_to_SQL On Wed, Nov 9, 2011 at 1:34 PM, George Gallen ggal...@wyanokegroup.com wrote: I'm in the process of creating/updating a MySQL database for external applications to analyze some of the data. My initial method of dealing with a multivalued field, is to create it's own table, keyed to the master table (1:n) But this gets a little tedious if you have a bunch of multivalued fields - and creates really bulky SQL statements with all the joins. What other ways are people using to work with 1:n relationships? ___ 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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Suggestions for flattening Multivalues...
Are any of the multivalued fields associated to each other? You would have a subtable per association, not per column. The messiness still exists, it just needs to be managed. On Wed, Nov 9, 2011 at 1:57 PM, George Gallen ggal...@wyanokegroup.com wrote: I was looking more for ideas on how to setup the database structure to handle the 1:n other than the Sidebar tables joined to the master table. Right now, the scope of the data being moved off is fairly small, I didn't want to involve any other apps The querying app would be custom in itself (most likely php or something) Just this one file we are moving contains about 20 different multivalued fields, and it seemed a little Overkill to have to create 21 tables to contain the data in a form MySQL can handle. I guess that what Happens when you've been raised on multivalue database structure, and are forced to work with one that Does not handle it natively! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Wednesday, November 09, 2011 1:41 PM To: U2 Users List Subject: Re: [U2] Suggestions for flattening Multivalues... It might be worth doing some of this work with an ORM (Object Relation Mapper). Almost all higher level languages have them. Once you get things configured, the messiness of the joins is hidden behind syntactic sugar. Here is a comparison of a lot of them from wikipedia. http://en.wikipedia.org/wiki/Comparison_of_object-relational_mapping_software SQLAlchemy is a market leader for python. If you are a microsoft shop, I understand LINQ us really nice. http://en.wikipedia.org/wiki/Language_Integrated_Query#LINQ_to_SQL On Wed, Nov 9, 2011 at 1:34 PM, George Gallen ggal...@wyanokegroup.com wrote: I'm in the process of creating/updating a MySQL database for external applications to analyze some of the data. My initial method of dealing with a multivalued field, is to create it's own table, keyed to the master table (1:n) But this gets a little tedious if you have a bunch of multivalued fields - and creates really bulky SQL statements with all the joins. What other ways are people using to work with 1:n relationships? ___ 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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Suggestions for flattening Multivalues...
For a couple of the fields, I've done this, but for most of them, there are no range of counts. Oh well. The only other method I'll use for some of the other fields is storing them with a delimiter (very Pick like) And have the application split the data, instead of splitting it in the database. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Wednesday, November 09, 2011 2:03 PM To: U2 Users List Subject: Re: [U2] Suggestions for flattening Multivalues... Whenever the fields are related (an association) the related fields can all make a single table. The only other thing you can do is to explode the single values to match the multivalues, but with different multivalue counts, you wind up with lots of null values. To make it really useful, I'm not aware of any other simple options. Relational databases really work best with normalized data... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: November-09-11 10:57 AM To: U2 Users List Subject: Re: [U2] Suggestions for flattening Multivalues... I was looking more for ideas on how to setup the database structure to handle the 1:n other than the Sidebar tables joined to the master table. Right now, the scope of the data being moved off is fairly small, I didn't want to involve any other apps The querying app would be custom in itself (most likely php or something) Just this one file we are moving contains about 20 different multivalued fields, and it seemed a little Overkill to have to create 21 tables to contain the data in a form MySQL can handle. I guess that what Happens when you've been raised on multivalue database structure, and are forced to work with one that Does not handle it natively! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Suggestions for flattening Multivalues...
Thanks for mentioning that. Yes, some are - that will cut down on some of the tables. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Wednesday, November 09, 2011 2:05 PM To: U2 Users List Subject: Re: [U2] Suggestions for flattening Multivalues... Are any of the multivalued fields associated to each other? You would have a subtable per association, not per column. The messiness still exists, it just needs to be managed. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Suggestions for flattening Multivalues...
Why are you using MySql if you are after free you could use Postgresql which I believe supported nested tables built in? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, 10 November 2011 8:06 a.m. To: U2 Users List Subject: Re: [U2] Suggestions for flattening Multivalues... For a couple of the fields, I've done this, but for most of them, there are no range of counts. Oh well. The only other method I'll use for some of the other fields is storing them with a delimiter (very Pick like) And have the application split the data, instead of splitting it in the database. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Wednesday, November 09, 2011 2:03 PM To: U2 Users List Subject: Re: [U2] Suggestions for flattening Multivalues... Whenever the fields are related (an association) the related fields can all make a single table. The only other thing you can do is to explode the single values to match the multivalues, but with different multivalue counts, you wind up with lots of null values. To make it really useful, I'm not aware of any other simple options. Relational databases really work best with normalized data... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: November-09-11 10:57 AM To: U2 Users List Subject: Re: [U2] Suggestions for flattening Multivalues... I was looking more for ideas on how to setup the database structure to handle the 1:n other than the Sidebar tables joined to the master table. Right now, the scope of the data being moved off is fairly small, I didn't want to involve any other apps The querying app would be custom in itself (most likely php or something) Just this one file we are moving contains about 20 different multivalued fields, and it seemed a little Overkill to have to create 21 tables to contain the data in a form MySQL can handle. I guess that what Happens when you've been raised on multivalue database structure, and are forced to work with one that Does not handle it natively! ___ 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] Suggestions for flattening Multivalues...
On 11/09/11 14:05, Steve Romanow wrote: Are any of the multivalued fields associated to each other? You would have a subtable per association, not per column. This is precisely how Datatel reverse-engineered their back end from Unidata to MSSQL. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Suggestions for flattening Multivalues...
It's what I'm used to using for those small projects...I didn't realize that it supported that. I'll have to look into it...minor learning curve. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: Wednesday, November 09, 2011 2:15 PM To: U2 Users List Subject: Re: [U2] Suggestions for flattening Multivalues... Why are you using MySql if you are after free you could use Postgresql which I believe supported nested tables built in? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, 10 November 2011 8:06 a.m. To: U2 Users List Subject: Re: [U2] Suggestions for flattening Multivalues... For a couple of the fields, I've done this, but for most of them, there are no range of counts. Oh well. The only other method I'll use for some of the other fields is storing them with a delimiter (very Pick like) And have the application split the data, instead of splitting it in the database. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Wednesday, November 09, 2011 2:03 PM To: U2 Users List Subject: Re: [U2] Suggestions for flattening Multivalues... Whenever the fields are related (an association) the related fields can all make a single table. The only other thing you can do is to explode the single values to match the multivalues, but with different multivalue counts, you wind up with lots of null values. To make it really useful, I'm not aware of any other simple options. Relational databases really work best with normalized data... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: November-09-11 10:57 AM To: U2 Users List Subject: Re: [U2] Suggestions for flattening Multivalues... I was looking more for ideas on how to setup the database structure to handle the 1:n other than the Sidebar tables joined to the master table. Right now, the scope of the data being moved off is fairly small, I didn't want to involve any other apps The querying app would be custom in itself (most likely php or something) Just this one file we are moving contains about 20 different multivalued fields, and it seemed a little Overkill to have to create 21 tables to contain the data in a form MySQL can handle. I guess that what Happens when you've been raised on multivalue database structure, and are forced to work with one that Does not handle it natively! ___ 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] Extracting XML attributes
I found this article, and thought it may be of use to you: https://u2devzone.rocketsoftware.com/accelerate/articles/u2-xml/u2-xml Chris Date: Wed, 9 Nov 2011 12:44:44 -0600 From: bwor...@coburns.com To: u2-users@listserver.u2ug.org Subject: [U2] Extracting XML attributes Does anyone have an example of an XPath definition to extract an attribute from an XML element? The universe documentation for 10.3 and 11.1 doesn't cover this. I am trying to get the value of ProductId from the following XML example: pr:Feed xmlns:pr=urn:someurl Data Products Product ProductId=ABC ... /Product Product ProductId=123 ... /Product Product ProductId=XYZ ... /Product /Products /Data /pr Using the this extraction file: U2XML_extraction xmlns:USxml=http://www.rocketU2.com/U2-xml; file_extraction start=/Data dictionary=XMLTESTFILE null=EMPTY / field_extraction field=@ID path=Products/Product/@ProductId ,/ /U2XML_extraction I get the following error: LIST XMLDATA EDGENET_XML XML/test.ext Open XML data file failed. XMLParser error message: Fatal error at file '/Volume1/MIS/XML/test.ext', line 3, column 69. Message: Expected an attribute name Open XML data file failed. XMLParser error message: Fatal error at file '/Volume1/MIS/XML/test.ext', line 3, column 69. Message: Expected an attribute name Unable to open XMLDATA:EDGENET_XML,XML/test.ext file. ___ 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] Suggestions for flattening Multivalues...
Try MongoDB - It's a good match to a mvdbms and has drivers for most common programming environments. djm phil walker-2 wrote: Why are you using MySql if you are after free you could use Postgresql which I believe supported nested tables built in? - Learn and Do Excel and Share http://mvdbs.com http://mvdbs.com -- View this message in context: http://old.nabble.com/Suggestions-for-flattening-Multivalues...-tp32813168p32813844.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Suggestions for Flattening
I asked this same question at a recent www.njsql.org meeting. The answer that a few of the SQL programmers (who have done this) seemed to agree on was to... just make a new SQL table for each of the associations. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Suggestions for flattening Multivalues...
I have used Sleepy Mongoose to push data to mongo via curl. http://www.snailinaturtleneck.com/blog/2010/02/22/sleepy-mongoose-a-mongodb-rest-interface/ On Wed, Nov 9, 2011 at 3:07 PM, DavidJMurray (mvdbs.com) nab...@mvdbs.com wrote: Try MongoDB - It's a good match to a mvdbms and has drivers for most common programming environments. djm phil walker-2 wrote: Why are you using MySql if you are after free you could use Postgresql which I believe supported nested tables built in? - Learn and Do Excel and Share http://mvdbs.com http://mvdbs.com -- View this message in context: http://old.nabble.com/Suggestions-for-flattening-Multivalues...-tp32813168p32813844.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ 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] [semi-ot] JE Sisk basic book on the eBay
Anyone need/want the original JES pick basic book, here's your chance to pick it up for a mere $10 spot, give or take a few cents. http://www.ebay.com/itm/Pick-Basic-Programmers-Guide-The-Pick-library-/30056 4645053?pt=US_Nonfiction_Bookhash=item45fb0c84bd Not affiliated ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [semi-ot] JE Sisk basic book on the eBay
It's commonly available on Amazon's market in used condition for that range as well. http://www.amazon.com/gp/offer-listing/0830628452/ref=dp_olp_used Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. Allen E. Elwood aelw...@socal.rr.com 11/9/2011 2:38 PM Anyone need/want the original JES pick basic book, here's your chance to pick it up for a mere $10 spot, give or take a few cents. http://www.ebay.com/itm/Pick-Basic-Programmers-Guide-The-Pick-library-/30056 4645053?pt=US_Nonfiction_Bookhash=item45fb0c84bd Not affiliated ___ 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] [semi-ot] JE Sisk basic book on the eBay
This listing has been removed Dan McGrath U2 Product Manager Rocket Software 4600 S. Ulster Street **Suite 1100 **Denver, CO 80237 * USA Tel: +1.720.475.8098 * Fax: +1.617.630.7392 Email: dmcgr...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen E. Elwood Sent: Wednesday, November 09, 2011 1:38 PM To: 'U2 Users List' Subject: [U2] [semi-ot] JE Sisk basic book on the eBay Anyone need/want the original JES pick basic book, here's your chance to pick it up for a mere $10 spot, give or take a few cents. http://www.ebay.com/itm/Pick-Basic-Programmers-Guide-The-Pick-library-/30056 4645053?pt=US_Nonfiction_Bookhash=item45fb0c84bd Not affiliated ___ 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] [semi-ot] JE Sisk basic book on the eBay
Copy the entire link to see it. Avante 9.1.7a/SB+ on Windows, tasty GUI flavored Best Regards, Caryl Lange Applications Development Manager HME 14110 Stowe Drive Poway, California 92064 phone: (858) 646-8806 cla...@hme.com Visit our website: www.hme.com Please consider the environment before printing this email CONFIDENTIALITY NOTICE: E-mail may contain proprietary confidential information that is legally privileged. Do not read this e-mail if you are not the intended recipient. This e-mail transmission, and any documents, files or previous e-mail messages attached to it may contain proprietary information, trade secrets, and/or other confidential information that is legally privileged. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of any of the information contained in or attached to this transmission is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notify the original sender by return E-mail, and destroy the original transmission and its attachments without reading or saving in any manner. Thank you. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Wednesday, November 09, 2011 12:46 PM To: U2 Users List Subject: Re: [U2] [semi-ot] JE Sisk basic book on the eBay This listing has been removed Dan McGrath U2 Product Manager Rocket Software 4600 S. Ulster Street **Suite 1100 **Denver, CO 80237 * USA Tel: +1.720.475.8098 * Fax: +1.617.630.7392 Email: dmcgr...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen E. Elwood Sent: Wednesday, November 09, 2011 1:38 PM To: 'U2 Users List' Subject: [U2] [semi-ot] JE Sisk basic book on the eBay Anyone need/want the original JES pick basic book, here's your chance to pick it up for a mere $10 spot, give or take a few cents. http://www.ebay.com/itm/Pick-Basic-Programmers-Guide-The-Pick-library-/30056 4645053?pt=US_Nonfiction_Bookhash=item45fb0c84bd Not affiliated ___ 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] [semi-ot] JE Sisk basic book on the eBay
http://knol.google.com/k/fft2001/books-on-the-pick-operating-system/mbasj7lzroyk/32# Books for sale on the Pick Operating System -Original Message- From: Daniel McGrath dmcgr...@rocketsoftware.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Nov 9, 2011 12:46 pm Subject: Re: [U2] [semi-ot] JE Sisk basic book on the eBay This listing has been removed Dan McGrath 2 Product Manager ocket Software 600 S. Ulster Street **Suite 1100 **Denver, CO 80237 * USA el: +1.720.475.8098 * Fax: +1.617.630.7392 mail: dmcgr...@rs.com eb: www.rocketsoftware.com/u2 -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Allen E. Elwood ent: Wednesday, November 09, 2011 1:38 PM o: 'U2 Users List' ubject: [U2] [semi-ot] JE Sisk basic book on the eBay nyone need/want the original JES pick basic book, here's your chance to pick it p for a mere $10 spot, give or take a few cents. http://www.ebay.com/itm/Pick-Basic-Programmers-Guide-The-Pick-library-/30056 645053?pt=US_Nonfiction_Bookhash=item45fb0c84bd Not affiliated ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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] Extracting XML attributes
Your start is the Feed element in the pr namespace. The u2 xml extraction does not always work too well with namespaces. If required I can supply you an xsl to 'de namepsace' an xml - it is then simple preprocessing task using xmltproc to give you a cleaner (in u2 regards) xml. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: 09 November 2011 18:45 To: U2 Users List Subject: [U2] Extracting XML attributes Does anyone have an example of an XPath definition to extract an attribute from an XML element? The universe documentation for 10.3 and 11.1 doesn't cover this. I am trying to get the value of ProductId from the following XML example: pr:Feed xmlns:pr=urn:someurl Data Products Product ProductId=ABC ... /Product Product ProductId=123 ... /Product Product ProductId=XYZ ... /Product /Products /Data /pr Using the this extraction file: U2XML_extraction xmlns:USxml=http://www.rocketU2.com/U2-xml; file_extraction start=/Data dictionary=XMLTESTFILE null=EMPTY / field_extraction field=@ID path=Products/Product/@ProductId ,/ /U2XML_extraction I get the following error: LIST XMLDATA EDGENET_XML XML/test.ext Open XML data file failed. XMLParser error message: Fatal error at file '/Volume1/MIS/XML/test.ext', line 3, column 69. Message: Expected an attribute name Open XML data file failed. XMLParser error message: Fatal error at file '/Volume1/MIS/XML/test.ext', line 3, column 69. Message: Expected an attribute name Unable to open XMLDATA:EDGENET_XML,XML/test.ext file. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1411 / Virus Database: 2092/4006 - Release Date: 11/09/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BCI
I cant remember exactly but I thought the date data type only came in on sql server 2005, and that it was just datetime before that . -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cooper, Rudy Sent: 09 November 2011 17:37 To: 'u2-users@listserver.u2ug.org' Subject: Re: [U2] BCI ?Symeon, The data type is 'date'. I have not tried any other data type. Maybe I should change the sql data type to 'datetime'? Rudy Message: 9 Date: Sat, 5 Nov 2011 11:31:29 - From: Symeon Breen syme...@gmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: Re: [U2] BCI Message-ID: 022c01cc9bae$7784abe0$668e03a0$@gmail.com Content-Type: text/plain; charset=us-ascii 1st problem - - the data type - is a date or datetime - have you tried the other - or even a timespan. Learn more about SAGE Research Methods Online (SRMO) - the essential tool for researchers http://www.srmo.sagepub.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cooper, Rudy Sent: 04 November 2011 22:02 To: 'u2-users@listserver.u2ug.org' Subject: [U2] BCI Need some help on using a bci function with sql server. We are running UV 10.3.3 on windows 2003 server sp2. We've been using bci to run sprocs in sql server. A couple of things came up that we're having problems with which we have never used before and thought this list might be of help to us. ... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1411 / Virus Database: 2092/4005 - Release Date: 11/08/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Wintegrate 3 on Windows 7 issues
From: Martin Braid VMWare also interferes with Wintegrate. Martin How so? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [semi-ot] JE Sisk basic book on the eBay
Since this thread is already labeled semi-ot, thought I'd throw this out there: http://wn.com/Dick_Pick It's a Pick Systems marketing video from 1990 that someone posted to YouTube. Might be interesting for anyone new to Pick and curious about its origins. I enjoyed it purely for nostalgia. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen E. Elwood Sent: Wednesday, November 09, 2011 12:38 PM To: 'U2 Users List' Subject: [U2] [semi-ot] JE Sisk basic book on the eBay Anyone need/want the original JES pick basic book, here's your chance to pick it up for a mere $10 spot, give or take a few cents. http://www.ebay.com/itm/Pick-Basic-Programmers-Guide-The-Pick-library-/3 0056 4645053?pt=US_Nonfiction_Bookhash=item45fb0c84bd Not affiliated ___ 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] Extracting XML attributes
The xsl would be much appreciated, thanks! Bob bwor...@coburns.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, November 09, 2011 4:11 PM To: 'U2 Users List' Subject: Re: [U2] Extracting XML attributes Your start is the Feed element in the pr namespace. The u2 xml extraction does not always work too well with namespaces. If required I can supply you an xsl to 'de namepsace' an xml - it is then simple preprocessing task using xmltproc to give you a cleaner (in u2 regards) xml. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Old tricks for old dogs
TOTAL.PAGES = KEY.COUNT/5 ; IF INT(TOTAL.PAGES)#TOTAL.PAGES THEN TOTAL.PAGES = INT(TOTAL.PAGES)+1 is equivalent to TOTAL.PAGES = INT((KEY.COUNT-1)/5) + 1 Or how to page and avoid a final blank page logic ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] unsubscribe
[http://www.coop-bookshop.com.au/page_images/lhs_christmas_maintile.jpg]http://www.coop-bookshop.com.au/bookshop/whats_new/christmas_feature.html Please consider the environment before printing this email. This email and any attached files are confidential and intended solely for the intended recipient(s). If you are not the named recipient you should not read, distribute, copy or alter this email. Any views or opinions expressed in this email are those of the author and do not represent those of the University Co-operative Bookshop Limited. Warning: Although precautions have been taken to make sure no viruses are present in this email, the company cannot accept responsibility for any loss or damage that arise from the use of this email or attachments. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [semi-ot] JE Sisk basic book on the eBay
From: Allen E. Elwood Anyone need/want the original JES pick basic book, here's your chance to pick it up for a mere $10 spot, give or take a few cents. This market could Really use new books that include platform-specific nuances, communications with different languages and protocols, and other modern concerns. But in a market that gets excited about $10 books that are over 20 years old, there's just no incentive for authors to create the material. I was in a MV user group meeting a couple years ago where the consensus was that no one reads documentation anyway so why bother writing or maintaining it. WTH? We've collectively created the market that we live in, and it's being killed off by the hand of people who claim to love it so well. I wrote about the book problem a few years ago: nospamNebula-RnD.com/blog/tech/mv/2007/05/mvbooks1.html T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Wintegrate 3 on Windows 7 issues
If you use Player to load an image, then Wintegrate will not start until you close the Player (not the image, the Player itself) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: 09 November 2011 22:16 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Wintegrate 3 on Windows 7 issues From: Martin Braid VMWare also interferes with Wintegrate. Martin How so? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== 9f4bTj7EW4NlTSDp90VMg7XIidmxQ5+qTmVy4oAFznL6w== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users