Skip to Content
0

How to add text qualifiers ".." in csv export in hybris Marketing

Feb 24 at 01:15 AM

64

avatar image

Dear Community,

how can we add text qualifiers like " in our csv export in hybris Marketing on prem? We did not found any settings in SPRO


thx, best regards
Peter

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vineet Kaul Feb 27 at 01:46 PM
0

Hi Peter,

Can you give a sample of what data you expect in the CSV and in what format?

Thanks

Vineet

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Dear Vineet,

e.g. we have a target group and want to export customer first- and last, address, zip and phone
csv as is: peter;meier;example steet;1234;1234567890
csv how we need it: "peter";"meier";"example steet";"1234";"1234567890"

How or where can we add this qualifiers?

best regards,
Peter

0

Hi Peter,

I am not sure if this can be done as standard, we do have options to use field separators in export definition which can be used if you have multiple values in the same column but your requirement seems to be more of concatenating the columns with special characters.

I see two options to do it.

Option 1:

Create a custom view which has all these fields and then create a concatenated column in HANA which view which is nothing but concatenation of all these fields including the qualifiers you need. You can then expose this calculated column for export and you should see the data in the file in the format you require.Or else rather than concatenating you can create calculated columns for all your fields which you need and each calculated column should be nothing but actual field wrapped in qualifiers.

F_NAME = Peter

CALC_F_NAME = "F_NAME" => "Peter"

or

F_NAME | L_NAME | ADDR1 | ADDR2 | CLAC_CUST_FILED

Peter | Meier | London | UK | "F_NAME"+"L_NAME"+"ADDR1"+"ADDR2"

Option 2:

Create Columns for special characters itself and then use them as fields in your export definition rather than qualifiers so your columns should look like

SP_CHAR1 F_NAME SP_CHAR2 L_NAME SP_CHAR3 ADDRESS and so on.

I would prefer option 1 until anyone else can suggest a better way of doing this ;)

Also, you may want to revisit the business requirement as to why this is required in this format.

Thanks

Vineet

0
Arnaud Buchholz
Mar 29 at 07:54 PM
0

Hi Peter,

Can you also name the tile you want to export CSV from?

Thanks & Regards,

- Arnaud

Share
10 |10000 characters needed characters left characters exceeded