Help importing Flat File. (One World XE)

aronnov

Active Member
I'm using TC to try to load the customer master but i'm stopped before i can even start. When setting up the TC report I can't get it to recognize the CSV file. I go to define formats and tell it it's delimited and that comma is the coulmn delimiter but when i get to define the mappings there's nothing to choose on the input side except one row that says TextLine for the Alias, no description and string data type. What am i doing wrong? This is my first data load. Thanks.

Aaron
 
I found TC to be a little confusing too, which is why I use business
functions "Fetch Next Line From Flat File" and "Parse Delimited String" to
read flat file records and parse into individual fields. You should try it.


_____

From: [email protected] [mailto:[email protected]] On
Behalf Of aronnov
Sent: May 10, 2006 2:07 PM
To: [email protected]
Subject: Help importing Flat File. (One World XE)


I'm using TC to try to load the customer master but i'm stopped before i can
even start. When setting up the TC report I can't get it to recognize the
CSV file. I go to define formats and tell it it's delimited and that comma
is the coulmn delimiter but when i get to define the mappings there's
nothing to choose on the input side except one row that says TextLine for
the Alias, no description and string data type. What am i doing wrong? This
is my first data load. Thanks.

Aaron


_____


The entire <http://www.jdelist.com/ubb/showflat.php?Cat=&Board=> JDELIST
thread is available for viewing.


Looking for a job? Check out the Job


This is the JDELIST EnterpriseOne Mailing List.
The instructions on how to unsubscribe from any JDELIST mailing list are
available here <http://www.jdelist.com/unsubscr.shtml> .
JDELIST is not affiliated with JDEdwards(r).
 
Re: RE: Help importing Flat File. (One World XE)

Can you give me an example of what I need to do? For the FlatFilename do i put the path? "C:/flat.txt"? What about idFileptr, FlatFileRecord, RecordLength. Can you give me some direction?
 
Re: RE: Help importing Flat File. (One World XE)

Here is an example:

Fetch Next Line from Flat File
PO szFileNamePath -> szFlatFileName
VA rpt_szFilePointer_GENLNG <> idFilePtr
VA rpt_szFlatFileRecord_APTA <-
szFlatFileRecord
"500" -> mnRecordLength
VA rpt_cSuppErrorMsg_SUPPS ->
cSuppressErrorMessage
VA rpt_cErrorCode_ERRC <- cErrorCode
VA rpt_szErrorMessageID_DTAI <-
szErrorMessageID

You can either Hardcode the flatfile name or define
that as Processing option value.
Define variable (Alias - GENLNG) and map that to
idFilePtr. Define variable (Alias - APTA) and map that
to szFlatFileRecord.
Record length - Record length of Flat flat record. In
this case we assumed the record length won't be more
then 500 characters.
Define variable (Alias - SUPPS) and map that to
SuppressErrormessage.
cErrorCode and szErrormessageId values are returned
from Business function.

Hope it helps. Good luck!!

Mitu
 
Re: RE: Help importing Flat File. (One World XE)

is the VA rpt_szFilePointer_GENLNG <> idFilePtr the length of the record?
 
Re: RE: Help importing Flat File. (One World XE)

idFilePtr - File Pointer
mnRecordLength - Record lengh
 
Re: RE: Help importing Flat File. (One World XE)

I guess the issue with ur TC could be that... u have not made an entry in P93081. Make an entry in P93081 for your TC to use flat file encoding UTF8 and also save your flat file using encoding UTF8.
 
Re: RE: Help importing Flat File. (One World XE)

I dont' seem to be able to fast path to P93081. Is that available to XE or just 8.9 and up?
 
Re: RE: Help importing Flat File. (One World XE)

I guess u dont have access to that... just check up with the CNC guys.
 
Re: RE: Help importing Flat File. (One World XE)

What is meant by file pointer? if you can i'd appreciate it if you went into detail about what each one meant.
 
Re: RE: Help importing Flat File. (One World XE)

Can you please tell me if this will work on AIX? I have to import records from flat file and insert in JDE table. I've used TC. However my main limitation is that TC need a predefined path while the requirement is about specifying the path at run time. I've used the bsfn "DELETE OR COPY FLAT FILE" to copy the input file to a hardcoded path from which the TC will work. This BSFN works well on Windows. However, it doesnt work on AIX. Can u please tell me about it? Does "DELETE OR COPY FLAT FILE" work on AIX or not? and how do we specify AIX paths correctly?

Am thinking of using Fetch Next Line from flat file to overcome the TC. Will it work on AIX?

How will i loop over a file having more than 1 lines and fetch 1 line at a time?

Please help.

Thanking You All.

Email: [email protected]
Phone: (+230) 7415014
 
Re: RE: Help importing Flat File. (One World XE)

Hi,

Yes, I confirm you that those Flat Files BSFNs work great
in AIX, you just have to check that :

1. The AIX user that's being used by the UBE/BSFN has
rights to read from source folder and read/write to
destination folder. In a typical installation, it
should be the "jde811" AIX user. Ask your AIX admin.

2. You specified the path correctly : remember AIX is
case-sensitive, and it uses / instead of \, and it
doesn't support double bars like // or \\.

3. It's a good idea to copy the flat file from its
variable location to the TC path with "Delete or
Copy Flat File" BSFN and then run your TC, it should work.

Good luck,
 
Back
Top