Questions tagged [impex]

IMPEX (Import/Export) scripts can be used to get data in and out of SAP Hybris Commerce.

The hybris Commerce Suite is shipped with a text-based import and export functionality called ImpEx. The ImpEx engine allows creating, updating, removing and exporting platform items such as customer, product or order data to and from comma-separated value (CSV) data files, both during run time and during the initialization or update process.

108 questions
6
votes
3 answers

How do I skip certain ValidateInterceptor?

I have created a VariantValueCategory and wanted to skip the ValidateInterceptor as it was not allowing me to create VariantValueCategory either by Impex or by HMC. Can any one suggest me how do I skip ValidateInterceptor or any Interceptor?
munna
  • 81
  • 1
  • 2
6
votes
2 answers

Unique values for combination of columns in Hybris Impex Files

I'm creating a Hybris impex file to import into my Database. I want to perform an INSERT_UPDATE action with the data from the file, so I need to tell Hybris which column(s) need to be unique, so that it knows when to update a record instead of…
Henrique Ordine
  • 3,107
  • 3
  • 35
  • 69
5
votes
2 answers

How to get config data from local.properties to impex?

Is it possible to get a value from the environment variables defined at local.properties configuration file and access it via the impex file? Ex. $someMacro= Thank you!
user1865775
  • 143
  • 1
  • 7
4
votes
2 answers

How to export data with condition

I need to export some instances of a model but I don't want them all. I need only the one that have a specific attribute. I can do that by code, I wonder how to do this with Impex?
alain.janinm
  • 19,035
  • 10
  • 56
  • 103
3
votes
1 answer

Why does restriction on a page does not work

I have a page named register and I want to restrict access to this page only to the predefined hybris user anonymous. in order to achieve that, I created the ImpEx bellow INSERT_UPDATE CMSUserRestriction; $contentCV[unique = true]; &userRestriction;…
Soufiane Roui
  • 526
  • 4
  • 12
3
votes
4 answers

Set Currency format in hybris

I am trying to set format of currency for a country with impex. Currentlty it is set as '42,953.87'. I want it should be changed to the format as '42.953,87'. Right now impex I am using for it is as INSERT_UPDATE…
Naved Ali
  • 538
  • 1
  • 8
  • 27
3
votes
2 answers

How to specify a particular tenant as an argument with "ant importImpex" command?

I'm trying to import the impex files using ant importImpex -DSource=items.impex. This is successfully importing the impex files but the changes are reflecting in the MASTER tenant. How to specify a particular tenant as an argument with ant…
ANIL
  • 2,001
  • 4
  • 17
  • 38
3
votes
2 answers

How I can export only one product in Hybris using impex

I want to export only one product using hybris impex: following sql give me that product. select * from products where code='489923' I am trying to modify the export script: # ---- Extension: core ---- Type: Product ---- "#% impex.setTargetFile(…
Adam
  • 31
  • 1
  • 2
2
votes
1 answer

Export same row multiple times with ImpEx

Is it possible to export the same row multiple times based on an attribute of the item? Let's say for example that the CategoryModel has a List. How can I do an export using ImpEx to get something like this: | category_code |…
user1234SI.
  • 1,561
  • 3
  • 17
2
votes
1 answer

User acess rights using MemberOfGroups in hybris

I have custome item type "Appeasement" , which contains attribute "appeasementStatus" of enum type "AppeasementStatusType" . For customersupportagentgroup we dont have write access to item type "Appeasement" but I want to provide write access to…
2
votes
1 answer

How to change delimiter in the exported data in Hybris?

I am exporting data from SAP Hybris. The data I am importing also has semicolons (;). In the exported data I see the delimiter is ; This is preventing me from splitting the data and do my work. Is there a way to change this delimiter to something…
2
votes
0 answers

de.hybris.platform.impex.jalo.ImpExException[HY--1] Exception in Hybris ImpEx

I am getting de.hybris.platform.impex.jalo.ImpExException[HY--1] Exception when I try and run this ImpEx code below. I have specified the atomictype property as java.time.LocalDate in my items.xml file. INSERT_UPDATE…
2
votes
1 answer

How to add Hybris Solr By for Boolean value

I have a Solr indexed property called isNewProduct (boolean) and I want to create a new Solr By option for this attribute. (the products with isNewProduct==true must appear first). Any hint about how can I achieve this ?
Nexussim Lements
  • 538
  • 3
  • 19
2
votes
1 answer

Hybris : How to import media which is in the zip file in impex?

I know we can import images which are not zipped like this $siteResource=jar:com.project.initialdata.constants.ProjectInitialDataConstants&/projectinitialdata/import/sampledata/images/brand INSERT_UPDATE Media ; code[unique=true] ;…
Junaid
  • 584
  • 2
  • 10
  • 29
2
votes
4 answers

How to remove a value from the collection using Impex in HYBRIS?

I'm trying to extend the OOTB Impex to remove customersupportagentrole from customersupportmanagergroup but it not working. Please help. this is OOB Impex. INSERT_UPDATE…
rrusev
  • 93
  • 1
  • 10
1
2 3 4 5 6 7 8