Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

textfile uploads to SAP problem.

SOLVED
Go to solution
JoyBag_1
Frequent Advisor

textfile uploads to SAP problem.

Hi,

I have a weird problem with uploading files to SAP. We have a process the FTP's an encrypted file from an external source, de-crypts it and uploads the plaintext file to SAP.

Well, thats the way it should work, but the SAP admins are telling me that there is a problem with the file. they are tell saying that no matter how many records are in the file, SAP is always seeing it as one big record on a single line. When I vi the file or run a 'wc -l' on it it clearly shows multiple lines/records.

Intially we thought it may be a problem with FTP embedding control characters in the file (^M and such like), but we have now added a dos2ux command to the process to strip these out but we are still getting the same problem.

Has anyone come across this before? I would have thought SAP is pretty robust when it comes to file formats?

Thanks in advance.
2 REPLIES
Steven E. Protter
Exalted Contributor
Solution

Re: textfile uploads to SAP problem.

Shalom,

If the file is encrypted, it is binary and should be uploaded and decrypted on the Unix server if possible.

If not, consider using sftp which gets binary/ascii ascii/binary issues right 100% of the time.

The windows ftp client, if you are using it defaults to ascii. If the file is binary this could be the cause of the problem.

You might be able to use dos2unix on the file after upload, but its most likely better to get the upload right.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
JoyBag_1
Frequent Advisor

Re: textfile uploads to SAP problem.

Steven, thanks for the suggests, but I'd already tried them.

As suspected, the problem was with the SAP upload process not the file structure.

thread closed.