I will be out of the office starting 06/20/2009 and will not return until
07/06/2009.
I will respond to your message when I return.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Hi
It's clearly making the call, otherwise you would have the ErrText reporting
a network error or malformed request rather than getting back a valid (in
terms of the call) HTTP 400 return. So looks like something is blocking
between your uv server and your target website: are you certain that
In unibasic, I have 2 select statements which produce XML output from
xmlexecute.
Both xml documents have the same format. I would like to merge these 2
documents into one with the first 2 documents below merging into xml3
Xml1:
ROOT
Record att1=001 att2=something /
Record att1=002 att2=something
-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
__ Information from ESET NOD32 Antivirus, version of virus
signature database 4176 (20090622) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
Curt Lashley
2803 North
Hi Curt
The routine should work as stands, though if you're not using a proxy it
might be worth commenting out the proxy name header. The snipped sections
are setting custom http headers and filling out posted form data, neither of
which applies here.
Also be aware that it is actually making
Actually, ours currently goes through a translator.
We upload/download XML documents to/from our provider,
who then runs them through their software to convert them
to edi and send them along their way.
I pull the edi of the documents themselves, so I can get
the envelope reference numbers,
We have lots of programs that export our data from UniData to tab-delimited
text files. Some of these are opened by Excel (which has its faults), some are
imported into other databases. These files will be 1) E-mailed as attachments
or written to specific location on the network.
If I know
Yes, if you quote-delimit all your fields then it's possible to pass
@VMs as line feeds, and it will do what you want.
Ed
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John
R.
Sent: 22 June 2009 14:56
To:
Cool.
Here is the next wrinkle. What if my UniData data has (or may have) quotes in
it? Am I out of luck or is there some alternate way to get the same result?
Is there something like in other languages that you could convert double quotes
in the raw data to /q or whatever, and Excel
Dunno, how about converting double quotes in the data to single quotes?
Or stripping them out entirely?
Ed
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John
R.
Sent: 22 June 2009 15:22
To: 'U2 Users
That would not work. We use double and single quotes in descriptions for
describing lengths. For example, we might sell something whose dimensions are:
2x3x10'
Even so, your info was helpful if I know my data will not have double quotes.
Anyone else have an idea?
John Israel
Sr.
Well, you could convert double quotes to two single quotes - in variable
width fonts the two forms are virtually indistinguishable.
(view the line below in something like Arial)
vs ''
Ed
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
I have to agree with Doug, I spend my entire day in Ms Visual Studio,
save the modifications I do for our UniVerse system. I started writing add-ins
for my Visual Studio to do conversion for things like UniVerse dates to Windows
dates, etcetera. I don't think I did it because I felt
Make your data into an HTML table.
Israel, John R. wrote:
That would not work. We use double and single quotes in descriptions for
describing lengths. For example, we might sell something whose dimensions are:
2x3x10'
Even so, your info was helpful if I know my data will not have double
For that matter, why not go the XML route where you can
define the column properties as well (at least I understand
you can...). Makes the files a bit more swollen, but most
excel's will load it up and parse it out properly.
George
-Original Message-
From:
Instead of Tab-delimited, look at CSV format. It supports embedded single-
and double-quotes. And CSV imports into Excel. Embedded double quotes are
two consecutive chars:
http://en.wikipedia.org/wiki/Comma-separated_values
Bob
-Original Message-
From:
I am using pyExcelerator to make native xls files on aix. I think this
package is depracated and has been replaced by xlrd and xlwt. My use is
not mature at all, but I envision a hook in Output.Redirect that will
allow direct to xls using python.
Anyone want to team up to bring this idea to
quote who='Steve Romanow' date='Monday 22 June 2009'
I am using pyExcelerator to make native xls files on aix. I think this
package is depracated and has been replaced by xlrd and xlwt. My use is
not mature at all, but I envision a hook in Output.Redirect that will
allow direct to xls
Do you have yours tied into SB+ at all? That is the holy grail.
Jeff Butera wrote:
quote who='Steve Romanow' date='Monday 22 June 2009'
I am using pyExcelerator to make native xls files on aix. I think this
package is depracated and has been replaced by xlrd and xlwt. My use is
not
This took some tweaking of my test program, but I think with all the needed
tests and data scrubbing, this is the way to go. It took some playing around
with the commas and quotes (the raw data could have either or both of these
conditions). It also deals with putting multiple lines in a
Double-quotes can be embedded within the quoted field by escaping them. Just
double up the double-quote character.
So the text: This is my description field. Would go be exported as: This
is my description field.
Robert F. Porter, MCSE, CCNA, ZCE
Sr. Programmer / Analyst
Laboratory
John,
Somehting I do for some extracts is replace with IN and ' with FT in
description data.
Israel, John R. wrote:
This took some tweaking of my test program, but I think with all the needed
tests and data scrubbing, this is the way to go. It took some playing around
with the commas and
quote who='Steve Romanow' date='Monday 22 June 2009'
Do you have yours tied into SB+ at all? That is the holy grail.
No.
--
Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
jbut...@hampshire.edu
413-559-5556
Dad, you're talking in grown-up and need to stop.
Since I have no idea how other folks may be using the exported data, I don't
dare change the description. Visually, it is no big deal (and might not even
be noticed), but if they are trying to match something up between systems, and
I have changed the text of one of these, then what used to
Steve;
SB+ downloads quite nicely to Excel. Query reports handle it natively (even
to 12 different graph types). Plus there is the TU.TO.EXCEL routine you can
look at if you want more explicit control. Primarily, it dumps it to a local
file, opens it with Excel and runs macros on it.
Hth
Colin
It requires sbclient and windows. I use neither.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Tony Gravagno would put an AD around it, but I've had great luck with his
NebulaXLite product. You populate a dynamic array, call Tony's routine, and
you get an Excel 2003 XML document with whatever formatting you want. He
even has a program to generate Basic code from any existing spreadsheet
This sounds like the perfect spot for a decent sized
open source group to spring up and fill the hole, making a
tool or the many plug-ins required to fill the void you're
describing.
Like that hasn't been tried. We can't even get volunteers to update the wiki
or post to the
Please also consider NebulaXLite to create nicely formatted
spreadsheets for Excel, OpenOffice, and Google Docs. When you
deliver CSV in response to a request for Excel, it's like
introducing someone to their new business software that looks
like DOS. It just makes the business software seem
Our production system is Universe 10.2.4, Pick format on an AIX version 5.3.
Execute COMO ON get
COMO ON TEST
COMO TEST established 13:54:37 22 JUN 2009
Execute COMO OFF get
COMO OFF TEST
COMO completed. 13:55:05 22 JUN 2009
Invalid keyword OFF on command line.
With a little
Try comparing the VOC entry for OFF in your systems?
Mark
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Alspach,
Vance
Sent: Monday, June 22, 2009 11:00 AM
To: U2 Users List
Subject: [U2] COMO OFF / DIVERT.OUT OFF
That is amazing. It looks like somebody wrote their own proprietary logoff
routine and overwrote the OFF verb.
I assumed that DIVERT.OUT OFF was just a parameter and not contigent on the OFF
verb.
Thanks,
Vance Alspach
John Deere Landscapes
-Original Message-
From:
We have a wiki?
From: br...@brianleach.co.uk
To: u2-users@listserver.u2ug.org
Date: Mon, 22 Jun 2009 18:25:38 +0100
Subject: Re: [U2] Basic Developer Toolkit - Eclipse SDK
This sounds like the perfect spot for a decent sized
open source group to spring up and fill the hole,
Jo,
Yes. It is featured prominently on the U2UG.org home page. Have a look
and feel free to contribute.
- Chuck
Jo Lester wrote:
We have a wiki?
From: br...@brianleach.co.uk
To: u2-users@listserver.u2ug.org
Date: Mon, 22 Jun 2009 18:25:38 +0100
Subject: Re: [U2] Basic Developer Toolkit
Wasn't your question about tying it into SB+? If you exclude the SBClient
portion of SB+ then how is it different from anything else? Whether you use
something like NebulaXLite to generate the document at the Basic level or
something server side like perl or python there shouldn't be anything
Brian;
You probably could. From what I've seen (especially with UniDebugger) it
uses the terminal session to actually run the code and uses SETDEBUGLINE (in
UD) to re-direct the output to the uniobjects connection UniDebugger is
using. Not sure how your MVDeveloper connects but you could probably
Colin,
I would like to to tie in to SB+ (as in an option available in
OUTPUT.REDIRECT). I think OUTPUT.REDIRECT is a prelude specific
routine, I may be wrong.
Where I make the distinction is I do not want to involve any DDE or COM
to the client, I would just liek the xls dropped to a dir
I know we're well into this thread now, but...
Most of my goofing around with web page grabs and the like was done
before the CallHTTP stuff was out, or when only the really early versions
that were buggy were out. So back then we just used wget for grabbing
web pages on our Unix based UV
@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
__ Information from ESET NOD32 Antivirus, version of virus
signature database 4179 (20090622) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
Curt Lashley
2803 North Boulevard
Tampa
The pick format is biting you with the off keyword. It needs to look like
thiss:
ED VOC OFF
0001: K
0002: 194
0003: LOGOUT
This will support both uses of OFF.
From: valsp...@johndeerelandscapes.com
To: u2-users@listserver.u2ug.org
Date: Mon, 22 Jun 2009 13:59:37 -0400
Subject: [U2] COMO
http://listserver.u2ug.org/mailman/listinfo/u2-users
__ Information from ESET NOD32 Antivirus, version of virus
signature database 4179 (20090622) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
Curt Lashley
2803 North Boulevard
Tampa, FL 33602
Cell: (813
, version of virus
signature database 4179 (20090622) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
Curt Lashley
2803 North Boulevard
Tampa, FL 33602
Cell: (813) 293-2878 or (800) 886-2878
Home: (813) 226-2878 or (800) 524-2878
Fax: (813) 229-2878
As Robert describes, double quotes are used in freeware I've
published called ExcelExport, which exports full workbooks and
individual worksheets to CSV. You can get the software from our
freeware page and see the TXT Readme for details.
no.spam.pleaseNebula-rnd.com/freeware/
Rather than making
Sorry for two ads in one day folks but John's note prompts a
specific response.
John, are you aware that the core library in mv.NET is full of
functions for Date, Time, DCount, and other MV-specific
IConv/OConv functions?
nospamNebula-RnD.com/products/mvdotnet
mv.NET isn't just a library, it's
From: Brian Leach
[all snipped, full agreement]
From: Jo Lester
We have a wiki?
Grrr - just look in the sig of almost every note I post to this
forum.
In addition to what Brian said, I'll add that there are many
solutions in our marketplace that are readily available but it's
evident from
UV 10.2.16 HP-UX 11i
UFD is a type 1 file by default. I have some files in UFD with long
filenames that go down 1 level. I have created an I-type to extract delimited
fields within the @ID which either spans the 2 levels, or is wholly in the 2nd
level.
Using this I-type to display in a LIST
I don't have a system to check this on but how about
0001: I
0002: OCONV(FIELD(@ID,'_',2),'D2.')
0003:
0004: DATE
0005: 8R
0006: S
- Original Message -
From: Norman, David (Health) david.nor...@health.sa.gov.au
To: u2-users@listserver.u2ug.org
Sent: Monday, June 22, 2009 9:46 PM
I am out of the office until 27/06/2009.
I am visiting a Customer in Finland.I have limited access to email and
phone.
For Support Matters Contact John Jenkins
For PSO Matters Ailsa Mcaless
Note: This is an automated response to your message U2-Users Digest, Vol
2, Issue 68 sent on 22/6/09
48 matches
Mail list logo