AppColl Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Groups

    Bulk Import of Task Types

    Foreign Law
    4
    6
    35
    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.
    • L
      LauraC4871 last edited by

      Hello,

      To expand on my earlier question: we’d like to request a way to bulk import and bulk edit task types, for example by uploading an Excel or CSV file.

      Why we need it: For every foreign law deadline AppColl creates, we have to create our own reminder task types that trigger off it, one at a time in the interface. For China alone, that’s about 70 reminders. Across all the countries we use, it’s several hundred. Building them by hand is slow and leaves a lot of room for error.

      What we’re asking for:

      Import: upload a spreadsheet where each row is a task type and the columns match the task type form: name, deadline type, owner, respond-by basis, month/day offsets, triggering task(s), default comment, and description.

      Export and re-import for edits: export our existing task types to the same format, edit them, and upload the changes. We’ve overhauled our naming conventions several times in the last few years, and renaming task types one at a time is where mistakes creep in.

      What it would give us: consistent names and settings across countries, fewer setup errors, and a reviewable record of our task types outside the interface.

      Thank you. Happy to share our spreadsheet as an example of the format we’d use.

      ChristianS2558 gregg_appcoll 2 Replies Last reply Reply Quote 0
      • gregg_appcoll
        gregg_appcoll @LauraC4871 last edited by

        @LauraC4871 We might have a solution for creating multiple Reminder tasks using a single task type. Can you submit a ticket to support@appcoll.com, and we'll get someone on a call with you in detail.

        1 Reply Last reply Reply Quote 0
        • ChristianS2558
          ChristianS2558 @MelissaT6414 last edited by

          @MelissaT6414 True, but Laura's post referred to "Export and re-import for edits," which is a scenario in which you'd have task type IDs.

          Any tasktype that didn't have an ID specified could be assumed to be a new one that is to be created.

          1 Reply Last reply Reply Quote 0
          • M
            MelissaT6414 @ChristianS2558 last edited by

            @ChristianS2558 I think if the intent is to import brand new task types that don't yet exist, I don't believe they would have an ID number. I might be missing the boat, though.

            ChristianS2558 1 Reply Last reply Reply Quote 0
            • gregg_appcoll
              gregg_appcoll last edited by

              Hi Laura,

              Thank you for the suggestion. We will look into this. It would be a significant effort to create such an interface. But it's something we will consider for the future. We hope this helps.

              1 Reply Last reply Reply Quote 0
              • ChristianS2558
                ChristianS2558 @LauraC4871 last edited by

                @LauraC4871 I thought we had an import at one time, but maybe I'm mistaken. I don't see it now. Bulk import would be nice. Although it should include the task type ID so that we can differentiate between identically named task types.....

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

                9
                Online

                718
                Users

                422
                Topics

                1.2k
                Posts