From mboxrd@z Thu Jan 1 00:00:00 1970 From: Bill Harris Subject: How do I make org-mode columnview show all file results? Date: Wed, 12 Mar 2014 10:28:31 -0700 Message-ID: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=001a11c296905d6cb904f46c2af7 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:37890) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WNmxL-0008ET-Hb for emacs-orgmode@gnu.org; Wed, 12 Mar 2014 13:28:41 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1WNmxF-00082p-TX for emacs-orgmode@gnu.org; Wed, 12 Mar 2014 13:28:39 -0400 Received: from mail-ee0-x229.google.com ([2a00:1450:4013:c00::229]:37718) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WNmxE-0007yx-SM for emacs-orgmode@gnu.org; Wed, 12 Mar 2014 13:28:33 -0400 Received: by mail-ee0-f41.google.com with SMTP id t10so4524472eei.28 for ; Wed, 12 Mar 2014 10:28:31 -0700 (PDT) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org --001a11c296905d6cb904f46c2af7 Content-Type: text/plain; charset=ISO-8859-1 I'm trying to create a set of files that describe project data and have a column view block in a summary file, but the columnview is only picking up one project, and I need it to pick up all. P1.org and P2.org are two sample project files, and MasterP.org is the summary file. P1.org: #+COLUMNS: %15PROJ(Project) %35ITEM(Task) %Start %End %8Effort{+} %TODO * Tasks :PROPERTIES: :ID: simple :PROJ: P1 :END: ** TODO Phase 1 :testbed: :PROPERTIES: :End: [2014-03-19 Wed] :Start: [2014-03-11 Tue] :END: ** TODO Phase 2 :testbed: :PROPERTIES: :Start: [2014-03-20 Tue] :Effort: 32h :End: [2014-04-01 Tue] :END: ** TODO Phase 3 :testbed: :PROPERTIES: :Start: [2014-04-02 Fri] :Effort: 20h :End: [2014-04-11 Fri] :END: P2.org: #+COLUMNS: %15PROJ(Project) %35ITEM(Task) %Start %End %8Effort{+} %TODO * Tasks :PROPERTIES: :ID: simple :PROJ: P2 :END: ** TODO Phase A :testbed: :PROPERTIES: :Start: [2014-03-24 Mon] :Effort: 10h :End: [2014-03-24 Mon] :END: ** TODO Phase B :testbed: :PROPERTIES: :Start: [2014-04-23 Wed] :Effort: 10h :End: [2014-04-23 Wed] :END: ** TODO Phase C :testbed: :PROPERTIES: :Start: [2014-05-13 Tue] :Effort: 10h :End: [2014-05-13 Tue] :END: MasterP.org: When I execute MasterP.org with C-c C-c, I get: #+COLUMNS: %15PROJ(Project) %35ITEM(Task) %Start %End %8Effort{+} %TODO * Table #+BEGIN: columnview :hlines 1 :id "simple" | Project | Task | Start | End | Effort | TODO | |---------+----------------------+------------------+------------------+--------+------| | P2 | * Tasks | | | 30.0 | | | | ** Phase A :testbed: | [2014-03-24 Mon] | [2014-03-24 Mon] | 10h | TODO | | | ** Phase B :testbed: | [2014-04-23 Wed] | [2014-04-23 Wed] | 10h | TODO | | | ** Phase C :testbed: | [2014-05-13 Tue] | [2014-05-13 Tue] | 10h | TODO | #+END: I want to see the data for P1, too, with the total effort at least being summed by project. If I could also get the total effort across projects, so much the better! What do I need to change? I discovered it works if I have unique :id entries for P1.org and P2.org and then create two tables in MasterP.org. While that could work, it does lead to two refinements to the question: how can I merge the two tables, and is there a way to do it without distinct :id entries? Thanks, Bill -- Bill Harris http://facilitatedsystems.com/weblog/ --001a11c296905d6cb904f46c2af7 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

I'm trying to create a set of files that describe project data and have= a column view block in a summary file, but the columnview is only picking = up one project, and I need it to pick up all.

P1.org and P2.org are two sample project files, and MasterP.org is the summ= ary file.

P1.org:

#+COLUMNS: %15PROJ(Pr=
oject) %35ITEM(Task) %Start %End %8Effort{+} %TODO=20

* Tasks
  :PROPERTIES:
  :ID:       simple
  :PROJ:     P1
  :END:

** TODO Phase 1                             :testbed:
   :PROPERTIES:
   :End:      [2014-03-19 Wed]
   :Start:    [2014-03-11 Tue]
   :END:
** TODO Phase 2                             :testbed:
   :PROPERTIES:
   :Start:    [2014-03-20 Tue]
   :Effort:   32h
   :End:      [2014-04-01 Tue]
   :END:
** TODO Phase 3                             :testbed:
   :PROPERTIES:
   :Start:    [2014-04-02 Fri]
   :Effort:   20h
   :End:      [2014-04-11 Fri]
   :END:

P2.org:

#+COLUMNS: %15PROJ(Pr=
oject) %35ITEM(Task) %Start %End %8Effort{+} %TODO=20

* Tasks
  :PROPERTIES:
  :ID:       simple
  :PROJ:     P2
  :END:

** TODO Phase A                             :testbed:
   :PROPERTIES:
   :Start:    [2014-03-24 Mon]
   :Effort:   10h
   :End:      [2014-03-24 Mon]
   :END:
** TODO Phase B                             :testbed:
   :PROPERTIES:
   :Start:    [2014-04-23 Wed]
   :Effort:   10h
   :End:      [2014-04-23 Wed]
   :END:

** TODO Phase C                             :testbed:
   :PROPERTIES:
   :Start:    [2014-05-13 Tue]
   :Effort:   10h
   :End:      [2014-05-13 Tue]
   :END:

MasterP.org:

When I execute MasterP.org with C-c C-c, I get:

#+COLUMNS: %15PROJ(Pr=
oject) %35ITEM(Task) %Start %End %8Effort{+} %TODO=20

* Table
#+BEGIN: columnview :hlines 1 :id "simple"
| Project | Task                 | Start            | End              | Ef=
fort | TODO |
|---------+----------------------+------------------+------------------+---=
-----+------|
| P2      | * Tasks              |                  |                  | 30=
.0   |      |
|         | ** Phase A :testbed: | [2014-03-24 Mon] | [2014-03-24 Mon] | 10=
h    | TODO |
|         | ** Phase B :testbed: | [2014-04-23 Wed] | [2014-04-23 Wed] | 10=
h    | TODO |
|         | ** Phase C :testbed: | [2014-05-13 Tue] | [2014-05-13 Tue] | 10=
h    | TODO |
#+END:

I want to see the data for P1, too, with the total effort at least being su= mmed by project. If I could also get the total effort across projects, so m= uch the better!

What do I need to change?

I discovered it works if I have unique :id entries for P1.org and = P2.org and then create two tables in MasterP.org. While that could work, it= does lead to two refinements to the question: how can I merge the two tabl= es, and is there a way to do it without distinct :id entries?

Thanks,

Bill

--=A0

Bill Harris=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0
http://facilitatedsystems.com/weblog/
--001a11c296905d6cb904f46c2af7--