Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login

    Importing CSV and definition of the "Period of warranty"

    Scheduled Pinned Locked Moved Allgemein
    2 Posts 2 Posters 151 Views 2 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • TerenceT Offline
      Terence
      last edited by

      Hello, i'm using the CSV import in I-doit and i'm willing to define the fields "Period of Warranty"in the "Accounting" tab on a Clients but i don't know what value my csv need to contains and what assigment do i need to define.
      The period of Warranty in i-doit is define with 3 fields on the same line, the first is a scrolling menu with 3 possible values ("by date of invoice", "by delivery date", by order date"), the second is a textbox which is supposed to contains a digit and the third is a scrolling menu with the time period ("Days", "Weeks", "Month", "Years").

      Do you know what value do i need to put into my csv to get a period of warranty like this : By date of invoice 3 Years ?

      Thanks per advance

      1 Reply Last reply Reply Quote 0
      • Michael HuhnM Offline
        Michael Huhn
        last edited by

        Hello @Terence,

        in case you haven't figured it out yourself yet.
        Here's the solution:

        The CSV looks like this:

        OBJTitle;Delivery Date;guarantee_period_dialog;guarantee_period_timeperiod
        backup0;2019-02-16;by delivery date;3 Years
        

        Now you have to map it like :
        csv-accounting.png

        And then start Importing. Done

        Best regards
        Micha

        1 Reply Last reply Reply Quote 0
        • First post
          Last post