I need to write a code that sorts filenames under different environements.
The heirarchy is as shown below-
Plan (around 50 palns)
Chapter (over 300)
Filenames (over 10000)
There are several plans. And each plan has several chapters. A plan and chapter of the same name can be present in another environment.
Now each chapter has filenames with the details of their owner and the milestone and platforms they are related to. Despite having same names the chapters can and will have different content in different environment.
I need to access these filenames and print them out in the followwing format
Plan: the plan its accessing
Chapter: the chapter under that plan
Owner:Default owner (there can be multiple owners)
Platfrom: Default platform
Env : Default environemt
(milestone=1 , env= if its not the default env display the other env here)
#print files relevant to milestone 1 under that plan under that chapter
(milestone=2 , env= if its not the default env display the other env here)
(milestone=3 , env= if its not the default env display the other env here)
(milestone=4 , env= if its not the default env display the other env here)
If a plan has multiple chapters, it should print out multiple similar output for all chapters.
And it shoul depict change in environement, owner or platform in the milestone brackets.
Btw i'm sorting the data in excel and accessing an excel file. So first i dump the data in excel sort it and then access it. So everything is in an order.
Any help would be appreciated.