question

Ankita P avatar image
0 Likes"
Ankita P asked Joerg Vogel edited

Is there a way to import data from SAP in global table?

Is there a way to import data from SAP in global table?

How to import data from an excel file stored in a shared network drive?

FlexSim 18.2.0
import datadata import
· 2
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Joshua S avatar image Joshua S commented ·

You can export data from SAP into excel format I believe, then import it into Flexsim using the Excel importing tool. Search "Excel" in the user manual in Flexsim for more information on how to import files from Excel into Flexsim. Are you currently having problems with importing your excel file from the shared network drive?

0 Likes 0 ·
Ankita P avatar image Ankita P Joshua S commented ·

Yes, I am facing issues there as well.

If the drive is not mapped in the system, the network path specified in Flexsim gets preceded by the local path where the Flexsim model is saved. And it throws Excel Read Error.

And if I map the drive in local system, then also Flexsim is throwing Excel Read Error.

0 Likes 0 ·
Joerg Vogel avatar image
0 Likes"
Joerg Vogel answered Joerg Vogel edited

Please read and adapt the information on your system

SAP help business warehouse connection (Live Data Connection to SAP BW via HTTP Server (SAP Data Center))

in combination with JSON in FlexSim

read and write json data.

Please don't contact me on this directly again, I am not an SAP expert not even a user nor am I a data interface expert.

5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Joerg Vogel avatar image
0 Likes"
Joerg Vogel answered

Please copy the file to a local directory. You can try to this within FlexSim or a batch file. You copy your data from the local copy. You prevent difficulties concerning 2 or more people try to access the shared resource.

5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.