Skip to Content (Press Enter)
2011-07-05 18-23-55
Fernanda Rodrigues
5Views
2Comments
Upload from an Excel file
Question
Hi,

I´m trying to upload some data from an excel file to the database, with no sucess. After implement in outsystems the upload action, everything is nice and functional, but when i´m trying to upload it from the browser an error occurs:

Error - could not read from file. Not a valid/supported excel file. System error - External table is not in the expected format.

Can anyone help me.

Thanks

Fernanda Rodrigues
RH_v7.oml
0
0
18 Feb 2009
Copy Link
UserImage.jpg
Nuno Mendes
Hi Fernanda,

Taking a quick look at your eSpace, it seems that you are talking about the WebScreen2, that's it right?

That error occurs when you are trying to upload an excel with the different structure from the expected, as you are "mapping" the ExcelToRecordList to the entity BOOK1, the excel should have te Format with the colummns Id, Projecto, Revenue, Invoicing, wip_bia.
In OutSystems when we upload an excel file we often use structures to mapp the excel into it.

I hope this helps!

Best Regards,
Nuno Mendes
1
0
18 Feb 2009
Copy Link
2011-07-05 18-23-55
Fernanda Rodrigues
Thanks
0
0
19 Feb 2009
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.