Skip to Content
Technical Articles

Map Windows Network Drive to Upload Multiple File Input Files to SAP Business ByDesign

If you are regularly uploading files into SAP Business ByDesign via the File Input method in Application and User Management, you may find it beneficial to map this location as a network drive on your PC so you can simply drag and drop files and let the background jobs then run automatically picking up the files and processing them.

To map the location as a network drive, simply follow these steps:

1. In Windows -> Select the Start button, then select My Computer

2. In Computer dialog, select the Map network drive button

3. Select drive letter e.g. Z

4. Paste the provided URL from File Input (the web dav link):

5. Tick the option “Reconnect at sign-in”

6. Tick the option “Connect using different credentials”

7. Select the Finish button:

8. In Windows security dialog, enter the user and the password you use to log onto ByDesign:

9. If you get a prompt about selecting a certificate, just click “Cancel”:

10. The folder from File Input will now be available as a standard windows drive allowing you to copy multiple files into as a standard windows PC folder

 

In summary, by enabling a network mapping to the file input folder coupled with a scheduled background job to run the file input job, you can simply the end user workflow for mass importing data in SAP Business ByDesign as users can simply drag and drop files into the folder for automatic processing without needing to log into ByDesign. As the file input process also supports parallel processing of input files, end users don’t need to worry about waiting for files to process before adding more to the folder.

3 Comments
You must be Logged on to comment or reply to a post.
  • Very nice paul. I really liked this approach of sharing/uploading the files to ByD without even anyone waiting for the current file being processed. Keep sharing such nice tricks.

    May be one question, I think in this approach every user, who want to upload the file, needs to pass his credential. It cannot be centrally managed via the IT team. Am I correct? What happens when the user logs off from the machine and re-login? Does he need to again pass on the ByD credentials to connect with the network drive or is it automatically taken care of?

    • Hi Saurabh,
      Yes the approach I've outlined requires the user to use their own credentials for ByDesign.  It would be possible to use a central account though managed by IT and deployed via central policies for example.
      Another approach could be single sign on so they use the same credentials for ByDesign as their computer?
      If the user selects the "Reconnect at sign-in" when mapping the drive and "remember my credentials" option when signing in the first time their PC should save the details and it will automatically be created each time they sign in. When they update their password on ByDesign then they should be prompted to sign in again to ByDesign.
      Another option is to have the drive mapping created as part of a login script; then the user would only need to do the bydesign credentials the first time after changing a password.
      Kind regards,
      Paul
      • Thanks, Paul for the explanation. I think it makes sense to me what you explained but I would really not use it productively mainly because of 2 reasons:

        1. If used with Central Policies deployment from IT team then anyone can upload a file which will definitely cause system overload. Further in an organization, only a few handfuls of people are allowed to access such administrative work center. What happens if someone is using mac? How does that impact those users?
        2. Too many fail attempts upon password change might cause the user lock.

        But I would still say this is a nice trick to use the existing capability of ByD in conjunction with local windows machine.