RE: [sqr-users] DAT files

["Lindquist, Maria" <mlindqui@uwc.edu>]

What I really meant is that I have to run this program thru PeopleSoft
Student Administration v8.0(External File Loads) and they require that
the file be DAT. I think what I'm going to do is write my own SQR that
will read in a CSV file and insert into the same table that the External
File Load program does. 

Thanks for any help.

Maria

-----Original Message-----
From: Alexander, Steve [mailto:Steve.Alexander@ci.sj.ca.us] 
Sent: Tuesday, June 10, 2003 4:50 PM
To: 'sqr-users@sqrug.org'
Subject: RE: [sqr-users] DAT files


We've had three questions today that really belong on other lists.  One
about a Peoplesoft Time and Labor page, one about how to identify
changes in Peopletools objects, and this one about saving files from
Excel.  The readers of our list are free to ignore these questions, so
we shouldn't be upset about them.  However, the people asking these
questions should consider using other discussion lists.  You're more
likely to get answers and the answers will probably be better on
discussion lists devoted to these subjects.  For example, in this case,
Mark assumed Maria meant "how do I produce DAT files from an SQR
program?"

I recommend the Peoplesoft sponsored Time & Labor SIG.  Go to
http://groups.yahoo.com/group/PS_TimeandLabor.

I also recommend a Peopletools discussion group sponsored by IT Toolbox.
Go to http://www.openitx.com/g/peopletools-l.asp.

I don't know a good Excel discussion group, but you could save your
spreadsheet with .PRN or .TXT extension, then rename it to have a .DAT
extension.  You'll have to make sure that Windows Explorer is set up to
include the extensions with the file names (in Windows 2000 Explorer:
Tools, Folder Options, View tab, "Hide file extensions for known file
types" checkbox should be unchecked).  Or, if your database can read
.CSV or .DBF files, save your spreadsheet that way.

-----Original Message-----
From: Lindquist, Maria [mailto:mlindqui@uwc.edu]
Sent: Tuesday, June 10, 2003 2:00 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] DAT files


What do you mean "open a file for writing". I'm trying to save an excel
file as a .dat file. There is no choice for .dat.


-----Original Message-----
From: Mark Hall [mailto:Mark.Hall@parkview.com] 
Sent: Tuesday, June 10, 2003 3:48 PM
To: sqr-users@sqrug.org; Lindquist, Maria
Subject: Re: [sqr-users] DAT files


open a file for writing.  Then use the write command.  See your sqr
user's manual.  
 
Mark Hall
IS Analyst
ERP Team
260-373-8796
mark.hall@parkview.com


>>> mlindqui@uwc.edu 06/10/03 03:37PM >>>
How do you create .dat files? Like for instance I need to use a dat file
when loading External Files into our database.



Maria K Lindquist
mlindqui@uwc.edu <mailto:mlindqui@uwc.edu> 
IS Programmer/Analyst - Business Office
University of Wisconsin Colleges
780 Regent St, PO Box 8680, Madison, WI  53708-8680
Phone: 608.265.2677 / Fax: 608.265.5770



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users