pmgeuze
Friends,
I would like your help in correcting my csv syntax to filter a master budget form to show project budget items on each project page.
My current syntax is:
<csv filter[4] [t]=“Acquire Supported Mobile Devices” file=development_plan:tbcu_development_budget.csv></csv>
I have tried the "g" and "r" instead of the "t" and sometimes I get all the results, but I do not seem to be able to only get the rows with the “Acquire Supported Mobile Devices” in the fourth column. I have tried with filter [3] and filter[4] since I am not sure if the column count starts at 1 or 0.
The base data in the "development_plan:tbcu_development_budget.csv" includes:
Priority,Category,CoA,Task,Name,Model,Short Description,OnHand,Need,Cost,SubTotal,Assigned,Supporting Documents
1,Equipment,,Acquire Computer Storage Media,Talino base model computer,Talino,This computer is intended to basic acquisition.,0,1,$1 ,$1 ,Technician 02,
1,Training,,Acquire Supported Mobile Devices,CI 091 - Introduction to Previewing,NW3C,This interactive online module provides an overview of the basic concepts behind secure previewing of digital devices.,0,1,$0 ,$0 ,Technician 01,
1,Training,,Acquire Supported Mobile Devices,CI 103 - Introduction to Cell Phone Investigations,NW3C,This course provides an overview of the two phases of a cell phone investigation,0,1,$0 ,$0 ,Technician 01,
1,Training,,Acquire Supported Mobile Devices,CI 131 - Social Media Basics,NW3C,"This course introduces learners to the world of social media, including fundamental concepts, trends and benefits for law enforcement organizations. ",0,1,$0 ,$0 ,Technician 01,
I am excited to be able to have a master file that I can work in Excel with and have automatically filtered sheet in the wiki for each project or person as needed.
As such, I really appreciate your time and effort on this.
Thank you.
Pieter-Michiel