3 ms·
Ask HN: a lightweight contact db that is Not a CRM
(This is pretty long, my apologies).
I'm looking for a very specific, very lightweight kind of contact database, and I'm having trouble finding it. Most contact db's are CRM solutions geared towards sales, which is overkill, and makes them harder and slower to use.
For this db the most important quality is to be able to create and export custom lists based on a very large number of attributes (which may be added and deleted over time).
CONTACTS
Of course, the db has to hold a large number of e-mail addresses, phone numbers and attributes like country, place of work, but also relatively long (and non-fixed) lists of specialties.
Every CRM or mailing program like Mailchimp can do this. The problem being that Mailchimp (and other mailing engines) allows only a limited number of groups or tags and that's simply not enough for the granularity needed in this db.
On the other hand, CRM's (like Highrise) are simply overkill for this. We don't want to track relationships with these contacts in the db.
LISTS
The db has to be able to produce lists of contacts based on combinations of attributes: "X and Y", "X and Y and/or Z", "A and X but not D".
EXPORT
The db then has to be able to export this list with a number of attributes (name, place of work, phone,...) to Excel.
CLOUD
Of course, we'd like to use this as a kind of cloud service and accessible by the whole team.
The solution has to be used by relatively junior staff. We tried Grubba but exporting from it proved too much of a hassle for said junior, non-technical staff. Thanks in advance for your help.
- jstanley 14y agoDepending on just how much data we're talking about, I would suggest using a tab-separated text file. To test attributes, use a column that is just a comma-separated list and use awk to match against that column. Excel can already read TSV.
- appmap 14y agoSince multiple people (including interns) will use the list (both to input new entries, change entries and export lists from it), this would be way too easy to erase I'm afraid. I'm looking for something with a minimum of interface and 'fool proofness'.
- devonbarrett 14y agoIf it doesn't have to be integrated into your own system, why not just google contacts?
- appmap 14y agoIt's not easy enough for junior staff to make granular search. (We're really talking stuff like radio buttons and pre-set "and/or" possibilities here).
- devonbarrett 14y agohttp://productforums.google.com/forum/#!topic/apps-script/aLwXLHre9CQ%5B1-25-false%5D http://productforums.google.com/forum/#!topic/apps-script/aL... Use google forms to create a fool proof interface for adding them, and do the same to search?
- pknerd 14y agoWhy not develop one for yourself?
- tamersalama 14y agoPerhaps I'm missing something, but why not just use a Google Spreadsheet?