How to upload the csv files into Azure storage through Cronjob

[former_member716879]

Hi Experts,

We had business requirement to load huge csv the Order data to Azure Cloud Storage blob. We have tried with API but there is some challenges on internal application error.

We need to upload the csv files into Azure Storage , We have internal other FTP server like SCPI. we have planned to do the via cronjob.

Please let us know your suggestion and help. if any one tried earlier.

[samuelyang · Accepted solution]

Hi Baskar,

In that case, if you want to implement some custom logics around the csv files by using SAP Commerce Media type, you might need to use the Azure Storage Java SDK, pom dependency like the following.

<dependency>
  <groupId>com.azure</groupId>
  <artifactId>azure-storage-file-share</artifactId>
  <version>12.2.0</version>
</dependency>

To get the real file from the Media item/model, you can use MediaModel.getLocation().

[samuelyang]

Hi Baskar,

Did you try the Azure Storage Explorer or Azure CLI, Powershell etc. ? Are you uploading the csv files as one-off task or recurring task? You can try the CLI or Powersehll to implement a cronjob for the same.

[former_member716879]

Thanks samuel.yang ,

We have tried with Azure storage Explorer with File share option not blob container. It's recurring task. We need to upload daily basis. I have tried with Azure Cloud OOTB but that is not working. I am trying to upload the files with custom logic.

The clarification required for me. I have saved the converted csv into Media model but from media model how we need to get the file and upload to Azure storage file share. That configuration i need it.

Thank you

[atulkumar1988]

Hi Vijaya ,

Did you get any solution for the same?

thanks,

Atul