RE: [U2] Excel from Unidata
Mr. Angliss: It seems that there's been some namespace shuffling. To generate binary excel files, use Spreadsheet::SimpleExcel, documented here: http://cpan.uwinnipeg.ca/htdocs/Spreadsheet-SimpleExcel/Spreadsheet/SimpleExcel.html For the new-fangled XML format that Microsoft is moving toward, use Spreadsheet::WriteExcelXML, documented here: http://cpan.uwinnipeg.ca/htdocs/Spreadsheet-WriteExcelXML/Spreadsheet/WriteExcelXML.html Thanks, Michael Doyle Linux Administrator / Developer On Fri, 2006-03-17 at 18:55 +, Piers Angliss wrote: Dave, There were a number of suggestions a few months ago, the more straightforward were along the lines of write csv or xml and let Excel sort it out. If you specifically want a .xls file then Michael Doyle posted : quote On UNIX, use Perl. Specifically, use the Spreadsheet::WriteExcel and Text::CSV modules. My csv2xls.pl script is only about 47 lines long. The Spreadsheet::WriteExcel module was utter garbage a few years ago, but thanks to the efforts of OpenOffice.org and the obvious benefits of open source software, the module has improved by leaps and bounds. /quote I don't know Perl but Google will probably yield some clues hth Piers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Tabor Sent: 17 March 2006 16:39 To: u2-users@listserver.u2ug.org Subject: [U2] Excel from Unidata Hi, I'd like to be able to create an excel file from a Unidata program to be used for download on a website, without any user intervention. Can anyone offer any tips/tricks to make this a simple process? Thanks, Dave PS: Unidata 6.0 / AIX 5.1 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Running a command from / via PCPERFORM
On Mon, 2006-03-13 at 17:08 -0500, Timothy Snyder wrote: Dean Armbruster wrote on 03/13/2006 04:33:27 PM: PCPERFORM can do multiple commands. Separate them with a linefeed (char(10)). snip This is on HP-UX with the Bourne shell. I don't know about other shells, other unix, or Windows. Unfortunately, this won't work on Windows. Neither will the semicolon as proposed in a previous posting. On Windows you can use an ampersand as a line separator. Of course, if you use that same construct in UNIX you'll get totally different results (possibly amusing, possibly frightening, definitely incorrect), since anything preceding the ampersand will be launched as a background process with the rest being tossed. But what if we use TWO ampersands?! It's so crazy, it just might work: cd something runcommand In both DOS and Bourne this command will change directory to something and, if that succeeded, execute runcommand. How you get 'something' to be '\' in DOS and '/' in UNIX is up to you. Which is to say, I don't think it's possible. Thanks, Michael Doyle Linux Administrator / Developer AMO Recoveries --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] A Jar Launching A Jar
So with a java app like this: class Hello{ public static void main(String args[]){ System.out.println(Hello World\n); } } saved to Hello.java and compiled to Hello.class, it seems that the following application will launch it: import java.io.*; public class CmdExec { public static void main(String argv[]) { try{ Process p = Runtime.getRuntime().exec(java Hello); BufferedReader input = new BufferedReader ( new InputStreamReader( p.getInputStream() ) ); String line; while( (line = input.readLine()) != null ) { System.out.println(line); } input.close(); return; }catch(IOException e){ System.err.println(Hope you're a java developer:); e.printStackTrace(); } }//main }//class CmdExec I pretty much snarfed this code from http://www.rgagnon.com/javadetails/java-0014.html fwiw. No EJB or J2EE. No Swing, for that matter, but Swing is just a GUI extension, so this should work fine. Mike Doyle Unix Developer / Administrator AMO Recoveries On Wed, 2006-02-08 at 10:50 -0500, Brutzman, Bill wrote: Without using EJB, can an executable Java program (.JAR) launch another JAR? That is, not using J2EE, what is the Java source-code command to launch a Swing application from a Swing menu? --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Simple OT question
Evidently, it's a C-14 inlet socket: http://en.wikipedia.org/wiki/IEC_60320_C13 which lies terribly often, but links to: http://www.accesscomms.com.au/iec320.htm and the images.google.com gives you: http://images.google.com/images?svnum=10hl=ensafe=offq=c14 +inletspell=1 Mike Doyle Unix Administrator / Developer AMO Recoveries, Inc. On Sun, 2006-02-05 at 08:40 -0500, Mark Johnson wrote: With every computer (and other) connector having a 'name', ie cat-5, db25 etc, what is the name of the female end (computer end) of the AC power cord? No joke, just curious. Thanks in advance. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] making a .csv file into an .xls file?
The convention, as I understand it, for handling embedded commas in of csv data is to wrap each datum in double quotes. This cheerfully introduces the problem of embedded double quotes in of csv data, of course, and the conventional solution is to substitute two adjacent double quotes for each double quote. Very easy to generate, but it makes writing csv parsing routines deplorable. Your parser has to have 1-character of read-ahead to distinguish an embedded double quote from the end of the cell. TAB-delimited files do avoid this situation, but bank on your not having tabs in your data. I am not aware of any conventional method for dealing with tab-embedded tab-delimited data. Almost makes XML seem like a good idea. Mike Doyle Unix Developer / Administrator AMO Recoveries On Fri, 2006-01-13 at 14:01 -0800, Kent Walker wrote: George, Mike is right - a Perl script can make the conversion easy and highly automated. However, I like to use TAB-delimited output to avoid the occasional messy situation when valid data contains commas or quotes. Write the program or paragraph such that it generates a text file and then shells to the Perl program to do the conversion. ActiveState's Perl for Windows does have the Spreadsheet::WriteExcel and Text::CSV modules available. Let me know if you want some samples to hack. Kent At 01:02 PM 1/13/2006, Michael Doyle wrote: On UNIX, use Perl. Specifically, use the Spreadsheet::WriteExcel and Text::CSV modules. My csv2xls.pl script is only about 47 lines long. The Spreadsheet::WriteExcel module was utter garbage a few years ago, but thanks to the efforts of OpenOffice.org and the obvious benefits of open source software, the module has improved by leaps and bounds. On Windows, I can only presume that Visual Basic can generate Excel spreadsheets. Mike Doyle Unix Developer / Administrator AMO Recoveries On Fri, 2006-01-13 at 14:45 -0500, George Gallen wrote: Our UV system creates an ASCII .csv file for another system to import on a daily basis. The 3rd party software after a recent upgrade now only imports .xls files. Is there an easy way to automate Excel to load the .csv, then save as .xls? Or how much more difficult is it to create the .xls instead of a .csv? I thought about getting one of those programs that records mouse clicks, and create a macro of the conversion (since the filename is the same each day), but wonder if there was something we could do in a batch file and run every day under the Windows scheduler. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- --- Kent Walker - Datatel Analyst Information Technology - U.C. Hastings College of the Law 415-565-4635 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] FW: sudo
Two questions: Which platform are you on, and how are you editing the sudoers file? On RHEL, you can't just edit the file, you use the command visudo which will file and compile the sudoers file, so to speak. Mike Doyle Unix Developer / Administrator AMO Recoveries On Fri, 2006-01-13 at 07:14 -0500, Wronkiewicz, Terrie wrote: Hi All, I am attempting to make sudo work for our IS users with unix level access. I have put myself in the sudoers file as follows: myloginname ourtestboxname = PASSWD:ALL However when I do: sudo ls -al It says: myloginname is not in the sudoers file. This incident will be reported. What am I doing wrong? Thanks, Terrie --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] making a .csv file into an .xls file?
On UNIX, use Perl. Specifically, use the Spreadsheet::WriteExcel and Text::CSV modules. My csv2xls.pl script is only about 47 lines long. The Spreadsheet::WriteExcel module was utter garbage a few years ago, but thanks to the efforts of OpenOffice.org and the obvious benefits of open source software, the module has improved by leaps and bounds. On Windows, I can only presume that Visual Basic can generate Excel spreadsheets. Mike Doyle Unix Developer / Administrator AMO Recoveries On Fri, 2006-01-13 at 14:45 -0500, George Gallen wrote: Our UV system creates an ASCII .csv file for another system to import on a daily basis. The 3rd party software after a recent upgrade now only imports .xls files. Is there an easy way to automate Excel to load the .csv, then save as .xls? Or how much more difficult is it to create the .xls instead of a .csv? I thought about getting one of those programs that records mouse clicks, and create a macro of the conversion (since the filename is the same each day), but wonder if there was something we could do in a batch file and run every day under the Windows scheduler. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] System Migration issues
Test your assumption by performing some manner of CRC on the files before and after transit. If you can perform an md5 checksum on AIX, Redhat will have a compatible program called md5sum. But realistically, ftp file transfer should have nil affect on the files. -Mike Doyle Unix Developer / Administrator AMO Recoveries On Thu, 2006-01-12 at 09:42 -0500, Sirulnick, Steve wrote: I am migrating an old AIX server running U2 to RH Linux. Because of the server's limitations, I need to transfer files between the two devices via FTP and then converting the files for Linux use. After doing so, my distributed files are getting corrupted. It looks like the IBM provided fixtool utility repairs the files, but it's taking way too long for my larger distributed files. Making a HUGE assumption that it's the file transfer responsible for the file corruption, is there a preferred method for copying data files? Steve --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV: Other ways of replicating?
UniVerse users, Recently, we've been looking at ways of developing a high availability cluster for our production UniVerse environment. Thanks to www.linux-ha.org we've been able to install two machines at different locations (cities twenty miles apart) and if the primary machine drops, users can log into the same IP address within a few seconds. The problem we have run into is replicating our data across the two nodes. The best way would be database replication. Unfortunately, UniVerse can't replicate the type 1 and type 19 files, which we use extensively. Further, we cannot use ALTER.TABLE or CLEAR.FILE on replicated files. (These from the Administrators manual.) The second option we've looked at is some sort of disk replication. IBM recommends DRBD for use with DB2. Unfortunately, it seems that this would not provide referential integrity. The third option we looked at was a complicated mix of transaction logs and NFS mounts. Our standby box would be constantly updating itself off of the transaction logs of the primary. In the event of an outage, the standby comes up more or less updated and the dead primary can refresh itself off of the standby's logs when it comes back up. Does anyone have any experience getting around the shortcomings of UniVerse's replication? Thanks, Mike Doyle Unix Developer / Administrator --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Emails into AIX
Mr. Witney: If you don't want to deal with the horrors of sendmail.cf, the quick and dirty way on any old Unix would be to create a system user with a crontab entry that checks mail every minute or so and greps the message contents for a command to run. Use perl. -Mike Doyle On Wed, 2005-12-07 at 08:55 +, Bob Witney wrote: I am happily using sendmail to email from the aix boxes but I need to be able to email into the aix box to trigger automatioc process Is anyone doing this How do I set it up ? Thanks Bob __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2][UV] Aborted Shutdown
UniGurus: We shutdown UniVerse nightly to perform a full data backup with a simple /etc/rc.d/init.d/uv.rc stop command. Twice in the past week this process has errored out with: Not all UniVerse processes were successfully terminated. 1 process(es) still attached to main UniVerse memory segment UniVerse has NOT been successfully terminated. Aborting shutdown request Any ideas? RTFM yields nothing. I'm imagining that this might be a shared-memory related problem. UniVerse 10.1 running on RHEL3. Thanks in advance, Mike Doyle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2][UV] Aborted Shutdown
Mr. Banker: Not manually, no. We simply call /etc/rc.d/init.d/uv.rc stop This problem has only happened twice recently. I don't believe we're using too many seats or anything. What makes you think licenses? Thanks, Mike Doyle On Mon, 2005-12-05 at 11:54 -0600, Jerry Banker wrote: Do you clean up the licenses before do this? - Original Message - From: Michael Doyle [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, December 05, 2005 10:23 AM Subject: [U2][UV] Aborted Shutdown UniGurus: We shutdown UniVerse nightly to perform a full data backup with a simple /etc/rc.d/init.d/uv.rc stop command. Twice in the past week this process has errored out with: Not all UniVerse processes were successfully terminated. 1 process(es) still attached to main UniVerse memory segment UniVerse has NOT been successfully terminated. Aborting shutdown request Any ideas? RTFM yields nothing. I'm imagining that this might be a shared-memory related problem. UniVerse 10.1 running on RHEL3. Thanks in advance, Mike Doyle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2][UV] Aborted Shutdown
Mr. Dattani: Thanks for the informative reply. Our homebrew shutdown script reports zero users logged in just prior to execution of uv.rc stop. It might be wrong, I suppose. I might also want to examine the output of ps for any zombie processes as well. These seem like out-on-a-limb suggestions, though. Thanks again, Mike Doyle On Mon, 2005-12-05 at 17:54 +, [EMAIL PROTECTED] wrote: Hi Michael, Hardly a guru, but fwiw I think the problem is likely to be a user process that has not completely died. When Universe starts, it creates a shared memory segment for its own use. As users login, a shared memory segment is created for each user. When the user logs off, the shared memory segment is removed. Before Universe shuts down, the script checks that there are no user shared memory segments left. If you execute the command ipcs -mop | grep ace at the Unix shell prompt, it will list all the shared memory segments in use by Universe. One of the processes will be owned by root (or possibly uvadm), and the others will be user processes. My guess is that a user is either still logged on when you do your shutdown, or is somehow left in a partially logged off state. Either way, the above command should identify the user concerned. hth, asvin. Michael Doyle [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/12/2005 16:23 Mail Size: 4539 Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject [U2][UV] Aborted Shutdown Entity Investment Banking Europe - IBEU UniGurus: We shutdown UniVerse nightly to perform a full data backup with a simple /etc/rc.d/init.d/uv.rc stop command. Twice in the past week this process has errored out with: Not all UniVerse processes were successfully terminated. 1 process(es) still attached to main UniVerse memory segment UniVerse has NOT been successfully terminated. Aborting shutdown request Any ideas? RTFM yields nothing. I'm imagining that this might be a shared-memory related problem. UniVerse 10.1 running on RHEL3. Thanks in advance, Mike Doyle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ HSBC Bank plc may be solicited in the course of its placement efforts for a new issue, by investment clients of the firm for whom the Bank as a firm already provides other services. It may equally decide to allocate to its own proprietary book or with an associate of HSBC Group. This represents a potential conflict of interest. HSBC Bank plc has internal arrangements designed to ensure that the firm would give unbiased and full advice to the corporate finance client about the valuation and pricing of the offering as well as internal systems, controls and procedures to identify and manage conflicts of interest. HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ, United Kingdom Registered in England - Number 14259 Authorised and regulated by the Financial Services Authority. - This transmission has been issued by a member of the HSBC Group HSBC for the information of the addressee only and should not be reproduced and/or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] Aborted Shutdown
Mr. Roberts: uv.rc -stop is being run as root, however. Wouldn't it then be able to unlock the semaphore? Thanks, Mike Doyle On Mon, 2005-12-05 at 11:01 -0800, Keith W. Roberts wrote: Just a thought ... are there any UV processes running as root? Perhaps uv.rc -stop doesn't stop those for some reason. I recall a discussion recently about someone always running such a process in case a user process running PORT.STATUS aborted, leaving the semaphore locked, in which case only a root (uvadm?) process can unlock it. -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, December 05, 2005 9:54 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] Aborted Shutdown Hi Michael, Hardly a guru, but fwiw I think the problem is likely to be a user process that has not completely died. When Universe starts, it creates a shared memory segment for its own use. As users login, a shared memory segment is created for each user. When the user logs off, the shared memory segment is removed. Before Universe shuts down, the script checks that there are no user shared memory segments left. If you execute the command ipcs -mop | grep ace at the Unix shell prompt, it will list all the shared memory segments in use by Universe. One of the processes will be owned by root (or possibly uvadm), and the others will be user processes. My guess is that a user is either still logged on when you do your shutdown, or is somehow left in a partially logged off state. Either way, the above command should identify the user concerned. hth, asvin. Michael Doyle [EMAIL PROTECTED] Subject [U2][UV] Aborted Shutdown UniGurus: We shutdown UniVerse nightly to perform a full data backup with a simple /etc/rc.d/init.d/uv.rc stop command. Twice in the past week this process has errored out with: Not all UniVerse processes were successfully terminated. 1 process(es) still attached to main UniVerse memory segment UniVerse has NOT been successfully terminated. Aborting shutdown request Any ideas? RTFM yields nothing. I'm imagining that this might be a shared-memory related problem. UniVerse 10.1 running on RHEL3. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Large UV VAR abandons Microsoft SQL Server/.NET Effort
On Mon, 2005-07-25 at 13:37 -0500, Jerry Banker wrote: In the same note read this article: http://update.informationweek.com/cgi-bin4/DM/y/hpNU0GTFXz0G6t0DY2x0Encle: Invalid URL. -- Mike Doyle [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] OCONV of no affect.
Brian Leach wrote: BTW, why did microsoft assign (-1) as true. I don't think (1) works as true and, while being 'not zero', is hard to use mathematically. Binary. As an UNSIGNED integer, -1 is all 1s. An unsigned negative value, huh? -- Mike Doyle [EMAIL PROTECTED] Unix Developer Asset Management Outsourcing, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/