Re: [U2] Reporting Tools

Ian you don't happen to have an example of what this code *does* do you?




-----Original Message-----
From: McGowan, Ian <[email protected]>
To: U2 Users List <[email protected]>
Sent: Mon, Mar 3, 2014 1:35 pm
Subject: Re: [U2] Reporting Tools


If you're not already, it's a really good idea to consider creating something 
that will make producing excel files (the number one choice of accounting groups 
everywhere) from your "reports" easily.  Many years ago we used to physically 
print a bunch of reports each night, but since creating a tool the users can 
easily use, almost everything is electronic.

http://www.pickwiki.com/cgi-bin/wiki.pl?DumpRecall shows one way to do it, 
though it's pretty specific to our needs.  It wouldn't be hard to use this as 
inspiration for something that works in your own environment.  I'd forgotten 
about the 150 field limit in unidata, but this comment remembers:

    * We have a list of field names and a select, parse them the hard way
    * and write a tab-seperated file.  This is slower but avoids limitations
    * on the number of columns (of unidata) and the perl module WriteExcel


-----Original Message-----
From: [email protected] [mailto:[email protected]] 
On Behalf Of jeffrey Butera
Sent: Monday, March 03, 2014 1:05 PM
To: U2 Users List; [email protected]
Subject: Re: [U2] Reporting Tools

On 3/3/14, 4:01 PM, Daniel McGrath wrote:
> Hi Jeff,
>
> In case you missed it before:
>
> " Does your query use the LIMIT keyword? This is an internally hardcoded limit 
that was increased, IIRC, in 7.3.6 to 250."
>
> On further checking, here is the issue, along with fix version. I suggest you 
update to the latest UDT version.
>
> UDT-4284 -> Request for UniQuery hard limit of 150 attributes (in LIST 
> or REFORMAT commands) to be increased
>
>   A change was made to increase this to 250 attributes in 7.3.5. The actual 
limit has now been added to the report from the LIMIT verb so you can see 
limitation as "U_ATTRLIST"

Thanks Dan - this helps immensely.


--
Jeffrey Butera, PhD
Associate Director for Application and Web Services Information Technology 
Hampshire College
413-559-5556

_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
-----------------------------------------
IMPORTANT NOTICE:   This message is intended only for the addressee
and may contain confidential, privileged information.  If you are
not the intended recipient, you may not use, copy or disclose any
information contained in the message.  If you have received this
message in error, please notify the sender by reply e-mail and
delete the message.
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users

 
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users