Import-Export Data

After create a data model, we need to insert some sample data in Data model which can be use for testing purpose .

Inserting data in data model most common way.

By Backoffice (Out of Box Hybris Data Manage Tool)
Import ImpEx using the Backoffice import wizard
Import ImpEx using the HAC

Enter data via Backoffice

First, you need to create data manually in the Backoffice :

Start Hybris server and login in to backoffice :
- URL: http://localhost:9001/backoffice
Search "Types" in the navigation Tree or Explore System -> Type
Search for your data model like "User", Customer etc
In the Results Area, double click on Data Model "User"
Click on Left corner button "Search By Type"
Click on Plus button
"Create New User" Pop Up will Open , Enter the data and click to save button.

ImpEx : Import-Export framework

ImpEx is an out-of-the-box import-export framework. It is integrated text-based import/export extension . You can create, update, export, and remove items in Hybris Platform.

Use of ImpEx

In live operation:

To import customer data into a production system
To synchronize data with other systems, such as an ERP or LDAP
To create backups
To update data at runtime
Can be run from CronJobs

In migrations:

To migrate data from one hybris installation to another

In development:

To import sample data (e.g. on system initialization)
To import test data into testing system

Syntax

Header syntax:

   Operation  itemType; attributes(refAttr)[modifiers];...

Example

INSERT  Product;  code; name[lang=en];

UPDATE  Bird;  code[unique=true]; name[lang=en];

INSERT_UPDATE  User;  userID[unique=true]; groups(uid);

REMOVE  Media;  code[unique=true];

Data row syntax:

   attr1value; attr2value; ...

Example

  ;ABC 123; Car;

  ;xyz; abc;

  ;12345ABC;

ImpEx Elements

Macros : It is allows aliases to stand in for frequently used statements
BeanShell, Groovy scripting
- It is allows script to be added to a CSV file.
- Predefined hooks beforeEach, afterEach, getLastImportedItem() etc.
Translators: It is implement custom ImpEx logic e.g to import medias (binary files).
Inclusion of data: It is allows you to split your ImpEx operations over several files.
Collections and HashMaps: It is allows you to use these types as attributes

Enter data via ImpEx using the Backoffice import wizard

Login into the BackOffice
Open the node System -> Tools -> Import
Set the import file name
Start the import: Click on the Start icon

Import ImpEx by Hybris Administration Console

Page updated

Google Sites

Report abuse