‎2008 Dec 03 6:48 AM
hii
what is the meaning of file type in ws_upload function module
for excel files what will be the file type
‎2008 Dec 03 6:50 AM
Hi
there r 4 possible values for file type...
'ASC' : ASCII file
The file is loaded line by line in the transferred table and this should have one-column and be of the type C. The file size is returned in the parameter FILELENGTH.
'TRU' : ASCII file + line wrap
If a line in a file does not fit into a row in a table, then the row is filled completely, and the rest of the line is written to the next row in the table. Words are not split, instead they are put into the next row of the table.
'BIN' : Binary file
The file is loaded into the transferred table which should have one-column and be of the type X. The table is filled line by line in this case. In this case, the last line need not necessarily be completely filled. For this reason, the parameter FILELENGTH must be used during further processing. The table may be a maximum of 1022 characters 'wide'!
'DAT' : ASCII file with tab formatting
The file is loaded line by line into the transferred table. Tabs in the file mean a change of field.
The file size is returned in the parameter FILELENGTH.
For ur excel sheet you can use ASC.....dats wat i normally use...
Regards
Winnie
‎2008 Dec 03 6:50 AM
Hi
there r 4 possible values for file type...
'ASC' : ASCII file
The file is loaded line by line in the transferred table and this should have one-column and be of the type C. The file size is returned in the parameter FILELENGTH.
'TRU' : ASCII file + line wrap
If a line in a file does not fit into a row in a table, then the row is filled completely, and the rest of the line is written to the next row in the table. Words are not split, instead they are put into the next row of the table.
'BIN' : Binary file
The file is loaded into the transferred table which should have one-column and be of the type X. The table is filled line by line in this case. In this case, the last line need not necessarily be completely filled. For this reason, the parameter FILELENGTH must be used during further processing. The table may be a maximum of 1022 characters 'wide'!
'DAT' : ASCII file with tab formatting
The file is loaded line by line into the transferred table. Tabs in the file mean a change of field.
The file size is returned in the parameter FILELENGTH.
For ur excel sheet you can use ASC.....dats wat i normally use...
Regards
Winnie