ERP 8 - Convenient way to export all tasks to a spreadsheet

HampMcCool

Active Member
Does anyone have a neat trick to export a "Solution Explorer Menu Tasks List"
to a spreadsheet that roughly simulates a detailed list of tasks in menu
sequence?

(I know how to use Excel to grab data from a table - but can't seem to
replicate the menu structure from any of the F900* tables.)

Thanks!
 
Since you havent written your system details its difficult to specify the exect way, but you can create a quick and dirty report(UBE/TC) to do the task, use BSFN which transfer data to csv. or take the output of the UBE in CSV instead of PDF.
You can also SQL the table and then export it to csv.
I hope one of this will be helpful, would appreciate if you could write the system details as your signature.
 
Here's what I did.
Choose a role and expand every parent so all child tasks are visible (start from the bottom).
Then do File >> Print and print to a text file.
From there, open it up in Excel and delimit by ",".
This will catch about 95% of the tasks and divide them into cells correctly assuming you haven't used many commas in your task names.
 
Back
Top