Re: [U2] Building an Excel File

2012-02-09 Thread Joshua Gallant
ogram I use to load a csv file, and a subroutine which converts back and forth between csv, dynamic and fixed width, either a line at a time or an entire flat file. Charlie On 02-09-2012 10:44 AM, Joshua Gallant wrote: > I was going to ask the same question about embedded line feeds.

Re: [U2] Building an Excel File

2012-02-09 Thread Joshua Gallant
I was going to ask the same question about embedded line feeds. I've been dealing with a lot of outside companies the last few months transferring data and found a lot have embedded line feeds all over. - Josh On 2/9/12 11:11 AM, "George Gallen" wrote: Is it possible that the URL has an em

Re: [U2] Building an Excel File

2012-02-08 Thread Joshua Gallant
t your programs? -Original Message----- From: Joshua Gallant To: U2 Users List Sent: Tue, Feb 7, 2012 12:41 pm Subject: Re: [U2] Building an Excel File We were running JET until our latest UniVerse upgrade earlier this year. e used it all over and the users actually resisted when we told them i

Re: [U2] Building an Excel File

2012-02-07 Thread Joshua Gallant
We were running JET until our latest UniVerse upgrade earlier this year. We used it all over and the users actually resisted when we told them it had to go. Go figure. After a few days testing with our own code they saw the light. - Josh On 2/7/12 12:46 PM, "Wjhonson" wrote: Dig it up and

Re: [U2] Extracting XML attributes

2012-01-12 Thread Joshua Gallant
When working with large XML files in the past I've always run into issues like this but I use a combination of xmapopen, xmapreadnext, and xmapclose. I couldn't ever come up with a great way to use the UV tools for parsing a large file at once so I open as a sequential file and parse the file unti

Re: [U2] UniVerse over Solaris Logon Question.

2012-01-12 Thread Joshua Gallant
When you execute the uv session the local directory you are in at the time is the account directory. I'd think you are changing to that directory in your login script or setting the path the same for every Solaris account. Something like this in your ".profile" file could help: cd /path/to/accou

Re: [U2] Soap error question

2010-05-03 Thread Joshua Gallant
I haven't worked a ton with SOAP requests but figured I'd throw this out there any how... Do you have a permissions error preventing a write? It seems most of what you've mentioned that's working are just reads but the one that write is failing. - Josh -Original Message- From: u2-user

Re: [U2] Paging protocols

2009-12-07 Thread Joshua Gallant
I've used SNPP before by passing arguments to a simple perl script which uses the Net::SNPP perl module. Below is a sample of the code in the perl script and I call it with something like '/usr/bin/perl /path/to/script/snpp.pl "$server" "$pager_num" "$message"' - Josh #!/usr/bin/perl # use

Re: [U2] sending text messages to a regular cell phone

2009-11-05 Thread Joshua Gallant
I know you can send an alpha-numeric page to a pager via SNPP but I'm not sure if it will work for a cell phone. We do that in the case that sendmail is having issues and backing up so an email can't get out. There is a simple to use perl module. We wrote a very simple perl script to call the per

Re: [U2] U2 University 2009, Denver

2009-09-12 Thread Joshua Gallant
I'll be there as well. -Josh -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, September 11, 2009 7:15 PM To: U2 Users List Subject: Re: [U2] U2 University 2009, Denver I won't be attending U

Re: [U2] SSH & Viewpoint Emulation

2009-09-02 Thread Joshua Gallant
We use AnzioWin and it fits our needs very well. - Josh -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Caminiti, Marc Sent: Wednesday, September 02, 2009 4:15 PM To: u2-users@listserver.u2ug.org Subject: [U2] SSH &

Re: [U2] XMAP HTML encoding

2009-08-19 Thread Joshua Gallant
e encoding of the xml to make sure they match. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Joshua Gallant Sent: 19 August 2009 14:05 To: U2 Users List Subject: [U2] XMAP HTML encoding I'm trying to imp

[U2] XMAP HTML encoding

2009-08-19 Thread Joshua Gallant
I'm trying to import an XML document that has some fields with HTML character encoding using the XMAPOpen & XMAPReadNext commands. The XML parser is taking the HTML and trying to parse when we'd like it to be left alone. For example, é is being converted to CHAR(195):CHAR(169) when we'd like to k

Re: [U2] UV global catalog in Pick flavour

2009-07-10 Thread Joshua Gallant
You just need to create a new voc item and copy of the contents from the CATALOG voc item. Change field 6 of the new voc item from PICK.FORMAT to INFORMATION.FORMAT. Here's what mine looks like: 0001 V 0002 CATALOG 0003 I 0004 BDGZ 0005

Re: [U2] UV and triggers

2009-07-10 Thread Joshua Gallant
It seems okay to me. What file type is the file you're trying to add the trigger to? - Josh -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, July 10, 2009 3:20 PM To: U2 Users List Subjec

Re: [U2] General guidelines on indexing

2009-07-10 Thread Joshua Gallant
It sounds to me like you guys are hitting a limit on the size of the memory segment. If that's true its tuned as a kernel parameter. I'd check there first and then try other ideas. - Josh -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserve

Re: [U2] General guidelines on indexing

2009-07-09 Thread Joshua Gallant
0.1239 seconds running on a Solaris machine with UV 10.2.2 and 250 other users. - Josh -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Thursday, July 09, 2009 1:56 PM To: U2 Users List Subject: Re

Re: [U2] XML mapping to multiple files & records

2009-06-25 Thread Joshua Gallant
ecords Call a subroutine that parses the data. I have done it several times. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Joshua Gallant Sent: Tuesday, June 23, 2009 10:49 AM To: U2 Users List Subject: Re: [U2]

Re: [U2] Mixed Case UV Basic Programming Standards.

2009-06-25 Thread Joshua Gallant
People use something other than ED? For the most part, all programmers on our staff do use the ED editor but there are a few of us who like the functions like syntax highlighting, etc. We code in all UPPER case here. We've had programs around for 30 years so the base programs were always upperca

Re: [U2] XML mapping to multiple files & records

2009-06-23 Thread Joshua Gallant
approach with a SQL type database, but in Universe, you can make the track data multi-valued related fields in the albums file. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behal

[U2] XML mapping to multiple files & records

2009-06-23 Thread Joshua Gallant
Hi Folks, Here's a scenario for you: Let's say there is an XML file containing album & track data that we'd like to import into 2 different Universe files. A sample layout might be something like:

Re: [U2] Linux / file create default permissions

2009-06-16 Thread Joshua Gallant
You do in fact want to look into the umask setting but 770 doesn't seem correct since that would grant access to "other" but not the owner or group. - Josh From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Tuesday, June

RE: [U2] Help with encryption

2009-05-13 Thread Joshua Gallant
I know someone already mentioned it but since there are so many responses trying to do something more difficult I figured I'd throw it out there again. Won't the DIGEST() function do what you're looking for? - Josh -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner

[U2] Help with sockets

2009-05-04 Thread Joshua Gallant
Hi Folks, Maybe one of you can help... Let's assume I'm writing a piece of client software to connect to a server using the basic socket calls & simply dump data through a port and receive a response back. Let's also assume the server shuts down mid process and sends a FINACK packet to the c

RE: [U2] How do you do a NOPAGE on a SELECT?

2009-04-24 Thread Joshua Gallant
Couldn't you just use HUSH before doing the select to suppress the output? - Josh -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, April 24, 2009 2:22 PM To: u2-users@listserver.u2ug.org Subje

RE: [U2] Question on UniVerse VOC record for CREATE.FILE

2009-04-24 Thread Joshua Gallant
The LONGNAMES command will update certain VOC records (CREATE.FILE, DELETE.FILE, CNAME, & CREATE.BFILE) so they will work with long file names properly. Certain fields are updated with the necessary data when that command is used that can be missed if modified manually. For the CREATE.FILE comman

RE: [U2] 81003 uvrpc error

2009-04-20 Thread Joshua Gallant
I'd start with the basics. First check for the process to be running (ps -ef | grep unirpc) and then for it to be listening on the port (netstat -an | grep 31438). I deal mainly with Solaris so the commands may be slightly different for linux but should be close. - Josh -Original Message--

RE: [U2] U2 University 2009 Schedule

2009-04-15 Thread Joshua Gallant
I have no link with dates but this was in the recent U2 news flash email: " U2 University Planning Status As reported earlier in this News Flash, the U2 Team is hard at work on U2 University 2009. Current status is as follows: Denver, USA, September 16-18, 2009 -- Confirmed! Liverpool, UK, Oct

RE: [U2] Speeding up processing through large dynamic table

2008-11-17 Thread Joshua Gallant
When running through an array with a for next loop the last item processed isn't remembered so the program needs to traverse the entire array for each record and will slow down as you get to records later in the process. Instead of this: A11 = DCOUNT(IN.TAB,@AM) FOR A1 = 1 TO A11 IN.LINE = IN.

[U2] CDATA in XML

2008-10-17 Thread Joshua Gallant
Hi folks, I tried posting this on the u2ug forum but it seems more folks use email than check the forum so figured I'd try here. I'm looking for a way to use the XMAP functions within UniVerse to import/export documents using a CDATA field instead of the default encoding UniVerse does. Does a