[SOLVED] 'as.csv' -Load CSV Data via the Application Server

geetikadua · #1 (**permalink**) April 17th, 2009, 09:55

Dear Users,

I read somewhere that when we upload a file whose name ends in “as.csv” instead of just “.CSV”, it will be interpreted as an application server CSV file, as opposed to a database-centric CSV file .
I tried the same, but it was not a successful attempt.

Has someone worked on 'as.csv' before??

Any suggestion is highly appreciated

Regards

Geetika Dua

Dave Lee · #2 (**permalink**) April 21st, 2009, 03:04

Quote:

Originally Posted by geetikadua

Dear Users,

I read somewhere that when we upload a file whose name ends in “as.csv” instead of just “.CSV”, it will be interpreted as an application server CSV file, as opposed to a database-centric CSV file .
I tried the same, but it was not a successful attempt.

Has someone worked on 'as.csv' before??

Any suggestion is highly appreciated

Regards

Geetika Dua

I dun have this problem. I am able to upload data via Integration in OTM using CSV file having both CSV and csv extension.

geetikadua · #3 (**permalink**) April 21st, 2009, 05:03

Hi Dave Lee,

Thanks for the response, Could you please share some test file of as.csv , which was successful during upload . Might be i am missing something

Regards
Geetika Dua

Dave Lee · #4 (**permalink**) April 21st, 2009, 06:10

No problem. I am sending you the Order Base Ref Number Qualifier csv data that i have uploaded successfully. Hope it's will help

geetikadua · #5 (**permalink**) April 21st, 2009, 06:21

Hi Dave Lee

Thank you for the attachment, but i need a appilcation server csv, which ends with 'as.csv' not like a normal csv .
Say for the same file OB_REFNUM_QUAL.csv , name for application csv would be OB_REFNUM_QUAL.as.csv

Can you please provide me that if possible.

Regards
Geetika Dua

nipunlakhotia · #6 (**permalink**) April 21st, 2009, 08:53

Hi Geetika,

PFA sample as.csv file (Location.as.csv). I tried this and it was uploaded correctly.

Please note the second line must be a comma-separated list of attribute names. Attribute names are like database column names, except they omit the underscores and use mixed case. For example,a column called location_gid corresponds to the attribute locationGid. Note that the first character is in lower-case for attribute names, but upper case for entity names.

geetikadua · #7 (**permalink**) April 21st, 2009, 09:19

Hi Nipun,

Its still giving the error which i found previously .

Please view the attachment for the error, It says ''class not found'' !! I am using OTM 5.5 . Which OTM version you are using ?

Please suggest !!!

Regards
Geetika Dua

nipunlakhotia · #8 (**permalink**) April 21st, 2009, 10:25

Hi Geetika,

I am working on OTM 5.5 cu04 and the above CSV get loaded correctly (without any such error). Just cross check again whether you have entered the domain names correctly at all places in the CSV

geetikadua · #9 (**permalink**) April 24th, 2009, 11:03

Hi Nipun,

domain looks fine, Still the same error

Regards
Geetika Dua

nipunlakhotia · #10 (**permalink**) April 24th, 2009, 11:52

Then it might be some other issue pertaining to domain/installation. Check with oracle support for the same