Datenzusammenführung Zeilenumbruch in einem Datenfeld nicht mehr möglich bei Publisher V2

[Mihafri]

Hallo,

ich möchte einen harten Zeilenumbruch, also mit ALT+ENTER in die Datenquelle im Datenfeld einfügen, um es bei der Datenzusammenführung auch übernommen wird. Leider geht es bei der V2 nicht mehr. Bei der V1 Version ging es ohne Probleme. 

Wie kann ich das ermöglichen?

Z.B.:
Es soll so aussehen in einem Feldinhalt:
Name >ALT+ENTER
Adresse >ALT+ENTER
Email > ALT+ENTER

Hinweis: Da es in dem Feld auch mehr als 3 Zeilen geben kann, wollte ich nicht eine extra Datenfeld in der Datenquelle einfügen.
Es ist kompakter und einfacher wenn es in einem Datenfeld einzutragen und übernommen werden würde.

[Mihafri]

Kann mir jemand behilflich sein zu dieser Frage?

[loukash]

7 hours ago, Mihafri said:

Kann mir jemand behilflich sein zu dieser Frage?

Ich nicht direkt, weil ich mich mit der Datenzusammenführung (noch) nicht so genau auskenne.
Aber vermutlich erhältst mehr Rückmeldungen, wenn du deine Frage auf Englisch formulieren würdest.

[Mihafri]

Hello,

I would like to insert a hard line break, i.e. with ALT+ENTER in the data source in the data field, so that it is also adopted in the data merge. Unfortunately, it no longer works with the V2. With the V1 version it went without problems. 

How can I make this possible?

For example:
It should look like this in a field content:
Name >ALT+ENTER
Address >ALT+ENTER
Email > ALT+ENTER

Note: Since there can be more than 3 lines in the field, I didn't want to add an extra data field in the data source.
It is more compact and easier if it would be entered and taken over in a data field.

Translated with DeepL

[DWright]

Hi @Mihafri,

Can you please send me a copy of your .afpub file and data merge source files using the following Dropbox link for me to test this issue

https://www.dropbox.com/request/4Y8AzBfaTIL7mhhw8BhH

[Ilja]

Did you get any results??

I would like to add another question to yours . . . .

How can I get rid of the empty line, that is automatically generated by an empty column in Excel??

Sometimes there are additional Information that are not in every line in excel.

For example:

Name: Peter Mustermann

Street: Am Hof 1

Addition to adress: Appartment 609

City: 51145 Cologne

 

Name: Klaus Mustermann

Street: An der Bitz 4

Addition to adress:

City: 53115 Bonn

 

Hope you get what I mean

In other Programs like InDesign ther is a function to ignor empty columns while importing from Excel.

Is this also possible in Affinity??

 

[Mihafri]

I haven't gotten a solution yet, but I'm putting a each line separately in a field with no line breaks. This is more cumbersome and requires more table fields but it works then.

Regarding your question, I don't have a solution but to try it would be the following: in the table field where there is no text, you could put a space. Maybe this could work then.

[Old Bruce]

On 3/27/2023 at 12:01 AM, Ilja said:

In other Programs like InDesign ther is a function to ignor empty columns while importing from Excel.

Is this also possible in Affinity??

Sadly the answer is no.

[Mihafri]

[Ilja]

22 minutes ago, Mihafri said:

Tried it but i didn’t work so far.

thanks for all replies!!! I did a workaround to get the job done. Splitted the excel job in three different parts, imported the data and exported the jobs in 3 pdf files that i finally merged together for the printjob.

cheers to evrybody!!!