5 * by JH <jheinonen@users.sourceforge.net>
7 * Copyright (C) Jaakko Heinonen
18 #include <sys/types.h>
19 #include "abook_curses.h"
36 extern abook_field_list *fields_list;
37 extern int fields_count;
40 * function declarations
44 * import filter prototypes
47 static int ldif_parse_file(FILE *handle);
48 static int mutt_parse_file(FILE *in);
49 static int pine_parse_file(FILE *in);
50 static int csv_parse_file(FILE *in);
51 static int allcsv_parse_file(FILE *in);
52 static int palmcsv_parse_file(FILE *in);
53 static int vcard_parse_file(FILE *in);
56 * export filter prototypes
59 static int ldif_export_database(FILE *out, struct db_enumerator e);
60 static int html_export_database(FILE *out, struct db_enumerator e);
61 static int pine_export_database(FILE *out, struct db_enumerator e);
62 static int csv_export_database(FILE *out, struct db_enumerator e);
63 static int allcsv_export_database(FILE *out, struct db_enumerator e);
64 static int palm_export_database(FILE *out, struct db_enumerator e);
65 static int vcard_export_database(FILE *out, struct db_enumerator e);
66 static int mutt_alias_export(FILE *out, struct db_enumerator e);
67 static int mutt_query_export_database(FILE *out, struct db_enumerator e);
68 static int elm_alias_export(FILE *out, struct db_enumerator e);
69 static int text_export_database(FILE *out, struct db_enumerator e);
70 static int spruce_export_database(FILE *out, struct db_enumerator e);
71 static int wl_export_database(FILE *out, struct db_enumerator e);
72 static int bsdcal_export_database(FILE *out, struct db_enumerator e);
73 static int custom_export_database(FILE *out, struct db_enumerator e);
76 * export filter item prototypes
79 void vcard_export_item(FILE *out, int item);
80 void muttq_print_item(FILE *file, int item);
81 void custom_print_item(FILE *out, int item);
84 * end of function declarations
87 struct abook_input_filter i_filters[] = {
88 { "abook", N_("abook native format"), parse_database },
89 { "ldif", N_("ldif / Netscape addressbook"), ldif_parse_file },
90 { "mutt", N_("mutt alias"), mutt_parse_file },
91 { "pine", N_("pine addressbook"), pine_parse_file },
92 { "csv", N_("comma separated values"), csv_parse_file },
93 { "allcsv", N_("comma separated values (all fields)"), allcsv_parse_file },
94 { "palmcsv", N_("Palm comma separated values"), palmcsv_parse_file },
95 { "vcard", N_("vCard file"), vcard_parse_file },
99 struct abook_output_filter e_filters[] = {
100 { "abook", N_("abook native format"), write_database },
101 { "ldif", N_("ldif / Netscape addressbook (.4ld)"), ldif_export_database },
102 { "vcard", N_("vCard 2 file"), vcard_export_database },
103 { "mutt", N_("mutt alias"), mutt_alias_export },
104 { "muttq", N_("mutt query format (internal use)"), mutt_query_export_database },
105 { "html", N_("html document"), html_export_database },
106 { "pine", N_("pine addressbook"), pine_export_database },
107 { "csv", N_("comma separated values"), csv_export_database },
108 { "allcsv", N_("comma separated values (all fields)"), allcsv_export_database },
109 { "palmcsv", N_("Palm comma separated values"), palm_export_database},
110 { "elm", N_("elm alias"), elm_alias_export },
111 { "text", N_("plain text"), text_export_database },
112 { "wl", N_("Wanderlust address book"), wl_export_database },
113 { "spruce", N_("Spruce address book"), spruce_export_database },
114 { "bsdcal", N_("BSD calendar"), bsdcal_export_database },
115 { "custom", N_("Custom format"), custom_export_database },
119 struct abook_output_item_filter u_filters[] = {
120 { "vcard", N_("vCard 2 file"), vcard_export_item },
121 { "muttq", N_("mutt alias"), muttq_print_item },
122 { "custom", N_("Custom format"), custom_print_item },
135 puts(_("input formats:"));
136 for(i=0; *i_filters[i].filtname ; i++)
137 printf("\t%s\t%s\n", i_filters[i].filtname,
138 gettext(i_filters[i].desc));
142 puts(_("output formats:"));
143 for(i=0; *e_filters[i].filtname ; i++)
144 printf("\t%s\t%s\n", e_filters[i].filtname,
145 gettext(e_filters[i].desc));
149 puts(_("query-compatible output formats:"));
150 for(i=0; *u_filters[i].filtname ; i++)
151 printf("\t%s\t%s\n", u_filters[i].filtname,
152 gettext(u_filters[i].desc));
158 number_of_output_filters()
162 for(i=0; *e_filters[i].filtname ; i++)
169 number_of_input_filters()
173 for(i=0; *i_filters[i].filtname ; i++)
182 char *username = getenv("USER");
183 struct passwd *pwent;
187 pwent = getpwnam(username);
189 if((tmp = xstrdup(pwent->pw_gecos)) == NULL)
190 return xstrdup(username);
192 rtn = sscanf(pwent->pw_gecos, "%[^,]", tmp);
193 if (rtn == EOF || rtn == 0) {
195 return xstrdup(username);
204 static int i_read_file(char *filename, int (*func) (FILE *in));
213 refresh_statusline();
214 headerline(_("import database"));
216 mvaddstr(3, 1, _("please select a filter"));
219 for(i=0; *i_filters[i].filtname ; i++)
220 mvprintw(5 + i, 6, "%c -\t%s\t%s\n", 'a' + i,
221 i_filters[i].filtname,
222 gettext(i_filters[i].desc));
224 mvprintw(6 + i, 6, _("x -\tcancel"));
232 int tmp = db_n_items();
236 filter = getch() - 'a';
237 if(filter == 'x' - 'a' ||
238 filter >= number_of_input_filters() || filter < 0) {
243 mvaddstr(5+filter, 2, "->");
245 filename = ask_filename(_("Filename: "));
251 if(i_read_file(filename, i_filters[filter].func ))
252 statusline_msg(_("Error occured while opening the file"));
253 else if(tmp == db_n_items())
254 statusline_msg(_("File does not seem to be a valid addressbook"));
265 i_read_file(char *filename, int (*func) (FILE *in))
270 if( (in = abook_fopen( filename, "r" )) == NULL )
281 import_file(char filtname[FILTNAME_LEN], char *filename)
284 int tmp = db_n_items();
288 if(! strncasecmp(i_filters[i].filtname, filtname,
291 if(! *i_filters[i].filtname) {
301 // this is a special case for
302 // libvformat whose API expects a filename
303 if(!strcmp(filtname, "vcard")) {
304 if(!strcmp(filename, "-"))
305 ret = vcard_parse_file_libvformat("/dev/stdin");
307 ret = vcard_parse_file_libvformat(filename);
312 if(!strcmp(filename, "-")) {
314 if((fstat(fileno(stdin), &s)) == -1 || S_ISDIR(s.st_mode))
317 ret = (*i_filters[i].func) (stdin);
319 ret = i_read_file(filename, i_filters[i].func);
321 if(tmp == db_n_items())
331 static int e_write_file(char *filename,
332 int (*func) (FILE *in, struct db_enumerator e), int mode);
342 refresh_statusline();
343 headerline(_("export database"));
345 mvaddstr(3, 1, _("please select a filter"));
348 for(i = 0; *e_filters[i].filtname ; i++)
349 mvprintw(5 + i, 6, "%c -\t%s\t%s\n", 'a' + i,
350 e_filters[i].filtname,
351 gettext(e_filters[i].desc));
353 mvprintw(6 + i, 6, _("x -\tcancel"));
360 int enum_mode = ENUM_ALL;
365 filter = getch() - 'a';
366 if(filter == 'x' - 'a' ||
367 filter >= number_of_output_filters() || filter < 0) {
372 mvaddstr(5 + filter, 2, "->");
374 if(selected_items()) {
375 switch(statusline_askchoice(
376 _("Export <a>ll, export <s>elected, or <c>ancel?"),
377 S_("keybindings:all/selected/cancel|asc"), 3)) {
381 enum_mode = ENUM_SELECTED;
391 filename = ask_filename(_("Filename: "));
397 if( e_write_file(filename, e_filters[filter].func, enum_mode))
398 statusline_msg(_("Error occured while exporting"));
406 struct abook_output_item_filter select_output_item_filter(char filtname[FILTNAME_LEN]) {
409 if(!strncasecmp(u_filters[i].filtname, filtname, FILTNAME_LEN))
411 if(!*u_filters[i].filtname) {
420 e_write_item(FILE *out, int item, void (*func) (FILE *in, int item))
426 e_write_file(char *filename, int (*func) (FILE *in, struct db_enumerator e),
431 struct db_enumerator enumerator = init_db_enumerator(mode);
433 if((out = fopen(filename, "a")) == NULL)
439 ret = (*func) (out, enumerator);
447 fexport(char filtname[FILTNAME_LEN], FILE *handle, int enum_mode)
450 struct db_enumerator e = init_db_enumerator(enum_mode);
453 if(!strncasecmp(e_filters[i].filtname, filtname,
456 if(!*e_filters[i].filtname) {
462 return (e_filters[i].func) (handle, e);
468 export_file(char filtname[FILTNAME_LEN], char *filename)
470 const int mode = ENUM_ALL;
473 struct db_enumerator e = init_db_enumerator(mode);
476 if(!strncasecmp(e_filters[i].filtname, filtname,
479 if(!*e_filters[i].filtname) {
488 if(!strcmp(filename, "-"))
489 ret = (e_filters[i].func) (stdout, e);
491 ret = e_write_file(filename, e_filters[i].func, mode);
497 * end of common functions
506 static void ldif_fix_string(char *str);
508 #define LDIF_ITEM_FIELDS 16
510 typedef char *ldif_item[LDIF_ITEM_FIELDS];
512 static ldif_item ldif_field_names = {
524 "facsimiletelephonenumber",
528 "objectclass", /* this must be the last entry */
531 static int ldif_conv_table[LDIF_ITEM_FIELDS] = {
534 ADDRESS, /* "streetaddress" */
535 ADDRESS2, /* "streetaddress2" */
536 CITY, /* "locality" */
538 ZIP, /* "postalcode" */
539 COUNTRY, /* "countryname" */
540 PHONE, /* "homephone" */
541 NOTES, /* "description" */
543 FAX, /* "facsimiletelephonenumber" */
544 MOBILEPHONE, /* "cellphone" */
545 WORKPHONE, /* "xmozillaanyphone" */
546 NICK, /* "xmozillanickname" */
547 -1, /* "objectclass" */ /* this must be the last entry */
552 ldif_read_line(FILE *in)
565 if(feof(in) || !line)
574 fseek(in, pos, SEEK_SET); /* fixme ! */
584 buf = strconcat(buf, ptr, NULL);
589 if(buf && *buf == '#' ) {
598 ldif_add_item(ldif_item li)
603 item = item_create();
605 if(!li[LDIF_ITEM_FIELDS -1])
609 for(i=0; i < LDIF_ITEM_FIELDS; i++) {
610 if(ldif_conv_table[i] >= 0 && li[i] && *li[i])
611 item_fput(item,ldif_conv_table[i],xstrdup(li[i]));
614 add_item2database(item);
617 for(i=0; i < LDIF_ITEM_FIELDS; i++)
624 ldif_convert(ldif_item item, char *type, char *value)
628 if(!strcmp(type, "dn")) {
633 for(i=0; i < LDIF_ITEM_FIELDS - 1; i++) {
634 if(!strcasecmp(ldif_field_names[i], type) && *value) {
635 item_fput(item, i, xstrdup(value));
642 ldif_parse_file(FILE *handle)
649 memset(item, 0, sizeof(item));
652 if( !(line = ldif_read_line(handle)) )
655 if(-1 == (str_parse_line(line, &type, &value, &vlen))) {
657 continue; /* just skip the errors */
660 ldif_fix_string(value);
662 ldif_convert(item, type, value);
665 } while ( !feof(handle) );
667 ldif_convert(item, "dn", "");
673 ldif_fix_string(char *str)
677 for(i = 0, j = 0; j < (int)strlen(str); i++, j++)
678 str[i] = ( str[j] == (char)0xc3 ?
679 (char) str[++j] + (char) 0x40 :
690 * mutt alias import filter
696 mutt_read_line(FILE *in, char **groups, char **alias, char **rest)
700 abook_list *glist = NULL;
702 if( !(line = ptr = getaline(in)) )
703 return 1; /* error / EOF */
707 if(strncmp("alias", ptr, 5)) {
715 /* If the group option is used, save the groups */
719 for(n_groups = 0; 0 == strncmp("-group", ptr, 6); n_groups++) {
725 abook_list_append(&glist,xstrndup(start, end - start));
729 if(n_groups && groups)
730 *groups = abook_list_to_csv(glist);
732 abook_list_free(&glist);
740 *alias = xstrndup(start, end - start);
743 *rest = xstrdup(ptr);
750 mutt_fix_quoting(char *p)
770 mutt_parse_email(list_item item)
772 char *line = item_fget(item, NAME);
780 mutt_fix_quoting(line);
781 tmp = strconcat("From: ", line, NULL);
782 getname(tmp, &name, &email);
786 item_fput(item, NAME, name);
791 item_fput(item, EMAIL, email);
796 * this is completely broken
799 while( (start = strchr(start, ',')) && i++ < MAX_EMAILS - 1) {
800 tmp = strconcat("From: ", ++start, NULL);
801 getname(tmp, &name, &email);
806 tmp = strconcat(item[EMAIL], ",", email, NULL);
818 mutt_parse_file(FILE *in)
820 list_item item = item_create();
823 memset(item, 0, fields_count * sizeof(char *));
825 if(!mutt_read_line(in,
826 (field_id(GROUPS) != -1) ? &item[field_id(GROUPS)] : NULL,
827 (field_id(NICK) != -1) ? &item[field_id(NICK)] : NULL,
828 &item[field_id(NAME)]) )
829 mutt_parse_email(item);
836 add_item2database(item);
844 * end of mutt alias import filter
853 ldif_fput_type_and_value(FILE *out,char *type, char *value )
857 tmp = ldif_type_and_value(type, value, strlen(value));
865 ldif_export_database(FILE *out, struct db_enumerator e)
867 char email[MAX_EMAILSTR_LEN];
869 fprintf(out, "version: 1\n");
871 db_enumerate_items(e) {
874 get_first_email(email, e.item);
876 tmp = strdup_printf("cn=%s,mail=%s",db_name_get(e.item),email);
878 ldif_fput_type_and_value(out, "dn", tmp);
881 for(j = 0; j < LDIF_ITEM_FIELDS; j++) {
882 if(ldif_conv_table[j] >= 0) {
883 if(ldif_conv_table[j] == EMAIL)
884 ldif_fput_type_and_value(out,
885 ldif_field_names[j], email);
886 else if(db_fget(e.item,ldif_conv_table[j]))
887 ldif_fput_type_and_value(out,
890 ldif_conv_table[j]));
894 fprintf(out, "objectclass: top\n"
895 "objectclass: person\n\n");
902 * end of ldif export filter
909 static void html_export_write_head(FILE *out);
910 static void html_export_write_tail(FILE *out);
912 extern struct index_elem *index_elements;
915 html_print_emails(FILE *out, struct list_field *f)
917 abook_list *l = csv_to_abook_list(f->data);
919 for(; l; l = l->next) {
920 fprintf(out, "<a href=\"mailto:%s\">%s</a>", l->data, l->data);
929 html_export_database(FILE *out, struct db_enumerator e)
932 struct index_elem *cur;
939 html_export_write_head(out);
941 db_enumerate_items(e) {
942 fprintf(out, "<tr>");
943 for(cur = index_elements; cur; cur = cur->next) {
944 if(cur->type != INDEX_FIELD)
947 get_list_field(e.item, cur, &f);
949 if(f.type == FIELD_EMAILS) {
950 fprintf(out, "<td>");
951 html_print_emails(out, &f);
952 fprintf(out, "</td>");
955 fprintf(out, "<td>%s</td>", safe_str(f.data));
958 fprintf(out, "</tr>\n");
961 html_export_write_tail(out);
967 html_export_write_head(FILE *out)
969 char *realname = get_real_name(), *str;
970 struct index_elem *cur;
972 fprintf(out, "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">\n");
973 fprintf(out, "<html>\n<head>\n <title>%s's addressbook</title>",
975 fprintf(out, "\n</head>\n<body>\n");
976 fprintf(out, "\n<h2>%s's addressbook</h2>\n", realname );
977 fprintf(out, "<br><br>\n\n");
979 fprintf(out, "<table border=\"1\" align=\"center\">\n<tr>");
980 for(cur = index_elements; cur; cur = cur->next) {
981 if(cur->type != INDEX_FIELD)
984 get_field_info(cur->d.field.id, NULL, &str, NULL);
985 fprintf(out, "<th>%s</th>", str);
987 fprintf(out, "</tr>\n\n");
993 html_export_write_tail(FILE *out)
995 fprintf(out, "\n</table>\n");
996 fprintf(out, "\n</body>\n</html>\n");
1000 * end of html export filter
1005 * pine addressbook import filter
1008 #define PINE_BUF_SIZE 2048
1011 pine_fixbuf(char *buf)
1015 for(i = 0,j = 0; j < (int)strlen(buf); i++, j++)
1016 buf[i] = buf[j] == '\n' ? buf[++j] : buf[j];
1020 pine_convert_emails(char *s)
1025 if(s == NULL || *s != '(')
1028 for(i = 0; s[i]; i++)
1031 if( ( tmp = strchr(s,')')) )
1034 for(i = 1; ( tmp = strchr(s, ',') ) != NULL ; i++, s = tmp + 1)
1035 if(i > MAX_LIST_ITEMS - 1) {
1043 pine_parse_buf(char *buf)
1048 char tmp[PINE_BUF_SIZE];
1050 int pine_conv_table[]= {NICK, NAME, EMAIL, -1, NOTES};
1052 item = item_create();
1054 for(i=0, last=0; !last ; i++) {
1055 if( !(end = strchr(start, '\t')) )
1058 len = last ? strlen(start) : (int) (end-start);
1059 len = min(len, PINE_BUF_SIZE - 1);
1061 if(i < (int)(sizeof(pine_conv_table) / sizeof(*pine_conv_table))
1062 && pine_conv_table[i] >= 0) {
1063 strncpy(tmp, start, len);
1066 item_fput(item, pine_conv_table[i],
1072 pine_convert_emails(item_fget(item, EMAIL));
1073 add_item2database(item);
1078 #define LINESIZE 1024
1081 pine_parse_file(FILE *in)
1083 char line[LINESIZE];
1088 fgets(line, LINESIZE, in);
1092 buf = xrealloc(buf, i*LINESIZE);
1095 fgets(line, LINESIZE, in);
1097 if(*ptr != ' ' || feof(in))
1111 pine_parse_buf(buf);
1120 * end of pine addressbook import filter
1125 * pine addressbook export filter
1127 * filter doesn't wrap the lines as it should but Pine seems to handle
1128 * created files without problems - JH
1132 pine_export_database(FILE *out, struct db_enumerator e)
1136 db_enumerate_items(e) {
1137 emails = db_email_get(e.item);
1138 fprintf(out, strchr(emails, ',') /* multiple addresses? */ ?
1139 "%s\t%s\t(%s)\t\t%s\n" : "%s\t%s\t%s\t\t%s\n",
1140 safe_str(db_fget(e.item, NICK)),
1141 safe_str(db_name_get(e.item)),
1143 safe_str(db_fget(e.item, NOTES))
1152 * end of pine addressbook export filter
1161 * these files should be parsed according to a certain
1162 * lay out, or the default if layout is not given, at
1163 * the moment only default is done...
1166 #define CSV_COMMENT_CHAR '#'
1167 #define CSV_DUPLICATE_SEPARATOR " "
1168 #define CSV_TABLE_SIZE(t) (sizeof (t) / sizeof *(t))
1170 static int csv_conv_table[] = {
1178 static int allcsv_conv_table[] = {
1197 static int palmcsv_conv_table[] = {
1198 NAME, /* Last name */
1199 NAME, /* First name */
1216 csv_convert_emails(char *s)
1224 for(i = 1; ( tmp = strchr(s, ',') ) != NULL ; i++, s = tmp + 1)
1225 if(i > MAX_LIST_ITEMS - 1) {
1233 csv_remove_quotes(char *s)
1235 char *copy, *trimmed;
1238 copy = trimmed = xstrdup(s);
1241 len = strlen(trimmed);
1242 if(trimmed[len - 1] == '\"' && *trimmed == '\"') {
1247 trimmed[len - 1] = 0;
1249 trimmed = xstrdup(trimmed);
1259 csv_field_to_item(int *table_base, size_t table_size, int field)
1261 if(field < table_size)
1262 return field_id(table_base[field]);
1268 csv_store_item(list_item item, int i, char *s)
1270 char *newstr = NULL;
1275 if( !(newstr = csv_remove_quotes(s)) )
1279 if (item[i] != NULL) {
1280 char *oldstr = item[i];
1282 item[i] = strconcat(newstr, CSV_DUPLICATE_SEPARATOR,
1295 csv_is_valid_quote_end(char *p)
1303 else if(!ISSPACE(*p))
1311 csv_is_valid_quote_start(char *p)
1316 else if(!ISSPACE(*p))
1324 csv_parse_line(char *line, int *table_base, size_t table_size)
1328 bool in_quote = FALSE;
1331 item = item_create();
1333 for(p = start = line, field = 0; *p; p++) {
1335 if(csv_is_valid_quote_end(p))
1338 if ( (((p - start) / sizeof (char)) < 2 ) &&
1339 csv_is_valid_quote_start(p) )
1343 if(*p == ',' && !in_quote) {
1345 csv_store_item(item,
1346 csv_field_to_item(table_base,table_size,field),
1355 csv_store_item(item, csv_field_to_item(table_base, table_size, field),
1358 csv_convert_emails(item_fget(item, EMAIL));
1359 add_item2database(item);
1364 csv_parse_file_common(FILE *in, int *conv_table, size_t table_size)
1369 line = getaline(in);
1371 if(line && *line && *line != CSV_COMMENT_CHAR)
1372 csv_parse_line(line, conv_table, table_size);
1381 csv_parse_file(FILE *in)
1383 return csv_parse_file_common(in, csv_conv_table,
1384 CSV_TABLE_SIZE(csv_conv_table));
1388 allcsv_parse_file(FILE *in)
1390 return csv_parse_file_common(in, allcsv_conv_table,
1391 CSV_TABLE_SIZE(allcsv_conv_table));
1395 palmcsv_parse_file(FILE *in)
1397 return csv_parse_file_common(in, palmcsv_conv_table,
1398 CSV_TABLE_SIZE(palmcsv_conv_table));
1402 * end of csv import filter
1406 * vCard import filter
1409 static char *vcard_fields[] = {
1410 "FN", /* FORMATTED NAME */
1411 "EMAIL", /* EMAIL */
1412 "ADR", /* ADDRESS */
1413 "ADR", /* ADDRESS2 - not used */
1417 "ADR", /* COUNTRY */
1419 "TEL", /* WORKPHONE */
1421 "TEL", /* MOBILEPHONE */
1422 "NICKNAME", /* NICK */
1425 "N", /* NAME: special case/mapping in vcard_parse_line() */
1426 NULL /* not implemented: ANNIVERSARY, ITEM_FIELDS */
1430 * mappings between vCard ADR field and abook's ADDRESS
1431 * see rfc2426 section 3.2.1
1433 static int vcard_address_fields[] = {
1434 -1, /* vCard(post office box) - not used */
1435 -1, /* vCard(the extended address) - not used */
1436 2, /* vCard(the street address) - ADDRESS */
1437 4, /* vCard(the locality) - CITY */
1438 5, /* vCard(the region) - STATE */
1439 6, /* vCard(the postal code) - ZIP */
1440 7 /* vCard(the country name) - COUNTRY */
1445 VCARD_KEY_ATTRIBUTE,
1450 vcard_get_line_element(char *line, int element)
1453 char *line_copy = 0;
1459 line_copy = xstrdup(line);
1461 /* change newline characters, if present, to end of string */
1462 for(i=0; line_copy[i]; i++) {
1463 if(line_copy[i] == '\r' || line_copy[i] == '\n') {
1464 line_copy[i] = '\0';
1469 /* separate key from value */
1470 for(i=0; line_copy[i]; i++) {
1471 if(line_copy[i] == ':') {
1472 line_copy[i] = '\0';
1474 value = &line_copy[i+1];
1479 /* separate key from key attributes */
1480 /* works for vCard 2 as well (automagically) */
1482 for(i=0; key[i]; i++) {
1485 key_attr = &key[i+1];
1494 result = xstrdup(key);
1496 case VCARD_KEY_ATTRIBUTE:
1498 result = xstrdup(key_attr);
1502 result = xstrdup(value);
1511 vcard_parse_email(list_item item, char *line)
1515 email = vcard_get_line_element(line, VCARD_VALUE);
1518 item[1] = strconcat(item[1], ",", email, 0);
1527 vcard_parse_address(list_item item, char *line)
1532 char *address_field;
1534 value = vcard_get_line_element(line, VCARD_VALUE);
1538 address_field = value;
1539 for(i=k=0; value[i]; i++) {
1540 if(value[i] == ';') {
1542 if(vcard_address_fields[k] >= 0) {
1543 item[vcard_address_fields[k]] = xstrdup(address_field);
1545 address_field = &value[i+1];
1547 if((k+1)==(sizeof(vcard_address_fields)/sizeof(*vcard_address_fields)))
1551 item[vcard_address_fields[k]] = xstrdup(address_field);
1556 vcard_parse_name(list_item item, char *line)
1558 // store the "N" field into "NAME" *if* no "FN:"
1559 // value has already been stored here
1563 item[0] = vcard_get_line_element(line, VCARD_VALUE);
1564 // "N:" can be multivalued => replace ';' separators by ' '
1565 while(item[0][++i]) if(item[0][i] == ';') item[0][i] = ' ';
1567 // http://www.daniweb.com/software-development/c/code/216919
1568 char *original = item[0], *p = original;
1571 if (*original != ' ' || trimmed) {
1572 trimmed = 1; *p++ = *original;
1574 } while(*original++);
1578 vcard_parse_phone(list_item item, char *line)
1580 char *type = vcard_get_line_element(line, VCARD_KEY_ATTRIBUTE);
1581 char *value = vcard_get_line_element(line, VCARD_VALUE);
1583 /* set the standard number */
1584 if (!type) item_fput(item, PHONE, value);
1587 * see rfc2426 section 3.3.1
1588 * Note: we probably support both vCard 2 and 3
1591 if (strcasestr(type, "home") != NULL)
1592 item_fput(item, PHONE, xstrdup(value));
1593 else if (strcasestr(type, "work") != NULL)
1594 item_fput(item, WORKPHONE, xstrdup(value));
1595 else if (strcasestr(type, "fax") != NULL)
1596 item_fput(item, FAX, xstrdup(value));
1597 else if (strcasestr(type, "cell") != NULL)
1598 item_fput(item, MOBILEPHONE, xstrdup(value));
1606 vcard_parse_line(list_item item, char *line)
1611 for(i=0; vcard_fields[i]; i++) {
1612 key = vcard_fields[i];
1614 if(0 == strncmp(key, line, strlen(key))) {
1615 if(0 == strcmp(key, "EMAIL"))
1616 vcard_parse_email(item, line);
1618 vcard_parse_address(item, line);
1619 else if(0 == strcmp(key, "TEL"))
1620 vcard_parse_phone(item, line);
1621 else if(0 == strcmp(key, "N"))
1622 vcard_parse_name(item, line);
1624 item[i] = vcard_get_line_element(line, VCARD_VALUE);
1631 vcard_parse_item(FILE *in)
1634 list_item item = item_create();
1637 line = getaline(in);
1639 if(line && !strncmp("END:VCARD", line, 9)) {
1644 vcard_parse_line(item, line);
1649 add_item2database(item);
1654 vcard_parse_file(FILE *in)
1659 line = getaline(in);
1661 if(line && !strncmp("BEGIN:VCARD", line, 11)) {
1663 vcard_parse_item(in);
1674 * end of vCard import filter
1678 * csv addressbook export filters
1681 #define CSV_LAST (-1)
1682 #define CSV_UNDEFINED (-2)
1683 #define CSV_SPECIAL(X) (-3 - (X))
1684 #define CSV_IS_SPECIAL(X) ((X) <= -3)
1687 csv_export_common(FILE *out, struct db_enumerator e,
1688 int fields[], void (*special_func)(FILE *, int, int))
1692 db_enumerate_items(e) {
1693 for(i = 0; fields[i] != CSV_LAST; i++) {
1694 if(fields[i] == CSV_UNDEFINED)
1695 fprintf(out, "\"\"");
1696 else if(CSV_IS_SPECIAL(fields[i])) {
1698 (*special_func)(out, e.item, fields[i]);
1701 strchr(safe_str(database[e.item][field_idx(fields[i])]), ',') ||
1702 strchr(safe_str(database[e.item][field_idx(fields[i])]), '\"')) ?
1704 safe_str(database[e.item][field_idx(fields[i])])
1706 fprintf(out, "\"%s\"",
1707 safe_str(db_fget(e.item,fields[i])));
1709 if(fields[i + 1] != CSV_LAST)
1719 csv_export_database(FILE *out, struct db_enumerator e)
1721 int csv_export_fields[] = {
1730 csv_export_common(out, e, csv_export_fields, NULL);
1736 allcsv_export_database(FILE *out, struct db_enumerator e)
1739 * TODO: Should get these atomatically from abook_fileds
1742 int allcsv_export_fields[] = {
1764 fprintf(out, "\"NAME\",");
1765 fprintf(out, "\"EMAIL\",");
1766 fprintf(out, "\"ADDRESS\",");
1767 fprintf(out, "\"ADDRESS2\",");
1768 fprintf(out, "\"CITY\",");
1769 fprintf(out, "\"STATE\",");
1770 fprintf(out, "\"ZIP\",");
1771 fprintf(out, "\"COUNTRY\",");
1772 fprintf(out, "\"PHONE\",");
1773 fprintf(out, "\"WORKPHONE\",");
1774 fprintf(out, "\"FAX\",");
1775 fprintf(out, "\"MOBILEPHONE\",");
1776 fprintf(out, "\"NICK\",");
1777 fprintf(out, "\"URL\",");
1778 fprintf(out, "\"NOTES\",");
1779 fprintf(out, "\"ANNIVERSARY\",");
1780 fprintf(out, "\"GROUPS\"\n");
1782 csv_export_common(out, e, allcsv_export_fields, NULL);
1791 #define PALM_CSV_NAME CSV_SPECIAL(0)
1792 #define PALM_CSV_END CSV_SPECIAL(1)
1793 #define PALM_CSV_CAT CSV_SPECIAL(2)
1796 palm_split_and_write_name(FILE *out, char *name)
1802 if ( (p = strchr(name, ' ')) ) {
1806 fprintf(out, "\"%s\",\"" , p + 1);
1807 fwrite((void *)name, p - name, sizeof(char), out);
1810 fprintf(out, "\"%s\"", safe_str(name));
1815 palm_csv_handle_specials(FILE *out, int item, int field)
1819 palm_split_and_write_name(out, db_name_get(item));
1822 fprintf(out, "\"abook\"");
1825 fprintf(out, "\"0\"");
1833 palm_export_database(FILE *out, struct db_enumerator e)
1835 int palm_export_fields[] = {
1836 PALM_CSV_NAME, /* LASTNAME, FIRSTNAME */
1837 CSV_UNDEFINED, /* TITLE */
1838 CSV_UNDEFINED, /* COMPANY */
1839 WORKPHONE, /* WORK PHONE */
1840 PHONE, /* HOME PHONE */
1842 MOBILEPHONE, /* OTHER */
1844 ADDRESS, /* ADDRESS */
1848 COUNTRY, /* COUNTRY */
1849 NICK, /* DEFINED 1 */
1850 URL, /* DEFINED 2 */
1851 CSV_UNDEFINED, /* DEFINED 3 */
1852 CSV_UNDEFINED, /* DEFINED 4 */
1854 PALM_CSV_END, /* "0" */
1855 PALM_CSV_CAT, /* CATEGORY */
1859 csv_export_common(out, e, palm_export_fields, palm_csv_handle_specials);
1865 * end of csv export filters
1869 * vCard 2 addressbook export filter
1873 vcard_export_database(FILE *out, struct db_enumerator e)
1875 db_enumerate_items(e)
1876 vcard_export_item(out, e.item);
1881 vcard_export_item(FILE *out, int item)
1885 abook_list *emails, *em;
1886 fprintf(out, "BEGIN:VCARD\r\nFN:%s\r\n",
1887 safe_str(db_name_get(item)));
1889 name = get_surname(db_name_get(item));
1890 for( j = strlen(db_name_get(item)) - 1; j >= 0; j-- ) {
1891 if((db_name_get(item))[j] == ' ')
1894 fprintf(out, "N:%s;%.*s\r\n",
1897 safe_str(db_name_get(item))
1902 if(db_fget(item, ADDRESS))
1903 fprintf(out, "ADR:;;%s;%s;%s;%s;%s;%s\r\n",
1904 safe_str(db_fget(item, ADDRESS)),
1905 safe_str(db_fget(item, ADDRESS2)),
1906 safe_str(db_fget(item, CITY)),
1907 safe_str(db_fget(item, STATE)),
1908 safe_str(db_fget(item, ZIP)),
1909 safe_str(db_fget(item, COUNTRY))
1912 if(db_fget(item, PHONE))
1913 fprintf(out, "TEL;HOME:%s\r\n",
1914 db_fget(item, PHONE));
1915 if(db_fget(item, WORKPHONE))
1916 fprintf(out, "TEL;WORK:%s\r\n",
1917 db_fget(item, WORKPHONE));
1918 if(db_fget(item, FAX))
1919 fprintf(out, "TEL;FAX:%s\r\n",
1920 db_fget(item, FAX));
1921 if(db_fget(item, MOBILEPHONE))
1922 fprintf(out, "TEL;CELL:%s\r\n",
1923 db_fget(item, MOBILEPHONE));
1925 tmp = db_email_get(item);
1927 emails = csv_to_abook_list(tmp);
1929 for(em = emails; em; em = em->next)
1930 fprintf(out, "EMAIL;INTERNET:%s\r\n", em->data);
1932 abook_list_free(&emails);
1936 if(db_fget(item, NOTES))
1937 fprintf(out, "NOTE:%s\r\n",
1938 db_fget(item, NOTES));
1939 if(db_fget(item, URL))
1940 fprintf(out, "URL:%s\r\n",
1941 db_fget(item, URL));
1943 fprintf(out, "END:VCARD\r\n\r\n");
1948 * end of vCard export filter
1953 * mutt alias export filter
1957 mutt_alias_genalias(int i)
1961 if(db_fget(i, NICK))
1962 return xstrdup(db_fget(i, NICK));
1964 tmp = xstrdup(db_name_get(i));
1966 if( ( pos = strchr(tmp, ' ') ) )
1975 * This function is a variant of abook_list_to_csv
1978 mutt_alias_gengroups(int i)
1980 char *groups, *res = NULL;
1981 char groupstr[7] = "-group ";
1982 abook_list *list, *tmp;
1984 groups = db_fget(i, GROUPS);
1989 list = csv_to_abook_list(groups);
1990 for(tmp = list; tmp; tmp = tmp->next) {
1992 res = xmalloc(strlen(groupstr)+strlen(tmp->data)+1);
1993 res = strcpy(res, groupstr);
1995 res = xrealloc(res, strlen(res)+1+strlen(groupstr)+strlen(tmp->data)+1);
1997 strcat(res, groupstr);
1999 strcat(res, tmp->data);
2001 abook_list_free(&list);
2008 mutt_alias_export(FILE *out, struct db_enumerator e)
2010 char email[MAX_EMAIL_LEN];
2012 char *groups = NULL;
2013 int email_addresses;
2016 db_enumerate_items(e) {
2017 alias = (field_id(NICK) != -1) ? mutt_alias_genalias(e.item) : NULL;
2018 groups = (field_id(GROUPS) != -1) ? mutt_alias_gengroups(e.item) : NULL;
2019 get_first_email(email, e.item);
2021 /* do not output contacts without email address */
2022 /* cause this does not make sense in mutt aliases */
2025 /* output first email address */
2026 fprintf(out,"alias ");
2028 fprintf(out, "%s ", groups);
2030 fprintf(out, "%s ", alias);
2031 fprintf(out, "%s <%s>\n",
2032 db_name_get(e.item),
2035 /* number of email addresses */
2036 email_addresses = 1;
2037 ptr = db_email_get(e.item);
2038 while (*ptr != '\0') {
2045 /* output other email addresses */
2046 while (email_addresses-- > 1) {
2047 roll_emails(e.item, ROTATE_RIGHT);
2048 get_first_email(email, e.item);
2049 fprintf(out,"alias ");
2051 fprintf(out, "%s ", groups);
2053 fprintf(out, "%s__%s ", alias, email);
2055 fprintf(out, "%s__%s ", db_name_get(e.item), email);
2056 fprintf(out, "%s <%s>\n",
2057 db_name_get(e.item),
2060 roll_emails(e.item, ROTATE_RIGHT);
2069 void muttq_print_item(FILE *file, int item)
2071 abook_list *emails, *e;
2072 char *tmp = db_email_get(item);
2074 emails = csv_to_abook_list(tmp);
2077 for(e = emails; e; e = e->next) {
2078 fprintf(file, "%s\t%s\t%s\n", e->data, db_name_get(item),
2079 !db_fget(item, NOTES) ?" " :db_fget(item, NOTES)
2081 if(!opt_get_bool(BOOL_MUTT_RETURN_ALL_EMAILS))
2084 abook_list_free(&emails);
2088 mutt_query_export_database(FILE *out, struct db_enumerator e)
2090 fprintf(out, "All items\n");
2091 db_enumerate_items(e)
2092 muttq_print_item(out, e.item);
2097 * end of mutt alias export filter
2102 * printable export filter
2107 text_write_address_us(FILE *out, int i) {
2108 fprintf(out, "\n%s", db_fget(i, ADDRESS));
2110 if(db_fget(i, ADDRESS2))
2111 fprintf(out, "\n%s", db_fget(i, ADDRESS2));
2113 if(db_fget(i, CITY))
2114 fprintf(out, "\n%s", db_fget(i, CITY));
2116 if(db_fget(i, STATE) || db_fget(i, ZIP)) {
2119 if(db_fget(i, STATE)) {
2120 fprintf(out, "%s", db_fget(i, STATE));
2126 fprintf(out, "%s", db_fget(i, ZIP));
2129 if(db_fget(i, COUNTRY))
2130 fprintf(out, "\n%s", db_fget(i, COUNTRY));
2135 text_write_address_uk(FILE *out, int i) {
2138 for(j = ADDRESS; j <= COUNTRY; j++)
2140 fprintf(out, "\n%s", db_fget(i, j));
2144 text_write_address_eu(FILE *out, int i) {
2145 fprintf(out, "\n%s", db_fget(i, ADDRESS));
2147 if(db_fget(i, ADDRESS2))
2148 fprintf(out, "\n%s", db_fget(i, ADDRESS2));
2150 if(db_fget(i, ZIP) || db_fget(i, CITY)) {
2153 if(db_fget(i, ZIP)) {
2154 fprintf(out, "%s", db_fget(i, ZIP));
2155 if(db_fget(i, CITY))
2159 fprintf(out, "%s", safe_str(db_fget(i, CITY)));
2162 if(db_fget(i, STATE))
2163 fprintf(out, "\n%s", db_fget(i, STATE));
2165 if(db_fget(i, COUNTRY))
2166 fprintf(out, "\n%s", db_fget(i, COUNTRY));
2170 text_export_database(FILE * out, struct db_enumerator e)
2172 abook_list *emails, *em;
2174 char *realname = get_real_name(), *str = NULL, *tmp;
2175 char *style = opt_get_str(STR_ADDRESS_STYLE);
2178 "-----------------------------------------\n%s's address book\n"
2179 "-----------------------------------------\n\n\n",
2183 db_enumerate_items(e) {
2185 "-----------------------------------------\n\n");
2186 fprintf(out, "%s", db_name_get(e.item));
2187 if(db_fget(e.item, NICK) && *db_fget(e.item, NICK))
2188 fprintf(out, "\n(%s)", db_fget(e.item, NICK));
2191 tmp = db_email_get(e.item);
2193 emails = csv_to_abook_list(tmp);
2196 for(em = emails; em; em = em->next)
2197 fprintf(out, "%s\n", em->data);
2199 abook_list_free(&emails);
2203 if(db_fget(e.item, ADDRESS)) {
2204 if(!safe_strcmp(style, "us")) /* US like */
2205 text_write_address_us(out, e.item);
2206 else if(!safe_strcmp(style, "uk")) /* UK like */
2207 text_write_address_uk(out, e.item);
2209 text_write_address_eu(out, e.item);
2214 if((db_fget(e.item, PHONE)) ||
2215 (db_fget(e.item, WORKPHONE)) ||
2216 (db_fget(e.item, FAX)) ||
2217 (db_fget(e.item, MOBILEPHONE))) {
2219 for(j = PHONE; j <= MOBILEPHONE; j++)
2220 if(db_fget(e.item, j)) {
2221 get_field_info(field_id(j),
2223 fprintf(out, "%s: %s\n", str,
2224 db_fget(e.item, j));
2228 if(db_fget(e.item, URL))
2229 fprintf(out, "\n%s\n", db_fget(e.item, URL));
2230 if(db_fget(e.item, NOTES))
2231 fprintf(out, "\n%s\n", db_fget(e.item, NOTES));
2236 fprintf(out, "-----------------------------------------\n");
2242 * end of printable export filter
2246 * elm alias export filter
2250 elm_alias_export(FILE *out, struct db_enumerator e)
2252 char email[MAX_EMAIL_LEN];
2255 db_enumerate_items(e) {
2256 alias = mutt_alias_genalias(e.item);
2257 get_first_email(email, e.item);
2258 fprintf(out, "%s = %s = %s\n",alias,db_name_get(e.item),email);
2266 * end of elm alias export filter
2271 * Spruce export filter
2275 spruce_export_database (FILE *out, struct db_enumerator e)
2277 char email[MAX_EMAIL_LEN];
2279 fprintf(out, "# This is a generated file made by abook for the Spruce e-mail client.\n\n");
2281 db_enumerate_items(e) {
2282 get_first_email(email, e.item);
2283 if(strcmp(email, "")) {
2284 fprintf(out, "# Address %d\nName: %s\nEmail: %s\nMemo: %s\n\n",
2286 db_name_get(e.item),
2288 safe_str(db_fget(e.item, NOTES))
2293 fprintf (out, "# End of address book file.\n");
2299 * end of Spruce export filter
2303 * wanderlust addressbook export filter
2307 wl_export_database(FILE *out, struct db_enumerator e)
2309 char email[MAX_EMAIL_LEN];
2311 fprintf(out, "# Wanderlust address book written by %s\n\n", PACKAGE);
2312 db_enumerate_items(e) {
2313 get_first_email(email, e.item);
2316 "%s\t\"%s\"\t\"%s\"\n",
2318 safe_str(db_fget(e.item, NICK)),
2319 safe_str(db_name_get(e.item))
2324 fprintf (out, "\n# End of address book file.\n");
2330 * end of wanderlust addressbook export filter
2334 * BSD calendar export filter
2338 bsdcal_export_database(FILE *out, struct db_enumerator e)
2340 db_enumerate_items(e) {
2341 int year, month = 0, day = 0;
2342 char *anniversary = db_fget(e.item, ANNIVERSARY);
2345 if(!parse_date_string(anniversary, &day, &month, &year))
2349 _("%02d/%02d\tAnniversary of %s\n"),
2352 safe_str(db_name_get(e.item))
2360 // see enum field_types @database.h
2361 static char *conv_table[] = {
2382 find_field_enum(char *s) {
2384 while (conv_table[i]) {
2385 if(!safe_strcmp(conv_table[i], s))
2393 /* Convert a string with named placeholders to
2394 a *printf() compatible string.
2395 Stores the abook field values into ft. */
2397 parse_custom_format(char *s, char *fmt_string, enum field_types *ft)
2399 if(! fmt_string || ! ft) {
2400 fprintf(stderr, _("parse_custom_format: fmt_string or ft not allocated\n"));
2404 char *p, *start, *field_name = NULL;
2410 p = strchr(start, '}');
2412 fprintf(stderr, _("parse_custom_format: invalid format\n"));
2415 strcat(fmt_string, "%s");
2416 field_name = strndup(start, (size_t)(p-start));
2417 *ft = find_field_enum(field_name);
2419 fprintf(stderr, _("parse_custom_format: invalid placeholder: {%s}\n"), field_name);
2427 p = strchr(start, '{');
2429 strncat(fmt_string, start, (size_t)(p-start));
2433 strncat( fmt_string,
2435 FORMAT_STRING_LEN - strlen(fmt_string) - 1 );
2444 custom_export_item(FILE *out, int item, char *s, enum field_types *ft);
2447 // used to store the format string from --outformatstr when "custom" format is used
2448 // default value overriden in export_file()
2449 extern char *parsed_custom_format;
2450 extern enum field_types *custom_format_fields;
2452 /* wrapper for custom_export_item:
2453 1) avoid messing with extern pointer
2455 3) follow the prototype needed for an abook_output_item_filter entry */
2457 custom_print_item(FILE *out, int item)
2460 if(custom_export_item(out, item, parsed_custom_format, custom_format_fields) == 0)
2465 custom_export_item(FILE *out, int item, char *fmt, enum field_types *ft)
2469 // if the first character is '!':
2470 // we first check that all fields exist before continuing
2472 enum field_types *ftp = ft;
2474 if(! db_fget(item, *ft) )
2483 if(!strncmp(fmt, "%s", 2)) {
2484 fprintf(out, "%s", safe_str(db_fget(item, *ft)));
2487 } else if (*ft == 66) {
2488 fprintf(out, "%s", fmt);
2491 p = strchr(fmt, '%');
2493 q = strndup(fmt, (size_t)(p-fmt));
2494 fprintf(out, "%s", q);
2499 fprintf(out, "%s", fmt);
2508 // used to store the format string from --outformatstr when "custom" format is used
2509 // default value overriden from abook.c
2510 extern char custom_format[FORMAT_STRING_LEN];
2513 custom_export_database(FILE *out, struct db_enumerator e)
2515 char *format_string =
2516 (char *)malloc(FORMAT_STRING_LEN * sizeof(char*));
2518 enum field_types *ft =
2519 (enum field_types *)malloc(FORMAT_STRING_MAX_FIELDS * sizeof(enum field_types *));
2521 parse_custom_format(custom_format, format_string, ft);
2523 db_enumerate_items(e) {
2524 if(custom_export_item(out, e.item, format_string, ft) == 0)
2531 * end of BSD calendar export filter