Re: 1WorldXE - Interface/Time Entry

AMASKAR

Member
Re: 1WorldXE - Interface/Time Entry

HI Jude,
If u could just tell me what situation r u in & what s the objective of ur process I can try helping u on this.

- Ajay

>>> jejims@yahoo.com 02/27/01 10:50AM >>>
Hello list

I am in a jam. Can any body instruct me on the exact steps needed to populate a flat file before conversion into the
Z-Table (f06116z1).

The information I need is already in an access table but with desimilar data types. All helps will be appreciated. You may
respond to me directly.

Thanks in advance.

Jude
 

jejims

Active Member
Re: 1WorldXE - Interface/Time Entry

Ajay.
The situation is that I am trying to write an interface b/w Time Collection
system whose database is not compatible
with 1world.
I have succeed in extracting the records to an access database.
All I need to populate to f06116z1 through a flat file conversion (R47002c)
are the total hours, empnum, cost center, ...... .
On successful writes, start the Z-input batch to f06116 and create time
cards.
I cannot seem to get these to happen for me. How do you get records to flat
files? I am going nuts!

Would appreciate all your help if time permits.
Jude
----- Original Message -----
From: "AMASKAR" <AMASKAR@mail.35sys.com>
To: <jdeowdevml@jdelist.com>
Sent: Tuesday, February 27, 2001 3:36 PM
Subject: Re: 1WorldXE - Interface/Time Entry


> HI Jude,
> If u could just tell me what situation r u in & what s the objective of ur
process I can try helping u on this.
>
> - Ajay
>
> >>> jejims@yahoo.com 02/27/01 10:50AM >>>
> Hello list
>
> I am in a jam. Can any body instruct me on the exact steps needed to
populate a flat file before conversion into the
> Z-Table (f06116z1).
>
> The information I need is already in an access table but with desimilar
data types. All helps will be appreciated. You may
> respond to me directly.
>
> Thanks in advance.
>
> Jude
>
>
>
>
> --------------------------
> 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=6329
> *************************************************************
> This is the JDEList One World / XE Developers Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
 

jejims

Active Member
Re: 1WorldXE - Interface/Time Entry

Yes, I have. It is giving me a nine page filled with errors. I am doing this
on demo junior.
I hope this is not part of my problem. I may need detailed instructions.


----- Original Message -----
From: "Ellen Deak" <Ellen.Deak@elkhartproducts.com>
To: <jdeowdevml@jdelist.com>
Sent: Wednesday, February 28, 2001 3:06 PM
Subject: RE: 1WorldXE - Interface/Time Entry


> Have you tried doing a table conversion directly from the Access database?
>
>
>
>
> --------------------------
> 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=6449
> *************************************************************
> This is the JDEList One World / XE Developers Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
 

Adrian_Chimirel

Legendary Poster
Re: 1WorldXE - Interface/Time Entry

Jude,
In order to have the Table Conversion work, there are a few initial mandatory steps, such as:
1-Create the ODBC & OneWorld datasources
2-Create a OW Environment (used for Input Environment, to be able to select your foreign/Access table from)
Have you created'em?
In order for you to get detailed instructions, please provide detailed symptoms; did you try to zip and attach your nine pages/logs?
You will have your TC working, if not this week, definitely the next one, trust the JDEList!
Warm regards,

Adrian Chimirel
Programmer Analyst
LIVE: B732.1 SP12.2, Oracle 806
SANDBOX: XE SP13, 8i
RS/6000, Citrix, 200+ clients
 

jejims

Active Member
Re: 1WorldXE - Interface/Time Entry

This is a multi-part message in MIME format.

------=_NextPart_000_001B_01C0A243.A7BF1400
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Yes, I have gone through the initial steps and they seem ok. The zipped log
is attached.
Help!!!

----- Original Message -----
From: "Adrian_Chimirel" <adrian.chimirel@home.com>
To: <jdeowdevml@jdelist.com>
Sent: Thursday, March 01, 2001 9:26 AM
Subject: Re: 1WorldXE - Interface/Time Entry


> Jude,
> In order to have the Table Conversion work, there are a few initial
mandatory steps, such as:
> 1-Create the ODBC & OneWorld datasources
> 2-Create a OW Environment (used for Input Environment, to be able to
select your foreign/Access table from)
> Have you created'em?
> In order for you to get detailed instructions, please provide detailed
symptoms; did you try to zip and attach your nine pages/logs?
> You will have your TC working, if not this week, definitely the next one,
trust the JDEList!
> Warm regards,
>
> Adrian Chimirel
> Programmer Analyst
> LIVE: B732.1 SP12.2, Oracle 806
> SANDBOX: XE SP13, 8i
> RS/6000, Citrix, 200+ clients
> --------------------------
> Visit the forum to view this thread at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Numbe
r=6489
> *************************************************************
> This is the JDEList One World / XE Developers Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************

------=_NextPart_000_001B_01C0A243.A7BF1400
Content-Type: application/x-zip-compressed;
name="Log.zip"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="Log.zip"

UEsDBBQAAAAIAApcYSoZGoTrqgQAAIktAAAHAAAATG9nLnR4dO2a2W7bRhSGr23A73DucuM6M1y0
3dmS7Cb1omgpmgaBQJFH1tRcVM5Qtvr0PUNqrVGgpGm5SSgDhkQO5z/bR5k/bBlN06iZ9Pu9pd82
9c/RcJbAjRMD48BZizdbVh0MxvjRUef6anwzuLrgTXZyfPTlQ7hwfOHB3QLjx1gohCiGPjreVxjO
EORSKgwgcJYwQTcKEJJQKmfi41nPR0cieDhJ7kHR2vP53Beuo0QUQiJFmB3tLjBU0E98hI5eeo/x
GZwc7yxu9ZjNee13fpStbV0kStEebVrwgN7J8cmxzsxiFqvZ77O3pv0sSctoGXyV5F3noj0e8aZh
U470gdGL1zn8BINP17dJ0EeZ+Eq2I1/C1BE+eiBCGOq84JKxpkGX0ckkCGF0PRp0+xTxUcehxHXK
XSUCHEbK8X+Okli+KMAGbfxvMZ3CABGuo/sXKTR1m2+EG0cymqqvX/QJ2HyGc9dFKaETC5qArOnb
kx9RgbdOG8N7ESK4ThhGCqYi9NIGi3CeKEhnQs/OnwnGS3iXVvHdGVB0DzRGSUwLFeCTkEqCk17q
KDokIXRoqoQEOUdfN8KN4hhd5S/PsnYNhufDbgsG1EKjSCE+di50ytyy69thYLZNu3dQurGY4Cr6
1SRMKQu1HYWzIqJ/eJOxFy+CepOTKIXQbNLxWoNELzMVFVHlhBJE319E0QRipNJJVSjFYW/cvuGs
0diIkVydxEZhmgiJRRPl0Ix7aZ/XYjCjVviYR9MoA7Fmo8bNLWN3N6Orfq8sxp5FWDpjzxTeiLG0
jG8KmVECZGkWuSgzDkqZ8YaU6Qxdx501GtY2Q8asvQwl+tRLmMZRsEHrwEDrGyV/rS/NHwfotIzf
PNBpFhXQr0KZzbaUXQ4G3eHnirIClNnse6DMZhVl5VNWN1ltC9mvnwYVYrkR0zX85gnTSfxAgO24
SCZtbPA9Td4y6i1m7pfVYCbfIaxhZk3rPqGbqHVJX75/vgF2Ka17lLCMknWmWcX1vGatfUSaSD3H
Mkmvnya+9rechAadVi3hMUp8GsYYHUrDSzKvCmHh+LSdvldks+/h0ynMYxE4NPUPuDzVDMTop76W
nIk5IdBOw0kv0DCtL54KJAVanr6RGRFuFGZ92ijqS05pyyBa4K5oquPhVDO5OayTnGMcEGvbHTBU
saCgd3EyqAGsSF/Wk91o1LeTbTG+N9m4av/zsc4rRTspy+IriggFejX3tChdIjaAD6HEWKX00iOQ
yWy+QcngplnPUDJYw7KfaxqsrGegQo9ARQLM981RROG79A1zFKI83zCHaAnfHHlSLOtPs/+gWYo1
X9w3LBJh6Yz9X7z5V/YNc1SiRN8wh+phKCvdnc+Z4Ut8w0MBXdw3rIA+nG94IKD/4RtWQJdIWUHf
sKLscL7h4Sjb9Q0rysqirKBvWCF2MN/wQITt+4YVYKRprzSV6yXB3EwdnWG7S/ciZlqp4kMYPYbQ
GdxdfBwPP/e6YNq5arhW6A9/GXd/691aNc1wf3SbNU67RhpFUMu5nj4aqnlMI6z/Wc2LUKZuYOAo
d7Z16tKl0TQ7IFzt6WmfTygMqtCq0KrQqtCq0KrQVqH9DVBLAQIUABQAAAAIAApcYSoZGoTrqgQA
AIktAAAHAAAAAAAAAAEAIAC2gQAAAABMb2cudHh0UEsFBgAAAAABAAEANQAAAM8EAAAAAA==

------=_NextPart_000_001B_01C0A243.A7BF1400--


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
 

jejims

Active Member
Re: 1WorldXE - Interface/Time Entry

Here are some of the errors I get.

4293404065/4293403529 Thu Mar 01 10:42:22 2001 jdb_drvm791
JDB9900168 - Failed to initialize db request

4293404065/4293403529 Thu Mar 01 10:42:22 2001 JTP_CM1088
JDB9909007 - Unable to obtain driver request handle

4293404065/4293403529 Thu Mar 01 10:42:22 2001 ODBC_U1925
ODB0000171 - SQLNumResultsCols failed in Table F7306
Column VQSY
Database EtimeTotalHours

4293404065/4293403529 Thu Mar 01 10:42:22 2001 ODBC_U1928
SQLNumResultsCols failed, See Log

4293404065/4293403529 Thu Mar 01 10:42:22 2001 ODBC_U1929
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine
cannot find the input table or query 'F7306'. Make sure it exists and that
its name is spelled correctly. - SQLSTATE: S0002

4293404065/4293403529 Thu Mar 01 10:42:22 2001 JDBODBC1457
ODB0000055 - Describe table failed for table F7306.

----- Original Message -----
From: "Ellen Deak" <Ellen.Deak@elkhartproducts.com>
To: <jdeowdevml@jdelist.com>
Sent: Thursday, March 01, 2001 1:06 PM
Subject: RE: 1WorldXE - Interface/Time Entry


> Can you post a sample of the first few errors?
>
>
>
>
> --------------------------
> 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=6510
> *************************************************************
> This is the JDEList One World / XE Developers Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
 

f_blettner

Member
RE: 1WorldXE - Interface/Time Entry

This error is not a problem because OW try to found this table in the
foreign database but this table isn't used. Do you have another errors in
your log ? If not, try to execute your batch with logs.

-----Message d'origine-----
De : jejims [mailto:jejims@yahoo.com]
Envoyé : jeudi 1 mars 2001 22:26
À : jdeowdevml@jdelist.com
Objet : Re: 1WorldXE - Interface/Time Entry


Here are some of the errors I get.

4293404065/4293403529 Thu Mar 01 10:42:22 2001 jdb_drvm791
JDB9900168 - Failed to initialize db request

4293404065/4293403529 Thu Mar 01 10:42:22 2001 JTP_CM1088
JDB9909007 - Unable to obtain driver request handle

4293404065/4293403529 Thu Mar 01 10:42:22 2001 ODBC_U1925
ODB0000171 - SQLNumResultsCols failed in Table F7306
Column VQSY
Database EtimeTotalHours

4293404065/4293403529 Thu Mar 01 10:42:22 2001 ODBC_U1928
SQLNumResultsCols failed, See Log

4293404065/4293403529 Thu Mar 01 10:42:22 2001 ODBC_U1929
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine
cannot find the input table or query 'F7306'. Make sure it exists and that
its name is spelled correctly. - SQLSTATE: S0002

4293404065/4293403529 Thu Mar 01 10:42:22 2001 JDBODBC1457
ODB0000055 - Describe table failed for table F7306.

----- Original Message -----
From: "Ellen Deak" <Ellen.Deak@elkhartproducts.com>
To: <jdeowdevml@jdelist.com>
Sent: Thursday, March 01, 2001 1:06 PM
Subject: RE: 1WorldXE - Interface/Time Entry


> Can you post a sample of the first few errors?
>
>
>
>
> --------------------------
> 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=6510
> *************************************************************
> This is the JDEList One World / XE Developers Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.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=6523
*************************************************************
This is the JDEList One World / XE Developers Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 

Adrian_Chimirel

Legendary Poster
Re: 1WorldXE - Interface/Time Entry

Hey Jude,
I'd like you to consider one of the two options that could make our life just a little easier:
1 - Use the Forum; the attachment are allowed there. As Eric spelled it out, the JDEList is not (yet) able to handle attachments.
2 - If you can't use the Forum, try to change your Outlook's MIME format to UUENCODE (not very sure about it, Dave (got_to _love_jde) had a thread "I don't like MIME mesages" and offered a solution for it, too).
Now, I had similar problems and I remember these hints:
a) The new environment has been created as a copy of the DEVB732 env.
b) The last step in configuring the TC was the OCM Default map (guess you've done it).
c) I FORGOT to check the "Write record" check-box :) I hope you won't!
Look into the FORUM's archives; topics such as Table Conversion, Foreign Table ...
Good luck now,

Adrian Chimirel
Programmer Analyst
LIVE: B732.1 SP12.2, Oracle 806
SANDBOX: XE SP13, 8i
RS/6000, Citrix, 200+ clients
 
Top