• State Not Answered
  • Locked Locked
  • Replies 4 replies
  • Subscribers 16 subscribers
  • Views 6417 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to use FormatString in Map Data?

maria.schultz
over 7 years ago

Have added a section for attachments in the destination (generated word files) in which I want a list of attachments to appears.
I get it almost to work, but would like to have a row break after each attachment link. As for now, no row breaks are made between each attachment.

I tried to use FormatString, with these settings "{0}<br/>" and "<br>{0}<br>".
But neither of them worked. I still get no row breaks between each attachment.

I don't find anything in the Users Manual about how to use FormatString when MapData.

  • 0 over 7 years ago
    What is the source element you are mapping from? A single Notes Rich Text field? An @-Formula giving the list of attachments? Something different?
  • 0 over 7 years ago

    I've simply defined a source data field BodyAttachmentLinks, where:
    ColumnType=AttachmentLinks
    AttachmentScope= AllAttachments

    Have also tried AttachmentScope=RichTextItem, which also works fine.

    In Dell MIgrator it seems like all would works fine as all the attachments are collected from the body.

    When preview data query it could look like this in rich text view:
    [aaa.pdf] [bbb.xlsx] [ccc.docx]

    But in the destination (i.e. the generated word document) it popup like this:
    aaa.pdfbbb.xlsxccc.docx

    It makes it hard for users to detect the files.

    Hence, would prefer have it like this:
    aaa.pdf
    bbb.xlsx
    ccc.docx

    The real filenames are often very long (50+ letters are not selldom), why a row break after each file would make sense. However, I would at least expect that it popup on in word as when preview data in rich text view.

  • 0 over 7 years ago
    I think the only thing you are missing is the Columns setting.

    So it will be:
    ColumnType=AttachmentLinks
    AttachmentScope=AllAttachments
    Columns=1

    This will line up the links in only one column.
    You may also want to use the Label setting which will put a heading above the list of attachment links.
  • 0 over 7 years ago
    Great Thanks!

    It simply worked all fine!