How to import the data from excel using Data hub?

[former_member664713]

Hi All I want to import the data from excel to hybris using Data Hub.

Thanks.

[Former Member]

You better save them as csv files and import them through hot-folder.
You have an example here

[former_member664713]

Hi ,

If I want to use csv files to upload the data into data hub, can you tell me the location where i need to place the files and structure of the files

Thanks,

[Former Member]

Hot folder is used only to import data into hybris, not to export data from hybris to third parties. Basically, hot folder transforms csv files into impex files.

I didn't send csv files to datahub but i think CSV Web Service extension is what you are looking for.

[former_member473180]

you need to update the csv adapter to deal with flat file ingestion

[bikrambsinha]

Hi Konda,

You can process csv file through DataHub. So, if csv can be used instead of excel sheet you can try that.

[Former Member]

Datahub cannot process excel data. If you want to use Excel as your data input then you will have to write your own custom implementation to read the excel file and publish to hybris.