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 257 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

        Hello! It looks like you're interested in this conversation, but you don't have an account yet.

        Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

        With your input, this post could be even better 💗

        Register Login
        • First post
          Last post