| csv file to be loaded from FTP [message #298069] |
Mon, 04 February 2008 22:50  |
manjuwkh
Messages: 7
Registered: January 2008
Location: Bangalore
|
Junior Member |
|
|
Hi all,
I'm trying to load a .csv File from FTP
But Its not at all able to pick the file, If its more than 250 Bytes, below this size its working fine....
But I can load a Maximum of 2000 bytes file, but its in .txt format....
Can i get some help on this?
I'm on a Linux Platform...
Thanks,
|
|
|
|
|
|
|
|
|
|
| Re: In FTP, csv file Size [message #298081 is a reply to message #298069] |
Mon, 04 February 2008 23:52  |
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
|
Member |
|
|
| Quote: | I'm trying to load a .csv File from FTP
|
upload or download ?, Which FTP client, Which FTP server, What is your error message. If you expect a reply for your questions in any forum than be kind enough to post enough details about your situation. It is not possible to figure out what you are attempting.
Regards
Manjit Kumar [mkbhati]
|
|
|
|
|
|
| Re: csv file to be loaded from FTP [message #298102 is a reply to message #298069] |
Tue, 05 February 2008 00:40 |
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
|
Member |
|
|
| Quote: | I coded using pl/sql to pick a file from Unix, then put into FTP
|
No one in this forum can make out what you are attempting to do until you explain your situation clearly. Which built in package you are using for FTP or you are directly manipulating TCP packages and playing with sockets on your own. Do not expect a reply until you explain your situation clearly.
Regards
Manjit Kumar [mkbhati]
|
|
|
|
|
|
| Re: csv file to be loaded from FTP [message #298115 is a reply to message #298069] |
Tue, 05 February 2008 01:15 |
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
|
Member |
|
|
| Quote: | am not a DBA guy, just got this in morning. am not much aware of FTP..
|
Fine, but what is preventing you from explaining your situation clearly. This forum has a reputation. Forum members are generous enough to answer even silliest questions. So do not hesitate in asking since it is the only secret to learning. No one in this forum is a borne DBA, everybody grew up with time & experience.
| Quote: | Tell me one thing, Mode transfer should be ASCII or Binary??
|
The transfer mode for FTP depend upon file content. if content is binary than use binary mode. If content is text than use text mode. In text mode you get CRLF translations done according to target host during transmission. In binary mode file contents are transmitted as it is without any kind of change or translations during transmission.
Regards
Manjit Kumar [mkbhati]
|
|
|
|
| Re: csv file to be loaded from FTP [message #298125 is a reply to message #298069] |
Tue, 05 February 2008 01:33 |
manjuwkh
Messages: 7
Registered: January 2008
Location: Bangalore
|
Junior Member |
|
|
Thanks Yaar Manjeet, for your time
It got solved, i was using ASCII mode
File contains both Text as well binary data.
But, with Binary its working fine....
So, will go with it...
Thanks all....
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
