# Import from csv **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [April 9, 2024, 10:47am UTC](https://forums.toadworld.com/t/import-from-csv/59222 "2024-04-09T10:47:26Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\ **Post date:** [April 9, 2024, 10:47am UTC](https://forums.toadworld.com/t/import-from-csv/59222/1 "2024-04-09T10:47:26Z")
Toad 17.0.353 ```auto CREATE TABLE P97911_BKP_A1PPP_A1PPI_SF ( BAN NUMBER(9) NOT NULL, SUBSCRIBER_NO VARCHAR2(25 CHAR) NOT NULL, SOC CHAR(9 CHAR) NOT NULL, SOC_SEQ_NO NUMBER(9) NOT NULL, SERVICE_FTR_SEQ_NO NUMBER(9) NOT NULL, FTR_SOC_VER_NO NUMBER(9) NOT NULL, SYS_CREATION_DATE DATE NOT NULL, SYS_UPDATE_DATE DATE, OPERATOR_ID NUMBER(9), APPLICATION_ID CHAR(6 CHAR), DL_SERVICE_CODE CHAR(5 CHAR), DL_UPDATE_STAMP NUMBER(4), SOC_EFFECTIVE_DATE DATE NOT NULL, CUSTOMER_ID NUMBER(9) NOT NULL, FEATURE_CODE CHAR(6 CHAR) NOT NULL, SERVICE_TYPE CHAR(1 CHAR) NOT NULL, SOC_LEVEL_CODE CHAR(1 CHAR) NOT NULL, FTR_EFFECTIVE_DATE DATE NOT NULL, FTR_EFF_RSN_CODE CHAR(1 CHAR), FTR_EXPIRATION_DATE DATE, FTR_EXP_RSN_CODE CHAR(1 CHAR), SERVICE_FTR_QTY NUMBER(4) NOT NULL, RC_WAIVER_EFF_DATE DATE, RC_WAIVER_EXPR_DATE DATE, RC_WAIVER_RSN CHAR(6 CHAR), RC_WAIVER_OPID NUMBER(9), CONV_RUN_NO NUMBER(3), FTR_EFF_ISSUE_DATE DATE, FTR_EXP_ISSUE_DATE DATE, FTR_TRX_ID NUMBER(9), FTR_PREV_SEQ_NO NUMBER(9), FTR_ADD_SW_PRM VARCHAR2(2000 CHAR), FTR_INS_TRX_ID NUMBER(9), ADDITIONAL_INFO_AMT NUMBER(11,2), ADDITIONAL_INF_EU_AMT NUMBER(11,4), ADDITIONAL_INFO_TYPE CHAR(1 CHAR), ADDITIONAL_INFO VARCHAR2(20 CHAR), BEN NUMBER(5), CHARGE_LEVEL_CODE CHAR(1 CHAR), REVENUE_CODE CHAR(3 CHAR), PRODUCT_TYPE CHAR(1 CHAR), MSISDN VARCHAR2(25 CHAR), FRIENDS_FAMILY_PARAM VARCHAR2(150 CHAR), RC_FREQ NUMBER(2), CPI_START_DATE DATE, RTR_EFFECTIVE_DT DATE, RTR_EXPIRATION_DT DATE ) TABLESPACE BATCH PCTUSED 40 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 40K NEXT 40K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; ``` Data (just swhing first few rows...enough to understand the problem: ```auto 523606215;06803224466;PRCBOB7 ;704036853;719236779;0;16-nov-2010 21:09:22;21-sep-2014 13:55:30;1074;RT1074;82109;8211;16-nov-2010 00:00:00;523606215;A1PPP ;P;C;16-nov-2010 00:00:00;A;;;0;;;;;;16-nov-2010 00:00:00;;703336722;;;703336722;;;;;;;;A;;;;;16-nov-2010 21:09:21; 522126687;06802313713;PRCBOB8 ;704039907;719255910;0;17-nov-2010 18:12:16;21-sep-2014 13:57:20;1074;RT1074;82109;8211;17-nov-2010 00:00:00;522126687;A1PPP ;P;C;17-nov-2010 00:00:00;A;;;1;;;;;;17-nov-2010 00:00:00;;703338636;;;703338636;;;;;;;;A;;;;;17-nov-2010 00:00:00; 521404568;06506226776;PRCBOB7 ;704044345;719283394;0;18-nov-2010 19:46:37;21-sep-2014 13:57:29;1074;RT1074;82109;8211;18-nov-2010 00:00:00;521404568;A1PPP ;P;C;18-nov-2010 00:00:00;A;;;1;;;;;;18-nov-2010 00:00:00;;703341396;;;703341396;;;;;;;;A;;;;;18-nov-2010 00:00:00; 521677794;06801337516;PRCBOB7 ;704044756;719286017;0;18-nov-2010 21:23:43;21-sep-2014 13:57:29;1074;RT1074;82109;8211;18-nov-2010 00:00:00;521677794;A1PPP ;P;C;18-nov-2010 00:00:00;A;;;1;;;;;;18-nov-2010 00:00:00;;703341645;;;703341645;;;;;;;;A;;;;;18-nov-2010 00:00:00; ``` ![image](https://global.discourse-cdn.com/quest/original/3X/3/8/38be9f52ee07b18c128ff4ca2ef7496b2f34559b.png) Next... ![image](https://global.discourse-cdn.com/quest/original/3X/5/e/5eb796b79030a78183a4c81d200cce964054b2dc.png) Next steps still all fine! ![image](https://global.discourse-cdn.com/quest/original/3X/2/7/27e3922645188677695f3b46f8472df98fcf0e03.png) Ad then comes strange missing date format (not recognized) ![image](https://global.discourse-cdn.com/quest/original/3X/6/d/6d2c7835359208a78ef1081fd133e519f3242e56.png) ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [April 9, 2024, 12:47pm UTC](https://forums.toadworld.com/t/import-from-csv/59222/2 "2024-04-09T12:47:23Z")
Hi Damir, I see two problems here. 1. The date format you should be using is `dd-mmm-yyyy hh:nn:ss` (we want a Delphi date format here, not Oracle date format). 2. There is a bug in Toad here that's not accepting the dash as a date separator in the "custom" date order. I will fix. Workaround - Don't use "Custom" date format. This works: ![image](https://global.discourse-cdn.com/quest/original/3X/3/d/3d18472927f040ef3517b5b2c29a5a85075d3e96.png) ---
**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\ **Post date:** [April 9, 2024, 1:36pm UTC](https://forums.toadworld.com/t/import-from-csv/59222/3 "2024-04-09T13:36:11Z")
Cannot ide custim as sata i jave as is Brg Damir (from mobile) ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [April 9, 2024, 1:46pm UTC](https://forums.toadworld.com/t/import-from-csv/59222/4 "2024-04-09T13:46:33Z")
I have no idea what you just said. Use the date format that I showed you in my screen shot and it will work. ---
**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\ **Post date:** [April 9, 2024, 2:13pm UTC](https://forums.toadworld.com/t/import-from-csv/59222/5 "2024-04-09T14:13:13Z")
Ok this is clear John. You mentiibed data...data i cannot influence...iz is what is Brg Damir (from mobile) ---
**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\ **Post date:** [April 9, 2024, 2:13pm UTC](https://forums.toadworld.com/t/import-from-csv/59222/6 "2024-04-09T14:13:44Z")
Ahhhhh Google corect Brg Damir (from mobile) ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [April 9, 2024, 2:21pm UTC](https://forums.toadworld.com/t/import-from-csv/59222/7 "2024-04-09T14:21:27Z")
> [@damir.vadas\_250](#): > > You mentiibed data...data i cannot influence...iz is what is Sorry, I didn't mean to make the data in your file a different format. I meant, in Toad Data Import settings, you made your custom date format = `dd-mon-yyyy hh24:mi:ss`. It should be `dd-mmm-yyyy hh:nn:ss` because Toad needs Delphi date formats here, not Oracle date formats. But you can work around it by not using CUSTOM at all, and make your date settings like my screen shot. ---
**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\ **Post date:** [April 9, 2024, 4:34pm UTC](https://forums.toadworld.com/t/import-from-csv/59222/8 "2024-04-09T16:34:05Z")
DMY format worked. Custom (dd-mmm-yyyy hh24:mi:ss) stil not works...but let us say that problem is solve I do not understand what then format in that part mens except it is tthe same as i have it in Grid, what should not have anything with it. 🙂 Cheers. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [April 9, 2024, 4:51pm UTC](https://forums.toadworld.com/t/import-from-csv/59222/9 "2024-04-09T16:51:48Z")
Hi Damir, The grid has nothing to do with it. The "Custom" date format wants a Delphi date format string, not an Oracle date format string. So... `dd-mmm-yyyy hh24:mi:ss` is also wrong. `dd-mmm-yyyy hh:nn:ss` SHOULD work, but it does not, but as I said in my first reply: _There is a bug in Toad here that's not accepting the dash as a date separator in the "custom" date order._ _I will fix._ -John