Re: [U2] html 2 xls
I use xlwt for this kind of work. Its not perfect, but does what I need. Will need a developer to setup your html -> xls transform. On Mon, Apr 25, 2011 at 3:37 PM, wrote: > Anyone know of a conversion tool that will take html and produce xls > (Excel spreadsheet) formatted files? > We are running UniData on HPUX but could probably use a utility on a > windows server if necessary. > > Thanks! > > Shaun Ferguson > Applications Architect I > Wolseley Group Services - 12500 Jefferson Avenue - Newport News - VA - > 23602-4314 > T: (757) 989-2916 - F: (757) 989-2801 - E: shaun.fergu...@wolseley.com > www.wolseley.com http://www.wolseley.com/> > Wolseley plc registered office Parkview 1220 Arlington Business Park > Theale Nr Reading RG7 4GA United Kingdom > Registration No. 29846 England > > > ___ > 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] html 2 xls
Is the HTML just a collection of table rows and columns? (table)(tr) and (td)'s? If so, Excel should load it just fine. You might need to use the (F)ile, Open instead of just clicking on it (which would open the browser). George > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of shaun.fergu...@ferguson.com > Sent: Monday, April 25, 2011 3:38 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] html 2 xls > > Anyone know of a conversion tool that will take html and produce xls > (Excel spreadsheet) formatted files? > We are running UniData on HPUX but could probably use a utility on a > windows server if necessary. > > Thanks! > > Shaun Ferguson > Applications Architect I > Wolseley Group Services - 12500 Jefferson Avenue - Newport News - VA - > 23602-4314 > T: (757) 989-2916 - F: (757) 989-2801 - E: shaun.fergu...@wolseley.com > www.wolseley.com http://www.wolseley.com/> > Wolseley plc registered office Parkview 1220 Arlington Business Park > Theale Nr Reading RG7 4GA United Kingdom > Registration No. 29846 England > > > ___ > 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] html 2 xls
Anyone know of a conversion tool that will take html and produce xls (Excel spreadsheet) formatted files? We are running UniData on HPUX but could probably use a utility on a windows server if necessary. Thanks! Shaun Ferguson Applications Architect I Wolseley Group Services - 12500 Jefferson Avenue - Newport News - VA - 23602-4314 T: (757) 989-2916 - F: (757) 989-2801 - E: shaun.fergu...@wolseley.com www.wolseley.com http://www.wolseley.com/> Wolseley plc registered office Parkview 1220 Arlington Business Park Theale Nr Reading RG7 4GA United Kingdom Registration No. 29846 England ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Saying Goodbye...
Hi Karl, Your story/post sound very similar to one that I would post. I am relatively new to this forum and have not posted much either. I too am a 25+ year veteran of Pick/Multivalue/U2 sytems and find myself unemployed. I live in Canada and in the past 6 months or so, there has been 2 Pick related job posting. So I too am trying to abandon Pick as my wife and kids need cash to survive :-). Best wishes and congrats on your new job. Elio Karl Pearson wrote: > > I'm not sure if most, or any, of you actually know me, but here's what > amounts to my swan song. > > For the past 18+ years I've been a decent UV DBA. I took classes from Mark > Baldridge and later Joel Yates way back when to learn how to manually > repair corrupt files, and was proficient before uniVerse became so stable > that corrupt files happened infrequently and fixtool worked. > > But during that time, I've maintained a personal email and web server, > running Majordomo v1.94.5, etc. and have learned a bit about the LAMP > stack in so doing. > > I've been a layed-off DBA, for a small retail company, for the past 22 > months, consulting my previous employer because they got rid of me so they > could have salary cap to hire a different type of IT manager and move off > UV to Profit21, which failed after $250,000 lost. They are back on UV and > will stay now. > > I, however, have to move on because I've received the proverbial offer one > can't refuse ($5000US signing bonus and the option for 5000 shares of > company stock), plus no one in the 'PICK' world has offered me anything, > though there may be a few things still in the works, which will now go > quietly away. I will be working in the LAMP world now, making a living > doing my hobby, so to speak. (FYI: LAMP = Linux, Apache, MySQL and PHP or > Perl, depending on who you listen to) > > I may hang around on the list for a bit, but will eventually have to > unsubscribe as my life moves farther and father away from a field I have > grown to respect and enjoy. Best wishes to all of you, and like others > before me, I'm sure I'll miss the group association you've provided, > though I'm mostly just a quiet observer. > > Thanks and I'll never forget this group of intelligent, insightful, > thought-provoking and often entertaining, professionals. > > --- > Karl Pearson > ka...@ourldsfamily.com > Owner/Administrator of the sites at > http://ourldsfamily.com > --- > "To mess up your Linux PC, you have to really work at it; > to mess up a microsoft PC you just have to work on it." > --- > Democracy is two wolves and a lamb voting on what to have > for lunch. Liberty is a well-armed lamb contesting the vote. > --Benjamin Franklin > --- > Children seldom misquote you. In fact, they usually > repeat word for word what you shouldn't have said. > --- > > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > -- View this message in context: http://old.nabble.com/Saying-Goodbye...-tp28702652p31472264.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Very Weird Trigger Behavior
Thanks for the info, Shaun. Shaun.Ferguson wrote: > > HP Itanium > UniData Release 7.1 > Basictype p > > Records cannot be deleted from TCL (ECL?) even with a select list > active: > > 1 records selected to list 0. > >>DELETE COUNTY > Do you want to delete records in select list?(Y/N) Y > 'KEY':cannot be deleted, due to trigger constraint. > > --- > > Wow! This is really similar to what I'm trying to do. What is your: OS, > Unidata version, BASICTYPE? > > Also, are you having success with both ECL DELETEs and UniBasic DELETEs? > > Thanks! > > Jonathan > > > Shaun.Ferguson wrote: >> >> We are doing this with a county and zip file - the trigger is on the >> county file and a record cannot be deleted if it's referenced in the > zip >> file: >> >> SUBROUTINE TRIG.COUNTY.DEL (EXECSTAT, DICTFLAG, FILENAME, COUNTY_ID) >> EQU DELETE_DENIED TO 0 >> EQU DELETE_ALLOWED TO 1 >> >> EXECSTAT = DELETE_DENIED >> >> IF (UNASSIGNED(FILENAME) OR (FILENAME NE "COUNTY")) THEN >>RETURN >> END >> IF (UNASSIGNED(COUNTY_ID) OR (TRIM(COUNTY_ID) EQ "")) THEN >>RETURN >> END >> >> CMD = 'SELECT P_ZIP WITH COUNTY_ID EQ "':COUNTY_ID:'"' >> ZIP_LIST = "" >> EXECUTE CMD RTNLIST ZIP_LIST CAPTURING OUTPUT >> >> IF @SYSTEM.RETURN.CODE EQ 0 THEN >>EXECSTAT = DELETE_ALLOWED >> END >> RETURN >> >> Shaun Ferguson >> Applications Architect I >> Wolseley Group Services - 12500 Jefferson Avenue - Newport News - VA - >> 23602-4314 >> T: (757) 989-2916 - F: (757) 989-2801 - E: shaun.fergu...@wolseley.com >> www.wolseley.com http://www.wolseley.com/> >> Wolseley plc registered office Parkview 1220 Arlington Business Park >> Theale Nr Reading RG7 4GA United Kingdom >> Registration No. 29846 England > > > Shaun Ferguson > Applications Architect I > Wolseley Group Services - 12500 Jefferson Avenue - Newport News - VA - > 23602-4314 > T: (757) 989-2916 - F: (757) 989-2801 - E: shaun.fergu...@wolseley.com > www.wolseley.com http://www.wolseley.com/> > Wolseley plc registered office Parkview 1220 Arlington Business Park > Theale Nr Reading RG7 4GA United Kingdom > Registration No. 29846 England > > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > -- View this message in context: http://old.nabble.com/Very-Weird-Trigger-Behavior-tp31450305p31471381.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Very Weird Trigger Behavior
Hi, Kevin. Shaun wasn't reporting a problem. He was answering my questions about his trigger that does what I'm trying to do. Kevin King-2 wrote: > > Shaun, have you checked the trigger code on that file? > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > -- View this message in context: http://old.nabble.com/Very-Weird-Trigger-Behavior-tp31450305p31471367.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
