Tip 48: Importing subtasks and setting dependencies in XLS, CSV, and JSON files

Tip 48: Importing subtasks and setting dependencies in XLS, CSV, and JSON files



Importing files from one platform to another is a tedious job and it is necessary to maintain the structure of the modules. You can import XLS/ JSON/ CSV files into Zoho Projects. While importing a XLS/CSV/JSON files, you can now import subtasks and also set dependency between the tasks in the import file.

Import Subtasks:
Consider a scenario where a project owner has to import a csv file with two tasks "Roof (T8)" and "Setting & Curing (T6)". While importing the file, he must enter the PARENT TASK ID() and PARENT TASK NAME(). If he enters T6 as the parent task, T8 automatically becomes the subtask of T6. 



Set Dependency:
Likewise, consider the scenario where a project owner has to import a csv file with two tasks "Demolition (T1)" and "Excavation (T2)". The latter can be completed only if the former is finished. Project owner can set dependency in the import file. He must create a separate column for the predecessor task, enter TASK ID() of the same and set the dependency between these tasks.



Download the sample files given below to know more about setting dependencies and importing subtasks. 

Do let us know if you have any questions! Write a comment below or mail to us at support@zohoprojects.com.








                            Zoho Desk Resources

                            • Desk Community Learning Series


                            • Digest


                            • Functions


                            • Meetups


                            • Kbase


                            • Resources


                            • Glossary


                            • Desk Marketplace


                            • MVP Corner


                            • Word of the Day



                                Zoho Marketing Automation
                                        • Sticky Posts

                                        • Auto-update the Successor Task Status.

                                          Hello folks! We have come up with a new use case for custom function to help you automate the workflow of your tasks. Users can write their own Custom Functions using deluge and call them from a workflow. Consider a scenario where the status of the successor
                                        • Collaborate Visually with Whiteboard in Zoho Projects

                                          Whiteboard in Zoho Projects allows you to collaborate visually by creating diagrams, annotating designs, and sketching project workflows using shapes, text, and images within project modules. Team members can work simultaneously, improving productivity
                                        • Introducing Projects 8.0 - Focusing on Ease-of-Use and New Features

                                          Hello everyone! It's time for the reveal of the 8th version of Zoho Projects! This year our focus has been on minimizing the learning curve and improving the ease-of-use of the tool, so anyone new to Projects can hit the ground running and existing users
                                        • Manage Documents with SharePoint Extension in Zoho Projects

                                          SharePoint is a digital platform to store and manage your documents. Multiple users can work on the same document simultaneously, which enhances your team's productivity. By installing the extension in Zoho Projects, users can access the documents seamlessly
                                        • Work agile in Zoho Projects! The much-awaited Zoho Sprints integration is in the making.

                                          Let your teams work in both classic and agile methodology using our integration with Zoho Sprints. We made sure you get the best of both worlds with this integration. You can scale through teams irrespective of what methodology they use and make sure they work with speed and flexibility. And, you can do it all from one place- Zoho Projects.  Why this integration is a benefit?  This integration mostly helps in managing classic and agile practices together. Most organizations use a mix of both classic


                                        Manage your brands on social media



                                                Zoho TeamInbox Resources

                                                  Zoho DataPrep Resources



                                                    Zoho CRM Plus Resources

                                                      Zoho Books Resources


                                                        Zoho Subscriptions Resources

                                                          Zoho Projects Resources


                                                            Zoho Sprints Resources


                                                              Qntrl Resources


                                                                Zoho Creator Resources


                                                                  Zoho WorkDrive Resources



                                                                    Zoho Campaigns Resources

                                                                      Zoho CRM Resources

                                                                      • CRM Community Learning Series

                                                                        CRM Community Learning Series


                                                                      • Tips

                                                                        Tips

                                                                      • Functions

                                                                        Functions

                                                                      • Meetups

                                                                        Meetups

                                                                      • Kbase

                                                                        Kbase

                                                                      • Resources

                                                                        Resources

                                                                      • Digest

                                                                        Digest

                                                                      • CRM Marketplace

                                                                        CRM Marketplace

                                                                      • MVP Corner

                                                                        MVP Corner




                                                                            Design. Discuss. Deliver.

                                                                            Create visually engaging stories with Zoho Show.

                                                                            Get Started Now