Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Simon Dingley 1470 posts 3427 karma points c-trib
    Jun 24, 2014 @ 15:27
    Simon Dingley
    0

    Combine two import file fields to map to one document type property

    Using CMSImport

    Hi Richard,

    Is it possible to combine/concatenate two fields into one during the import process? For example, a customer has an import file with the date and time split into two separate columns, when imported they will need to be combined to create a single DateTime value for the document type property.

    Thanks, Simon

    Copy Link
  • Richard Soeteman 4035 posts 12842 karma points MVP
    Jun 24, 2014 @ 16:29
    Richard Soeteman
    1

    Hi Simon,

    You can't do this via the UI. What you can do is use the event system to update the value after the record was imported . Or create a custom Data provider that combines the 2 fields during read of the file. Both require a bit of coding but it is possible then.

    Best,

    Richard

    Copy Link
  • Simon Dingley 1470 posts 3427 karma points c-trib
    Jun 24, 2014 @ 16:33
    Simon Dingley
    0

    OK thanks Richard - I thought that may be the case.

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft