Flat File Conversion (R47002C)

gng_ca

Member
Hi,

Have anybody use the flat fle conversion UBE? I am
following the example from the Developer's guide, but
can't get it to work.

I am trying to upload a cvs flat file to OW
(Oracle/NT/JDE 7332). The "Import Flat File' UBE
failed with error code 3003. Any idea on how to find
more info on this error code?

Where should the flat file be located (server/local)?
I created a test file on my local C:\. Do I need to
set up the Data source and data mapping?

Your help is appreciated,
Gordon


__________________________________________________
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE.
http://im.yahoo.com/
 
--------------499DF2FFF7F13ABF57949130
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Yes, you need to setup a an odbc datasource, a jde datasource, and, I beleive an
object librarian entry. Then you need to run the ube locally until the program gets
built into a package and put on the server.

ps we usually import text files into access files using file templates of jde files
becuase it is easier to import from a foreign table than a text file.

gng_ca wrote:

> Hi,
>
> Have anybody use the flat fle conversion UBE? I am
> following the example from the Developer's guide, but
> can't get it to work.
>
> I am trying to upload a cvs flat file to OW
> (Oracle/NT/JDE 7332). The "Import Flat File' UBE
> failed with error code 3003. Any idea on how to find
> more info on this error code?
>
> Where should the flat file be located (server/local)?
> I created a test file on my local C:\. Do I need to
> set up the Data source and data mapping?
>
> Your help is appreciated,
> Gordon
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Messenger - Talk while you surf! It's FREE.
> http://im.yahoo.com/
>
> --------------------------
> To view this thread, visit the JDEList forum at:
> http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Number=177
> ****************************************************ÃRv*****
> This is the JDEList One World Developers Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************

--------------499DF2FFF7F13ABF57949130
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Yes, you need to setup a an odbc datasource, a jde datasource, and, I beleive
an object librarian entry. Then you need to run the ube locally until
the program gets built into a package and put on the server.


ps we usually import text files into access files using file templates
of jde files becuase it is easier to import from a foreign table than a
text file.


gng_ca wrote:
<blockquote TYPE=CITE>Hi,


Have anybody use the flat fle conversion UBE? I am

following the example from the Developer's guide, but

can't get it to work.


I am trying to upload a cvs flat file to OW

(Oracle/NT/JDE 7332). The "Import Flat File' UBE

failed with error code 3003. Any idea on how to find

more info on this error code?


Where should the flat file be located (server/local)?

I created a test file on my local C:\. Do I need to

set up the Data source and data mapping?


Your help is appreciated,

Gordon


__________________________________________________

Do You Yahoo!?

Yahoo! Messenger - Talk while you surf! It's FREE.

http://im.yahoo.com/


--------------------------

To view this thread, visit the JDEList forum at:

http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Number=177

*************************************************************

This is the JDEList One World Developers Mailing List.

Archives and information on how to SUBSCRIBE, and

UNSUBSCRIBE can be found at http://www.JDELIST.com

*************************************************************</blockquote>
</html>

--------------499DF2FFF7F13ABF57949130--
 
What database are you coming from and to? We currently do conversions into
SQL Server using comma delimited flat files. We had problems as well using
the flat file conversion and decided to go directly through Data
Transformation in SQL 7.0. This worked great. You loose any edits that
Edwards was doing, but that is easily checked.



From: gng_ca <[email protected]>@jdelist.com on 10/26/2000 06:37 PM

Please respond to [email protected]

Sent by: [email protected]


To: [email protected]
cc:
Subject: Flat File Conversion (R47002C) ~~0:177


Hi,

Have anybody use the flat fle conversion UBE? I am
following the example from the Developer's guide, but
can't get it to work.

I am trying to upload a cvs flat file to OW
(Oracle/NT/JDE 7332). The "Import Flat File' UBE
failed with error code 3003. Any idea on how to find
more info on this error code?

Where should the flat file be located (server/local)?
I created a test file on my local C:\. Do I need to
set up the Data source and data mapping?

Your help is appreciated,
Gordon


__________________________________________________
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE.
http://im.yahoo.com/




--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Number=177

*************************************************************
This is the JDEList One World Developers Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 
We are running Oracle 8.0 on NT. We'll try Access
route for now and see how it goes.

Thanks for sharing all the valuable experience.

Gordon

--- Kenneth_Elder <[email protected]> wrote:
>
> What database are you coming from and to? We
> currently do conversions into
> SQL Server using comma delimited flat files. We had
> problems as well using
> the flat file conversion and decided to go directly
> through Data
> Transformation in SQL 7.0. This worked great. You
> loose any edits that
> Edwards was doing, but that is easily checked.
>
>
>
> From: gng_ca <[email protected]>@jdelist.com on
> 10/26/2000 06:37 PM
>
> Please respond to [email protected]
>
> Sent by: [email protected]
>
>
> To: [email protected]
> cc:
> Subject: Flat File Conversion (R47002C) ~~0:177
>
>
> Hi,
>
> Have anybody use the flat fle conversion UBE? I am
> following the example from the Developer's guide,
> but
> can't get it to work.
>
> I am trying to upload a cvs flat file to OW
> (Oracle/NT/JDE 7332). The "Import Flat File' UBE
> failed with error code 3003. Any idea on how to
> find
> more info on this error code?
>
> Where should the flat file be located
> (server/local)?
> I created a test file on my local C:\. Do I need to
> set up the Data source and data mapping?
>
> Your help is appreciated,
> Gordon
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Messenger - Talk while you surf! It's FREE.
> http://im.yahoo.com/
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Number=177
>
>
*************************************************************
> This is the JDEList One World Developers Mailing
> List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
>
*************************************************************
>
>
>
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Number=191
>
>
*************************************************************
> This is the JDEList One World Developers Mailing
> List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
>
*************************************************************
>


__________________________________________________
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE.
http://im.yahoo.com/
 
You could find more info in the data dictionary because your error is a
standard Error.
3003 says that your file is not accessible.

The flat files can be on your local computer or on the server. But you must
say where it is located with the P47002 application. I think that The
"Import Flat File' UBE is not the better way to import data into OneWorld,
but it works fine. I prefer to use the table conversion UBE to import data.

If you want more details, send me an email.

Franck BLETTNER

email: mailto:[email protected]
tel. (33) 04 72 13 16 16
FOCAL Ingénierie SUD
Le 6e Avenue, 75, cours Albert Thomas
69447 LYON Cedex 03 FRANCE



-----Message d'origine-----
De : Kenneth_Elder [mailto:[email protected]]
Envoyé : vendredi 27 octobre 2000 18:49
À : [email protected]
Objet : Re: Flat File Conversion (R47002C) ~~177:191



What database are you coming from and to? We currently do conversions into
SQL Server using comma delimited flat files. We had problems as well using
the flat file conversion and decided to go directly through Data
Transformation in SQL 7.0. This worked great. You loose any edits that
Edwards was doing, but that is easily checked.



From: gng_ca <[email protected]>@jdelist.com on 10/26/2000 06:37 PM

Please respond to [email protected]

Sent by: [email protected]


To: [email protected]
cc:
Subject: Flat File Conversion (R47002C) ~~0:177


Hi,

Have anybody use the flat fle conversion UBE? I am
following the example from the Developer's guide, but
can't get it to work.

I am trying to upload a cvs flat file to OW
(Oracle/NT/JDE 7332). The "Import Flat File' UBE
failed with error code 3003. Any idea on how to find
more info on this error code?

Where should the flat file be located (server/local)?
I created a test file on my local C:\. Do I need to
set up the Data source and data mapping?

Your help is appreciated,
Gordon


__________________________________________________
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE.
http://im.yahoo.com/




--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Numb
er=177

*************************************************************
This is the JDEList One World Developers Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************







--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Numb
er=191
*************************************************************
This is the JDEList One World Developers Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 
Re: RE: Flat File Conversion (R47002C)

Franck,
That is interesting. Where in the DD does it define that error code (3003) ?
TIA,
dave
 
Re: RE: Flat File Conversion (R47002C)

Dave, do not wonder.

If I'm right, messages (error, warning, workflow, etc.) are also treated as Data Dictionary Items by JDE terminology. Although, their usage are quite different, they are not for data storage like PRIMARY Data Items are.

You can access Error Messages on the same GH951 "Data Dictionary Design" menu like Primary Data items, further you can acces it from the "Work With Data Items" form (P92001/W92001B) via "Glossary Data Item" form exit too.

Zoltan
 
Re: RE: Flat File Conversion (R47002C)

Yes, this makes sense. Thank you sir !
dave
 
Back
Top