From mboxrd@z Thu Jan 1 00:00:00 1970 From: Jean Louis Subject: Re: exported contacts problem Date: Sat, 3 Aug 2019 18:32:19 +0200 Message-ID: <20190803163219.GZ23820@protected.rcdrun.com> References: <20190802160236.GR17561@protected.rcdrun.com> <87mugrb7fi.fsf@ericabrahamsen.net> <20190802213421.GZ17561@protected.rcdrun.com> <875znfaycd.fsf@ericabrahamsen.net> <20190803103340.GN23820@protected.rcdrun.com> <874l2yxnrs.fsf@ericabrahamsen.net> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Return-path: Received: from eggs.gnu.org ([2001:470:142:3::10]:41449) by lists.gnu.org with esmtp (Exim 4.86_2) (envelope-from ) id 1htwxj-0004se-BA for emacs-orgmode@gnu.org; Sat, 03 Aug 2019 12:32:56 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1htwxh-000113-Ud for emacs-orgmode@gnu.org; Sat, 03 Aug 2019 12:32:55 -0400 Received: from stw1.rcdrun.com ([217.170.207.13]:52985) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1htwxh-0000lb-Ny for emacs-orgmode@gnu.org; Sat, 03 Aug 2019 12:32:53 -0400 Content-Disposition: inline In-Reply-To: <874l2yxnrs.fsf@ericabrahamsen.net> 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" To: Eric Abrahamsen Cc: emacs-orgmode@gnu.org * Eric Abrahamsen [2019-08-03 17:39]: > No, and I think it would fall apart under your workload. But I would > like to make it better, and gradually get it closer to supporting the > sort of thing you're doing. I have started some teaching lessons in how to create personal information management, but it will take time until it becomes ready. I wish GNU Emacs would have more of such applications developed, including invoicing people, accounting and similar. > Yes, that's on my (mid-length) list of to do: a vcard parsing library > that just turns vcards into a couple pre-defined formats, or lets you > register your own consumption functions. That is really missing, as Androids are providing contact management export in VCF format. The NextCloud contact management has it too. It became some kind of a standard. Even it is not as good for exchange. > I'm also not fond of vcard, but I *am* fond of carddav, and having my > contacts synced to my phone, and shared with co-workers, etc. Otherwise > I probably wouldn't bother. I was looking on Wikipedia, that is basically protocol to exchange the vCards if I understand well. Exactly, for syncing it is necessary. > EBDB now provides for a sort of poor-man's relational database, with > multiple roles and relations, linking people to people and people to > organizations. But it's still limited and kind of awkward. That is true. I have started long ago with PostgreSQL and it works well, and it is extensible. What I think it is good is to give to people possibility to extend the personal information management without limitations. As such are the SQL databases. I have been using Gedafe[1] for long time. It is Generic Database Frontend and it works over web. But for my fast writing and needs it is not enough fast. Also not developed for long time. But imagine, you create the table and the interface gives you search, to add, delete, modify records and with some efforts to make custom reports. Isn't that nice? In that sense I have made few functions to read the database tables and basically edit any field there is through Emasc Lisp and helm. Now imagine if you make ebdb so that it is based on a database and that people can freely add a new database related to basic skeleton, and that all tables can be used and inserted. Then we have all kinds of opportunities: EXAMPLE A: ========== 1. Maybe somebody is managing lands, like real estate, he could make real estate database tables, and relate it to people in the contact address book. Right? Isn't that why we are keeping the address books, because all of the people belong to some kind of groups, be it family, or enemies, sibblins, customers, it could be donors, it could be potential leads, travelers we meet in hotels worldwide. It could be real estate owners, right? Somebody needs familiar interface to manage entries related to real estate related to contacts. It requires "relational" database. 2. Then Org mode could be used to link directly to the person in the database, and link to the report about the house from the real estate database. It results with real estate report in the Org document with pictures, that can be printed, distributed, glued on the display, and similar. 3. Now imagine some will have 300 or 1000 properties to list that way, it becomes breeze to speed up such cycles. EXAMPLE B: ========== 1. Imagine Italian manufacturer selling Venetian masks. Customers are from all over the world. He could create table about "Venetian Masks" and relate it to contacts and organizations. Generic functions to edit such table, modify entries, add new entries could be made in Emacs Lisp. It becomes inventory management. Any of those tables in the database are almost always related to some people. And we keep having separate packages for this and that, instead of using databases more for the relational organization of information. Jean Footnotes: [1] https://gedafe.github.io/index.en.html