TableConversion

[Shiji]

Hai All,

When I do table conversion from MS ACCESS to JDE it is giving the error "Date dataType not implemented" for all the date fields.

Can anyone tell me how can I rectify this? When I do not map the date fields it is working fine. But how can I map the date fields and transfer the datas to JDE?


-Shiji

 

[cuhand]

convert date to jde format

 

[Adrian_Chimirel]

Hi Shiji, and welcome to the JDEList!
The Access "Date" datatype is different from OneWorld's: OW uses a Julian datatype, i.e.
Human Access (m/d/y) OW
Jan 1, 1995 1/1/1995 95001
Jan 30, 2003 1/30/2003 103030

If you look into JDE's database (and you did NOT specify it - why?) you'll notice the difference.
I suggest you:
1 - research the archives for "Date" and "Julian Date", and
2 - modify the values in Access accordingly, BEFORE mapping/convert your table,
3 - describe your system configuration information; see mine?
Warm regards,

 

[Christian Audet]

Shiji,

I'm doing a conversion from a system that have a DateTime field like yours and This is what we did :

- First we created a view in SQL to select data from the Foreign table:

Example : (Lets say that created_date from your foreign file is a DateTime field)

***View F55TEST***
SELECT name as XXName,
Company as XXCompany,
CONVERT(char, created_date, 112) AS XXDate,
CONVERT(char, created_date, 108) AS XXTime
From "External File"

Then in OneWorld Table Conversion Tools you use F55TEST and you convert XXDate and XXTime from String to Date and Time separatly.

That our way of doing it and we tried it with 5 million records

Christian Audet