f



Need help to read/write tab-delimited files

Currently we are running RD AP-PRO 6.0 and PIC-LAN 2.0.0.36 and I am
using the PLDOS-IMPORT and PLDOS-EXPORT commands to import and export
flat, tab-delimited files from the PICK box to a Novell server using a
DOS Services Gateway.



We are looking into the possibility of converting over to Universe 10.0
running on RedHat 8.0 Linux operating system.



Question: How do I go about reading and writing these flat tab files
from Universe to Novell and back again?



Any help would be greatly appreciated.


--
Posted via http://dbforums.com
0
polkster13
9/9/2003 5:37:50 PM
comp.databases.pick 5449 articles. 2 followers. ttrroonniicc (5) is leader. Post Follow

7 Replies
307 Views

Similar Articles

[PageSpeed] 18

You need a program.
0
wayniepooh
9/9/2003 6:38:13 PM
There are no built in utilities to do that. I recommend hiring a competent
programmer who is familiar with AP and Universe to review your file layouts
and write conversion programs for you.

-- 

Jeffrey Kaufman
Key Data Systems Group
www.keydata.us
559-432-3832
559-432-4657 fax

Western Pacific Supply
www.westpacsupply.com
888-WestPac

"polkster13" <member35818@dbforums.com> wrote in message
news:3348827.1063129070@dbforums.com...
>
> Currently we are running RD AP-PRO 6.0 and PIC-LAN 2.0.0.36 and I am
> using the PLDOS-IMPORT and PLDOS-EXPORT commands to import and export
> flat, tab-delimited files from the PICK box to a Novell server using a
> DOS Services Gateway.
>
>
>
> We are looking into the possibility of converting over to Universe 10.0
> running on RedHat 8.0 Linux operating system.
>
>
>
> Question: How do I go about reading and writing these flat tab files
> from Universe to Novell and back again?
>
>
>
> Any help would be greatly appreciated.
>
>
> --
> Posted via http://dbforums.com


0
Jeffrey
9/9/2003 6:47:09 PM
polkster13 <member35818@dbforums.com> wrote in 
news:3348827.1063129070@dbforums.com:

[...]
> 
> Question: How do I go about reading and writing these flat tab files
> from Universe to Novell and back again?
> 

I hate to think that I could expand on wayniepooh's answer, but I'll give 
it my best! :)

There are two components to your question.

1. You want to move a file from a Novell server to Universe and back again. 
If I were you, and I understand why you wouldn't want to be me, I would 
download and install the Novell Natice File Access Pack 
(http://www.novell.com/products/nfa/). I've not used it, but it looks like 
spending $300 will allow just about any OS to talk to your Novell server. 
Once you have the Universe Server talking to the Novell server, you can 
mount the Novell share and then have the UV application read and write 
directly to the shared directory. It should be pretty easy to get it done. 
I don't want to say that Doug's Pic-Lan had any flaws, but this should be a 
better way to transfer the data.

2. Reading and writing the CSV file. I don't know how you are handleing 
this now, but you might need to modify your program some. It shouldn't take 
too much work to make it work with UV. You could also write a simple 
program to read the file from the shared directory, read each line and 
create a record in a UV hashed file. When done you would have a second 
program that would do the reverse.

Good luck.

-- 
~ kevin zollinger
kevin@mailsoap.com
0
kevin
9/9/2003 7:06:58 PM
A couple of possiblities

1)Account Saves if you have compatible tape drives
2)Using Accuterm/etc emulators which come with tools which you can use 
to move files directly from one pick system to another

both of the above bypass the need for pic-lan & novell

just a thought, Rich

polkster13 wrote:
> Currently we are running RD AP-PRO 6.0 and PIC-LAN 2.0.0.36 and I am
> using the PLDOS-IMPORT and PLDOS-EXPORT commands to import and export
> flat, tab-delimited files from the PICK box to a Novell server using a
> DOS Services Gateway.
> 
> 
> 
> We are looking into the possibility of converting over to Universe 10.0
> running on RedHat 8.0 Linux operating system.
> 
> 
> 
> Question: How do I go about reading and writing these flat tab files
> from Universe to Novell and back again?
> 
> 
> 
> Any help would be greatly appreciated.
> 
> 
> --
> Posted via http://dbforums.com

0
Richard
9/9/2003 7:17:32 PM
Have a look at the program "download" at:

ftp colon slash slash ftp dot cedarville dot edu/download/download602

This should easily let you create the files (you will still have to link the
Linux box to the Novell box using NFS/Samba/FTP).

Looking at the code should also show you how to read the information back
in. I've done it lots with UniData where it is remarkably simple.

Colin Alfke
Calgary, Alberta Canada

"polkster13" <member35818@dbforums.com> wrote in message
news:3348827.1063129070@dbforums.com...
>
> Currently we are running RD AP-PRO 6.0 and PIC-LAN 2.0.0.36 and I am
> using the PLDOS-IMPORT and PLDOS-EXPORT commands to import and export
> flat, tab-delimited files from the PICK box to a Novell server using a
> DOS Services Gateway.
>
>
>
> We are looking into the possibility of converting over to Universe 10.0
> running on RedHat 8.0 Linux operating system.
>
>
>
> Question: How do I go about reading and writing these flat tab files
> from Universe to Novell and back again?
>
>
>
> Any help would be greatly appreciated.
>
>
> --
> Posted via http://dbforums.com


0
Colin
9/10/2003 4:29:18 AM
On Tue, 09 Sep 2003 13:37:50 -0400, in article
     <3348827.1063129070@dbforums.com> member35818@dbforums.com
     "polkster13" wrote:

> We are looking into the possibility of converting over to Universe 10.0
> running on RedHat 8.0 Linux operating system.

> Question: How do I go about reading and writing these flat tab files
> from Universe to Novell and back again?

You could run SAMBA on RedHat and mount the source and destination 
directories on the Universe server as simple Windows shares.  All that 
would be required would be simple copy back and forth.
-- 
Gulraj Rijhwani             \\  Courtfields Limited, Chessington, Surrey, UK
gdr@courtfields.com           \\  Tel: +44 (0)20 8255 4667  Mo: 07976 431936
http://www.courtfld.demon.co.uk \\  Fax: +44 (0)20 8287 8381
----- Specialist in Pick, Unidata, datacomms and general connectivity -----
All material copyright Gulraj Rijhwani and Courtfields.  ALL RIGHTS RETAINED.
0
gdr
9/17/2003 11:20:46 PM
On Thursday, in article
     <20030917.2320.2140snz@courtfields.com> gdr@courtfields.com
     "Gulraj Rijhwani" wrote:

> On Tue, 09 Sep 2003 13:37:50 -0400, in article
>      <3348827.1063129070@dbforums.com> member35818@dbforums.com
>      "polkster13" wrote:

> > Question: How do I go about reading and writing these flat tab files
> > from Universe to Novell and back again?

> You could run SAMBA on RedHat and mount the source and destination 
> directories on the Universe server as simple Windows shares.  All that 
> would be required would be simple copy back and forth.

Actually, one potential step further, although I've never tried it:
The Linux kernel can be compiled with NCP support for direct mounting 
of Netware directories.  With that in place you could copy directly 
from the Universe platform back and forth.  That depends, of course, 
on having all the necessary elements installed to re-compile the kernel 
AND appropriate versions of the mount and file utilities, and 
furthermore that the re-compiled kernel still supports Universe 
satisfactorily.  (Certainly it's a challenge I'd like to try, if it 
were my project.)
-- 
Gulraj Rijhwani             \\  Courtfields Limited, Chessington, Surrey, UK
gdr@courtfields.com           \\  Tel: +44 (0)20 8255 4667  Mo: 07976 431936
http://www.courtfld.demon.co.uk \\  Fax: +44 (0)20 8287 8381
----- Specialist in Pick, Unidata, datacomms and general connectivity -----
All material copyright Gulraj Rijhwani and Courtfields.  ALL RIGHTS RETAINED.
0
gdr
9/18/2003 6:10:25 PM
Reply:

Similar Artilces:

Writing and reading a comma delimited or tab delimited file one record at a time
I need to be able to write a large file with delimited fields with a new line symbol separating records. Since the files can be very large, I can't create or read them all at once and work with them in memory. It would be nice to create small sample files I can look at in EXCEL (I'm on a MAC). The files I need to create consist of 5 string valued fields and a positive real number. I suspect this is simple, but I can not see a simple way to do it from the documentation: The goal is to take alfa code 1 .... alfa code 5 amount to alfa code1, alfa code 2, ... , alfa...

Need help to write data onto an XML file after reading data from another xml file
Hello Users, I am in dire need of your help. I have been working on this code for quite some time and it is making me restless. All I am trying to do is, 1. Read data from an xml file. Source: http://sndlib.zib.de/coredata.download.action?objectName=germany50&format=xml&objectType=network 2. The data I'm concerned about is the node ID, co-ordinates, capacity of the links, source and destination names. 3. I'm creating a topology with this information and the topology is same as the one given in the xml file. But, I'd like to add a few extra parameters and demands...

need help with reading/writing to files
I've been trying to write a program that will take a file, do some find/replace operation and save the file. I'm pretty new to ruby, and I can't seem to figure out how to do this succinctly. This is my latest attempt, but it seems like I shouldn't need to open the file twice. I tried to just open the file with "r+" permissions, but if I overwrote it with a string that was shorter than the original contents, the extra characters would stick around. I couldn't figure out how to slice off the extra stuff I didn't need. Any suggestions on how to reduce this to o...

Need help with large file reading and writing.
Hello Pals: When I use fortran 90 code to read larger files,about 1G each, and write the data to other opened files with 32-bit Intel-compiler. Each time, I just opened 3 files simultaneously and closed unused ones. The code always stops at the point of 10 files reading. I am not sure it is the compiler problem about the limitation of buffer memory. Thanks very much Liscon Simple code: open(unit=18,file="aux.out") do i=1,10 open(unit=101+i,file="fort.1+i") !old file; unit and file name just for simplicity open(unit=1001+i,file="fort.101...

Need help with reading/writing to/from a text file
I have had some difficulty reading a text from a file with Visual Studio's Win32 Console Application. When I build the code it gives no errors but when I run the code...nothing happens. Instead, an empty text file is created.Even when I create a text file with words, the run code deletes its contents and gives me back an empty text file. Below are two variants of the code I've been puzzling with. Can someone throw me a bone? Thanks. Joseph 1. #include <iostream> #include<fstream> #include<cstdio> #include<string> using namespace std; int main() { string...

need help writing database entires to file
I have used dreamweaver to do a lot of php "programming" but now I need to write a real php function. I have a hosted mysql database that I need to export to MS Access. I can't use myODBC to do it because hosting company denies access to db port. I looked at other ways to dump the data but the escaped characters always threw the import off. There probably a way to do using MySQLDUMP command. HOwever, I remember a long time ago I wrote some code to read raw data into lotus notes and figured there is probably a way to write out the data using whatever field & record termina...

Is it more CPU-efficient to read/write config file or read/write sqlite database?
I have a number of python processes which communicate with each other throu= gh writing/reading config text files. The python ConfigParser is used. I am= wondering if it is more CPU-efficient to switch to using sqlite database i= nstead of using configuration files. If the software does plenty of reading= /writing, is it more efficient to use config text files or sqlite database? Thank you. On 14-12-2013 16:29, JL wrote: > I have a number of python processes which communicate with each other through > writing/reading config text files. The python ConfigParser is used. I am wo...

Awk help needed for tab delimited text file
I have an input file with five fields: Field A : 24 bytes Field B : 72 Bytes Field C : 8 Bytes Field D : 10 Bytes Field E : 10 bytes This is a tab delimited text file. Each field also has spaces in it. For example, the sample file looks like Yet another Campaign TG1 1104200408000001230800000555 Yet another Campaign TG1 1104200408000001230800000555 Yet another Campaign TG1 110...

Need help with strings, read text and writing text to file...
Hi all; I have writen a program to read in a list of filenmaes and to output javascript and html code. The resulting html code is then run thru a html to js program ( Easy HTML To Any Script Converter]. All this to display the pictures in a slideshow. The code did work at one stage... before I fully tested. But now I don't know whats gone wrong. As the html and javascript look right, as does the js code. There are three slide show, each with their own buttons... However some work, while others don't! #include <stdio.h> #include <string.h> #include <...

Read tab delimited files with header file
Dear all; I have two types of tab delimited files, first separated with ' ' or 'space' and ';' or 'semi'. All files are in CSV type and have a header file which is not variable names separated by the tabs. For the first type (separated with space), I read as: fid = fopen(fname1); fmt=['%s %s %f %f %d %s %s %f %d %d %d %d %f %f %s' repmat('%8.1f',1,1024) '%s']; data = textscan(fid,fmt,'HeaderLines',1,'Delimiter',',','CollectOutput',1); However, for the second type (separated with ';'...

Need help: Carion TPS database files innaccessible: Lost program to read them.
Hello: Maybe you can help? Attached files to a CD Music database used to store CD album titles and their songs. Nature: CD database used as part of a larger Music database app. OS: Windows 98 Lic.: Freeware I wash to have you to read these files and convert them -if possible- to a freeware app that can use them. Please leave me a note as to progress. Thanks a bunch for your time. Onedrive.com Storage: https://onedrive.live.com/?cid=d9130c0b5a1a9029&mkt=en-US#cid=F1C69E25E0D2390A&id=F1C69E25E0D2390A!109 Sincerely, Donald B. On Thursday, March 6, 2014 4:34:10 PM...

Re: Need help reading raw data file with semi colon delimiter -
It worked when I used informat and format. ...

Need help reading raw data file with semi colon delimiter
I have a data file with semi colon delimeter. I used the infile statement as below: infile ‘file' DLM = ';' DSD MISSOVER lrecl=206; input var1 $3 var2 3 var3 $8; The output shows: xxx ;56 7;yyyyyy It looks like the DLM = ';' was not executed. Can anyone tell me what's wrong here? TIA Huong On Mar 28, 6:40 pm, huongnhal...@YAHOO.COM (Huong Halpin) wrote: > I have a data file with semi colon delimeter. I used the infile statement > as below: > > infile 'file' DLM = ';' DSD MISSOVER lrecl=206; > input var1 $3 > var2...

Re: Need help reading raw data file with semi colon delimiter
On Wed, 28 Mar 2007 19:40:17 -0400, Huong Halpin <huongnhalpin@YAHOO.COM> wrote: >I have a data file with semi colon delimeter. I used the infile statement >as below: > > infile ‘file' DLM = ';' DSD MISSOVER lrecl=206; > input var1 $3 > var2 3 > var3 $8; > >The output shows: >xxx ;56 7;yyyyyy > >It looks like the DLM = ';' was not executed. Can anyone tell me what's >wrong here? > >TIA >Huong I cannot explain the output because you do not show the input data or the code used to generate the output. I notice...

Opening Multiple Date Stamped Tab Delimited Txt Files, apply common transformation syntax, write to database
I receive daily date-stamped, tab-delimited text files (e.g. CSAT_SM_STG-20100714.txt). Periodically (at least once a week), I need to open these files in SPSS, run syntax that performs a number of transformations on the data, and then update a SQL Server database table with the results. Currently, I run the entire syntax from opening the file to saving to the database for one file, then change the filename in the GET FILE statement to reflect the next day's filename and run the syntax again. I repeat this until I've gone through all the txt files. I am not very familiar ...

Merge two xml files on common date field and write out tab-delimited file
I am using the Saxon xml parser and I need some help transforming the following 2 xml files: gps.xml: -------- <?xml version="1.0"?> <root> <record> <longitude>-105.111111</longitude> <latitude>39.111111</latitude> <date_time>2003/12/10.16:08</date_time> </record> <record> <longitude>-105.222222</longitude> <latitude>39.222222</latitude> <date_time>2003/12/10.16:18</date_time> </record> <record> <longitude>-105.111111</longitude> <lati...

Reading a Tab Delimited File
Hello All I am having a tough time reading a tab delimited file. My file looks follows. Date:|01/12/2005 ACD|Skill Num|Skill Name|Avg Speed Ans|Avg Aban Time|ACD Calls|Avg ACD Time|Avg ACW Time|Aban Calls|Max Delay|Flow In|Flow Out|Extn Out Calls|Avg Extn Out Time|% ACD Time|% Ans Calls|% Within Service Level Totals|ACD|ACD|8.24714851379|281|789|438.997467041|463.315582275|5|1205|0|0|1663|220.772705078|30.35|99.37| BANKCARD_SVCS|458|TE HLD High Pri S458|0.00613496918231||163|853.582824707|973.239257813|0|1|0|0|1368|225.820175171|43.65|100.00|100.0 BANKCARD_SVCS|459|TE National S459|0.354058712721|20|579|333.129547119|345.939544678|1|72|0|0|228|250.188598633|18.91|99.83|99.3 BANKCARD_SVCS|469|TE HLD Spanish S469|134.063827515|346.25|47|305.382965088|140.829788208|4|1205|0|0|67|17.6119403839|12.41|92.16|47.1 Date:|01/11/2005 ACD|Skill Num|Skill Name|Avg Speed Ans|Avg Aban Time|ACD Calls|Avg ACD Time|Avg ACW Time|Aban Calls|Max Delay|Flow In|Flow Out|Extn Out Calls|Avg Extn Out Time|% ACD Time|% Ans Calls|% Within Service Level Totals|ACD|ACD|2.24423956871|575.666687012|868|416.888244629|278.236175537|9|1663|0|0|1749|143.236709595|26.81|98.97| BANKCARD_SVCS|458|TE HLD High Pri S458|0.019417475909||206|750.592224121|419.228149414|0|1|0|0|1454|154.313613892|38.98|100.00|100.0 BANKCARD_SVCS|459|TE National S459|0.0183333326131||600|308.421661377|239.119995117|0|1|0|0|193|115.601036072|15.11|100.00|100.0 BANKCARD_SVCS|469|TE HLD Spanish S469|31.1774196625|575.666687012|62|357.80645...

how to read a tab delimited file
how would i read a tab delimited file? at the same time put what i read in an array, say for example that i know that the file is an array with column= 5 and row=unknown. jrlen balane wrote: > how would i read a tab delimited file? at the same time put what i > read in an array, say for example that i know that the file is an > array with column= 5 and row=unknown. Use the "csv" module. Although that stands for "comma separated values", it readily supports alternative delimiters such as TAB. -Peter if i am going to do this, how should i continue: how would i k...

Reading tab delimited files
How do I read I tab-delimited file into sas? I tried delimiter=3Dtab and dsd delimiter=3Dtab on the infile statement, but it is only reading in = the 1st variable. You may need to use the DSD option as well as the DELIMITER='09'x option (ASCII systems). Just go to http://support.sas.com/ and search for 'Reading tab delimited files', you'll easily find solutions like: Sample 56: Reading a TAB delimited file http://support.sas.com/ctx/samples/index.jsp?sid=56 __ See also: http://www.ciser.cornell.edu/CRADC/FAQ/SAS/other_delimiters.shtml On Aug 28, 6:23 pm, Lorna.Si...@...

help reading writing file
hi i need to read file situated in "C:\file.txt" and to read it line by line. how can i do it? how can i write TO File also? ...

Need help reading a file.
I am trying to read a file a character at a time, I want to read in the new line character. I am printing out each character to the screen. For some reason it will not print out the new line. I want to do this so the line will break on the console while reading it in a character at a time. I am using fgetc on a file opened for reading in text mode. What could be the problem? Can anyone help?... Amkcoder wrote: > I am trying to read a file a character at a time, > I want to read in the new line character. > I am printing out each character to the screen. > For some reason it wil...

Reading tab-delimited files
Can someone tell me why SAS is truncating some records, while reading others perfectly? I'm reading a tab-delimited file, with "delimiter='09'x MISSOVER DSD" in the infile statement. Excel can open the file without any truncation and I can view the file in a text editor and see the tab indicators. I'm reading a file which is about 140 data columns wide. SAS truncates the first seven records, not at the same point, then reads records 7-11 correctly, truncates 12, reads 13, truncates 14, reads 16-20, etc. An exerpt from the SAS log: NOTE: 27 records were read fro...

How to populate column titles for y values when using Write to Measurement File Express VI with a tab delimited text-based .lvm file?
The .lvm file generated by the Write to Measurement File Express VI includes column heading titles for the y values, but they are a default value of "untitled".&nbsp; See attached example of a sample&nbsp;file when opened in Excel, the values in question are highlighted.&nbsp; Is there a way to specify the column titles when the file is written? &nbsp; This is a similar question to <a href="http://forums.ni.com/ni/board/message?board.id=170&amp;message.id=125937&amp;query.id=529265" target="_blank">this posting</a>, which receiv...

Reading from a mat file. I need a help
This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C44E53.9995CD00 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable Hello, Supposing we have: save file.mat p and p is: p=3D[ 2 3 4;5 6 7] now I would like to read the data from a file and use it in another file = for example I have a function function [y]=3Dbip(p,i,n); load file p; for i=3D1:n if (p=3D=3D1)&(i=3D=3D1) block=3Dp(n,:); end end Why it does not work?Matlab displays an error: undefined variable Please about a help in correcting...

Web resources about - Need help to read/write tab-delimited files - comp.databases.pick

Resources last updated: 2/25/2016 6:36:41 PM