RE: [U2] Importing data from OS file
So what is the suggestion? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Firl Sent: Tuesday, July 20, 2004 12:59 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Importing data from OS file An easy way (if you are on a Linux/Unix box), would be to create a pseudo-floppy drive on your system in the DEVICE file Lee, Thanks for the suggestion. I was aware of this capability on UNIX platforms, but I require a solution that works on UNIX and Windows, as well as jBASE and Universe. In the absence of standard bulk file loading utility for MV, I started working on my own. Tom Firl --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Importing data from OS file
Below is Lee's suggestion (post)... In short, Lee is describes how to setup a Universe tape device that uses a file instead of a block device for reading and writing the i/o stream. Note, I do not believe this will work on Windows (or so I've been told by Universe tech support, and a few others). The DEVICE file can be edited from the UV account. I think there is a definition of the attributes on the Universe Admin manual... I can dig it up if you need it and can't find it. Basically, you are working on the same file when you create or change a tape devices in Uniadmin or from the UV account menus. There is nothing special about the path listed in attributes 2 and 7 -- they simply point to a file to which the tape i/o stream should be written. If the file does not exist, you will want to do touch /binarystar/MV.LASER/MvLaser.vtf from the OS shell to create the file. Rather than use the tape command in attributes 10 and 11, I use echo $tape. I think attribute 3 is the default block size and attribute 16 is the maximum block size for the device. There is one big limitation and that is you can only write one contiguous segment to the file. Once you write an end-of-file the reference pointer goes back to the beginning of the file. Any subsequent writes will destroy the existing data in the file. Hopefully, this helps... Tom Firl post Tom, An easy way (if you are on a Linux/Unix box), would be to create a pseudo-floppy drive on your system in the DEVICE file It should like like this: PF1 0001 Test1 Pseudo Floppy 0002 /binarystar/MV.LASER/MvLaser.vtf 0003 500 0004 F 0005 0006 0007 /binarystar/MV.LASER/MvLaser.vtf 0008 0009 0010 0011 tape rewind $tape 0012 tape rewind $tape 0013 0014 0015 0016 500 0017 0018 0019 Then you can ASSIGN PF1 TO MTU 0 T-REW T-LOAD FileName If anyone has information on how to do this on a Windows platform, it would be appreciated. Thanks Lee Bacall http://www.binarystar.com Phone: +1 (954) 791-8575 Cell: +1 (954) 655-6581 /post -Original Message- From: Buffington, Wyatt [mailto:[EMAIL PROTECTED] Sent: Thursday, July 22, 2004 9:03 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Importing data from OS file So what is the suggestion? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Firl Sent: Tuesday, July 20, 2004 12:59 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Importing data from OS file An easy way (if you are on a Linux/Unix box), would be to create a pseudo-floppy drive on your system in the DEVICE file Lee, Thanks for the suggestion. I was aware of this capability on UNIX platforms, but I require a solution that works on UNIX and Windows, as well as jBASE and Universe. In the absence of standard bulk file loading utility for MV, I started working on my own. Tom Firl --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Importing data from OS file
If the number of records is a concern, why not ZIP/GZIP them -- 1 file can then be unzipped for your 100K+ records . viola! Ross Ferris Stamina Software Visage an Evolution in Software Development -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Tom Firl Sent: Saturday, 17 July 2004 2:31 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Importing data from OS file Off the top of my head: /DATA directory on CDROM holding each record in a single file (delimit record elements with CR or LF as appropriate for your O/S) ED VOC IMPFILE F Data Import /dev/cdrom/DATA Thanks, Craig and those of you who responded off-list. I'm not very conversant in CD-ROM standards, but I know I am limited to creating ISO-9660 level-1 disks that will be distributed to a wide variety of operating systems. I think the limit on the maximum number of files for this format is somewhere around 65536 -- not enough to contain all the records in a type-1/19 file. More or less I'm fishing for a simple, free bulk-loader utility for MV systems. Rolling my own solution is easy enough... just thought I'd see if there is a standard solution floating around in MV-land. Tom Firl --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.725 / Virus Database: 480 - Release Date: 19/07/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.725 / Virus Database: 480 - Release Date: 19/07/2004 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Importing data from OS file
Why char(253) raise ? I thought the CR was automatically converted to @fm on read ( reverse on write ?) Ross Ferris Stamina Software Visage an Evolution in Software Development -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Stuart Boydell Sent: Friday, 16 July 2004 10:07 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Importing data from OS file I have the flexibility of choosing the format the files contained on the CD-ROM. Any suggestions? UniVerse or Jbase format. Seriously, instead of say, comma/cr delimited files get them to save with char(253)/cr instead. A simple readseq raise() gets you your data. (Of course if they'll do that then it's just one more step to just write the records as type 19 formatted items in a directory for you.) ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.725 / Virus Database: 480 - Release Date: 19/07/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.725 / Virus Database: 480 - Release Date: 19/07/2004 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Importing data from OS file
Because if the file is originally a multi-line flat file then when you read the item, as you say CRs will get converted to @AM. This gives you a multi-attribute record in memory. Each line of which I am assuming needs to be parsed and turned into a record. If the delimiter is an @VM then each attribute (line) can be extracted, raised and converted into a record. Possibly no more or less effective than any other method - he just said he could choose the format. Ideally that could also mean a U2 file but alas that would probably be taking it too literally. Stuart -Original Message- [mailto:[EMAIL PROTECTED] Behalf Of Ross Ferris Why char(253) raise ? I thought the CR was automatically converted to @fm on read ( reverse on write ?) Ross Ferris Stamina Software Visage an Evolution in Software Development ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Importing data from OS file
How does one go about to create this DEVICE file? This is something that would help me greatly. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Firl Sent: Tuesday, July 20, 2004 12:59 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Importing data from OS file An easy way (if you are on a Linux/Unix box), would be to create a pseudo-floppy drive on your system in the DEVICE file Lee, Thanks for the suggestion. I was aware of this capability on UNIX platforms, but I require a solution that works on UNIX and Windows, as well as jBASE and Universe. In the absence of standard bulk file loading utility for MV, I started working on my own. Tom Firl --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Importing data from OS file
Tom, Would you consider a relatively inexpensive commercial product? [AD] Zeus should do what you need to do. Look at www.MtOlympus.us for details, or you can contact me at [EMAIL PROTECTED] [/AD] -- - Charles Barouch (718) 762-3884 x 1 - Key Ally Voice mail [EMAIL PROTECTED]- Consulting services [EMAIL PROTECTED] - News [EMAIL PROTECTED] - U2-Users Moderator [EMAIL PROTECTED] - Zeus Data Integration Mount Olympus, Home of Zeus Data Integration^(TM) Tom Firl wrote: An easy way (if you are on a Linux/Unix box), would be to create a pseudo-floppy drive on your system in the DEVICE file Lee, Thanks for the suggestion. I was aware of this capability on UNIX platforms, but I require a solution that works on UNIX and Windows, as well as jBASE and Universe. In the absence of standard bulk file loading utility for MV, I started working on my own. Tom Firl --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Importing data from OS file
I have the flexibility of choosing the format the files contained on the CD-ROM. Any suggestions? UniVerse or Jbase format. Seriously, instead of say, comma/cr delimited files get them to save with char(253)/cr instead. A simple readseq raise() gets you your data. (Of course if they'll do that then it's just one more step to just write the records as type 19 formatted items in a directory for you.) ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Importing data from OS file
Off the top of my head: /DATA directory on CDROM holding each record in a single file (delimit record elements with CR or LF as appropriate for your O/S) ED VOC IMPFILE F Data Import /dev/cdrom/DATA Thanks, Craig and those of you who responded off-list. I'm not very conversant in CD-ROM standards, but I know I am limited to creating ISO-9660 level-1 disks that will be distributed to a wide variety of operating systems. I think the limit on the maximum number of files for this format is somewhere around 65536 -- not enough to contain all the records in a type-1/19 file. More or less I'm fishing for a simple, free bulk-loader utility for MV systems. Rolling my own solution is easy enough... just thought I'd see if there is a standard solution floating around in MV-land. Tom Firl --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Importing data from OS file
If it's a one time deal, then just pop the cd into the cd reader on your universe box and us OS commands to copy the files to a directory accessible by universe. Then write a small program to read these files and do with them what you will. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tom Firl Sent: Thursday, July 15, 2004 14:08 To: [EMAIL PROTECTED] Subject: [U2] Importing data from OS file I'm looking for a way to essentially COPY or IMPORT 100K+ records contained in files on CD-ROM media into database files on Universe (and if possible jBASE) systems. I have the flexibility of choosing the format the files contained on the CD-ROM. I'd prefer to avoid hand-crafting a program, but am open to using a freely distributable, (and free) third-party tool. A tool that is the converse of DOWNLOAD would be excellent, or a command-line program that imports from a standard formatted file would be fine, too. Any suggestions? Tom Firl Database Analyst Columbia Ultimate 4400 NE 77th Avenue, Suite 100 Vancouver, WA 98662 Phone: 360-256-7358 x137 Fax: 360-260-1614 [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/