Import date format for CSV

[KBURKE]

I have tried several ways to import the date for the Tariff_Effective_Date in the Rate Offering import file. I have saved the column as text and used 1999-10-01 to no avail.

Any ideas?

[nick.polites]

Re: Import date format for CSV

You need to set the date format in the top of your CSV file. Please refer to the data loading guide found in your /otm/docs directory on your app server.

The third line in your CSV needs to look something like this:

EXEC SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYYMMDDHH24MISS'

[KBURKE]

Re: Import date format for CSV

NICK,

Can I modify the date format to exclude time?

[asheema.garg]

Re: Import date format for CSV

Hi,

Im also facing the same issue I have given in thrid line of my CSV file, and date format is given in 29-Oct-2013 format, but then also it is not processing and showing below error.

EXEC SQL ALTER SESSION SET NLS_DATE_FORMAT ='YYYYMMDDHH24MISS'

Please suggest ..

TableName>OB_ORDER_BASE</TableName>
<Exception>ORA-01858: a non-numeric character was found where a numeric was expected</Exception>


<Data>EBS.PO-4113242.1-975724522,PO-4113242.1-975724522,PURCHASE_ORDER,29-Oct-13,KGM,0,0,FTQ,0,EBS,EBS.ADMIN,501976985</Data>



Thanks

[bixam]

Re: Import date format for CSV

Asheema,

Since you specified the date format as YYYYMMDDHH24MISS, the date value should be in the same format. (change 29-Oct-13 to 20131029000000).

[shanki]

Re: Import date format for CSV

Try this...
In your CSV, in the 3rd line you will notice the EXEC SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYYMMDDHH24MISS'
Replace it with
EXEC SQL ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MM-YYYY HH24MISS'
Change the date format appropriately in all the applicable columns. It works.

[Prasad Chandane]

Re: Import date format for CSV

Hello,

Please find attachment for sample csv file which contains proper date format

Note: Do not open file in Microsoft Excel and kindly change files extension to .csv before uploading it to OTM

Thank you!


Kr, Prasad