3 * $Id: filter.c,v 1.55 2006/09/06 02:46:44 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
);
64 static int bsdcal_export_database(FILE *out
, struct db_enumerator e
);
67 * end of function declarations
70 struct abook_input_filter i_filters
[] = {
71 { "abook", N_("abook native format"), parse_database
},
72 { "ldif", N_("ldif / Netscape addressbook"), ldif_parse_file
},
73 { "mutt", N_("mutt alias"), mutt_parse_file
},
74 { "pine", N_("pine addressbook"), pine_parse_file
},
75 { "csv", N_("comma separated values"), csv_parse_file
},
76 { "allcsv", N_("comma separated values (all fields)"), allcsv_parse_file
},
77 { "palmcsv", N_("Palm comma separated values"), palmcsv_parse_file
},
81 struct abook_output_filter e_filters
[] = {
82 { "abook", N_("abook native format"), write_database
},
83 { "ldif", N_("ldif / Netscape addressbook (.4ld)"), ldif_export_database
},
84 { "mutt", N_("mutt alias"), mutt_alias_export
},
85 { "html", N_("html document"), html_export_database
},
86 { "pine", N_("pine addressbook"), pine_export_database
},
87 { "gcrd", N_("GnomeCard (VCard) addressbook"), gcrd_export_database
},
88 { "csv", N_("comma separated values"), csv_export_database
},
89 { "allcsv", N_("comma separated values (all fields)"), allcsv_export_database
},
90 { "palmcsv", N_("Palm comma separated values"), palm_export_database
},
91 { "elm", N_("elm alias"), elm_alias_export
},
92 { "text", N_("plain text"), text_export_database
},
93 { "wl", N_("Wanderlust address book"), wl_export_database
},
94 { "spruce", N_("Spruce address book"), spruce_export_database
},
95 { "bsdcal", N_("BSD calendar"), bsdcal_export_database
},
109 for(i
=0; *i_filters
[i
].filtname
; i
++)
110 printf("\t%s\t%s\n", i_filters
[i
].filtname
,
111 gettext(i_filters
[i
].desc
));
116 for(i
=0; *e_filters
[i
].filtname
; i
++)
117 printf("\t%s\t%s\n", e_filters
[i
].filtname
,
118 gettext(e_filters
[i
].desc
));
124 number_of_output_filters()
128 for(i
=0; *e_filters
[i
].filtname
; i
++)
135 number_of_input_filters()
139 for(i
=0; *i_filters
[i
].filtname
; i
++)
148 char *username
= getenv("USER");
149 struct passwd
*pwent
;
153 pwent
= getpwnam(username
);
155 if((tmp
= xstrdup(pwent
->pw_gecos
)) == NULL
)
156 return xstrdup(username
);
158 rtn
= sscanf(pwent
->pw_gecos
, "%[^,]", tmp
);
159 if (rtn
== EOF
|| rtn
== 0) {
161 return xstrdup(username
);
170 static int i_read_file(char *filename
, int (*func
) (FILE *in
));
179 refresh_statusline();
180 headerline(_("import database"));
182 mvaddstr(3, 1, _("please select a filter"));
185 for(i
=0; *i_filters
[i
].filtname
; i
++)
186 mvprintw(5 + i
, 6, "%c -\t%s\t%s\n", 'a' + i
,
187 i_filters
[i
].filtname
,
188 gettext(i_filters
[i
].desc
));
190 mvprintw(6 + i
, 6, _("x -\tcancel"));
198 int tmp
= db_n_items();
202 filter
= getch() - 'a';
203 if(filter
== 'x' - 'a' ||
204 filter
>= number_of_input_filters() || filter
< 0) {
209 mvaddstr(5+filter
, 2, "->");
211 filename
= ask_filename(_("Filename: "));
217 if(i_read_file(filename
, i_filters
[filter
].func
))
218 statusline_msg(_("Error occured while opening the file"));
219 else if(tmp
== db_n_items())
220 statusline_msg(_("File does not seem to be a valid addressbook"));
231 i_read_file(char *filename
, int (*func
) (FILE *in
))
236 if( (in
= abook_fopen( filename
, "r" )) == NULL
)
247 import_file(char filtname
[FILTNAME_LEN
], char *filename
)
250 int tmp
= db_n_items();
254 if(! strncasecmp(i_filters
[i
].filtname
, filtname
,
257 if(! *i_filters
[i
].filtname
) {
266 if(!strcmp(filename
, "-")) {
268 if((fstat(fileno(stdin
), &s
)) == -1 || S_ISDIR(s
.st_mode
))
271 ret
= (*i_filters
[i
].func
) (stdin
);
273 ret
= i_read_file(filename
, i_filters
[i
].func
);
275 if(tmp
== db_n_items())
285 static int e_write_file(char *filename
,
286 int (*func
) (FILE *in
, struct db_enumerator e
), int mode
);
296 refresh_statusline();
297 headerline(_("export database"));
299 mvaddstr(3, 1, _("please select a filter"));
302 for(i
= 0; *e_filters
[i
].filtname
; i
++)
303 mvprintw(5 + i
, 6, "%c -\t%s\t%s\n", 'a' + i
,
304 e_filters
[i
].filtname
,
305 gettext(e_filters
[i
].desc
));
307 mvprintw(6 + i
, 6, _("x -\tcancel"));
314 int enum_mode
= ENUM_ALL
;
319 filter
= getch() - 'a';
320 if(filter
== 'x' - 'a' ||
321 filter
>= number_of_output_filters() || filter
< 0) {
326 mvaddstr(5 + filter
, 2, "->");
328 if(selected_items()) {
329 switch(statusline_askchoice(
330 _("Export <a>ll, export <s>elected, or <c>ancel?"),
331 S_("keybindings:all/selected/cancel|asc"), 3)) {
335 enum_mode
= ENUM_SELECTED
;
345 filename
= ask_filename(_("Filename: "));
351 if( e_write_file(filename
, e_filters
[filter
].func
, enum_mode
))
352 statusline_msg(_("Error occured while exporting"));
361 e_write_file(char *filename
, int (*func
) (FILE *in
, struct db_enumerator e
),
366 struct db_enumerator enumerator
= init_db_enumerator(mode
);
368 if((out
= fopen(filename
, "a")) == NULL
)
374 ret
= (*func
) (out
, enumerator
);
382 fexport(char filtname
[FILTNAME_LEN
], FILE *handle
, int enum_mode
)
385 struct db_enumerator e
= init_db_enumerator(enum_mode
);
388 if(!strncasecmp(e_filters
[i
].filtname
, filtname
,
391 if(!*e_filters
[i
].filtname
) {
397 return (e_filters
[i
].func
) (handle
, e
);
403 export_file(char filtname
[FILTNAME_LEN
], char *filename
)
405 const int mode
= ENUM_ALL
;
408 struct db_enumerator e
= init_db_enumerator(mode
);
411 if(!strncasecmp(e_filters
[i
].filtname
, filtname
,
414 if(!*e_filters
[i
].filtname
) {
423 if(!strcmp(filename
, "-"))
424 ret
= (e_filters
[i
].func
) (stdout
, e
);
426 ret
= e_write_file(filename
, e_filters
[i
].func
, mode
);
432 * end of common functions
441 static void ldif_fix_string(char *str
);
443 #define LDIF_ITEM_FIELDS 16
445 typedef char *ldif_item
[LDIF_ITEM_FIELDS
];
447 static ldif_item ldif_field_names
= {
459 "facsimiletelephonenumber",
463 "objectclass", /* this must be the last entry */
466 static int ldif_conv_table
[LDIF_ITEM_FIELDS
] = {
469 ADDRESS
, /* "streetaddress" */
470 ADDRESS2
, /* "streetaddress2" */
471 CITY
, /* "locality" */
473 ZIP
, /* "postalcode" */
474 COUNTRY
, /* "countryname" */
475 PHONE
, /* "homephone" */
476 NOTES
, /* "description" */
478 FAX
, /* "facsimiletelephonenumber" */
479 MOBILEPHONE
, /* "cellphone" */
480 WORKPHONE
, /* "xmozillaanyphone" */
481 NICK
, /* "xmozillanickname" */
482 -1, /* "objectclass" */ /* this must be the last entry */
487 ldif_read_line(FILE *in
)
500 if(feof(in
) || !line
)
509 fseek(in
, pos
, SEEK_SET
); /* fixme ! */
519 buf
= strconcat(buf
, ptr
, NULL
);
524 if(buf
&& *buf
== '#' ) {
533 ldif_add_item(ldif_item li
)
538 item
= item_create();
540 if(!li
[LDIF_ITEM_FIELDS
-1])
544 for(i
=0; i
< LDIF_ITEM_FIELDS
; i
++) {
545 if(ldif_conv_table
[i
] >= 0 && li
[i
] && *li
[i
])
546 item_fput(item
,ldif_conv_table
[i
],xstrdup(li
[i
]));
549 add_item2database(item
);
552 for(i
=0; i
< LDIF_ITEM_FIELDS
; i
++)
559 ldif_convert(ldif_item item
, char *type
, char *value
)
563 if(!strcmp(type
, "dn")) {
568 for(i
=0; i
< LDIF_ITEM_FIELDS
; i
++) {
569 if(!safe_strcmp(ldif_field_names
[i
], type
) && *value
) {
570 if(i
== LDIF_ITEM_FIELDS
- 1) /* this is a dirty hack */
571 if(safe_strcmp("person", value
))
574 if(item_fget(item
, i
))
575 free(item_fget(item
, i
));
577 item_fput(item
, i
, xstrdup(value
));
583 ldif_parse_file(FILE *handle
)
590 memset(item
, 0, sizeof(item
));
593 if( !(line
= ldif_read_line(handle
)) )
596 if(-1 == (str_parse_line(line
, &type
, &value
, &vlen
))) {
598 continue; /* just skip the errors */
601 ldif_fix_string(value
);
603 ldif_convert(item
, type
, value
);
606 } while ( !feof(handle
) );
608 ldif_convert(item
, "dn", "");
614 ldif_fix_string(char *str
)
618 for(i
= 0, j
= 0; j
< (int)strlen(str
); i
++, j
++)
619 str
[i
] = ( str
[j
] == (char)0xc3 ?
620 (char) str
[++j
] + (char) 0x40 :
631 * mutt alias import filter
637 mutt_read_line(FILE *in
, char **alias
, char **rest
)
639 char *line
, *ptr
, *tmp
;
642 if( !(line
= ptr
= getaline(in
)) )
643 return 1; /* error / EOF */
647 if(strncmp("alias", ptr
, 5)) {
658 while( ! ISSPACE(*ptr
) )
661 alias_len
= (size_t)(ptr
- tmp
);
664 *alias
= xmalloc_inc(alias_len
, 1);
666 strncpy(*alias
, tmp
, alias_len
);
667 *(*alias
+ alias_len
) = 0;
671 *rest
= xstrdup(ptr
);
678 mutt_fix_quoting(char *p
)
698 mutt_parse_email(list_item item
)
700 char *line
= item_fget(item
, NAME
);
708 mutt_fix_quoting(line
);
709 tmp
= strconcat("From: ", line
, NULL
);
710 getname(tmp
, &name
, &email
);
714 item_fput(item
, NAME
, name
);
719 item_fput(item
, EMAIL
, email
);
724 * this is completely broken
727 while( (start
= strchr(start
, ',')) && i
++ < MAX_EMAILS
- 1) {
728 tmp
= strconcat("From: ", ++start
, NULL
);
729 getname(tmp
, &name
, &email
);
734 tmp
= strconcat(item
[EMAIL
], ",", email
, NULL
);
746 mutt_parse_file(FILE *in
)
748 list_item item
= item_create();
751 memset(item
, 0, fields_count
* sizeof(char *));
753 if(!mutt_read_line(in
,
754 (field_id(NICK
) != -1) ?
755 &item
[field_id(NICK
)] : NULL
,
756 &item
[field_id(NAME
)]))
757 mutt_parse_email(item
);
764 add_item2database(item
);
772 * end of mutt alias import filter
781 ldif_fput_type_and_value(FILE *out
,char *type
, char *value
)
785 tmp
= ldif_type_and_value(type
, value
, strlen(value
));
793 ldif_export_database(FILE *out
, struct db_enumerator e
)
795 char email
[MAX_EMAILSTR_LEN
];
797 fprintf(out
, "version: 1\n");
799 db_enumerate_items(e
) {
802 get_first_email(email
, e
.item
);
804 tmp
= strdup_printf("cn=%s,mail=%s",db_name_get(e
.item
),email
);
806 ldif_fput_type_and_value(out
, "dn", tmp
);
809 for(j
= 0; j
< LDIF_ITEM_FIELDS
; j
++) {
810 if(ldif_conv_table
[j
] >= 0) {
811 if(ldif_conv_table
[j
] == EMAIL
)
812 ldif_fput_type_and_value(out
,
813 ldif_field_names
[j
], email
);
814 else if(db_fget(e
.item
,ldif_conv_table
[j
]))
815 ldif_fput_type_and_value(out
,
818 ldif_conv_table
[j
]));
822 fprintf(out
, "objectclass: top\n"
823 "objectclass: person\n\n");
830 * end of ldif export filter
837 static void html_export_write_head(FILE *out
);
838 static void html_export_write_tail(FILE *out
);
840 extern struct index_elem
*index_elements
;
843 html_print_emails(FILE *out
, struct list_field
*f
)
845 abook_list
*l
= csv_to_abook_list(f
->data
);
847 for(; l
; l
= l
->next
) {
848 fprintf(out
, "<a href=\"mailto:%s\">%s</a>", l
->data
, l
->data
);
857 html_export_database(FILE *out
, struct db_enumerator e
)
860 struct index_elem
*cur
;
867 html_export_write_head(out
);
869 db_enumerate_items(e
) {
870 fprintf(out
, "<tr>");
871 for(cur
= index_elements
; cur
; cur
= cur
->next
) {
872 if(cur
->type
!= INDEX_FIELD
)
875 get_list_field(e
.item
, cur
, &f
);
877 if(f
.type
== FIELD_EMAILS
) {
878 fprintf(out
, "<td>");
879 html_print_emails(out
, &f
);
880 fprintf(out
, "</td>");
883 fprintf(out
, "<td>%s</td>", safe_str(f
.data
));
886 fprintf(out
, "</tr>\n");
889 html_export_write_tail(out
);
895 html_export_write_head(FILE *out
)
897 char *realname
= get_real_name(), *str
;
898 struct index_elem
*cur
;
900 fprintf(out
, "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">\n");
901 fprintf(out
, "<html>\n<head>\n <title>%s's addressbook</title>",
903 fprintf(out
, "\n</head>\n<body>\n");
904 fprintf(out
, "\n<h2>%s's addressbook</h2>\n", realname
);
905 fprintf(out
, "<br><br>\n\n");
907 fprintf(out
, "<table border=\"1\" align=\"center\">\n<tr>");
908 for(cur
= index_elements
; cur
; cur
= cur
->next
) {
909 if(cur
->type
!= INDEX_FIELD
)
912 get_field_info(cur
->d
.field
.id
, NULL
, &str
, NULL
);
913 fprintf(out
, "<th>%s</th>", str
);
915 fprintf(out
, "</tr>\n\n");
921 html_export_write_tail(FILE *out
)
923 fprintf(out
, "\n</table>\n");
924 fprintf(out
, "\n</body>\n</html>\n");
928 * end of html export filter
933 * pine addressbook import filter
936 #define PINE_BUF_SIZE 2048
939 pine_fixbuf(char *buf
)
943 for(i
= 0,j
= 0; j
< (int)strlen(buf
); i
++, j
++)
944 buf
[i
] = buf
[j
] == '\n' ? buf
[++j
] : buf
[j
];
948 pine_convert_emails(char *s
)
953 if(s
== NULL
|| *s
!= '(')
956 for(i
= 0; s
[i
]; i
++)
959 if( ( tmp
= strchr(s
,')')) )
962 for(i
= 1; ( tmp
= strchr(s
, ',') ) != NULL
; i
++, s
= tmp
+ 1)
963 if(i
> MAX_LIST_ITEMS
- 1) {
971 pine_parse_buf(char *buf
)
976 char tmp
[PINE_BUF_SIZE
];
978 int pine_conv_table
[]= {NICK
, NAME
, EMAIL
, -1, NOTES
};
980 item
= item_create();
982 for(i
=0, last
=0; !last
; i
++) {
983 if( !(end
= strchr(start
, '\t')) )
986 len
= last
? strlen(start
) : (int) (end
-start
);
987 len
= min(len
, PINE_BUF_SIZE
- 1);
989 if(i
< (int)(sizeof(pine_conv_table
) / sizeof(*pine_conv_table
))
990 && pine_conv_table
[i
] >= 0) {
991 strncpy(tmp
, start
, len
);
994 item_fput(item
, pine_conv_table
[i
],
1000 pine_convert_emails(item_fget(item
, EMAIL
));
1001 add_item2database(item
);
1006 #define LINESIZE 1024
1009 pine_parse_file(FILE *in
)
1011 char line
[LINESIZE
];
1016 fgets(line
, LINESIZE
, in
);
1020 buf
= xrealloc(buf
, i
*LINESIZE
);
1023 fgets(line
, LINESIZE
, in
);
1025 if(*ptr
!= ' ' || feof(in
))
1039 pine_parse_buf(buf
);
1048 * end of pine addressbook import filter
1053 * pine addressbook export filter
1055 * filter doesn't wrap the lines as it should but Pine seems to handle
1056 * created files without problems - JH
1060 pine_export_database(FILE *out
, struct db_enumerator e
)
1064 db_enumerate_items(e
) {
1065 emails
= db_email_get(e
.item
);
1066 fprintf(out
, strchr(emails
, ',') /* multiple addresses? */ ?
1067 "%s\t%s\t(%s)\t\t%s\n" : "%s\t%s\t%s\t\t%s\n",
1068 safe_str(db_fget(e
.item
, NICK
)),
1069 safe_str(db_name_get(e
.item
)),
1071 safe_str(db_fget(e
.item
, NOTES
))
1080 * end of pine addressbook export filter
1089 * these files should be parsed according to a certain
1090 * lay out, or the default if layout is not given, at
1091 * the moment only default is done...
1094 #define CSV_COMMENT_CHAR '#'
1095 #define CSV_DUPLICATE_SEPARATOR " "
1096 #define CSV_TABLE_SIZE(t) (sizeof (t) / sizeof *(t))
1098 static int csv_conv_table
[] = {
1106 static int allcsv_conv_table
[] = {
1125 static int palmcsv_conv_table
[] = {
1126 NAME
, /* Last name */
1127 NAME
, /* First name */
1144 csv_convert_emails(char *s
)
1152 for(i
= 1; ( tmp
= strchr(s
, ',') ) != NULL
; i
++, s
= tmp
+ 1)
1153 if(i
> MAX_LIST_ITEMS
- 1) {
1161 csv_remove_quotes(char *s
)
1163 char *copy
, *trimmed
;
1166 copy
= trimmed
= xstrdup(s
);
1169 len
= strlen(trimmed
);
1170 if(trimmed
[len
- 1] == '\"' && *trimmed
== '\"') {
1175 trimmed
[len
- 1] = 0;
1177 trimmed
= xstrdup(trimmed
);
1187 csv_field_to_item(int *table_base
, size_t table_size
, int field
)
1189 if(field
< table_size
)
1190 return field_id(table_base
[field
]);
1196 csv_store_item(list_item item
, int i
, char *s
)
1198 char *newstr
= NULL
;
1203 if( !(newstr
= csv_remove_quotes(s
)) )
1207 if (item
[i
] != NULL
) {
1208 char *oldstr
= item
[i
];
1210 item
[i
] = strconcat(newstr
, CSV_DUPLICATE_SEPARATOR
,
1223 csv_is_valid_quote_end(char *p
)
1231 else if(!ISSPACE(*p
))
1239 csv_is_valid_quote_start(char *p
)
1244 else if(!ISSPACE(*p
))
1252 csv_parse_line(char *line
, int *table_base
, size_t table_size
)
1256 bool in_quote
= FALSE
;
1259 item
= item_create();
1261 for(p
= start
= line
, field
= 0; *p
; p
++) {
1263 if(csv_is_valid_quote_end(p
))
1266 if ( (((p
- start
) / sizeof (char)) < 2 ) &&
1267 csv_is_valid_quote_start(p
) )
1271 if(*p
== ',' && !in_quote
) {
1273 csv_store_item(item
,
1274 csv_field_to_item(table_base
,table_size
,field
),
1283 csv_store_item(item
, csv_field_to_item(table_base
, table_size
, field
),
1286 csv_convert_emails(item_fget(item
, EMAIL
));
1287 add_item2database(item
);
1292 csv_parse_file_common(FILE *in
, int *conv_table
, size_t table_size
)
1297 line
= getaline(in
);
1299 if(line
&& *line
&& *line
!= CSV_COMMENT_CHAR
)
1300 csv_parse_line(line
, conv_table
, table_size
);
1309 csv_parse_file(FILE *in
)
1311 return csv_parse_file_common(in
, csv_conv_table
,
1312 CSV_TABLE_SIZE(csv_conv_table
));
1316 allcsv_parse_file(FILE *in
)
1318 return csv_parse_file_common(in
, allcsv_conv_table
,
1319 CSV_TABLE_SIZE(allcsv_conv_table
));
1323 palmcsv_parse_file(FILE *in
)
1325 return csv_parse_file_common(in
, palmcsv_conv_table
,
1326 CSV_TABLE_SIZE(palmcsv_conv_table
));
1330 * end of csv import filter
1334 * csv addressbook export filters
1337 #define CSV_LAST (-1)
1338 #define CSV_UNDEFINED (-2)
1339 #define CSV_SPECIAL(X) (-3 - (X))
1340 #define CSV_IS_SPECIAL(X) ((X) <= -3)
1343 csv_export_common(FILE *out
, struct db_enumerator e
,
1344 int fields
[], void (*special_func
)(FILE *, int, int))
1348 db_enumerate_items(e
) {
1349 for(i
= 0; fields
[i
] != CSV_LAST
; i
++) {
1350 if(fields
[i
] == CSV_UNDEFINED
)
1351 fprintf(out
, "\"\"");
1352 else if(CSV_IS_SPECIAL(fields
[i
])) {
1354 (*special_func
)(out
, e
.item
, fields
[i
]);
1357 strchr(safe_str(database[e.item][field_idx(fields[i])]), ',') ||
1358 strchr(safe_str(database[e.item][field_idx(fields[i])]), '\"')) ?
1360 safe_str(database[e.item][field_idx(fields[i])])
1362 fprintf(out
, "\"%s\"",
1363 safe_str(db_fget(e
.item
,fields
[i
])));
1365 if(fields
[i
+ 1] != CSV_LAST
)
1375 csv_export_database(FILE *out
, struct db_enumerator e
)
1377 int csv_export_fields
[] = {
1386 csv_export_common(out
, e
, csv_export_fields
, NULL
);
1392 allcsv_export_database(FILE *out
, struct db_enumerator e
)
1395 * TODO: Should get these atomatically from abook_fileds
1398 int allcsv_export_fields
[] = {
1419 fprintf(out
, "\"NAME\",");
1420 fprintf(out
, "\"EMAIL\",");
1421 fprintf(out
, "\"ADDRESS\",");
1422 fprintf(out
, "\"ADDRESS2\",");
1423 fprintf(out
, "\"CITY\",");
1424 fprintf(out
, "\"STATE\",");
1425 fprintf(out
, "\"ZIP\",");
1426 fprintf(out
, "\"COUNTRY\",");
1427 fprintf(out
, "\"PHONE\",");
1428 fprintf(out
, "\"WORKPHONE\",");
1429 fprintf(out
, "\"FAX\",");
1430 fprintf(out
, "\"MOBILEPHONE\",");
1431 fprintf(out
, "\"NICK\",");
1432 fprintf(out
, "\"URL\",");
1433 fprintf(out
, "\"NOTES\",");
1434 fprintf(out
, "\"ANNIVERSARY\"\n");
1436 csv_export_common(out
, e
, allcsv_export_fields
, NULL
);
1445 #define PALM_CSV_NAME CSV_SPECIAL(0)
1446 #define PALM_CSV_END CSV_SPECIAL(1)
1447 #define PALM_CSV_CAT CSV_SPECIAL(2)
1450 palm_split_and_write_name(FILE *out
, char *name
)
1456 if ( (p
= strchr(name
, ' ')) ) {
1460 fprintf(out
, "\"%s\",\"" , p
+ 1);
1461 fwrite((void *)name
, p
- name
, sizeof(char), out
);
1464 fprintf(out
, "\"%s\"", safe_str(name
));
1469 palm_csv_handle_specials(FILE *out
, int item
, int field
)
1473 palm_split_and_write_name(out
, db_name_get(item
));
1476 fprintf(out
, "\"abook\"");
1479 fprintf(out
, "\"0\"");
1487 palm_export_database(FILE *out
, struct db_enumerator e
)
1489 int palm_export_fields
[] = {
1490 PALM_CSV_NAME
, /* LASTNAME, FIRSTNAME */
1491 CSV_UNDEFINED
, /* TITLE */
1492 CSV_UNDEFINED
, /* COMPANY */
1493 WORKPHONE
, /* WORK PHONE */
1494 PHONE
, /* HOME PHONE */
1496 MOBILEPHONE
, /* OTHER */
1498 ADDRESS
, /* ADDRESS */
1502 COUNTRY
, /* COUNTRY */
1503 NICK
, /* DEFINED 1 */
1504 URL
, /* DEFINED 2 */
1505 CSV_UNDEFINED
, /* DEFINED 3 */
1506 CSV_UNDEFINED
, /* DEFINED 4 */
1508 PALM_CSV_END
, /* "0" */
1509 PALM_CSV_CAT
, /* CATEGORY */
1513 csv_export_common(out
, e
, palm_export_fields
, palm_csv_handle_specials
);
1519 * end of csv export filters
1523 * GnomeCard (VCard) addressbook export filter
1527 gcrd_export_database(FILE *out
, struct db_enumerator e
)
1531 abook_list
*emails
, *em
;
1533 db_enumerate_items(e
) {
1534 fprintf(out
, "BEGIN:VCARD\r\nFN:%s\r\n",
1535 safe_str(db_name_get(e
.item
)));
1537 name
= get_surname(db_name_get(e
.item
));
1538 for( j
= strlen(db_name_get(e
.item
)) - 1; j
>= 0; j
-- ) {
1539 if((db_name_get(e
.item
))[j
] == ' ')
1542 fprintf(out
, "N:%s;%.*s\r\n",
1545 safe_str(db_name_get(e
.item
))
1550 if(db_fget(e
.item
, ADDRESS
))
1551 fprintf(out
, "ADR:;;%s;%s;%s;%s;%s;%s\r\n",
1552 safe_str(db_fget(e
.item
, ADDRESS
)),
1553 safe_str(db_fget(e
.item
, ADDRESS2
)),
1554 safe_str(db_fget(e
.item
, CITY
)),
1555 safe_str(db_fget(e
.item
, STATE
)),
1556 safe_str(db_fget(e
.item
, ZIP
)),
1557 safe_str(db_fget(e
.item
, COUNTRY
))
1560 if(db_fget(e
.item
, PHONE
))
1561 fprintf(out
, "TEL;HOME:%s\r\n",
1562 db_fget(e
.item
, PHONE
));
1563 if(db_fget(e
.item
, WORKPHONE
))
1564 fprintf(out
, "TEL;WORK:%s\r\n",
1565 db_fget(e
.item
, WORKPHONE
));
1566 if(db_fget(e
.item
, FAX
))
1567 fprintf(out
, "TEL;FAX:%s\r\n",
1568 db_fget(e
.item
, FAX
));
1569 if(db_fget(e
.item
, MOBILEPHONE
))
1570 fprintf(out
, "TEL;CELL:%s\r\n",
1571 db_fget(e
.item
, MOBILEPHONE
));
1573 tmp
= db_email_get(e
.item
);
1575 emails
= csv_to_abook_list(tmp
);
1577 for(em
= emails
; em
; em
= em
->next
)
1578 fprintf(out
, "EMAIL;INTERNET:%s\r\n", em
->data
);
1580 abook_list_free(&emails
);
1584 if(db_fget(e
.item
, NOTES
))
1585 fprintf(out
, "NOTE:%s\r\n",
1586 db_fget(e
.item
, NOTES
));
1587 if(db_fget(e
.item
, URL
))
1588 fprintf(out
, "URL:%s\r\n",
1589 db_fget(e
.item
, URL
));
1591 fprintf(out
, "END:VCARD\r\n\r\n");
1599 * end of GnomeCard export filter
1604 * mutt alias export filter
1608 mutt_alias_genalias(int i
)
1612 if(db_fget(i
, NICK
))
1613 return xstrdup(db_fget(i
, NICK
));
1615 tmp
= xstrdup(db_name_get(i
));
1617 if( ( pos
= strchr(tmp
, ' ') ) )
1626 mutt_alias_export(FILE *out
, struct db_enumerator e
)
1628 char email
[MAX_EMAIL_LEN
];
1631 db_enumerate_items(e
) {
1632 alias
= mutt_alias_genalias(e
.item
);
1633 get_first_email(email
, e
.item
);
1634 fprintf(out
, *email
? "alias %s %s <%s>\n": "alias %s %s%s\n",
1636 db_name_get(e
.item
),
1645 * end of mutt alias export filter
1650 * printable export filter
1655 text_write_address_us(FILE *out
, int i
) {
1656 fprintf(out
, "\n%s", db_fget(i
, ADDRESS
));
1658 if(db_fget(i
, ADDRESS2
))
1659 fprintf(out
, "\n%s", db_fget(i
, ADDRESS2
));
1661 if(db_fget(i
, CITY
))
1662 fprintf(out
, "\n%s", db_fget(i
, CITY
));
1664 if(db_fget(i
, STATE
) || db_fget(i
, ZIP
)) {
1667 if(db_fget(i
, STATE
)) {
1668 fprintf(out
, "%s", db_fget(i
, STATE
));
1674 fprintf(out
, "%s", db_fget(i
, ZIP
));
1677 if(db_fget(i
, COUNTRY
))
1678 fprintf(out
, "\n%s", db_fget(i
, COUNTRY
));
1683 text_write_address_uk(FILE *out
, int i
) {
1686 for(j
= ADDRESS
; j
<= COUNTRY
; j
++)
1688 fprintf(out
, "\n%s", db_fget(i
, j
));
1692 text_write_address_eu(FILE *out
, int i
) {
1693 fprintf(out
, "\n%s", db_fget(i
, ADDRESS
));
1695 if(db_fget(i
, ADDRESS2
))
1696 fprintf(out
, "\n%s", db_fget(i
, ADDRESS2
));
1698 if(db_fget(i
, ZIP
) || db_fget(i
, CITY
)) {
1701 if(db_fget(i
, ZIP
)) {
1702 fprintf(out
, "%s", db_fget(i
, ZIP
));
1703 if(db_fget(i
, CITY
))
1707 fprintf(out
, "%s", safe_str(db_fget(i
, CITY
)));
1710 if(db_fget(i
, STATE
))
1711 fprintf(out
, "\n%s", db_fget(i
, STATE
));
1713 if(db_fget(i
, COUNTRY
))
1714 fprintf(out
, "\n%s", db_fget(i
, COUNTRY
));
1718 text_export_database(FILE * out
, struct db_enumerator e
)
1720 abook_list
*emails
, *em
;
1722 char *realname
= get_real_name(), *str
= NULL
, *tmp
;
1723 char *style
= opt_get_str(STR_ADDRESS_STYLE
);
1726 "-----------------------------------------\n%s's address book\n"
1727 "-----------------------------------------\n\n\n",
1731 db_enumerate_items(e
) {
1733 "-----------------------------------------\n\n");
1734 fprintf(out
, "%s", db_name_get(e
.item
));
1735 if(db_fget(e
.item
, NICK
) && *db_fget(e
.item
, NICK
))
1736 fprintf(out
, "\n(%s)", db_fget(e
.item
, NICK
));
1739 tmp
= db_email_get(e
.item
);
1741 emails
= csv_to_abook_list(tmp
);
1744 for(em
= emails
; em
; em
= em
->next
)
1745 fprintf(out
, "%s\n", em
->data
);
1747 abook_list_free(&emails
);
1751 if(db_fget(e
.item
, ADDRESS
)) {
1752 if(!safe_strcmp(style
, "us")) /* US like */
1753 text_write_address_us(out
, e
.item
);
1754 else if(!safe_strcmp(style
, "uk")) /* UK like */
1755 text_write_address_uk(out
, e
.item
);
1757 text_write_address_eu(out
, e
.item
);
1762 if((db_fget(e
.item
, PHONE
)) ||
1763 (db_fget(e
.item
, WORKPHONE
)) ||
1764 (db_fget(e
.item
, FAX
)) ||
1765 (db_fget(e
.item
, MOBILEPHONE
))) {
1767 for(j
= PHONE
; j
<= MOBILEPHONE
; j
++)
1768 if(db_fget(e
.item
, j
)) {
1769 get_field_info(field_id(j
),
1771 fprintf(out
, "%s: %s\n", str
,
1772 db_fget(e
.item
, j
));
1776 if(db_fget(e
.item
, URL
))
1777 fprintf(out
, "\n%s\n", db_fget(e
.item
, URL
));
1778 if(db_fget(e
.item
, NOTES
))
1779 fprintf(out
, "\n%s\n", db_fget(e
.item
, NOTES
));
1784 fprintf(out
, "-----------------------------------------\n");
1790 * end of printable export filter
1794 * elm alias export filter
1798 elm_alias_export(FILE *out
, struct db_enumerator e
)
1800 char email
[MAX_EMAIL_LEN
];
1803 db_enumerate_items(e
) {
1804 alias
= mutt_alias_genalias(e
.item
);
1805 get_first_email(email
, e
.item
);
1806 fprintf(out
, "%s = %s = %s\n",alias
,db_name_get(e
.item
),email
);
1814 * end of elm alias export filter
1819 * Spruce export filter
1823 spruce_export_database (FILE *out
, struct db_enumerator e
)
1825 char email
[MAX_EMAIL_LEN
];
1827 fprintf(out
, "# This is a generated file made by abook for the Spruce e-mail client.\n\n");
1829 db_enumerate_items(e
) {
1830 get_first_email(email
, e
.item
);
1831 if(strcmp(email
, "")) {
1832 fprintf(out
, "# Address %d\nName: %s\nEmail: %s\nMemo: %s\n\n",
1834 db_name_get(e
.item
),
1836 safe_str(db_fget(e
.item
, NOTES
))
1841 fprintf (out
, "# End of address book file.\n");
1847 * end of Spruce export filter
1851 * wanderlust addressbook export filter
1855 wl_export_database(FILE *out
, struct db_enumerator e
)
1857 char email
[MAX_EMAIL_LEN
];
1859 fprintf(out
, "# Wanderlust address book written by %s\n\n", PACKAGE
);
1860 db_enumerate_items(e
) {
1861 get_first_email(email
, e
.item
);
1864 "%s\t\"%s\"\t\"%s\"\n",
1866 safe_str(db_fget(e
.item
, NICK
)),
1867 safe_str(db_name_get(e
.item
))
1872 fprintf (out
, "\n# End of address book file.\n");
1878 * end of wanderlust addressbook export filter
1882 * BSD calendar export filter
1886 bsdcal_export_database(FILE *out
, struct db_enumerator e
)
1888 db_enumerate_items(e
) {
1889 int year
, month
= 0, day
= 0;
1890 char *anniversary
= db_fget(e
.item
, ANNIVERSARY
);
1893 parse_date_string(anniversary
, &day
, &month
, &year
);
1896 _("%02d/%02d\tAnniversary of %s\n"),
1899 safe_str(db_name_get(e
.item
))
1908 * end of BSD calendar export filter