Skip to Content

How to upload a Excel in custom BO

Dear Experts,

Are there any possibilities to upload an Excel file Directly in SAP ByDesign?

I succeeded to upload process. 1. Download XML file from Service Integration 2.Fill the data by Excel 3.Again convert to XML. 4. Upload that XML file in SAP ByDesign System.

But I need to upload an excel file directly instead of converting XML file. Is it possible? Please provide a solution!

Thanks,

Sankaran A

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jul 18, 2016 at 09:51 AM

    Hi Sankaran,

    unfortunatelly you cannot upload data as excel file into ByDesign/Cloud for Customer.

    You can upload data either using xml upload or using a webservice.

    I think it should be possible to create an excel having a "save as xml"-button to reduce the work for your users but better ask an excel magician for that.

    Hope to help,

    Ludger

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 19, 2016 at 06:30 PM

    Sankaran,

    While i wouldn't recommend it, it's technically possible to make use of a delimited text file (such as a CSV) in ByDesign.

    I've done this by creating a custom business object with an Attachment Folder dependent object that allows the user to upload a CSV file.

    I then created a text parsing ABSL script to read the data and make the updates in ByDesign.

    Again, i wouldn't really recommend it unless there is no alternative, but it is technically possible.

    -Dan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.