Exporting Data from SAP Commerce by ImpEx

 From time to time I need to export data from SAP Commerce Cloud system. For me the best approach is to have them in Excel where I can filter them out nicely.

I usually use for that ImpEx Export with flexibleSearch query.

Here is an example of that kind of script:

in export line there is FlexibleSearch query with WHERE clause which I use to filter out data for my needs.

Usually I run ImpEx Export from hac cockpit, where I have zip file listed right away after execution.

Package contains CSV file, which I open in Excel/Calc/Numbers and do the filtering.

Recently I had to remove large volume of business processes after load tests. For that I have created similar impex, but with more user-friendly method for querying data to be filtered. Here I have used exportItemsFlexibleSearch method.

impex.exportItemsFlexibleSearch(""/* flexible search query */"");

Here as you can see, there is only query used, with no additional parameters required.

Generated zip file has been used as it is in hac for Impex Import. So that is was really no brainer.

For more information related to impex.* methods which can be used in ImpEx headers, please take a look at SAP Commerce Cloud Javadoc API documentation Exporter class

Comments

Post a Comment

Popular posts from this blog

SAP Commerce Cloud and Read-Only Replica

Image
 Introduction SAP Commerce Cloud introduced Read-Only Replicas as a standard feature for all production environments. Aim for Read-only data source is to offload batch queries or expensive ones from master data.  That data-source gives copy of same sized like master. When production runs on Premium P11 master, RO replica will be same, Premium P11 instance running side-by-side with master. Read-Only replica is available for all Premium DBs in CCv2. That is a standard functionality provided by Azure. Product Availability Feature is available from SAP Commerce Cloud version 1905 +.  With patches onward: 1905.37 , 2005.21 , 2011.16 , and 2105.6 . (You need to run update (aka 'Migrate Data') operation during deployment). CronJob and Job models have been extended and usage of replica has been simplified to a flag. This patch introduces the support for a read-only replica. The feature includes additional configuration options for the Backoffice search, task engine, Job/CronJob...
Read more

Eclipse plugin development and Apple Silicon M1

So... I have upgraded recently laptop to Macbook Pro M1. I am happy with hardware as it is blazing fast, cold, just perfect. But... I have issues with development. I am not going to mention, that my VMWare Fusion is not available on Apple Silicon and I am not able to test my eclipse plugin anymore on Windows 10, which is like... 80% of all users. Just maddness. When I decided to go with Apple Silicon I assumed, that VMWare will deliver Fusion pretty fast. I know there is beta released, but still I am not able to use it. Recently I have encountered an issue with architecture, when I tried to run my plugin in debug mode from Eclipse IDE. Let's check what problem I have: Eclipse RCP configuration looked like this: VM linked is embedded JRE: /Users/User/Develop/bin/EclipseRCP.app/Contents/Eclipse/plugins/org.eclipse.justj.openjdk.hotspot.jre.full.macosx.aarch64_17.0.2.v20220201-1208/jre/lib/libjli.dylib Solution for mixing architecture on Eclipse Debug Mode The reason of...
Read more

FlexibleSearch Pagination

SAP Commerce platform provides functionality for pagination DB results. You are able to find paginated DAO: There is also Flexible Service which also allows pagination: That implementation depends on other DTOs i.e: PaginatedFlexibleSearchParameter and SearchPageData : Usage of that code is not popular in platform. Can be found in few places (I will update that part later on) but what is most important here, it is not easiest solution at all! Solution for pagination So how to make it better, with no hassle with extra helper objects? Just use what FlexibleSearchQuery class gives to you. FlexibleSearchQuery gives you 2 methods setStart and setCount thanks to that you are able to set up pagination functionality in code. SAP API Documentation FlexibleSearchQuery
Read more