date:20090622

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 that the users will always use Excel to open the attachment, I 
usually make the file extension xls so that it simply fires up Excel when 
double-clicked and parses everything out reasonably cleanly (but still drops 
leading zeros, converts big numbers to scientific notation, etc).



We are using UniData on HP-Unix.



Is there a good way to convert @VMs to something that Excel will correctly 
convert to what would be equivalent to the Alt+Enter in Excel?  I do not want 
the data on multiple rows - I want multiple lines with breaks within a single 
row/cell.





John Israel

Sr. Programmer/Analyst

Dayton Superior Corporation

721 Richard St.

Dayton, OH  45342

937-866-0711 x44380
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Simple Export to Excel

2009-06-22 Thread Edward Brown

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: 'U2 Users List'
Subject: [U2] Simple Export to Excel

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 that the users will always use Excel to open the attachment, I
usually make the file extension xls so that it simply fires up Excel
when double-clicked and parses everything out reasonably cleanly (but
still drops leading zeros, converts big numbers to scientific notation,
etc).



We are using UniData on HP-Unix.



Is there a good way to convert @VMs to something that Excel will
correctly convert to what would be equivalent to the Alt+Enter in Excel?
I do not want the data on multiple rows - I want multiple lines with
breaks within a single row/cell.





John Israel

Sr. Programmer/Analyst

Dayton Superior Corporation

721 Richard St.

Dayton, OH  45342

937-866-0711 x44380
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

---
Please remember to recycle wherever possible. 
Reduce, reuse, recycle, think do you need to print this e-mail?
---
This e-mail and any attachment(s), is confidential and may be legally 
privileged. It is intended solely for the addressee. If you are not the 
addressee, dissemination, copying or use of this e-mail or any of its content 
is prohibited and may be unlawful. If you are not the intended recipient please 
inform the sender immediately and destroy the e-mail, any attachment(s) and any 
copies. All liability for viruses is excluded to the fullest extent permitted 
by law. It is your responsibility to scan or otherwise check this email and any 
attachment(s). Unless otherwise stated (i) views expressed in this message are 
those of the individual sender (ii) no contract may be construed by this 
e-mail. Emails may be monitored and you are taken to consent to this 
monitoring.  

Civica Services Limited, Company No. 02374268; Civica UK Limited, Company No. 
01628868
Both companies are registered in England and Wales and each has its registered 
office at 2 Burston Road, Putney, London, SW15 6AR.
---

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Simple Export to Excel

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 would know how to handle this?





John Israel

Sr. Programmer/Analyst

Dayton Superior Corporation

721 Richard St.

Dayton, OH  45342

937-866-0711 x44380



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Monday, June 22, 2009 9:58 AM
To: U2 Users List
Subject: Re: [U2] Simple Export to Excel



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: 'U2 Users List'

Subject: [U2] Simple Export to Excel



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 that the users will always use Excel to open the attachment, I

usually make the file extension xls so that it simply fires up Excel

when double-clicked and parses everything out reasonably cleanly (but

still drops leading zeros, converts big numbers to scientific notation,

etc).







We are using UniData on HP-Unix.







Is there a good way to convert @VMs to something that Excel will

correctly convert to what would be equivalent to the Alt+Enter in Excel?

I do not want the data on multiple rows - I want multiple lines with

breaks within a single row/cell.











John Israel



Sr. Programmer/Analyst



Dayton Superior Corporation



721 Richard St.



Dayton, OH  45342



937-866-0711 x44380

___

U2-Users mailing list

U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users



---

Please remember to recycle wherever possible.

Reduce, reuse, recycle, think do you need to print this e-mail?

---

This e-mail and any attachment(s), is confidential and may be legally 
privileged. It is intended solely for the addressee. If you are not the 
addressee, dissemination, copying or use of this e-mail or any of its content 
is prohibited and may be unlawful. If you are not the intended recipient please 
inform the sender immediately and destroy the e-mail, any attachment(s) and any 
copies. All liability for viruses is excluded to the fullest extent permitted 
by law. It is your responsibility to scan or otherwise check this email and any 
attachment(s). Unless otherwise stated (i) views expressed in this message are 
those of the individual sender (ii) no contract may be construed by this 
e-mail. Emails may be monitored and you are taken to consent to this monitoring.



Civica Services Limited, Company No. 02374268; Civica UK Limited, Company No. 
01628868

Both companies are registered in England and Wales and each has its registered 
office at 2 Burston Road, Putney, London, SW15 6AR.

---



___

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] Simple Export to Excel

2009-06-22 Thread Edward Brown

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 List'
Subject: Re: [U2] Simple Export to Excel

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 would know how to handle this?





John Israel

Sr. Programmer/Analyst

Dayton Superior Corporation

721 Richard St.

Dayton, OH  45342

937-866-0711 x44380



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Monday, June 22, 2009 9:58 AM
To: U2 Users List
Subject: Re: [U2] Simple Export to Excel



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: 'U2 Users List'

Subject: [U2] Simple Export to Excel



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 that the users will always use Excel to open the attachment, I

usually make the file extension xls so that it simply fires up Excel

when double-clicked and parses everything out reasonably cleanly (but

still drops leading zeros, converts big numbers to scientific notation,

etc).







We are using UniData on HP-Unix.







Is there a good way to convert @VMs to something that Excel will

correctly convert to what would be equivalent to the Alt+Enter in Excel?

I do not want the data on multiple rows - I want multiple lines with

breaks within a single row/cell.











John Israel



Sr. Programmer/Analyst



Dayton Superior Corporation



721 Richard St.



Dayton, OH  45342



937-866-0711 x44380

___

U2-Users mailing list

U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users




---

Please remember to recycle wherever possible.

Reduce, reuse, recycle, think do you need to print this e-mail?


---

This e-mail and any attachment(s), is confidential and may be legally
privileged. It is intended solely for the addressee. If you are not the
addressee, dissemination, copying or use of this e-mail or any of its
content is prohibited and may be unlawful. If you are not the intended
recipient please inform the sender immediately and destroy the e-mail,
any attachment(s) and any copies. All liability for viruses is excluded
to the fullest extent permitted by law. It is your responsibility to
scan or otherwise check this email and any attachment(s). Unless
otherwise stated (i) views expressed in this message are those of the
individual sender (ii) no contract may be construed by this e-mail.
Emails may be monitored and you are taken to consent to this monitoring.



Civica Services Limited, Company No. 02374268; Civica UK Limited,
Company No. 01628868

Both companies are registered in England and Wales and each has its
registered office at 2 Burston Road, Putney, London, SW15 6AR.


---



___

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] Simple Export to Excel

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. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH  45342
937-866-0711 x44380

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Monday, June 22, 2009 10:25 AM
To: U2 Users List
Subject: Re: [U2] Simple Export to 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 List'
Subject: Re: [U2] Simple Export to Excel

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 would know how to handle this?





John Israel

Sr. Programmer/Analyst

Dayton Superior Corporation

721 Richard St.

Dayton, OH  45342

937-866-0711 x44380



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Monday, June 22, 2009 9:58 AM
To: U2 Users List
Subject: Re: [U2] Simple Export to Excel



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: 'U2 Users List'

Subject: [U2] Simple Export to Excel



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 that the users will always use Excel to open the attachment, I

usually make the file extension xls so that it simply fires up Excel

when double-clicked and parses everything out reasonably cleanly (but

still drops leading zeros, converts big numbers to scientific notation,

etc).







We are using UniData on HP-Unix.







Is there a good way to convert @VMs to something that Excel will

correctly convert to what would be equivalent to the Alt+Enter in Excel?

I do not want the data on multiple rows - I want multiple lines with

breaks within a single row/cell.











John Israel



Sr. Programmer/Analyst



Dayton Superior Corporation



721 Richard St.



Dayton, OH  45342



937-866-0711 x44380

___

U2-Users mailing list

U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users




---

Please remember to recycle wherever possible.

Reduce, reuse, recycle, think do you need to print this e-mail?


---

This e-mail and any attachment(s), is confidential and may be legally
privileged. It is intended solely for the addressee. If you are not the
addressee, dissemination, copying or use of this e-mail or any of its
content is prohibited and may be unlawful. If you are not the intended
recipient please inform the sender immediately and destroy the e-mail,
any attachment(s) and any copies. All liability for viruses is excluded
to the fullest extent permitted by law. It is your responsibility to
scan or otherwise check this email and any attachment(s). Unless
otherwise stated (i) views expressed in this message are those of the
individual sender (ii) no contract may be construed by this e-mail.
Emails may be monitored and you are taken to consent to this monitoring.



Civica Services Limited, Company No. 02374268; Civica UK Limited,
Company No. 01628868

Both companies are registered in England and Wales and each has its
registered office at 2 Burston Road, Putney, London, SW15 6AR.


---



___

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

Re: [U2] Simple Export to Excel

2009-06-22 Thread Edward Brown

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
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John
R.
Sent: 22 June 2009 15:30
To: 'U2 Users List'
Subject: Re: [U2] Simple Export to Excel

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. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH  45342
937-866-0711 x44380

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Monday, June 22, 2009 10:25 AM
To: U2 Users List
Subject: Re: [U2] Simple Export to 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 List'
Subject: Re: [U2] Simple Export to Excel

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 would know how to handle this?





John Israel

Sr. Programmer/Analyst

Dayton Superior Corporation

721 Richard St.

Dayton, OH  45342

937-866-0711 x44380



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Monday, June 22, 2009 9:58 AM
To: U2 Users List
Subject: Re: [U2] Simple Export to Excel



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: 'U2 Users List'

Subject: [U2] Simple Export to Excel



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 that the users will always use Excel to open the attachment, I

usually make the file extension xls so that it simply fires up Excel

when double-clicked and parses everything out reasonably cleanly (but

still drops leading zeros, converts big numbers to scientific notation,

etc).







We are using UniData on HP-Unix.







Is there a good way to convert @VMs to something that Excel will

correctly convert to what would be equivalent to the Alt+Enter in Excel?

I do not want the data on multiple rows - I want multiple lines with

breaks within a single row/cell.











John Israel



Sr. Programmer/Analyst



Dayton Superior Corporation



721 Richard St.



Dayton, OH  45342



937-866-0711 x44380

___

U2-Users mailing list

U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users




---

Please remember to recycle wherever possible.

Reduce, reuse, recycle, think do you need to print this e-mail?


---

This e-mail and any attachment(s), is confidential and may be legally
privileged. It is intended solely for the addressee. If you are not the
addressee, dissemination, copying or use of this e-mail or any of its
content is prohibited and may be unlawful. If you are not the intended
recipient please inform the sender immediately and destroy the e-mail,
any attachment(s) and any copies. All liability for viruses is excluded
to the fullest extent permitted by law. It is your responsibility to
scan or otherwise check this email and any attachment(s). Unless
otherwise stated (i) views expressed in this message are those of the
individual sender (ii) no contract may be construed by this e-mail.
Emails may be monitored and you are taken to consent to this monitoring.



Civica Services Limited, Company No. 02374268; Civica UK Limited,
Company No. 01628868

Both companies are registered in England and Wales and each has its
registered office at 2 Burston Road, Putney, London, SW15 6AR.

Re: [U2] Basic Developer Toolkit - Eclipse SDK

2009-06-22 Thread John J. Wahl


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 I had to make them, but 
because I didn't know there was a tool like BASIC Developer Toolkit, or 
anything else for that matter that fit into how I work now.  Even the U2 .NET 
add-on doesn't really seem like it's the perfect solution from what I've seen 
so far.  Perhaps what you have all just explained really does say it all.  

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.  Since I had never even heard of Eclipse 
(mostly because I live 95% of the time in the Ms world), I think it needs more 
preaching and tweaking so it speaks for itself.

---
John J. Wahl
Employee Owner
Programmer / Analyst 
Web:  http://www.Joseph.com/ 



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch
Sent: Friday, June 19, 2009 11:26
To: 'U2 Users List'
Subject: Re: [U2] Basic Developer Toolkit - Eclipse SDK

Charles,

Having worked for a lot of different organizations that build code on other
platforms, I would disagree with your comments.  You will see MS programmers
in Visual Studio all day, day after day.  You will see Java programmers do
the same in Eclipse.  Oracle programmers are no different.

Why are UniBasic programmers so different?

Because we have not had a tool that we can live in since the dawn of Pick.
When a CEO looks at me coding in AE/ED at their site, they invariable ask if
UniBasic is a DOS tool.  So, when a SQL server software vendor comes by to
sell them on merits of their new software, the invariable listen and
sometimes buy.

If we want to sell this database to management so that they realize the
power of U2, we better show them the we have a great tool set like those MS
programmers.  We cannot just talk the talk, we have to walk the walk.

I know I don't have all of the power tools yet for Eclipse.  I still have to
login into the database to perform whatever, but I know that this madness
has to stop.  Whether it is SOX compliance or by management degree, we
programmers need to stay out of the database. 

I know the U2 world is different, but why am I typing C/VAR/VAR1/G100 or
my favorite =t 31`R 12`FI`=t.

The power of Eclipse is the plug-ins.  I do have other tools but they are
plug-ins to Eclipse.  I have my HTML editor from Eclipse, my JavaScript
editor from Adobe, my UniBasic editor from U2logic, my Web Developer from
U2logic, CVS from Eclipse, my Resizer from U2logic, my report writer is BIRT
from Eclipse, and someday other U2 plug-ins from whomever.

Regards,
Doug
www.u2logic.com


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Results
Sent: Friday, June 19, 2009 8:45 AM
To: U2 Users List
Subject: Re: [U2] Basic Developer Toolkit - Eclipse SDK

David,
   I agree. I have yet to see a compelling reason to have just one tool. 
My projects and needs vary too much to just use AccuTerm, or just use
mvDeveloper, or just use *anything*. I need a variety of tools in my
toolkit.

- Chuck Have More Than Just Hammers, See More Than Just Nails Barouch

___
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] Simple Export to Excel

2009-06-22 Thread Jeff Schasny


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 quotes.

Anyone else have an idea?


John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH  45342
937-866-0711 x44380

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Monday, June 22, 2009 10:25 AM
To: U2 Users List
Subject: Re: [U2] Simple Export to 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 List'
Subject: Re: [U2] Simple Export to Excel

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 would know how to handle this?





John Israel

Sr. Programmer/Analyst

Dayton Superior Corporation

721 Richard St.

Dayton, OH  45342

937-866-0711 x44380



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Monday, June 22, 2009 9:58 AM
To: U2 Users List
Subject: Re: [U2] Simple Export to Excel



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: 'U2 Users List'

Subject: [U2] Simple Export to Excel



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 that the users will always use Excel to open the attachment, I

usually make the file extension xls so that it simply fires up Excel

when double-clicked and parses everything out reasonably cleanly (but

still drops leading zeros, converts big numbers to scientific notation,

etc).







We are using UniData on HP-Unix.







Is there a good way to convert @VMs to something that Excel will

correctly convert to what would be equivalent to the Alt+Enter in Excel?

I do not want the data on multiple rows - I want multiple lines with

breaks within a single row/cell.











John Israel



Sr. Programmer/Analyst



Dayton Superior Corporation



721 Richard St.



Dayton, OH  45342



937-866-0711 x44380

___

U2-Users mailing list

U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users




---

Please remember to recycle wherever possible.

Reduce, reuse, recycle, think do you need to print this e-mail?


---

This e-mail and any attachment(s), is confidential and may be legally
privileged. It is intended solely for the addressee. If you are not the
addressee, dissemination, copying or use of this e-mail or any of its
content is prohibited and may be unlawful. If you are not the intended
recipient please inform the sender immediately and destroy the e-mail,
any attachment(s) and any copies. All liability for viruses is excluded
to the fullest extent permitted by law. It is your responsibility to
scan or otherwise check this email and any attachment(s). Unless
otherwise stated (i) views expressed in this message are those of the
individual sender (ii) no contract may be construed by this e-mail.
Emails may be monitored and you are taken to consent to this monitoring.



Civica Services Limited, Company No. 02374268; Civica UK Limited,
Company No. 01628868

Both companies are registered in England and Wales and each has its
registered office at 2 Burston Road, Putney, London, SW15 6AR.


---



___

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] Simple Export to Excel

2009-06-22 Thread George Gallen

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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
 boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
 Sent: Monday, June 22, 2009 11:05 AM
 To: U2 Users List
 Subject: Re: [U2] Simple Export to Excel

 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
 quotes.
 
  Anyone else have an idea?
 
 
  John Israel
  Sr. Programmer/Analyst
  Dayton Superior Corporation
  721 Richard St.
  Dayton, OH  45342
  937-866-0711 x44380
 
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
 boun...@listserver.u2ug.org] On Behalf Of Edward Brown
  Sent: Monday, June 22, 2009 10:25 AM
  To: U2 Users List
  Subject: Re: [U2] Simple Export to 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 List'
  Subject: Re: [U2] Simple Export to Excel
 
  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 would know how to handle this?
 
 
 
 
 
  John Israel
 
  Sr. Programmer/Analyst
 
  Dayton Superior Corporation
 
  721 Richard St.
 
  Dayton, OH  45342
 
  937-866-0711 x44380
 
 
 
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward
 Brown
  Sent: Monday, June 22, 2009 9:58 AM
  To: U2 Users List
  Subject: Re: [U2] Simple Export to Excel
 
 
 
  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: 'U2 Users List'
 
  Subject: [U2] Simple Export to Excel
 
 
 
  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 that the users will always use Excel to open the
 attachment, I
 
  usually make the file extension xls so that it simply fires up
 Excel
 
  when double-clicked and parses everything out reasonably cleanly (but
 
  still drops leading zeros, converts big numbers to scientific
 notation,
 
  etc).
 
 
 
 
 
 
 
  We are using UniData on HP-Unix.
 
 
 
 
 
 
 
  Is there a good way to convert @VMs to something that Excel will
 
  correctly convert to what would be equivalent to the Alt+Enter in
 Excel?
 
  I do not want the data on multiple rows - I want multiple lines with
 
  breaks within a single row/cell.
 
 
 
 
 
 
 
 
 
 
 
  John Israel
 
 
 
  Sr. Programmer/Analyst
 
 
 
  Dayton Superior Corporation
 
 
 
  721 Richard St.
 
 
 
  Dayton, OH  45342
 
 
 
  937-866-0711 x44380
 
  ___
 
  U2-Users mailing list
 
  U2-Users@listserver.u2ug.org
 
  http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 
 
  -
 ---
  ---
 
  Please remember to recycle wherever possible.
 
  Reduce, reuse, recycle, think do you need to print this e-mail?
 
  -
 ---
  ---
 
  This e-mail and any attachment(s), is confidential and may be legally
  privileged. It is intended solely for the addressee. If you are not
 the
  addressee, dissemination, copying or use of this e-mail or any of its
  content is prohibited and may be unlawful. If you are not the
 intended
  recipient please inform the sender immediately and destroy the e-
 mail,
  any attachment(s) and any copies. All liability for viruses is
 excluded
  to the fullest extent permitted by law. It is your responsibility to
  scan or otherwise check this email and any attachment(s). Unless
  otherwise stated (i) views expressed in this message are those of

Re: [U2] Simple Export to Excel

2009-06-22 Thread Bobby Worley

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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John
R.
Sent: 22 June 2009 15:30
To: 'U2 Users List'
Subject: Re: [U2] Simple Export to Excel

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. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH  45342
937-866-0711 x44380

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Monday, June 22, 2009 10:25 AM
To: U2 Users List
Subject: Re: [U2] Simple Export to 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 List'
Subject: Re: [U2] Simple Export to Excel

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 would know how to handle this?





John Israel

Sr. Programmer/Analyst

Dayton Superior Corporation

721 Richard St.

Dayton, OH  45342

937-866-0711 x44380



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Monday, June 22, 2009 9:58 AM
To: U2 Users List
Subject: Re: [U2] Simple Export to Excel



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: 'U2 Users List'

Subject: [U2] Simple Export to Excel



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 that the users will always use Excel to open the attachment, I

usually make the file extension xls so that it simply fires up Excel

when double-clicked and parses everything out reasonably cleanly (but

still drops leading zeros, converts big numbers to scientific notation,

etc).







We are using UniData on HP-Unix.







Is there a good way to convert @VMs to something that Excel will

correctly convert to what would be equivalent to the Alt+Enter in Excel?

I do not want the data on multiple rows - I want multiple lines with

breaks within a single row/cell.











John Israel



Sr. Programmer/Analyst



Dayton Superior Corporation



721 Richard St.



Dayton, OH  45342



937-866-0711 x44380

___

U2-Users mailing list

U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users




---

Please remember to recycle wherever possible.

Reduce, reuse, recycle, think do you need to print this e-mail?


---

This e-mail and any attachment(s), is confidential and may be legally
privileged. It is intended solely for the addressee. If you are not the
addressee, dissemination, copying or use of this e-mail or any of its
content is prohibited and may be unlawful. If you are not the intended
recipient please inform the sender immediately and destroy the e-mail,
any attachment(s) and any copies. All liability for viruses is excluded
to the fullest extent permitted by law. It is your responsibility to
scan or otherwise check this email and any attachment(s). Unless
otherwise stated (i) views expressed in this message are those of the
individual sender (ii) no contract may be construed by this e-mail.
Emails may be monitored and you are taken to consent to this monitoring.



Civica Services Limited, Company No. 02374268; Civica UK Limited,
Company No. 01628868

Both companies are registered in England and Wales and each has its
registered office at 2 Burston Road, Putney, London, SW15 6AR.

Re: [U2] Simple Export to Excel

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 realization?

George Gallen wrote:

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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: Monday, June 22, 2009 11:05 AM
To: U2 Users List
Subject: Re: [U2] Simple Export to Excel

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
  

quotes.


Anyone else have an idea?


John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH  45342
937-866-0711 x44380

-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
  

boun...@listserver.u2ug.org] On Behalf Of Edward Brown


Sent: Monday, June 22, 2009 10:25 AM
To: U2 Users List
Subject: Re: [U2] Simple Export to 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 List'
Subject: Re: [U2] Simple Export to Excel

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 would know how to handle this?





John Israel

Sr. Programmer/Analyst

Dayton Superior Corporation

721 Richard St.

Dayton, OH  45342

937-866-0711 x44380



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward
  

Brown


Sent: Monday, June 22, 2009 9:58 AM
To: U2 Users List
Subject: Re: [U2] Simple Export to Excel



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: 'U2 Users List'

Subject: [U2] Simple Export to Excel



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 that the users will always use Excel to open the
  

attachment, I


usually make the file extension xls so that it simply fires up
  

Excel


when double-clicked and parses everything out reasonably cleanly (but

still drops leading zeros, converts big numbers to scientific
  

notation,


etc).







We are using UniData on HP-Unix.







Is there a good way to convert @VMs to something that Excel will

correctly convert to what would be equivalent to the Alt+Enter in
  

Excel?


I do not want the data on multiple rows - I want multiple lines with

breaks within a single row/cell.











John Israel



Sr. Programmer/Analyst



Dayton Superior Corporation



721 Richard St.



Dayton, OH  45342



937-866-0711 x44380

___

U2-Users mailing list

U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users



-
  

---


---

Please remember to recycle wherever possible.

Reduce, reuse, recycle, think do you need to print this e-mail?

-
  

---


---

This e-mail and any attachment(s), is confidential and may be legally
privileged. It is intended solely for the addressee. If you are not
  

the


addressee, dissemination, copying or use of this e-mail or any of its
content is prohibited and may be unlawful. If you are not the
  

intended


recipient please inform the sender immediately and destroy the e-
  

mail,


any

Re: [U2] Simple Export to Excel

2009-06-22 Thread Jeff Butera

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 using python.

Similarly, we have used the Perl module  Spreadsheet::WriteExcel to extract 
Unidata data and write Excel spreadsheets on the fly.

-- 
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.
 Catherine Butera

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Simple Export to Excel


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 mature at all, but I envision a hook in Output.Redirect that will 
allow direct to xls using python.



Similarly, we have used the Perl module  Spreadsheet::WriteExcel to extract 
Unidata data and write Excel spreadsheets on the fly.

  

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Simple Export to Excel

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 single cell by 
enclosing that data in quotes, and putting the data on multiple lines.  This 
looks goofy at first glance (putting 1 row of data on multiple lines), but it 
does work.  Study the last example on the link below.



Thanks Bob.



John Israel

Sr. Programmer/Analyst

Dayton Superior Corporation

721 Richard St.

Dayton, OH  45342

937-866-0711 x44380



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley
Sent: Monday, June 22, 2009 10:44 AM
To: 'U2 Users List'
Subject: Re: [U2] Simple Export to Excel



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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Simple Export to Excel

2009-06-22 Thread Robert Porter

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 Information Services
Ochsner Health System
(504) 842 - 5185
 
 
 
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.


 Israel, John R. johnisr...@daytonsuperior.com 6/22/2009 9:29 AM 
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. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH  45342
937-866-0711 x44380

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Monday, June 22, 2009 10:25 AM
To: U2 Users List
Subject: Re: [U2] Simple Export to 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 List'
Subject: Re: [U2] Simple Export to Excel

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 would know how to handle this?





John Israel

Sr. Programmer/Analyst

Dayton Superior Corporation

721 Richard St.

Dayton, OH  45342

937-866-0711 x44380



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Monday, June 22, 2009 9:58 AM
To: U2 Users List
Subject: Re: [U2] Simple Export to Excel



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: 'U2 Users List'

Subject: [U2] Simple Export to Excel



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 that the users will always use Excel to open the attachment, I

usually make the file extension xls so that it simply fires up Excel

when double-clicked and parses everything out reasonably cleanly (but

still drops leading zeros, converts big numbers to scientific notation,

etc).







We are using UniData on HP-Unix.







Is there a good way to convert @VMs to something that Excel will

correctly convert to what would be equivalent to the Alt+Enter in Excel?

I do not want the data on multiple rows - I want multiple lines with

breaks within a single row/cell.











John Israel



Sr. Programmer/Analyst



Dayton Superior Corporation



721 Richard St.



Dayton, OH  45342



937-866-0711 x44380

___

U2-Users mailing list

U2-Users@listserver.u2ug.org 

http://listserver.u2ug.org/mailman/listinfo/u2-users 




---

Please remember to recycle wherever possible.

Reduce, reuse, recycle, think do you need to print this e-mail?


---

This e-mail and any attachment(s), is confidential and may be legally
privileged. It is intended solely for the addressee. If you are not the
addressee, dissemination, copying or use of this e-mail or any of its
content is prohibited and may be unlawful. If you are not the intended
recipient please inform the sender immediately and destroy the e-mail,
any attachment(s) and any copies. All liability for viruses is excluded
to the fullest extent permitted by

Re: [U2] Simple Export to Excel


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 quotes (the raw data could have either or both of these 
conditions).  It also deals with putting multiple lines in a single cell by 
enclosing that data in quotes, and putting the data on multiple lines.  This 
looks goofy at first glance (putting 1 row of data on multiple lines), but it 
does work.  Study the last example on the link below.



Thanks Bob.



John Israel

Sr. Programmer/Analyst

Dayton Superior Corporation

721 Richard St.

Dayton, OH  45342

937-866-0711 x44380



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley
Sent: Monday, June 22, 2009 10:44 AM
To: 'U2 Users List'
Subject: Re: [U2] Simple Export to Excel



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
___
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] Simple Export to Excel

2009-06-22 Thread Jeff Butera

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.
 Catherine Butera

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Simple Export to Excel

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 line up will not.

I do not want to explain to senior management why some external process that 
worked flawlessly for years suddenly stopped working.

John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH  45342
937-866-0711 x44380

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow
Sent: Monday, June 22, 2009 11:45 AM
To: U2 Users List
Subject: Re: [U2] Simple Export to Excel

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 quotes (the raw data could have either or both of these 
 conditions).  It also deals with putting multiple lines in a single cell by 
 enclosing that data in quotes, and putting the data on multiple lines.  This 
 looks goofy at first glance (putting 1 row of data on multiple lines), but it 
 does work.  Study the last example on the link below.



 Thanks Bob.



 John Israel

 Sr. Programmer/Analyst

 Dayton Superior Corporation

 721 Richard St.

 Dayton, OH  45342

 937-866-0711 x44380



 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley
 Sent: Monday, June 22, 2009 10:44 AM
 To: 'U2 Users List'
 Subject: Re: [U2] Simple Export to Excel



 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
 ___
 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] Simple Export to Excel

2009-06-22 Thread Colin Alfke

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 Alfke
Calgary, Canada

-Original Message-
From: Steve Romanow

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 mature at all, but I envision a hook in Output.Redirect that will 
 allow direct to xls using python.
 

 Similarly, we have used the Perl module  Spreadsheet::WriteExcel to
extract Unidata data and write Excel spreadsheets on the fly.

   

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Simple Export to Excel

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

Re: [U2] Simple Export to Excel

2009-06-22 Thread Ross Morrissey

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 to
get you started.

On Mon, Jun 22, 2009 at 7:29 AM, Israel, John R. 
johnisr...@daytonsuperior.com 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
 quotes.

 Anyone else have an idea?


 John Israel
 Sr. Programmer/Analyst
 Dayton Superior Corporation
 721 Richard St.
 Dayton, OH  45342
 937-866-0711 x44380

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org [mailto:
 u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
 Sent: Monday, June 22, 2009 10:25 AM
 To: U2 Users List
 Subject: Re: [U2] Simple Export to 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 List'
 Subject: Re: [U2] Simple Export to Excel

 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 would know how to handle this?





 John Israel

 Sr. Programmer/Analyst

 Dayton Superior Corporation

 721 Richard St.

 Dayton, OH  45342

 937-866-0711 x44380



 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
 Sent: Monday, June 22, 2009 9:58 AM
 To: U2 Users List
 Subject: Re: [U2] Simple Export to Excel



 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: 'U2 Users List'

 Subject: [U2] Simple Export to Excel



 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 that the users will always use Excel to open the attachment, I

 usually make the file extension xls so that it simply fires up Excel

 when double-clicked and parses everything out reasonably cleanly (but

 still drops leading zeros, converts big numbers to scientific notation,

 etc).







 We are using UniData on HP-Unix.







 Is there a good way to convert @VMs to something that Excel will

 correctly convert to what would be equivalent to the Alt+Enter in Excel?

 I do not want the data on multiple rows - I want multiple lines with

 breaks within a single row/cell.











 John Israel



 Sr. Programmer/Analyst



 Dayton Superior Corporation



 721 Richard St.



 Dayton, OH  45342



 937-866-0711 x44380

 ___

 U2-Users mailing list

 U2-Users@listserver.u2ug.org

 http://listserver.u2ug.org/mailman/listinfo/u2-users



 
 ---

 Please remember to recycle wherever possible.

 Reduce, reuse, recycle, think do you need to print this e-mail?

 
 ---

 This e-mail and any attachment(s), is confidential and may be legally
 privileged. It is intended solely for the addressee. If you are not the
 addressee, dissemination, copying or use of this e-mail or any of its
 content is prohibited and may be unlawful. If you are not the intended
 recipient please inform the sender immediately and destroy the e-mail,
 any attachment(s) and any copies. All liability for viruses is excluded
 to the fullest extent permitted by law. It is your responsibility to
 scan or otherwise check this email and any attachment(s). Unless
 otherwise stated (i) views expressed in this message are those of the
 individual sender (ii) no contract may be construed by this e-mail.
 Emails may be monitored and you are taken to consent to this monitoring.



 Civica Services Limited, Company No. 02374268; Civica UK Limited,
 Company No. 01628868

 Both companies are registered in England and Wales and each has its
 registered office at 2 Burston Road, Putney,

Re: [U2] Basic Developer Toolkit - Eclipse SDK

2009-06-22 Thread Brian Leach

 

   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 website let alone finding people willing to put aside the
sort of time you would need for building toolsets.

No, to be blunt - what it needs is a community willing to put their money
where their mouths are and invest in the tools that are available, so it
then becomes worthwhile for tool vendors to spend the amounts of time and
money required to produce them. Creating quality tools is not trivial: in
most cases it takes a lot more work than creating the buiness applications
they help others to produce.

Unfortunately, it's all too usually the case that people will splash out on
tools like Visual Studio, and (if they are sensible) in buying the right
components to speed up client side development - but when it comes to their
multivalue system that is backing all of this, they simply refuse to pay for
anything that will help them. And then every so often people - often the
same people - complain that the tools aren't there. Hmmm - really?

But then 'twas ever thus... I wrote my first Windows based editor for
UniVerse (with all the bells and whistles you could ask for) back in 1990
and I continue as far as I can to develop tools today. And I'm not alone in
that: there are other tool vendors - including Doug - producing precisely
these types of tools for the U2 space. 

But in the final analysis the tools I build today - editors, installation
tools, source code tools etc. - are there primarily to assist me and I have
to squeeze them out between paid work. Because by themselves in this market
they certainly don't pay the bills. 


Brian

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Simple Export to Excel [AD]

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 antiquated
and people start looking elsewhere for more modern applications.

NebulaXLite is entirely free and fully functional for developers
and VARs that demo their software on end-user systems.  You can
download it, use it as long as you want, and we won't ever ask
you for a penny.  For production use, there is a one-time
purchase price of $200 for any server that goes live with
business reports.  There are no additional fees.  Support and
limited enhancements are always free.  There are no connectivity
components or any other hidden costs.  As a lite product, this
product model is simply to make it easy for a lot of people to do
something that makes MV look good.

Get more info, software, and full documentation here:
remove.pleaseNebula-RnD.com/products/xlite.htm 

Thanks for your time,
Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
Nebula RD sells mv.NET and other Pick/MultiValue products
worldwide, and provides related development services
remove.pleaseNebula-RnD.com/blog
Visit PickWiki.com!  Contribute!

 From: Edward Brown
 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.
 
 From: Israel, John R.
  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 that the users will always use Excel to open 
  the attachment, I usually make the file extension 
  xls so that it simply fires up Excel when 
  double-clicked and parses everything out reasonably 
  cleanly (but still drops leading zeros, converts big 
  numbers to scientific notation, etc).
 
  We are using UniData on HP-Unix.
  
  Is there a good way to convert @VMs to something that 
  Excel will correctly convert to what would be 
  equivalent to the Alt+Enter in Excel? I do not want 
  the data on multiple rows - I want multiple lines with 
  breaks within a single row/cell.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] COMO OFF / DIVERT.OUT OFF

2009-06-22 Thread Alspach, Vance

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 research, I discovered that COMO is a front-end for DIVERT.OUT.

However, COMO/DIVERT.OUT both work on our Dev box version 10.0.14 AIX 5.2 and 
on my personal version.

Has anybody else ever experience this?


Vance Alspach
John Deere Landscapes

CONFIDENTIALITY. This electronic mail and any files transmitted with it may 
contain information proprietary to Deere  Company, or one of its subsidiaries 
or affiliates, and are intended solely for the use of the individual or entity 
to whom they are addressed, shall be maintained in confidence and not disclosed 
to third parties without the written consent of the sender. If you are not the 
intended recipient or the person responsible for delivering the electronic mail 
to the intended recipient, be advised that you have received this electronic 
mail in error and that any use, dissemination, forwarding, printing, or copying 
of this electronic mail is strictly prohibited. If you have received this 
electronic mail in error, please immediately notify the sender by return mail.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] COMO OFF / DIVERT.OUT OFF

2009-06-22 Thread Mark Eastwood

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

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] COMO OFF / DIVERT.OUT OFF

2009-06-22 Thread Alspach, Vance

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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood
Sent: Monday, June 22, 2009 2:04 PM
To: U2 Users List
Subject: Re: [U2] COMO OFF / DIVERT.OUT OFF

Try comparing the VOC entry for OFF in your systems?

Mark


CONFIDENTIALITY. This electronic mail and any files transmitted with it may 
contain information proprietary to Deere  Company, or one of its subsidiaries 
or affiliates, and are intended solely for the use of the individual or entity 
to whom they are addressed, shall be maintained in confidence and not disclosed 
to third parties without the written consent of the sender. If you are not the 
intended recipient or the person responsible for delivering the electronic mail 
to the intended recipient, be advised that you have received this electronic 
mail in error and that any use, dissemination, forwarding, printing, or copying 
of this electronic mail is strictly prohibited. If you have received this 
electronic mail in error, please immediately notify the sender by return mail.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Basic Developer Toolkit - Eclipse SDK

2009-06-22 Thread Jo Lester

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, 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 website let alone finding people willing to put aside the
sort of time you would need for building toolsets.

No, to be blunt - what it needs is a community willing to put their money
where their mouths are and invest in the tools that are available, so it
then becomes worthwhile for tool vendors to spend the amounts of time and
money required to produce them. Creating quality tools is not trivial: in
most cases it takes a lot more work than creating the buiness applications
they help others to produce.

Unfortunately, it's all too usually the case that people will splash out on
tools like Visual Studio, and (if they are sensible) in buying the right
components to speed up client side development - but when it comes to their
multivalue system that is backing all of this, they simply refuse to pay for
anything that will help them. And then every so often people - often the
same people - complain that the tools aren't there. Hmmm - really?

But then 'twas ever thus... I wrote my first Windows based editor for
UniVerse (with all the bells and whistles you could ask for) back in 1990
and I continue as far as I can to develop tools today. And I'm not alone in
that: there are other tool vendors - including Doug - producing precisely
these types of tools for the U2 space.

But in the final analysis the tools I build today - editors, installation
tools, source code tools etc. - are there primarily to assist me and I have
to squeeze them out between paid work. Because by themselves in this market
they certainly don't pay the bills.

Brian

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

_
Bing™ brings you maps, menus, and reviews organized in one place. Try it now.
http://www.bing.com/search?q=restaurantsform=MLOGENpubl=WLHMTAGcrea=TEXT_MLOGEN_Core_tagline_local_1x1
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Basic Developer Toolkit - Eclipse SDK

2009-06-22 Thread Results


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 - Eclipse SDK




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 website let alone finding people willing to put aside the
sort of time you would need for building toolsets.

No, to be blunt - what it needs is a community willing to put their money
where their mouths are and invest in the tools that are available, so it
then becomes worthwhile for tool vendors to spend the amounts of time and
money required to produce them. Creating quality tools is not trivial: in
most cases it takes a lot more work than creating the buiness applications
they help others to produce.

Unfortunately, it's all too usually the case that people will splash out on
tools like Visual Studio, and (if they are sensible) in buying the right
components to speed up client side development - but when it comes to their
multivalue system that is backing all of this, they simply refuse to pay for
anything that will help them. And then every so often people - often the
same people - complain that the tools aren't there. Hmmm - really?

But then 'twas ever thus... I wrote my first Windows based editor for
UniVerse (with all the bells and whistles you could ask for) back in 1990
and I continue as far as I can to develop tools today. And I'm not alone in
that: there are other tool vendors - including Doug - producing precisely
these types of tools for the U2 space. 


But in the final analysis the tools I build today - editors, installation
tools, source code tools etc. - are there primarily to assist me and I have
to squeeze them out between paid work. Because by themselves in this market
they certainly don't pay the bills. 



Brian

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



_
Bing™  brings you maps, menus, and reviews organized in one place.   Try it now.
http://www.bing.com/search?q=restaurantsform=MLOGENpubl=WLHMTAGcrea=TEXT_MLOGEN_Core_tagline_local_1x1
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 8.5.339 / Virus Database: 270.12.87/2195 - Release Date: 06/22/09 06:54:00


  


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Simple Export to Excel

2009-06-22 Thread Colin Alfke

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 unique
about SB+ that would prevent any solution from anything else from working.

Colin

-Original Message-
From: Steve Romanow

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

Re: [U2] Basic Developer Toolkit - Eclipse SDK

2009-06-22 Thread Colin Alfke

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 do the
same thing...

Hth
Colin Alfke
Calgary, Canada

-Original Message-
From: Brian Leach

The only real downside is that I can't do
the same level of integration with the Basic debugger. That's probably the
one time you really do want to crank Eclipse into life.

Brian


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Simple Export to Excel


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 on the 
filesystem or possibly emailed (based on size limitations.)


I am thinking of a tool that is client agnostic.  Doesnt depend on 
anything running client side for the creation of the xls.


Colin Alfke wrote:

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 unique
about SB+ that would prevent any solution from anything else from working.

Colin

-Original Message-
From: Steve Romanow

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
  

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] uvRunCommand

2009-06-22 Thread David A Barrett

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 servers.  It works like a charm and 
requires very little setup to use and no programming to test and view the 
results.

An added advantage is that it runs from the Unix command line so we use it 
for a pantload of other things that don't touch on UV at all. For 
instance, we have a web enabled temperature sensor in our computer room. 
We have a cron job that runs every 15 minutes on one of our Unix servers, 
uses wget to grab the status page from the sensor and then runs the 
results through some cut and grep commands to whittle the results down 
to a singe number.  If it breaks a threshold then it starts sending text 
messages and emails to people.


Dave Barrett,
Lawyers' Professional Indemnity Company
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] uvRunCommand

2009-06-22 Thread u2list0512


Thanks for the info, but we are running Windows Server 2003 R2 in both cases.

At 6/22/2009 03:32 PM, you wrote:

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 servers.  It works like a charm and
requires very little setup to use and no programming to test and view the
results.

An added advantage is that it runs from the Unix command line so we use it
for a pantload of other things that don't touch on UV at all. For
instance, we have a web enabled temperature sensor in our computer room.
We have a cron job that runs every 15 minutes on one of our Unix servers,
uses wget to grab the status page from the sensor and then runs the
results through some cut and grep commands to whittle the results down
to a singe number.  If it breaks a threshold then it starts sending text
messages and emails to people.


Dave Barrett,
Lawyers' Professional Indemnity Company
___
U2-Users mailing list
U2-Users@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, FL 33602
Cell: (813) 293-2878 or (800) 886-2878
Home: (813) 226-2878 or (800) 524-2878
Fax: (813) 229-2878

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] COMO OFF / DIVERT.OUT OFF

2009-06-22 Thread Ron Hutchings

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 OFF / DIVERT.OUT OFF

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 research, I discovered that COMO is a front-end for DIVERT.OUT.

However, COMO/DIVERT.OUT both work on our Dev box version 10.0.14 AIX 5.2 and
on my personal version.

Has anybody else ever experience this?

Vance Alspach
John Deere Landscapes

CONFIDENTIALITY. This electronic mail and any files transmitted with it may
contain information proprietary to Deere Company, or one of its
subsidiaries or affiliates, and are intended solely for the use of the
individual or entity to whom they are addressed, shall be maintained in
confidence and not disclosed to third parties without the written consent of
the sender. If you are not the intended recipient or the person responsible
for delivering the electronic mail to the intended recipient, be advised that
you have received this electronic mail in error and that any use,
dissemination, forwarding, printing, or copying of this electronic mail is
strictly prohibited. If you have received this electronic mail in error,
please immediately notify the sender by return mail.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] uvRunCommand

2009-06-22 Thread Robert Porter

Just FYI, 
wget is quite handy, is opensource and is available for Windows as well...
http://gnuwin32.sourceforge.net/packages/wget.htm 
 
And notice the line: Wget works exceedingly well on slow or unstable 
connections...
That's VERY true - much more so than many other methods.
 
Besides using it means at least that aspect doesn't need to change when moving
your application from Windows to 'nix. 
 
Robert
 
Robert F. Porter, MCSE, CCNA, ZCE
Sr. Programmer / Analyst
Laboratory Information Services
Ochsner Health System
(504) 842 - 5185
 
 
 
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.


 u2list0...@curt.com 6/22/2009 2:48 PM 
Thanks for the info, but we are running Windows Server 2003 R2 in both cases.

At 6/22/2009 03:32 PM, you wrote:
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 servers.  It works like a charm and
requires very little setup to use and no programming to test and view the
results.

An added advantage is that it runs from the Unix command line so we use it
for a pantload of other things that don't touch on UV at all. For
instance, we have a web enabled temperature sensor in our computer room.
We have a cron job that runs every 15 minutes on one of our Unix servers,
uses wget to grab the status page from the sensor and then runs the
results through some cut and grep commands to whittle the results down
to a singe number.  If it breaks a threshold then it starts sending text
messages and emails to people.


Dave Barrett,
Lawyers' Professional Indemnity Company
___
U2-Users mailing list
U2-Users@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, FL 33602
Cell: (813) 293-2878 or (800) 886-2878
Home: (813) 226-2878 or (800) 524-2878
Fax: (813) 229-2878

___
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] uvRunCommand

2009-06-22 Thread Jeff Schasny

Wget is a great tool for retrieving web data however I prefer cURL
because it can be used to both get and send data. It too works on both
Unix and Windows.

Robert Porter wrote:
Just FYI,
wget is quite handy, is opensource and is available for Windows as well...
http://gnuwin32.sourceforge.net/packages/wget.htm

And notice the line: Wget works exceedingly well on slow or unstable connections...

That's VERY true - much more so than many other methods.

Besides using it means at least that aspect doesn't need to change when moving
your application from Windows to 'nix.

Robert

Robert F. Porter, MCSE, CCNA, ZCE

Sr. Programmer / Analyst
Laboratory Information Services
Ochsner Health System
(504) 842 - 5185

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.

u2list0...@curt.com 6/22/2009 2:48 PM

Thanks for the info, but we are running Windows Server 2003 R2 in both cases.

At 6/22/2009 03:32 PM, you wrote:

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 servers. It works like a charm and
requires very little setup to use and no programming to test and view the
results.

An added advantage is that it runs from the Unix command line so we use it
for a pantload of other things that don't touch on UV at all. For
instance, we have a web enabled temperature sensor in our computer room.
We have a cron job that runs every 15 minutes on one of our Unix servers,
uses wget to grab the status page from the sensor and then runs the
results through some cut and grep commands to whittle the results down
to a singe number. If it breaks a threshold then it starts sending text
messages and emails to people.

Dave Barrett,
Lawyers' Professional Indemnity Company
___
U2-Users mailing list
U2-Users@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, FL 33602
Cell: (813) 293-2878 or (800) 886-2878
Home: (813) 226-2878 or (800) 524-2878
Fax: (813) 229-2878

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Simple Export to Excel

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 another post, I'll mention here that people
are using our NebulaXLite from SB+, and it even displays progress
info through SBClient as it works through large reports.  And for
people who say use XML, well, that's exactly what NebulaXLite
does.

Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
Visit PickWiki.com!  Contribute!

 From: Robert Porter
 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.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Basic Developer Toolkit - Eclipse SDK [AD]

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 fully integrated with Visual
Studio:
- Edit, Compile, and Catalog MV BASIC code in VS 
- Maintain all configuration data to different systems in VS
- Maintain dict and data items in VS
- Create U2 files from VS
- Graphically create reports in VS
- If you wish, open a telnet window from VS too
In addition to that there are three libraries, one for core
development, one for ADO.NET development with MV (no data
flattening required) and one for directly binding data to
controls.

A soon-to-be-released major update for mv.NET will include
generation of rich class definitions from MV dictionaries, to be
used as DataSource objects.  See my blog for a discussion of this
topic:
nospam.pleaseNebula-RnD.com/blog/tech/mv/2008/11/mvcodegen2.html

I don't see a void that needs to be filled.  For a couple
hundred bucks you can do everything you've described.  Some
people say this should come from IBM but many people don't
realize that IBM did purchase the source for an older version of
mv.NET, rebranded it, limited the functionality, and they're now
marketing it under a different name.  So you have two options.
Of course I'd prefer that you contact me about mv.NET.  :)

HTH

Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
Nebula RD sells mv.NET and other Pick/MultiValue products
worldwide, and provides related development services
remove.thisNebula-RnD.com/blog 
Visit PickWiki.com!  Contribute!

 From: John J. Wahl
 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 I had to make them, but 
 because I didn't know there was a tool like BASIC 
 Developer Toolkit, or anything else for that matter 
 that fit into how I work now.  Even the U2 .NET add-on 
 doesn't really seem like it's the perfect solution 
 from what I've seen so far.  Perhaps what you have all 
 just explained really does say it all.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Basic Developer Toolkit - Eclipse SDK