RE: [U2] UniVerse - file importation
As Gordon mentioned, you can read .dbf files using BASIC. Here is a snippet I dug up from an old program that processed dBaseIV (Foxpro?) files (I think I got the .dbf file-spec from wotsit.org): if first.time then * header.size & rec.size can be determined by reading the * header data, but make sure that block size is greater * than the header size. h1 = seq(new.block[9,1]) h2 = seq(new.block[10,1]) header.size = (256*h2)+h1 + 4 ;* was +2? r1 = seq(new.block[11,1]) r2 = seq(new.block[12,1]) rec.size = (256*r2)+r1 first.time = 0 end Header.size tells you where the data records start, rec.size tells you how big each record is; from there on it's just parsing fixed length records. Here are some other ways to get your dBase data: 1. Import to Excel, export as tab-delimited, OPENSEQ from UV. 2. Accuterm can import dBase files directly into Pick (I'll bet Wintegrate can too). /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- Whoa! dBase IV! As I recall that DB was way before ODBC for external access to the data. But IIRC the data files themselves are just text files with fixed length fields. You should be able to access the DB files with UniBasic and READSEQ. The first "record" in a dBase file is the data definition with the length and name of each field. From there you should be able to parse the records as needed. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse - file importation
If you email offline (see email below) I will send you a DBF converter I have written in Unidata (surely easily converted to Universe) that can read the DBF file DIRECTLY in it's binary format and create a unidata file (complete with dictionaries from the DBF structure) . Thanks, Don Verhagen [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 4:16:54 PM 11/10/2005 >>> Perhaps a nightly (or hourly) Windows script to create a .txt file from dBase to a Windows network drive. I presume that wIntegrate has some (cron) scripting functionality. From wIntegrate, run a UniBasic application to thing to grab the .txt file and save the data to a UV file. As an alternative, I expect that an ODBC/JDBC/XML thing could be setup. A challenging task... --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Barry Rogen Sent: Thursday, November 10, 2005 2:08 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniVerse - file importation Does anybody know of a good way (or program/utility) to import (translate as it were) dBase IV data onto a UniVerse system. We have a shipping package that uses dBase IV and I would love to be able to utlize that data from UniVerse. As always, any help is greatly appreciated. UV :10.0.19 HPUX: 11.0 Cheers, Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat --- 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] UniVerse - file importation [ad]
Barry Rogen wrote: > Does anybody know of a good way (or > program/utility) to import (translate as it were) dBase > IV data onto a UniVerse system. We have a shipping > package that uses dBase IV and I > would love to be able to utlize that data from UniVerse. > As always, any help is greatly appreciated. Barry, at the risk of posting something here about .NET twice in one day, I'll suggest that .NET is an option for all of these questions we see here about "how do I connect X to U2?". See these links for info about dBASE and .NET (sew the URL pieces together): General ODBC to dBaseIV without a DSN: http://www.carlprothman .net/Default.aspx?tabid=90#ODBCDriverForDBASE ODBC .NET Data Provider to datasources like dBaseIV with a DSN: http://www.carlprothman .net/Default.aspx?tabid=86#ODBCManagedProvider (scroll down to "For all other ODBC Drivers) (lots of other providers listed on that page, good info!) ODBC and OLEDB connection info to DBF among many others: http:// www.connectionstrings .com/ Sample code: http://www.kdkeys .net/forums/748/ShowPost.aspx And http://www.experts-exchange .com/Programming/Programming_Languages /Dot_Net/Q_20666541.html And http://aspadvice .com/blogs/andrewmooney/archive/2004/10/22/2477.aspx So that gets your dBASE files connected to .NET, but then what? ADO.NET, usable with those links above is a good universal hub for data from any relational or MV source. And then to U2? [now the ad part] mv.NET is a wheel spoke (so to speak) to any MV environment. UO.NET is not adequate for this it does not include native integration with ADO.NET where mv.NET does, so while you can use UO.NET to do this for free, you will need to manually write a lot of code for all of these sorts of projects. I hope that helps. Tony TG@ removethisNebula-RnD .com (all domains and addresses munged to minimize spam) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniVerse - file importation
Whoa! dBase IV! As I recall that DB was way before ODBC for external access to the data. But IIRC the data files themselves are just text files with fixed length fields. You should be able to access the DB files with UniBasic and READSEQ. The first "record" in a dBase file is the data definition with the length and name of each field. From there you should be able to parse the records as needed. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 [EMAIL PROTECTED] wrote on 11/10/2005 02:07:45 PM: > Does anybody know of a good way (or program/utility) to > import (translate as it were) dBase IV data onto a UniVerse > system. We have a shipping package that uses dBase IV and I > would love to be able to utlize that data from UniVerse. As always, > any help is greatly appreciated. > UV :10.0.19 > HPUX: 11.0 > > Cheers, > Barry Rogen > PNY Technologies, Inc. > Senior Programmer/Analyst > (973) 515 - 9700 ext 5327 > [EMAIL PROTECTED] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse - file importation
Perhaps a nightly (or hourly) Windows script to create a .txt file from dBase to a Windows network drive. I presume that wIntegrate has some (cron) scripting functionality. From wIntegrate, run a UniBasic application to thing to grab the .txt file and save the data to a UV file. As an alternative, I expect that an ODBC/JDBC/XML thing could be setup. A challenging task... --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Barry Rogen Sent: Thursday, November 10, 2005 2:08 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniVerse - file importation Does anybody know of a good way (or program/utility) to import (translate as it were) dBase IV data onto a UniVerse system. We have a shipping package that uses dBase IV and I would love to be able to utlize that data from UniVerse. As always, any help is greatly appreciated. UV :10.0.19 HPUX: 11.0 Cheers, Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat --- 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/