3 * $Id: filter.c,v 1.53 2006/08/07 19:20:26 cduval Exp $
5 * by JH <jheinonen@users.sourceforge.net>
7 * Copyright (C) Jaakko Heinonen
16 #include <sys/types.h>
17 #include "abook_curses.h"
30 extern abook_field_list *fields_list;
31 extern int fields_count;
34 * function declarations
38 * import filter prototypes
41 static int ldif_parse_file(FILE *handle);
42 static int mutt_parse_file(FILE *in);
43 static int pine_parse_file(FILE *in);
44 static int csv_parse_file(FILE *in);
45 static int allcsv_parse_file(FILE *in);
46 static int palmcsv_parse_file(FILE *in);
49 * export filter prototypes
52 static int ldif_export_database(FILE *out, struct db_enumerator e);
53 static int html_export_database(FILE *out, struct db_enumerator e);
54 static int pine_export_database(FILE *out, struct db_enumerator e);
55 static int csv_export_database(FILE *out, struct db_enumerator e);
56 static int allcsv_export_database(FILE *out, struct db_enumerator e);
57 static int palm_export_database(FILE *out, struct db_enumerator e);
58 static int gcrd_export_database(FILE *out, struct db_enumerator e);
59 static int mutt_alias_export(FILE *out, struct db_enumerator e);
60 static int elm_alias_export(FILE *out, struct db_enumerator e);
61 static int text_export_database(FILE *out, struct db_enumerator e);
62 static int spruce_export_database(FILE *out, struct db_enumerator e);
63 static int wl_export_database(FILE *out, struct db_enumerator e);
66 * end of function declarations
69 struct abook_input_filter i_filters[] = {
70 { "abook", N_("abook native format"), parse_database },
71 { "ldif", N_("ldif / Netscape addressbook"), ldif_parse_file },
72 { "mutt", N_("mutt alias"), mutt_parse_file },
73 { "pine", N_("pine addressbook"), pine_parse_file },
74 { "csv", N_("comma separated values"), csv_parse_file },
75 { "allcsv", N_("comma separated values (all fields)"), allcsv_parse_file },
76 { "palmcsv", N_("Palm comma separated values"), palmcsv_parse_file },
80 struct abook_output_filter e_filters[] = {
81 { "abook", N_("abook native format"), write_database },
82 { "ldif", N_("ldif / Netscape addressbook (.4ld)"), ldif_export_database },
83 { "mutt", N_("mutt alias"), mutt_alias_export },
84 { "html", N_("html document"), html_export_database },
85 { "pine", N_("pine addressbook"), pine_export_database },
86 { "gcrd", N_("GnomeCard (VCard) addressbook"), gcrd_export_database },
87 { "csv", N_("comma separated values"), csv_export_database },
88 { "allcsv", N_("comma separated values (all fields)"), allcsv_export_database },
89 { "palmcsv", N_("Palm comma separated values"), palm_export_database},
90 { "elm", N_("elm alias"), elm_alias_export },
91 { "text", N_("plain text"), text_export_database },
92 { "wl", N_("Wanderlust address book"), wl_export_database },
93 { "spruce", N_("Spruce address book"), spruce_export_database },
107 for(i=0; *i_filters[i].filtname ; i++)
108 printf("\t%s\t%s\n", i_filters[i].filtname,
109 gettext(i_filters[i].desc));
114 for(i=0; *e_filters[i].filtname ; i++)
115 printf("\t%s\t%s\n", e_filters[i].filtname,
116 gettext(e_filters[i].desc));
122 number_of_output_filters()
126 for(i=0; *e_filters[i].filtname ; i++)
133 number_of_input_filters()
137 for(i=0; *i_filters[i].filtname ; i++)
146 char *username = getenv("USER");
147 struct passwd *pwent;
151 pwent = getpwnam(username);
153 if((tmp = xstrdup(pwent->pw_gecos)) == NULL)
154 return xstrdup(username);
156 rtn = sscanf(pwent->pw_gecos, "%[^,]", tmp);
157 if (rtn == EOF || rtn == 0) {
159 return xstrdup(username);
168 static int i_read_file(char *filename, int (*func) (FILE *in));
177 refresh_statusline();
178 headerline(_("import database"));
180 mvaddstr(3, 1, _("please select a filter"));
183 for(i=0; *i_filters[i].filtname ; i++)
184 mvprintw(5 + i, 6, "%c -\t%s\t%s\n", 'a' + i,
185 i_filters[i].filtname,
186 gettext(i_filters[i].desc));
188 mvprintw(6 + i, 6, _("x -\tcancel"));
196 int tmp = db_n_items();
200 filter = getch() - 'a';
201 if(filter == 'x' - 'a' ||
202 filter >= number_of_input_filters() || filter < 0) {
207 mvaddstr(5+filter, 2, "->");
209 filename = ask_filename(_("Filename: "));
215 if(i_read_file(filename, i_filters[filter].func ))
216 statusline_msg(_("Error occured while opening the file"));
217 else if(tmp == db_n_items())
218 statusline_msg(_("File does not seem to be a valid addressbook"));
229 i_read_file(char *filename, int (*func) (FILE *in))
234 if( (in = abook_fopen( filename, "r" )) == NULL )
245 import_file(char filtname[FILTNAME_LEN], char *filename)
248 int tmp = db_n_items();
252 if(! strncasecmp(i_filters[i].filtname, filtname,
255 if(! *i_filters[i].filtname) {
264 if(!strcmp(filename, "-")) {
266 if((fstat(fileno(stdin), &s)) == -1 || S_ISDIR(s.st_mode))
269 ret = (*i_filters[i].func) (stdin);
271 ret = i_read_file(filename, i_filters[i].func);
273 if(tmp == db_n_items())
283 static int e_write_file(char *filename,
284 int (*func) (FILE *in, struct db_enumerator e), int mode);
294 refresh_statusline();
295 headerline(_("export database"));
297 mvaddstr(3, 1, _("please select a filter"));
300 for(i = 0; *e_filters[i].filtname ; i++)
301 mvprintw(5 + i, 6, "%c -\t%s\t%s\n", 'a' + i,
302 e_filters[i].filtname,
303 gettext(e_filters[i].desc));
305 mvprintw(6 + i, 6, _("x -\tcancel"));
312 int enum_mode = ENUM_ALL;
317 filter = getch() - 'a';
318 if(filter == 'x' - 'a' ||
319 filter >= number_of_output_filters() || filter < 0) {
324 mvaddstr(5 + filter, 2, "->");
326 if(selected_items()) {
327 switch(statusline_askchoice(
328 _("Export <a>ll, export <s>elected, or <c>ancel?"),
329 S_("keybindings:all/selected/cancel|asc"), 3)) {
333 enum_mode = ENUM_SELECTED;
343 filename = ask_filename(_("Filename: "));
349 if( e_write_file(filename, e_filters[filter].func, enum_mode))
350 statusline_msg(_("Error occured while exporting"));
359 e_write_file(char *filename, int (*func) (FILE *in, struct db_enumerator e),
364 struct db_enumerator enumerator = init_db_enumerator(mode);
366 if((out = fopen(filename, "a")) == NULL)
372 ret = (*func) (out, enumerator);
380 fexport(char filtname[FILTNAME_LEN], FILE *handle, int enum_mode)
383 struct db_enumerator e = init_db_enumerator(enum_mode);
386 if(!strncasecmp(e_filters[i].filtname, filtname,
389 if(!*e_filters[i].filtname) {
395 return (e_filters[i].func) (handle, e);
401 export_file(char filtname[FILTNAME_LEN], char *filename)
403 const int mode = ENUM_ALL;
406 struct db_enumerator e = init_db_enumerator(mode);
409 if(!strncasecmp(e_filters[i].filtname, filtname,
412 if(!*e_filters[i].filtname) {
421 if(!strcmp(filename, "-"))
422 ret = (e_filters[i].func) (stdout, e);
424 ret = e_write_file(filename, e_filters[i].func, mode);
430 * end of common functions
439 static void ldif_fix_string(char *str);
441 #define LDIF_ITEM_FIELDS 16
443 typedef char *ldif_item[LDIF_ITEM_FIELDS];
445 static ldif_item ldif_field_names = {
457 "facsimiletelephonenumber",
461 "objectclass", /* this must be the last entry */
464 static int ldif_conv_table[LDIF_ITEM_FIELDS] = {
467 ADDRESS, /* "streetaddress" */
468 ADDRESS2, /* "streetaddress2" */
469 CITY, /* "locality" */
471 ZIP, /* "postalcode" */
472 COUNTRY, /* "countryname" */
473 PHONE, /* "homephone" */
474 NOTES, /* "description" */
476 FAX, /* "facsimiletelephonenumber" */
477 MOBILEPHONE, /* "cellphone" */
478 WORKPHONE, /* "xmozillaanyphone" */
479 NICK, /* "xmozillanickname" */
480 -1, /* "objectclass" */ /* this must be the last entry */
485 ldif_read_line(FILE *in)
498 if(feof(in) || !line)
507 fseek(in, pos, SEEK_SET); /* fixme ! */
517 buf = strconcat(buf, ptr, NULL);
522 if(buf && *buf == '#' ) {
531 ldif_add_item(ldif_item li)
536 item = item_create();
538 if(!li[LDIF_ITEM_FIELDS -1])
542 for(i=0; i < LDIF_ITEM_FIELDS; i++) {
543 if(ldif_conv_table[i] >= 0 && li[i] && *li[i])
544 item_fput(item,ldif_conv_table[i],xstrdup(li[i]));
547 add_item2database(item);
550 for(i=0; i < LDIF_ITEM_FIELDS; i++)
557 ldif_convert(ldif_item item, char *type, char *value)
561 if(!strcmp(type, "dn")) {
566 for(i=0; i < LDIF_ITEM_FIELDS; i++) {
567 if(!safe_strcmp(ldif_field_names[i], type) && *value) {
568 if(i == LDIF_ITEM_FIELDS - 1) /* this is a dirty hack */
569 if(safe_strcmp("person", value))
572 if(item_fget(item, i))
573 free(item_fget(item, i));
575 item_fput(item, i, xstrdup(value));
581 ldif_parse_file(FILE *handle)
588 memset(item, 0, sizeof(item));
591 if( !(line = ldif_read_line(handle)) )
594 if(-1 == (str_parse_line(line, &type, &value, &vlen))) {
596 continue; /* just skip the errors */
599 ldif_fix_string(value);
601 ldif_convert(item, type, value);
604 } while ( !feof(handle) );
606 ldif_convert(item, "dn", "");
612 ldif_fix_string(char *str)
616 for(i = 0, j = 0; j < (int)strlen(str); i++, j++)
617 str[i] = ( str[j] == (char)0xc3 ?
618 (char) str[++j] + (char) 0x40 :
629 * mutt alias import filter
635 mutt_read_line(FILE *in, char **alias, char **rest)
637 char *line, *ptr, *tmp;
640 if( !(line = ptr = getaline(in)) )
641 return 1; /* error / EOF */
645 if(strncmp("alias", ptr, 5)) {
656 while( ! ISSPACE(*ptr) )
659 alias_len = (size_t)(ptr - tmp);
662 *alias = xmalloc_inc(alias_len, 1);
664 strncpy(*alias, tmp, alias_len);
665 *(*alias + alias_len) = 0;
669 *rest = xstrdup(ptr);
676 mutt_fix_quoting(char *p)
696 mutt_parse_email(list_item item)
698 char *line = item_fget(item, NAME);
706 mutt_fix_quoting(line);
707 tmp = strconcat("From: ", line, NULL);
708 getname(tmp, &name, &email);
712 item_fput(item, NAME, name);
717 item_fput(item, EMAIL, email);
722 * this is completely broken
725 while( (start = strchr(start, ',')) && i++ < MAX_EMAILS - 1) {
726 tmp = strconcat("From: ", ++start, NULL);
727 getname(tmp, &name, &email);
732 tmp = strconcat(item[EMAIL], ",", email, NULL);
744 mutt_parse_file(FILE *in)
746 list_item item = item_create();
749 memset(item, 0, fields_count * sizeof(char *));
751 if(!mutt_read_line(in,
752 (field_id(NICK) != -1) ?
753 &item[field_id(NICK)] : NULL,
754 &item[field_id(NAME)]))
755 mutt_parse_email(item);
762 add_item2database(item);
770 * end of mutt alias import filter
779 ldif_fput_type_and_value(FILE *out,char *type, char *value )
783 tmp = ldif_type_and_value(type, value, strlen(value));
791 ldif_export_database(FILE *out, struct db_enumerator e)
793 char email[MAX_EMAILSTR_LEN];
795 fprintf(out, "version: 1\n");
797 db_enumerate_items(e) {
800 get_first_email(email, e.item);
802 tmp = strdup_printf("cn=%s,mail=%s",db_name_get(e.item),email);
804 ldif_fput_type_and_value(out, "dn", tmp);
807 for(j = 0; j < LDIF_ITEM_FIELDS; j++) {
808 if(ldif_conv_table[j] >= 0) {
809 if(ldif_conv_table[j] == EMAIL)
810 ldif_fput_type_and_value(out,
811 ldif_field_names[j], email);
812 else if(db_fget(e.item,ldif_conv_table[j]))
813 ldif_fput_type_and_value(out,
816 ldif_conv_table[j]));
820 fprintf(out, "objectclass: top\n"
821 "objectclass: person\n\n");
828 * end of ldif export filter
835 static void html_export_write_head(FILE *out, int extra_column);
836 static void html_export_write_tail(FILE *out);
839 html_export_database(FILE *out, struct db_enumerator e)
841 char tmp[MAX_EMAILSTR_LEN], *emails;
847 extra_column = init_extra_field(STR_EXTRA_COLUMN);
848 html_export_write_head(out, extra_column);
850 db_enumerate_items(e) {
851 get_first_email(tmp, e.item);
853 fprintf(out, "<tr>\n<td>"
854 "<a href=\"mailto:%s\">%s</a>"
857 db_name_get(e.item));
859 fprintf(out, "<tr>\n<td>%s</td>\n", db_name_get(e.item));
861 emails = db_email_get(e.item);
862 fprintf(out, "<td>%s</td>\n", emails);
864 if(extra_column >= 0)
865 fprintf(out, "<td>%s</td>\n",
866 safe_str(db_fget_byid(e.item, extra_column)));
867 fprintf(out, "</tr>\n\n");
870 html_export_write_tail(out);
876 html_export_write_head(FILE *out, int extra_column)
878 char *realname = get_real_name(), *extra_column_name = NULL;
880 fprintf(out, "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">\n");
881 fprintf(out, "<html>\n<head>\n <title>%s's addressbook</title>",
883 fprintf(out, "\n</head>\n<body>\n");
884 fprintf(out, "\n<h2>%s's addressbook</h2>\n", realname );
885 fprintf(out, "<br><br>\n\n");
887 fprintf(out, "<table border=\"1\" align=\"center\">\n");
888 fprintf(out, "\n<tr><th>Name</th><th>E-mail address(es)</th>");
889 if(extra_column >= 0) {
890 get_field_keyname(extra_column, NULL, &extra_column_name);
891 fprintf(out, "<th>%s</th>", safe_str(extra_column_name));
893 fprintf(out, "</tr>\n\n");
899 html_export_write_tail(FILE *out)
901 fprintf(out, "\n</table>\n");
902 fprintf(out, "\n</body>\n</html>\n");
906 * end of html export filter
911 * pine addressbook import filter
914 #define PINE_BUF_SIZE 2048
917 pine_fixbuf(char *buf)
921 for(i = 0,j = 0; j < (int)strlen(buf); i++, j++)
922 buf[i] = buf[j] == '\n' ? buf[++j] : buf[j];
926 pine_convert_emails(char *s)
931 if(s == NULL || *s != '(')
934 for(i = 0; s[i]; i++)
937 if( ( tmp = strchr(s,')')) )
940 for(i = 1; ( tmp = strchr(s, ',') ) != NULL ; i++, s = tmp + 1)
941 if(i > MAX_LIST_ITEMS - 1) {
949 pine_parse_buf(char *buf)
954 char tmp[PINE_BUF_SIZE];
956 int pine_conv_table[]= {NICK, NAME, EMAIL, -1, NOTES};
958 item = item_create();
960 for(i=0, last=0; !last ; i++) {
961 if( !(end = strchr(start, '\t')) )
964 len = last ? strlen(start) : (int) (end-start);
965 len = min(len, PINE_BUF_SIZE - 1);
967 if(i < (int)(sizeof(pine_conv_table) / sizeof(*pine_conv_table))
968 && pine_conv_table[i] >= 0) {
969 strncpy(tmp, start, len);
972 item_fput(item, pine_conv_table[i],
978 pine_convert_emails(item_fget(item, EMAIL));
979 add_item2database(item);
984 #define LINESIZE 1024
987 pine_parse_file(FILE *in)
994 fgets(line, LINESIZE, in);
998 buf = xrealloc(buf, i*LINESIZE);
1001 fgets(line, LINESIZE, in);
1003 if(*ptr != ' ' || feof(in))
1017 pine_parse_buf(buf);
1026 * end of pine addressbook import filter
1031 * pine addressbook export filter
1033 * filter doesn't wrap the lines as it should but Pine seems to handle
1034 * created files without problems - JH
1038 pine_export_database(FILE *out, struct db_enumerator e)
1042 db_enumerate_items(e) {
1043 emails = db_email_get(e.item);
1044 fprintf(out, strchr(emails, ',') /* multiple addresses? */ ?
1045 "%s\t%s\t(%s)\t\t%s\n" : "%s\t%s\t%s\t\t%s\n",
1046 safe_str(db_fget(e.item, NICK)),
1047 safe_str(db_name_get(e.item)),
1049 safe_str(db_fget(e.item, NOTES))
1058 * end of pine addressbook export filter
1067 * these files should be parsed according to a certain
1068 * lay out, or the default if layout is not given, at
1069 * the moment only default is done...
1072 #define CSV_COMMENT_CHAR '#'
1073 #define CSV_DUPLICATE_SEPARATOR " "
1074 #define CSV_TABLE_SIZE(t) (sizeof (t) / sizeof *(t))
1076 static int csv_conv_table[] = {
1084 static int allcsv_conv_table[] = {
1103 static int palmcsv_conv_table[] = {
1104 NAME, /* Last name */
1105 NAME, /* First name */
1122 csv_convert_emails(char *s)
1130 for(i = 1; ( tmp = strchr(s, ',') ) != NULL ; i++, s = tmp + 1)
1131 if(i > MAX_LIST_ITEMS - 1) {
1139 csv_remove_quotes(char *s)
1141 char *copy, *trimmed;
1144 copy = trimmed = xstrdup(s);
1147 len = strlen(trimmed);
1148 if(trimmed[len - 1] == '\"' && *trimmed == '\"') {
1153 trimmed[len - 1] = 0;
1155 trimmed = xstrdup(trimmed);
1165 csv_field_to_item(int *table_base, size_t table_size, int field)
1167 if(field < table_size)
1168 return field_id(table_base[field]);
1174 csv_store_item(list_item item, int i, char *s)
1176 char *newstr = NULL;
1181 if( !(newstr = csv_remove_quotes(s)) )
1185 if (item[i] != NULL) {
1186 char *oldstr = item[i];
1188 item[i] = strconcat(newstr, CSV_DUPLICATE_SEPARATOR,
1201 csv_is_valid_quote_end(char *p)
1209 else if(!ISSPACE(*p))
1217 csv_is_valid_quote_start(char *p)
1222 else if(!ISSPACE(*p))
1230 csv_parse_line(char *line, int *table_base, size_t table_size)
1234 bool in_quote = FALSE;
1237 item = item_create();
1239 for(p = start = line, field = 0; *p; p++) {
1241 if(csv_is_valid_quote_end(p))
1244 if ( (((p - start) / sizeof (char)) < 2 ) &&
1245 csv_is_valid_quote_start(p) )
1249 if(*p == ',' && !in_quote) {
1251 csv_store_item(item,
1252 csv_field_to_item(table_base,table_size,field),
1261 csv_store_item(item, csv_field_to_item(table_base, table_size, field),
1264 csv_convert_emails(item_fget(item, EMAIL));
1265 add_item2database(item);
1270 csv_parse_file_common(FILE *in, int *conv_table, size_t table_size)
1275 line = getaline(in);
1277 if(line && *line && *line != CSV_COMMENT_CHAR)
1278 csv_parse_line(line, conv_table, table_size);
1287 csv_parse_file(FILE *in)
1289 return csv_parse_file_common(in, csv_conv_table,
1290 CSV_TABLE_SIZE(csv_conv_table));
1294 allcsv_parse_file(FILE *in)
1296 return csv_parse_file_common(in, allcsv_conv_table,
1297 CSV_TABLE_SIZE(allcsv_conv_table));
1301 palmcsv_parse_file(FILE *in)
1303 return csv_parse_file_common(in, palmcsv_conv_table,
1304 CSV_TABLE_SIZE(palmcsv_conv_table));
1308 * end of csv import filter
1312 * csv addressbook export filters
1315 #define CSV_LAST (-1)
1316 #define CSV_UNDEFINED (-2)
1317 #define CSV_SPECIAL(X) (-3 - (X))
1318 #define CSV_IS_SPECIAL(X) ((X) <= -3)
1321 csv_export_common(FILE *out, struct db_enumerator e,
1322 int fields[], void (*special_func)(FILE *, int, int))
1326 db_enumerate_items(e) {
1327 for(i = 0; fields[i] != CSV_LAST; i++) {
1328 if(fields[i] == CSV_UNDEFINED)
1329 fprintf(out, "\"\"");
1330 else if(CSV_IS_SPECIAL(fields[i])) {
1332 (*special_func)(out, e.item, fields[i]);
1335 strchr(safe_str(database[e.item][field_idx(fields[i])]), ',') ||
1336 strchr(safe_str(database[e.item][field_idx(fields[i])]), '\"')) ?
1338 safe_str(database[e.item][field_idx(fields[i])])
1340 fprintf(out, "\"%s\"",
1341 safe_str(db_fget(e.item,fields[i])));
1343 if(fields[i + 1] != CSV_LAST)
1353 csv_export_database(FILE *out, struct db_enumerator e)
1355 int csv_export_fields[] = {
1364 csv_export_common(out, e, csv_export_fields, NULL);
1370 allcsv_export_database(FILE *out, struct db_enumerator e)
1373 * TODO: Should get these atomatically from abook_fileds
1376 int allcsv_export_fields[] = {
1397 fprintf(out, "\"NAME\",");
1398 fprintf(out, "\"EMAIL\",");
1399 fprintf(out, "\"ADDRESS\",");
1400 fprintf(out, "\"ADDRESS2\",");
1401 fprintf(out, "\"CITY\",");
1402 fprintf(out, "\"STATE\",");
1403 fprintf(out, "\"ZIP\",");
1404 fprintf(out, "\"COUNTRY\",");
1405 fprintf(out, "\"PHONE\",");
1406 fprintf(out, "\"WORKPHONE\",");
1407 fprintf(out, "\"FAX\",");
1408 fprintf(out, "\"MOBILEPHONE\",");
1409 fprintf(out, "\"NICK\",");
1410 fprintf(out, "\"URL\",");
1411 fprintf(out, "\"NOTES\",");
1412 fprintf(out, "\"ANNIVERSARY\"\n");
1414 csv_export_common(out, e, allcsv_export_fields, NULL);
1423 #define PALM_CSV_NAME CSV_SPECIAL(0)
1424 #define PALM_CSV_END CSV_SPECIAL(1)
1425 #define PALM_CSV_CAT CSV_SPECIAL(2)
1428 palm_split_and_write_name(FILE *out, char *name)
1434 if ( (p = strchr(name, ' ')) ) {
1438 fprintf(out, "\"%s\",\"" , p + 1);
1439 fwrite((void *)name, p - name, sizeof(char), out);
1442 fprintf(out, "\"%s\"", safe_str(name));
1447 palm_csv_handle_specials(FILE *out, int item, int field)
1451 palm_split_and_write_name(out, db_name_get(item));
1454 fprintf(out, "\"abook\"");
1457 fprintf(out, "\"0\"");
1465 palm_export_database(FILE *out, struct db_enumerator e)
1467 int palm_export_fields[] = {
1468 PALM_CSV_NAME, /* LASTNAME, FIRSTNAME */
1469 CSV_UNDEFINED, /* TITLE */
1470 CSV_UNDEFINED, /* COMPANY */
1471 WORKPHONE, /* WORK PHONE */
1472 PHONE, /* HOME PHONE */
1474 MOBILEPHONE, /* OTHER */
1476 ADDRESS, /* ADDRESS */
1480 COUNTRY, /* COUNTRY */
1481 NICK, /* DEFINED 1 */
1482 URL, /* DEFINED 2 */
1483 CSV_UNDEFINED, /* DEFINED 3 */
1484 CSV_UNDEFINED, /* DEFINED 4 */
1486 PALM_CSV_END, /* "0" */
1487 PALM_CSV_CAT, /* CATEGORY */
1491 csv_export_common(out, e, palm_export_fields, palm_csv_handle_specials);
1497 * end of csv export filters
1501 * GnomeCard (VCard) addressbook export filter
1505 gcrd_export_database(FILE *out, struct db_enumerator e)
1509 abook_list *emails, *em;
1511 db_enumerate_items(e) {
1512 fprintf(out, "BEGIN:VCARD\r\nFN:%s\r\n",
1513 safe_str(db_name_get(e.item)));
1515 name = get_surname(db_name_get(e.item));
1516 for( j = strlen(db_name_get(e.item)) - 1; j >= 0; j-- ) {
1517 if((db_name_get(e.item))[j] == ' ')
1520 fprintf(out, "N:%s;%.*s\r\n",
1523 safe_str(db_name_get(e.item))
1528 if(db_fget(e.item, ADDRESS))
1529 fprintf(out, "ADR:;;%s;%s;%s;%s;%s;%s\r\n",
1530 safe_str(db_fget(e.item, ADDRESS)),
1531 safe_str(db_fget(e.item, ADDRESS2)),
1532 safe_str(db_fget(e.item, CITY)),
1533 safe_str(db_fget(e.item, STATE)),
1534 safe_str(db_fget(e.item, ZIP)),
1535 safe_str(db_fget(e.item, COUNTRY))
1538 if(db_fget(e.item, PHONE))
1539 fprintf(out, "TEL;HOME:%s\r\n",
1540 db_fget(e.item, PHONE));
1541 if(db_fget(e.item, WORKPHONE))
1542 fprintf(out, "TEL;WORK:%s\r\n",
1543 db_fget(e.item, WORKPHONE));
1544 if(db_fget(e.item, FAX))
1545 fprintf(out, "TEL;FAX:%s\r\n",
1546 db_fget(e.item, FAX));
1547 if(db_fget(e.item, MOBILEPHONE))
1548 fprintf(out, "TEL;CELL:%s\r\n",
1549 db_fget(e.item, MOBILEPHONE));
1551 tmp = db_email_get(e.item);
1553 emails = csv_to_abook_list(tmp);
1555 for(em = emails; em; em = em->next)
1556 fprintf(out, "EMAIL;INTERNET:%s\r\n", em->data);
1558 abook_list_free(&emails);
1562 if(db_fget(e.item, NOTES))
1563 fprintf(out, "NOTE:%s\r\n",
1564 db_fget(e.item, NOTES));
1565 if(db_fget(e.item, URL))
1566 fprintf(out, "URL:%s\r\n",
1567 db_fget(e.item, URL));
1569 fprintf(out, "END:VCARD\r\n\r\n");
1577 * end of GnomeCard export filter
1582 * mutt alias export filter
1586 mutt_alias_genalias(int i)
1590 if(db_fget(i, NICK))
1591 return xstrdup(db_fget(i, NICK));
1593 tmp = xstrdup(db_name_get(i));
1595 if( ( pos = strchr(tmp, ' ') ) )
1604 mutt_alias_export(FILE *out, struct db_enumerator e)
1606 char email[MAX_EMAIL_LEN];
1609 db_enumerate_items(e) {
1610 alias = mutt_alias_genalias(e.item);
1611 get_first_email(email, e.item);
1612 fprintf(out, *email ? "alias %s %s <%s>\n": "alias %s %s%s\n",
1614 db_name_get(e.item),
1623 * end of mutt alias export filter
1628 * printable export filter
1633 text_write_address_us(FILE *out, int i) {
1634 fprintf(out, "\n%s", db_fget(i, ADDRESS));
1636 if(db_fget(i, ADDRESS2))
1637 fprintf(out, "\n%s", db_fget(i, ADDRESS2));
1639 if(db_fget(i, CITY))
1640 fprintf(out, "\n%s", db_fget(i, CITY));
1642 if(db_fget(i, STATE) || db_fget(i, ZIP)) {
1645 if(db_fget(i, STATE)) {
1646 fprintf(out, "%s", db_fget(i, STATE));
1652 fprintf(out, "%s", db_fget(i, ZIP));
1655 if(db_fget(i, COUNTRY))
1656 fprintf(out, "\n%s", db_fget(i, COUNTRY));
1661 text_write_address_uk(FILE *out, int i) {
1664 for(j = ADDRESS; j <= COUNTRY; j++)
1666 fprintf(out, "\n%s", db_fget(i, j));
1670 text_write_address_eu(FILE *out, int i) {
1671 fprintf(out, "\n%s", db_fget(i, ADDRESS));
1673 if(db_fget(i, ADDRESS2))
1674 fprintf(out, "\n%s", db_fget(i, ADDRESS2));
1676 if(db_fget(i, ZIP) || db_fget(i, CITY)) {
1679 if(db_fget(i, ZIP)) {
1680 fprintf(out, "%s", db_fget(i, ZIP));
1681 if(db_fget(i, CITY))
1685 fprintf(out, "%s", safe_str(db_fget(i, CITY)));
1688 if(db_fget(i, STATE))
1689 fprintf(out, "\n%s", db_fget(i, STATE));
1691 if(db_fget(i, COUNTRY))
1692 fprintf(out, "\n%s", db_fget(i, COUNTRY));
1696 text_export_database(FILE * out, struct db_enumerator e)
1698 abook_list *emails, *em;
1700 char *realname = get_real_name(), *str = NULL, *tmp;
1701 char *style = opt_get_str(STR_ADDRESS_STYLE);
1704 "-----------------------------------------\n%s's address book\n"
1705 "-----------------------------------------\n\n\n",
1709 db_enumerate_items(e) {
1711 "-----------------------------------------\n\n");
1712 fprintf(out, "%s", db_name_get(e.item));
1713 if(db_fget(e.item, NICK) && *db_fget(e.item, NICK))
1714 fprintf(out, "\n(%s)", db_fget(e.item, NICK));
1717 tmp = db_email_get(e.item);
1719 emails = csv_to_abook_list(tmp);
1722 for(em = emails; em; em = em->next)
1723 fprintf(out, "%s\n", em->data);
1725 abook_list_free(&emails);
1729 if(db_fget(e.item, ADDRESS)) {
1730 if(!safe_strcmp(style, "us")) /* US like */
1731 text_write_address_us(out, e.item);
1732 else if(!safe_strcmp(style, "uk")) /* UK like */
1733 text_write_address_uk(out, e.item);
1735 text_write_address_eu(out, e.item);
1740 if((db_fget(e.item, PHONE)) ||
1741 (db_fget(e.item, WORKPHONE)) ||
1742 (db_fget(e.item, FAX)) ||
1743 (db_fget(e.item, MOBILEPHONE))) {
1745 for(j = PHONE; j <= MOBILEPHONE; j++)
1746 if(db_fget(e.item, j)) {
1747 get_field_keyname(field_id(j),
1749 fprintf(out, "%s: %s\n", str,
1750 db_fget(e.item, j));
1754 if(db_fget(e.item, URL))
1755 fprintf(out, "\n%s\n", db_fget(e.item, URL));
1756 if(db_fget(e.item, NOTES))
1757 fprintf(out, "\n%s\n", db_fget(e.item, NOTES));
1762 fprintf(out, "-----------------------------------------\n");
1768 * end of printable export filter
1772 * elm alias export filter
1776 elm_alias_export(FILE *out, struct db_enumerator e)
1778 char email[MAX_EMAIL_LEN];
1781 db_enumerate_items(e) {
1782 alias = mutt_alias_genalias(e.item);
1783 get_first_email(email, e.item);
1784 fprintf(out, "%s = %s = %s\n",alias,db_name_get(e.item),email);
1792 * end of elm alias export filter
1797 * Spruce export filter
1801 spruce_export_database (FILE *out, struct db_enumerator e)
1803 char email[MAX_EMAIL_LEN];
1805 fprintf(out, "# This is a generated file made by abook for the Spruce e-mail client.\n\n");
1807 db_enumerate_items(e) {
1808 get_first_email(email, e.item);
1809 if(strcmp(email, "")) {
1810 fprintf(out, "# Address %d\nName: %s\nEmail: %s\nMemo: %s\n\n",
1812 db_name_get(e.item),
1814 safe_str(db_fget(e.item, NOTES))
1819 fprintf (out, "# End of address book file.\n");
1825 * end of Spruce export filter
1829 * wanderlust addressbook export filter
1833 wl_export_database(FILE *out, struct db_enumerator e)
1835 char email[MAX_EMAIL_LEN];
1837 fprintf(out, "# Wanderlust address book written by %s\n\n", PACKAGE);
1838 db_enumerate_items(e) {
1839 get_first_email(email, e.item);
1842 "%s\t\"%s\"\t\"%s\"\n",
1844 safe_str(db_fget(e.item, NICK)),
1845 safe_str(db_name_get(e.item))
1850 fprintf (out, "\n# End of address book file.\n");
1856 * end of wanderlust addressbook export filter