load customer and address into Hybris from csv file

[Former Member]

Hello,

I have a CSV file that contains customer details and address details. I need to load that data into Hybris.

I am thinking to load the data using hot folder impex.

(1) Is there any better option to load the data from csv to impex?

(2) Do I need to write 2 hot folder impex's (one for customer and one for address) or in one hot folder I can write both impex's (customer and address impex)?

(3) Is there sample impex for customer and address available OOTB?

Thanks in advance.

[Former Member]

Thank you Wojciech. The links that you provided helped me lot..

[Former Member]

Thank you for your quick response. The links that you provided not working. Could you tell me the correct link?

[former_member636435]

Sorry, I forgot you're unable to see the content from those links. Here's example xml file showing the use of multiple headers: https://gist.github.com/wojciechsmol/208bf73bba88cc33fcb32cb50f24abbc

And here's a sample impex that imports Customer and Address data: https://gist.github.com/wojciechsmol/74396a221e187fb919297c4ff3f943a1

[former_member636435]

Hey SasiReddy,

1. I think hot folder is currently the best way to load the data from a csv to impex. It is fast, reliable and easy to use.

2. You can create or update multiple hybris types from a single CSV line. You just need multiple headers, then the data will be loaded into different tables. Here's an example of how to do that: https://wiki.hybris.com/display/~/Multiple+items+for+a+single+hot+folder+CSV+line

3. Here is a sample impex which includes importing Customer and Address data: https://wiki.hybris.com/pages/viewpage.action?pageId=215421695, however you've got to create your own impex that matches your needs. If you need advice on how to configure you hot folder I suggest you look at this default file in hybris: …\hybris\bin\ext-accelerator\acceleratorservices\resources\acceleratorservices\integration\hot-folder-spring.xml

Hope that helps,