RE: [U2] Pushing csv
We automatically send CSV-formatted ASNs (Advance Ship Notices), but use the following to send them as an attachment that, to the user, appears to be an Excel spreadsheet. Some of the more informative lines would be: 027: MAIL.TO.EMAIL1,1 = mailto:'[EMAIL PROTECTED]' '[EMAIL PROTECTED]' 028: MAIL.TO.NAME1,1 = 'ASN List' 029: MAIL.SUBJECT = ASN for :OCONV(DATE(), D2/) 030: MAIL.CONTENT.TYPE1,1 = 'text/plain' 031: MAIL.HEADER.USE = 'DEFAULT-ONLY' 032: MAIL.MULTIPART = 'Y' 033: 034: * Send generated spreadsheet via email 035: MAIL.TEXT1,1,1 = 'EDI ASN for ':OCONV(DATE(), D2/) 036: MAIL.TEXT1,1,1 := . Please send any comments to [EMAIL PROTECTED] 037: MAIL.TEXT1,2 = '' 038: MAIL.CONTENT.TYPE1,2 = 'application/vnd.ms-excel' 039:READV HOME.PATH FROM CONTROL,'HOMEPATH',1 ELSE 040: HOME.PATH = /export/home/ftptrans 041:END 042: MAIL.ATTACH.FILES1,2 = HOME.PATH:'/':SPRDSHT.NAME We then call a generic subroutine, SEND.MIME.EMAIL, that attaches the generated CSV file and bangs directly on the mail server to send it out. Hope this helps. If you'd like more details, contact me off list and I'll be happy to answer questions. -- Dave Walker Programmer/Analyst Ivy Hill - Louisville (502) 473-2811 *IBM Certified Solutions Expert *U2 Family Application Development --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Installing UniObjects [not-secure]
In my experience the syntax is: uvrpc 31438/tcp Mark Hennessey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, November 08, 2007 10:02 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Installing UniObjects I think I remember one other step I had to do last time I installed it. In /etc/services, add the line: 31438uvrpc or is that 31438unirpc I never can remember, but I think it's the former. HTH, Karl quote who=John Hester -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Thursday, November 08, 2007 2:23 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] [UV] Installing UniObjects I want to install UniObjects on the server side on our... HP-Ux v11i with UniVerse v10. I am unable to locate any installation instructions. I would like to do UniObjects for Java. Suggestions would be appreciated. --Bill It's been a while since I did a new install, but I think all you need to do on the server side is make sure the unirpc service is running. You can start it from Package -- Rpc administration on the UV master menu. You'll need this file: `cat /.unishared`/uojsdk/lib/asjava.zip on the client side to connect to the server. I think it's installed on the server by default when you install UV. If you're doing desktop applets, you may wan't asjava_p.zip too. It allows a proxy connection so you can get data from the client-side java sandbox back to the UV server. -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 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. --- 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] Pushing csv
Chuck, If you don't send the Content-length, the browser will have no idea how much data it should expect during download. If you want the transfer size to be shown during download then you need to provide the total Content-length of the HTTP message body. Remember: this includes ALL characters in the body after the first CRLF that starts the body section of the response(CR,LF,FF,etc). DATA1=1,2,3,4 DATA2=5,6,7,8 If DATA1 and DATA2 are sent to the browser with UV adding CRLF combos for each attribute of DATA then the total Content-length would be 18. 14 for the visible chars and 4 for both CRLF combos. If you notice your download coming up short on a few characters, then check your content length calculator. As far as forcing a download, just set the MIME-type to a bogus application value. Content-type: application/keyally. The browser will prompt the user to determine how to handle the keyally document type. To take this a step further, you could write your own CSV import utility for the O/S and update the O/S file handling to match. Set file types of .keyally and also MIME types of application/keyally to open with insert import tool. Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 E-mail: [EMAIL PROTECTED] Web: http://www.all-spec.com Blog: http://blog.all-spec.com -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Rex Gozar Sent: Thursday, November 08, 2007 5:43 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Pushing csv Charles, To have the browser treat your data stream as a download, you need to set the HTTP header Content-type: application/download. This needs to be set in the header, not the HEAD section. Universe has the setRequestHeader() function, but the documentation is not clear on how to set the body of the data. Normally, an HTTP response is pretty straightforward: 001: Content-type: application/download 002: 003: some,comma,delimited,data 004: some,comma,delimited,data Omit the line numbers. The HTTP header is separated from the content using a blank line (linefeed). I don't think any other headers are required (but I could be wrong.) Content-length is nice to have. Note that you can experiment with other mime-types to get the download to open in an application. rex --- 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] Installing UniObjects
I'm on uniVerse version 10.1.7 and it's not there. I'm expecting to upgrade to 10.2.4 soon, so we'll see. Karl quote who=Ray Wurlod As far as I'm aware (in version 10) it's just there - you don't need to install anything. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 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. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Putting Universe on a SAN
I know I saw some information on this list about not putting Universe on a SAN. Does anyone have that information readily available? Does anyone know if the problems they were having were fixed or could be fixed? We are thinking of putting our Universe data accounts, not the runtime, on a SAN and using replication to another SAN off site. There will be other databases on the SAN, FoxPro and SQL Server, Will this cause a problem? Are any of you doing this? What kind of results are you getting? UV is on Red Hat the others are on Windows will that be a problem? Jerry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Putting Universe on a SAN
re SAN's and Universe: DELETE.FILE and RESIZE.FILE will not work on dynamic files that are NFS mounted. (Universe keeps the DATA.30 file open while trying to delete the enclosing directory. This will fail on an nfs mounted directory.) Override the VOC entry with your own version. Do not access a snapshot of a file from the same mount as the original. At least on NetApps, the inode of the snapshot will be the same as the inode of the original. Universe will confuse the data. Besides the usual caveats about making sure that a single machine controls locks for any given file, it is also worthwhile to keep the NFS under a set folders(4-6 or so) and then give each of these folders its own mount point on the host machine. Effectively creating multiple devices under UV. Of course: do not try this without a good UPS. Most SAN's have one built in too. Corruption of a group is still possible, but our experience has been good. My advice would be to replicate snapshots rather than live data (Unless you are using Uv Replication). With snapshots, you can temporarily suspend IO, take a snapshot, and continue. If you are doing live replication at the SAN level, then a major problem (an errant DELETE.FILE, for instance) will be replicated on your backup SAN. Also, suspending IO will avoid catching files in transitional states. Good Luck! -Rick Nuckolls Lynden, Inc On Nov 9, 2007, at 11:01 AM, Jerry Banker wrote: Does anyone know if the problems they were having were fixed or could be fixed? Not at 10.2.2 for those mentioned above. I have not used Uv Data Replication. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Putting Universe on a SAN
They're talking about mounting the SAN through a fiber channel instead of NFS or Samba. Will the same problem apply. -Original Message- From: Richard Nuckolls [mailto:[EMAIL PROTECTED] Sent: Friday, November 09, 2007 3:13 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Putting Universe on a SAN re SAN's and Universe: DELETE.FILE and RESIZE.FILE will not work on dynamic files that are NFS mounted. (Universe keeps the DATA.30 file open while trying to delete the enclosing directory. This will fail on an nfs mounted directory.) Override the VOC entry with your own version. Do not access a snapshot of a file from the same mount as the original. At least on NetApps, the inode of the snapshot will be the same as the inode of the original. Universe will confuse the data. Besides the usual caveats about making sure that a single machine controls locks for any given file, it is also worthwhile to keep the NFS under a set folders(4-6 or so) and then give each of these folders its own mount point on the host machine. Effectively creating multiple devices under UV. Of course: do not try this without a good UPS. Most SAN's have one built in too. Corruption of a group is still possible, but our experience has been good. My advice would be to replicate snapshots rather than live data (Unless you are using Uv Replication). With snapshots, you can temporarily suspend IO, take a snapshot, and continue. If you are doing live replication at the SAN level, then a major problem (an errant DELETE.FILE, for instance) will be replicated on your backup SAN. Also, suspending IO will avoid catching files in transitional states. Good Luck! -Rick Nuckolls Lynden, Inc On Nov 9, 2007, at 11:01 AM, Jerry Banker wrote: Does anyone know if the problems they were having were fixed or could be fixed? Not at 10.2.2 for those mentioned above. I have not used Uv Data Replication. --- 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] Putting Universe on a SAN
Well, this would be a not-so-good way to go. The big sticking point in this particular scenario is that you're sharing the SAN. I know, that's part of the point of having one. But what happens is that UniVerse is requesting relatively small I/O from the OS, typically 4, 8, or 16K per request, and usually lots of those. Other things don't necessarily do the same thing; a foxpro page could also bring up pictures and very pretty graphics, so you may get a 1 Mb request from the SAN for that. While it's servicing that 1Mb request, UV's 4K requests often are piling up in the queue. Then we have to consider thinks like how you've carved out your metas luns, stripe sizes (I've seen places with 960K stripe sizes, to service 16K requests...), how many actual spindles have you got uv on, etc. Steve O'Neil has been point on these issues, and is probably the fellow with whom you want to speak. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Friday, November 09, 2007 2:02 PM To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED] Subject: [U2] Putting Universe on a SAN I know I saw some information on this list about not putting Universe on a SAN. Does anyone have that information readily available? Does anyone know if the problems they were having were fixed or could be fixed? We are thinking of putting our Universe data accounts, not the runtime, on a SAN and using replication to another SAN off site. There will be other databases on the SAN, FoxPro and SQL Server, Will this cause a problem? Are any of you doing this? What kind of results are you getting? UV is on Red Hat the others are on Windows will that be a problem? Jerry --- 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] Pushing csv - solution and [AD] Real spreadsheets
From: Dave Walker We automatically send CSV-formatted ASNs (Advance Ship Notices), ...that, to the user, appears to be an Excel spreadsheet. NebulaXLite generates real formatted Excel spreadsheets from BASIC. The documents can also be opened from OpenOffice and Google Docs. You don't need Excel at all, and it's much better than a CSV. Apropos to this thread, rather than pushing CSV to a browser, rap the data in HTML. A simple table will do - do not include HTML or BODY tags, start with TABLE. Then use ContentType: application/vnd.ms-excel Other MIME types to try: application/excel application/x-excel application/x-msexcel With NebulaXLite, just save the file to a web server as .xls. When the user opens it with a plain link, it opens with Excel in the browser in edit mode. Click the example on the page below. Tony Gravagno Nebula Research and Development http:// remove.pleaseNebula-RnD.com/products/xlite.htm http:// remove.thisNebula-RnD.com/forum (See notes about Excel to MV too, including free source code) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/