* how to be sure that there are not doble entries for org-id-locations @ 2023-06-18 16:20 Uwe Brauer 2023-06-18 16:35 ` Ihor Radchenko 0 siblings, 1 reply; 4+ messages in thread From: Uwe Brauer @ 2023-06-18 16:20 UTC (permalink / raw) To: emacs-orgmode Hi I am using the following workflow (for the org-aggregate pkg, but the logic for lookup is similar) I have one file with a table #+Name: short-notes | Name | Exam1 | Exam2 | Result | |-------+-------+-------+--------| | Smith | 8 | 10 | 9 | #+TBLFM: $4=vmean($2..$3);f2 And I want to extract the last column in another org file #+BEGIN: aggregate :table short-notes :cols "Name Result" | Name | Result | |-------+--------| | Smith | 9 | #+END: That *does not* work, so what I do I add to the file with short-notes via =org-id-get-create= And org-id, However I find the selected «name» cumbersome (although I understand its purpose) so I replace it by * Short notes :PROPERTIES: :ID: short-notes :END: and run =org-id-update-id-locations= then everything is fine. however my «smart» way of selecting org-id might run into problems, since I accidently can introduce such and id, twice. Therefore is there any way to check it (other then opening the opening .org-id-locacations and check it manually)? Thanks Uwe Brauer -- Warning: Content may be disturbing to some audiences I strongly condemn Putin's war of aggression against the Ukraine. I support to deliver weapons to Ukraine's military. I support the NATO membership of the Ukraine. I support the EU membership of the Ukraine. https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/ ^ permalink raw reply [flat|nested] 4+ messages in thread
* Re: how to be sure that there are not doble entries for org-id-locations 2023-06-18 16:20 how to be sure that there are not doble entries for org-id-locations Uwe Brauer @ 2023-06-18 16:35 ` Ihor Radchenko 2023-06-18 20:02 ` Uwe Brauer 0 siblings, 1 reply; 4+ messages in thread From: Ihor Radchenko @ 2023-06-18 16:35 UTC (permalink / raw) To: Uwe Brauer; +Cc: emacs-orgmode Uwe Brauer <oub@mat.ucm.es> writes: > Hi I am using the following workflow (for the org-aggregate pkg, but the > logic for lookup is similar) > ... > > And I want to extract the last column in another org file > > #+BEGIN: aggregate :table short-notes :cols "Name Result" > | Name | Result | > |-------+--------| > | Smith | 9 | > #+END: > > That *does not* work, so what I do I add to the file with short-notes > via > =org-id-get-create= > ... Looks like XY problem. Why not just use remote reference? See 3.5.1 References section of Org manual. -- Ihor Radchenko // yantar92, Org mode contributor, Learn more about Org mode at <https://orgmode.org/>. Support Org development at <https://liberapay.com/org-mode>, or support my work at <https://liberapay.com/yantar92> ^ permalink raw reply [flat|nested] 4+ messages in thread
* Re: how to be sure that there are not doble entries for org-id-locations 2023-06-18 16:35 ` Ihor Radchenko @ 2023-06-18 20:02 ` Uwe Brauer 2023-06-18 20:51 ` Ihor Radchenko 0 siblings, 1 reply; 4+ messages in thread From: Uwe Brauer @ 2023-06-18 20:02 UTC (permalink / raw) To: Ihor Radchenko; +Cc: Uwe Brauer, emacs-orgmode [-- Attachment #1: Type: text/plain, Size: 1206 bytes --] > Uwe Brauer <oub@mat.ucm.es> writes: > Looks like XY problem. > Why not just use remote reference? > See 3.5.1 References section of Org manual. I am very confused. According to that part of the manual and I quote ,---- | | where NAME can be the name of a table in the current file as set by a | | ‘#+NAME:’ line before the table. It can also be the ID of an entry, even | in a different file, and the reference then refers to the first table in | that entry. REF is an absolute field or range reference as described | above for example ‘@3$3’ or ‘$somename’, valid in the referenced table. `---- Since the table is in another file I am also force to use an ID, as with the solution I posted before. =org-id-get-create= =org-id-update-id-locations= So my problem still persists. What do I miss -- Warning: Content may be disturbing to some audiences I strongly condemn Putin's war of aggression against the Ukraine. I support to deliver weapons to Ukraine's military. I support the NATO membership of the Ukraine. I support the EU membership of the Ukraine. https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/ [-- Attachment #2: smime.p7s --] [-- Type: application/pkcs7-signature, Size: 5673 bytes --] ^ permalink raw reply [flat|nested] 4+ messages in thread
* Re: how to be sure that there are not doble entries for org-id-locations 2023-06-18 20:02 ` Uwe Brauer @ 2023-06-18 20:51 ` Ihor Radchenko 0 siblings, 0 replies; 4+ messages in thread From: Ihor Radchenko @ 2023-06-18 20:51 UTC (permalink / raw) To: Uwe Brauer; +Cc: emacs-orgmode Uwe Brauer <oub@mat.ucm.es> writes: > I am very confused. According to that part of the manual and I quote > ... > Since the table is in another file I am also force to use an ID, as with > the solution I posted before. > > =org-id-get-create= > =org-id-update-id-locations= Hmm. Right. So, is your question "how to check duplicate IDs"? If yes, the answer is M-x org-lint -- Ihor Radchenko // yantar92, Org mode contributor, Learn more about Org mode at <https://orgmode.org/>. Support Org development at <https://liberapay.com/org-mode>, or support my work at <https://liberapay.com/yantar92> ^ permalink raw reply [flat|nested] 4+ messages in thread
end of thread, other threads:[~2023-06-18 20:48 UTC | newest] Thread overview: 4+ messages (download: mbox.gz / follow: Atom feed) -- links below jump to the message on this page -- 2023-06-18 16:20 how to be sure that there are not doble entries for org-id-locations Uwe Brauer 2023-06-18 16:35 ` Ihor Radchenko 2023-06-18 20:02 ` Uwe Brauer 2023-06-18 20:51 ` Ihor Radchenko
Code repositories for project(s) associated with this public inbox https://git.savannah.gnu.org/cgit/emacs/org-mode.git This is a public inbox, see mirroring instructions for how to clone and mirror all data and code used for this inbox; as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).