Re: [evolution-patches] [addressbook] CSV and Tab Importers for addressbook
- From: Devashish <sdevashish novell com>
- To: patches <evolution-patches gnome org>
- Subject: Re: [evolution-patches] [addressbook] CSV and Tab Importers for addressbook
- Date: Fri, 16 Dec 2005 18:02:43 +0530
Hi
Attaching the revised patch with almost all the changes done except for
the locale stuff.
Locale stuff will be handled in the importer plugin itself so that it
can be applied to all the importers.
Thanks
Devashish Sharma
On Thu, 2005-12-15 at 11:44 +0000, Tor Lillqvist wrote:
> Some comments:
> >
> > +#ifdef HAVE_CONFIG_H
> > +#include <config.h>
> > +#endif
>
> I think the ifdef HAVE_CONFIG_H can be dropped around #include
> <config.h>. This code is not going to be built anywhere except inside
> Evolution's source code, so the ifdef is mostly pointless. IMHO.
>
> > +#include <gtk/gtkvbox.h>
>
> In new code, please just #include <gtk/gtk.h>. I don't think there is
> any rational reason to try to hand-pick what gtk headers to include.
>
>
> > +gint importer;
> > +char delimiter;
>
> Make these static. And do these really need to be global variables,
> can't they be fields in some struct?
>
> > + g_string_append_unichar(value, *ptr);
>
> What about the character set? Files that have been exported from Outlook
> are in the system codepage of the exporting machine, presumably. Not
> necessarily CP1252 (ISO-8859-1) which using g_string_append_unichar()
> implies (as the bytes of CP1252 are identical to the first 256 Unicode
> code points). This is actually a rather complicated issue if one also
> wants to be able to import CSV files exported in double-byte codepages
> (in CJK locales). And why not support CJK locales?
>
> What you probably want to to is to have a GUI to select what the charset
> the input file is in, convert each line as it has been read to UTF-8,
> and then scan and parse the line using GLib's UTF-8 functionality. This
> probably is a more generic issue for Evo's import stuff, and should be
> taken care of on a higher level, though. At least the GUI to select the
> charset of the file to be imported?
> that
> As the imported file might originate from Windows, you should look for
> potential CRLF line terminators, too.
>
> > + file = fopen(s->uri_src+7, "r");
>
> For portability, use g_fopen (g_filename_from_uri (s->uri_src, NULL,
> NULL), "r").
>
> > + g_message(G_STRLOC ":Couldn't Create EBook");
>
> Is it really useful to have G_STRLOC in all these messages, if they are
> intended for the end-user?
>
> The functions outlook_csv_import(), mozilla_csv_import() and
> evolution_csv_import() are essentially identical. Refactor please into
> one function with a parameter instead.
>
> --tml
>
Index: addressbook/ChangeLog
===================================================================
RCS file: /cvs/gnome/evolution/addressbook/ChangeLog,v
retrieving revision 1.2018
diff -u -p -r1.2018 ChangeLog
--- addressbook/ChangeLog 15 Dec 2005 08:27:33 -0000 1.2018
+++ addressbook/ChangeLog 15 Dec 2005 10:57:59 -0000
@@ -1,3 +1,8 @@
+2005-12-15 Devashish Sharma <sdevashish novell com>
+
+ * importers/evolution-csv-importer.c : Added support for CSV and TAB
+ file import.
+
2005-12-15 Srinivasa Ragavan <set EMAIL_ADDRESS environment variable>
* gui/search/e-addressbook-search-dialog.c: (dialog_response): Added
Index: addressbook/importers/Makefile.am
===================================================================
RCS file: /cvs/gnome/evolution/addressbook/importers/Makefile.am,v
retrieving revision 1.3
diff -u -p -r1.3 Makefile.am
--- addressbook/importers/Makefile.am 9 Aug 2005 22:40:59 -0000 1.3
+++ addressbook/importers/Makefile.am 15 Dec 2005 10:56:39 -0000
@@ -14,6 +14,7 @@ INCLUDES = \
libevolution_addressbook_importers_la_SOURCES = \
evolution-ldif-importer.c \
evolution-vcard-importer.c \
+ evolution-csv-importer.c \
evolution-addressbook-importers.h
libevolution_addressbook_importers_la_LDFLAGS = $(NO_UNDEFINED)
Index: addressbook/importers/evolution-addressbook-importers.h
===================================================================
RCS file: /cvs/gnome/evolution/addressbook/importers/evolution-addressbook-importers.h,v
retrieving revision 1.2
diff -u -p -r1.2 evolution-addressbook-importers.h
--- addressbook/importers/evolution-addressbook-importers.h 12 Jul 2005 04:04:09 -0000 1.2
+++ addressbook/importers/evolution-addressbook-importers.h 16 Dec 2005 12:36:09 -0000
@@ -1,3 +1,6 @@
struct _EImportImporter *evolution_ldif_importer_peek(void);
struct _EImportImporter *evolution_vcard_importer_peek(void);
+struct _EImportImporter *evolution_csv_outlook_importer_peek(void);
+struct _EImportImporter *evolution_csv_mozilla_importer_peek(void);
+struct _EImportImporter *evolution_csv_evolution_importer_peek(void);
--- /dev/null 2005-03-20 01:06:14.000000000 +0530
+++ addressbook/importers/evolution-csv-importer.c 2005-12-16 17:49:52.000000000 +0530
@@ -0,0 +1,729 @@
+
+#include <config.h>
+#include <stdio.h>
+#include <ctype.h>
+#include <string.h>
+
+#include <glib/gi18n.h>
+#include <glib/gstdio.h>
+
+#include <gtk/gtkvbox.h>
+
+#include <libebook/e-book.h>
+#include <libedataserverui/e-source-selector.h>
+
+#include <libebook/e-destination.h>
+
+#include "e-util/e-import.h"
+
+#include "evolution-addressbook-importers.h"
+
+#define NOMAP -1
+#define EVOLUTION_IMPORTER 3
+#define MOZILLA_IMPORTER 2
+#define OUTLOOK_IMPORTER 1
+#define CSV_FILE_DELIMITER ','
+#define TAB_FILE_DELIMITER '\t'
+
+typedef struct {
+ EImport *import;
+ EImportTarget *target;
+
+ guint idle_id;
+
+ int state;
+ FILE *file;
+ gulong size;
+ gint count;
+
+ EBook *book;
+ GSList *contacts;
+} CSVImporter;
+
+static gint importer;
+static char delimiter;
+
+static void csv_import_done(CSVImporter *gci);
+
+typedef struct {
+ char *csv_attribute;
+ EContactField contact_field;
+#define FLAG_HOME_ADDRESS 0x01
+#define FLAG_WORK_ADDRESS 0x02
+#define FLAG_OTHER_ADDRESS 0x04
+#define FLAG_STREET 0x08
+#define FLAG_CITY 0x10
+#define FLAG_STATE 0x20
+#define FLAG_POSTAL_CODE 0x40
+#define FLAG_COUNTRY 0x80
+#define FLAG_POBOX 0x70
+#define FLAG_DATE_BDAY 0x03
+#define FLAG_BIRTH_DAY 0x05
+#define FLAG_BIRTH_YEAR 0x07
+#define FLAG_BIRTH_MONTH 0x50
+#define FLAG_DATE_ANNIVERSARY 0x30
+#define FLAG_INVALID 0xff
+ int flags;
+}import_fields;
+
+import_fields csv_fields_outlook[] = {
+ {"Title", NOMAP},
+ {"First Name", E_CONTACT_GIVEN_NAME},
+ {"Middle Name", NOMAP},
+ {"Last Name", E_CONTACT_FAMILY_NAME},
+ {"Suffix", NOMAP},
+ {"Company", E_CONTACT_ORG},
+ {"Department", E_CONTACT_ORG_UNIT},
+ {"Job Title", E_CONTACT_TITLE},
+ {"Business Street", NOMAP, FLAG_WORK_ADDRESS|FLAG_STREET },
+ {"Business Street 2", NOMAP, FLAG_WORK_ADDRESS|FLAG_STREET },
+ {"Business Street 3", NOMAP, FLAG_WORK_ADDRESS|FLAG_STREET},
+ {"Business City", NOMAP, FLAG_WORK_ADDRESS|FLAG_CITY},
+ {"Business State", NOMAP, FLAG_WORK_ADDRESS|FLAG_STATE},
+ {"Business Postal Code", NOMAP, FLAG_WORK_ADDRESS|FLAG_POSTAL_CODE},
+ {"Business Country", NOMAP, FLAG_WORK_ADDRESS|FLAG_COUNTRY},
+ {"Home Street", NOMAP, FLAG_HOME_ADDRESS|FLAG_STREET},
+ {"Home Street 2", NOMAP, FLAG_HOME_ADDRESS|FLAG_STREET},
+ {"Home Street 3", NOMAP, FLAG_HOME_ADDRESS|FLAG_STREET},
+ {"Home City", NOMAP, FLAG_HOME_ADDRESS|FLAG_CITY},
+ {"Home State", NOMAP, FLAG_HOME_ADDRESS|FLAG_STATE},
+ {"Home Postal Code", NOMAP,FLAG_HOME_ADDRESS|FLAG_POSTAL_CODE},
+ {"Home Country", NOMAP, FLAG_HOME_ADDRESS|FLAG_COUNTRY},
+ {"Other Street", NOMAP, FLAG_OTHER_ADDRESS|FLAG_STREET},
+ {"Other Street 2", NOMAP, FLAG_OTHER_ADDRESS|FLAG_STREET},
+ {"Other Street 3", NOMAP, FLAG_OTHER_ADDRESS|FLAG_STREET},
+ {"Other City", NOMAP, FLAG_OTHER_ADDRESS|FLAG_CITY},
+ {"Other State", NOMAP, FLAG_OTHER_ADDRESS|FLAG_STATE},
+ {"Other Postal Code", NOMAP, FLAG_OTHER_ADDRESS|FLAG_POSTAL_CODE},
+ {"Other Country", NOMAP, FLAG_OTHER_ADDRESS|FLAG_COUNTRY},
+ {"Assistant's Phone", E_CONTACT_PHONE_ASSISTANT},
+ {"Business Fax", E_CONTACT_PHONE_BUSINESS_FAX},
+ {"Business Phone", E_CONTACT_PHONE_BUSINESS},
+ {"Business Phone 2", E_CONTACT_PHONE_BUSINESS_2},
+ {"Callback", E_CONTACT_PHONE_CALLBACK},
+ {"Car Phone", E_CONTACT_PHONE_CAR},
+ {"Company Main Phone", E_CONTACT_PHONE_COMPANY},
+ {"Home Fax", E_CONTACT_PHONE_HOME_FAX},
+ {"Home Phone", E_CONTACT_PHONE_HOME},
+ {"Home Phone 2", E_CONTACT_PHONE_HOME_2},
+ {"ISDN", E_CONTACT_PHONE_ISDN},
+ {"Mobile Phone", E_CONTACT_PHONE_MOBILE},
+ {"Other Fax", E_CONTACT_PHONE_OTHER_FAX},
+ {"Other Phone", E_CONTACT_PHONE_OTHER},
+ {"Pager", E_CONTACT_PHONE_PAGER},
+ {"Primary Phone", E_CONTACT_PHONE_PRIMARY},
+ {"Radio Phone", E_CONTACT_PHONE_RADIO},
+ {"TTY/TDD Phone", E_CONTACT_PHONE_TTYTDD},
+ {"Telex", E_CONTACT_PHONE_TELEX},
+ {"Account", NOMAP},
+ {"Anniversary", NOMAP, FLAG_DATE_ANNIVERSARY},
+ {"Assistant's Name", E_CONTACT_ASSISTANT},
+ {"Billing Information", NOMAP},
+ {"Birthday", NOMAP, FLAG_DATE_BDAY},
+ {"Business Address PO Box", NOMAP, FLAG_WORK_ADDRESS|FLAG_POBOX},
+ {"Categories", E_CONTACT_CATEGORIES},
+ {"Children", NOMAP},
+ {"Directory Server", NOMAP},
+ {"E-mail Address", E_CONTACT_EMAIL_1},
+ {"E-mail Type", NOMAP},
+ {"E-mail Display Name", NOMAP},
+ {"E-mail 2 Address", E_CONTACT_EMAIL_2},
+ {"E-mail 2 Type", NOMAP},
+ {"E-mail 2 Display Name", NOMAP},
+ {"E-mail 3 Address", E_CONTACT_EMAIL_3},
+ {"E-mail 3 Type", NOMAP},
+ {"E-mail 3 Display Name", NOMAP},
+ {"Gender", NOMAP},
+ {"Government ID Number", NOMAP},
+ {"Hobby", NOMAP},
+ {"Home Address PO Box", NOMAP, FLAG_HOME_ADDRESS|FLAG_POBOX},
+ {"Initials", NOMAP},
+ {"Internet FREE/BUSY", E_CONTACT_FREEBUSY_URL},
+ {"Keywords", NOMAP},
+ {"Language", NOMAP},
+ {"Location", NOMAP},
+ {"Managers Name", E_CONTACT_MANAGER},
+ {"Mileage", NOMAP},
+ {"Notes", NOMAP},
+ {"Office Location", NOMAP},
+ {"Organizational ID Number", NOMAP},
+ {"Other Address PO Box", NOMAP, FLAG_OTHER_ADDRESS|FLAG_POBOX},
+ {"Priority", NOMAP},
+ {"Private", NOMAP},
+ {"Profession", NOMAP},
+ {"Referred By", NOMAP},
+ {"Senstivity", NOMAP},
+ {"Spouse", E_CONTACT_SPOUSE},
+ {"User 1", NOMAP},
+ {"User 2", NOMAP},
+ {"User 3", NOMAP},
+ {"User 4", NOMAP},
+ {"Web Page", E_CONTACT_HOMEPAGE_URL},
+};
+
+import_fields csv_fields_mozilla[] = {
+ {"First Name", E_CONTACT_GIVEN_NAME},
+ {"Last Name", E_CONTACT_FAMILY_NAME},
+ {"Display Name", NOMAP},
+ {"NickName", E_CONTACT_NICKNAME},
+ {"E-mail Address", E_CONTACT_EMAIL_1},
+ {"E-mail 2 Address", E_CONTACT_EMAIL_2},
+ {"Business Phone", E_CONTACT_PHONE_BUSINESS},
+ {"Home Phone", E_CONTACT_PHONE_HOME},
+ {"Business Fax", E_CONTACT_PHONE_BUSINESS_FAX},
+ {"Pager", E_CONTACT_PHONE_PAGER},
+ {"Mobile Phone", E_CONTACT_PHONE_MOBILE},
+ {"Home Street", NOMAP, FLAG_HOME_ADDRESS|FLAG_STREET},
+ {"Home Street 2", NOMAP, FLAG_HOME_ADDRESS|FLAG_STREET},
+ {"Home City", NOMAP, FLAG_HOME_ADDRESS|FLAG_CITY},
+ {"Home State", NOMAP, FLAG_HOME_ADDRESS|FLAG_STATE},
+ {"Home Postal Code", NOMAP,FLAG_HOME_ADDRESS|FLAG_POSTAL_CODE},
+ {"Home Country", NOMAP, FLAG_HOME_ADDRESS|FLAG_COUNTRY},
+ {"Business Street", NOMAP, FLAG_WORK_ADDRESS|FLAG_STREET },
+ {"Business Street 2", NOMAP, FLAG_WORK_ADDRESS|FLAG_STREET },
+ {"Business City", NOMAP, FLAG_WORK_ADDRESS|FLAG_CITY},
+ {"Business State", NOMAP, FLAG_WORK_ADDRESS|FLAG_STATE},
+ {"Business Postal Code", NOMAP, FLAG_WORK_ADDRESS|FLAG_POSTAL_CODE},
+ {"Business Country", NOMAP, FLAG_WORK_ADDRESS|FLAG_COUNTRY},
+ {"Job Title", E_CONTACT_TITLE},
+ {"Department", E_CONTACT_ORG_UNIT},
+ {"Company", E_CONTACT_ORG},
+ {"Web Page", E_CONTACT_HOMEPAGE_URL},
+ {"Home Web Page", NOMAP},
+ {"Birth Year", NOMAP, FLAG_BIRTH_YEAR},
+ {"Birth Month", NOMAP,FLAG_BIRTH_MONTH},
+ {"Birth Day", NOMAP, FLAG_BIRTH_DAY},
+ {"Custom 1", NOMAP},
+ {"Custom 2", NOMAP},
+ {"Custom 3", NOMAP},
+ {"Custom 4", NOMAP},
+ {"Notes", NOMAP},
+
+
+};
+
+import_fields csv_fields_evolution[] = {
+ {"First Name", E_CONTACT_GIVEN_NAME},
+ {"Last Name", E_CONTACT_FAMILY_NAME},
+ {"id", NOMAP, FLAG_INVALID},
+ {"NickName", E_CONTACT_NICKNAME},
+ {"E-mail Address", E_CONTACT_EMAIL_1},
+ {"E-mail 2 Address", E_CONTACT_EMAIL_2},
+ {"E-mail 3 Address", E_CONTACT_EMAIL_3},
+ {"E-mail 4 Address", E_CONTACT_EMAIL_4},
+ {"Wants HTML", E_CONTACT_WANTS_HTML},
+ {"Business Phone", E_CONTACT_PHONE_BUSINESS},
+ {"Home Phone", E_CONTACT_PHONE_HOME},
+ {"Business Fax", E_CONTACT_PHONE_BUSINESS_FAX},
+ {"Pager", E_CONTACT_PHONE_PAGER},
+ {"Mobile Phone", E_CONTACT_PHONE_MOBILE},
+ {"Home Street", NOMAP, FLAG_HOME_ADDRESS|FLAG_STREET},
+ {"Home Street 2", NOMAP, FLAG_INVALID},
+ {"Home City", NOMAP, FLAG_HOME_ADDRESS|FLAG_CITY},
+ {"Home State", NOMAP, FLAG_HOME_ADDRESS|FLAG_STATE},
+ {"Home Postal Code", NOMAP,FLAG_HOME_ADDRESS|FLAG_POSTAL_CODE},
+ {"Home Country", NOMAP, FLAG_HOME_ADDRESS|FLAG_COUNTRY},
+ {"Business Street", NOMAP, FLAG_WORK_ADDRESS|FLAG_STREET },
+ {"Business Street 2", NOMAP, FLAG_INVALID },
+ {"Business City", NOMAP, FLAG_WORK_ADDRESS|FLAG_CITY},
+ {"Business State", NOMAP, FLAG_WORK_ADDRESS|FLAG_STATE},
+ {"Business Postal Code", NOMAP, FLAG_WORK_ADDRESS|FLAG_POSTAL_CODE},
+ {"Business Country", NOMAP, FLAG_WORK_ADDRESS|FLAG_COUNTRY},
+ {"Job Title", E_CONTACT_TITLE},
+ {"Office", E_CONTACT_OFFICE},
+ {"Company", E_CONTACT_ORG},
+ {"Web Page", E_CONTACT_HOMEPAGE_URL},
+ {"Cal uri", E_CONTACT_CALENDAR_URI},
+ {"Birth Year", NOMAP, FLAG_BIRTH_YEAR},
+ {"Birth Month", NOMAP,FLAG_BIRTH_MONTH},
+ {"Birth Day", NOMAP, FLAG_BIRTH_DAY},
+ {"Notes", E_CONTACT_NOTE},
+};
+
+static void
+add_to_notes(EContact *contact, gint i, char *val) {
+ const gchar *old_text;
+ const gchar *field_text = NULL;
+ GString *new_text;
+
+ old_text = e_contact_get_const(contact, E_CONTACT_NOTE);
+ if(importer == OUTLOOK_IMPORTER)
+ field_text = csv_fields_outlook[i].csv_attribute;
+ else if(importer == MOZILLA_IMPORTER)
+ field_text = csv_fields_mozilla[i].csv_attribute;
+ else
+ field_text = csv_fields_evolution[i].csv_attribute;
+
+ new_text = g_string_new(old_text);
+ if(strlen(new_text->str) != 0)
+ new_text = g_string_append_c(new_text, '\n');
+ new_text = g_string_append(new_text, field_text);
+ new_text = g_string_append_c(new_text, ':');
+ new_text = g_string_append(new_text, val);
+
+ e_contact_set(contact, E_CONTACT_NOTE, new_text->str);
+ g_string_free(new_text, TRUE);
+}
+
+static gboolean
+parseLine (CSVImporter *gci, EContact *contact, char **buf) {
+
+ char *ptr = *buf;
+ GString *value;
+ gint i = 0;
+ int flags = 0;
+ int contact_field;
+ EContactAddress *home_address = NULL, *work_address = NULL, *other_address = NULL;
+ EContactDate *bday = NULL;
+ GString *home_street, *work_street, *other_street;
+ home_street = g_string_new("");
+ work_street = g_string_new("");
+ other_street = g_string_new("");
+ home_address = g_new0(EContactAddress, 1);
+ work_address = g_new0(EContactAddress, 1);
+ other_address = g_new0(EContactAddress, 1);
+ bday = g_new0(EContactDate, 1);
+
+ while(*ptr != '\n') {
+ value = g_string_new("");
+ while(*ptr != delimiter) {
+ if(*ptr == '\n')
+ break;
+ if(*ptr != '"') {
+ g_string_append_unichar(value, *ptr);
+ }
+ ptr++;
+ }
+ if(importer == OUTLOOK_IMPORTER) {
+ contact_field = csv_fields_outlook[i].contact_field;
+ flags = csv_fields_outlook[i].flags;
+ }
+ else if(importer == MOZILLA_IMPORTER) {
+ contact_field = csv_fields_mozilla[i].contact_field;
+ flags = csv_fields_mozilla[i].flags;
+ }
+ else {
+ contact_field = csv_fields_evolution[i].contact_field;
+ flags = csv_fields_evolution[i].flags;
+ }
+
+ if(strlen(value->str) != 0) {
+ if (contact_field != NOMAP) {
+ if(importer == OUTLOOK_IMPORTER)
+ e_contact_set(contact, csv_fields_outlook[i].contact_field, value->str);
+ else if(importer == MOZILLA_IMPORTER)
+ e_contact_set(contact, csv_fields_mozilla[i].contact_field, value->str);
+ else
+ e_contact_set(contact, csv_fields_evolution[i].contact_field, value->str);
+ }
+ else {
+ switch (flags) {
+
+ case FLAG_HOME_ADDRESS|FLAG_STREET:
+ if(strlen(home_street->str) != 0) {
+ home_street = g_string_append(home_street, ",\n");
+ }
+ home_street = g_string_append(home_street, value->str);
+ break;
+ case FLAG_HOME_ADDRESS|FLAG_CITY:
+ home_address->locality = g_strdup(value->str);
+ break;
+ case FLAG_HOME_ADDRESS|FLAG_STATE:
+ home_address->region = g_strdup(value->str);
+ break;
+ case FLAG_HOME_ADDRESS|FLAG_POSTAL_CODE:
+ home_address->code = g_strdup(value->str);
+ break;
+ case FLAG_HOME_ADDRESS|FLAG_POBOX:
+ home_address->po = g_strdup(value->str);
+ break;
+ case FLAG_HOME_ADDRESS|FLAG_COUNTRY:
+ home_address->country = g_strdup(value->str);
+ break;
+
+ case FLAG_WORK_ADDRESS|FLAG_STREET:
+ if(strlen(work_street->str) != 0) {
+ work_street = g_string_append(work_street, ",\n");
+ }
+ work_street = g_string_append(work_street, value->str);
+ break;
+ case FLAG_WORK_ADDRESS|FLAG_CITY:
+ work_address->locality = g_strdup(value->str);
+ break;
+ case FLAG_WORK_ADDRESS|FLAG_STATE:
+ work_address->region = g_strdup(value->str);
+ break;
+ case FLAG_WORK_ADDRESS|FLAG_POSTAL_CODE:
+ work_address->code = g_strdup(value->str);
+ break;
+ case FLAG_WORK_ADDRESS|FLAG_POBOX:
+ work_address->po = g_strdup(value->str);
+ break;
+ case FLAG_WORK_ADDRESS|FLAG_COUNTRY:
+ work_address->country = g_strdup(value->str);
+ break;
+
+ case FLAG_OTHER_ADDRESS|FLAG_STREET:
+ if(strlen(other_street->str) != 0) {
+ other_street = g_string_append(other_street, ",\n");
+ }
+ other_street = g_string_append(other_street, value->str);
+ break;
+ case FLAG_OTHER_ADDRESS|FLAG_CITY:
+ other_address->locality = g_strdup(value->str);
+ break;
+ case FLAG_OTHER_ADDRESS|FLAG_STATE:
+ other_address->region = g_strdup(value->str);
+ break;
+ case FLAG_OTHER_ADDRESS|FLAG_POSTAL_CODE:
+ other_address->code = g_strdup(value->str);
+ break;
+ case FLAG_OTHER_ADDRESS|FLAG_COUNTRY:
+ other_address->country = g_strdup(value->str);
+ break;
+
+ case FLAG_DATE_BDAY:
+ e_contact_set(contact, E_CONTACT_BIRTH_DATE, e_contact_date_from_string(value->str));
+ break;
+
+ case FLAG_DATE_ANNIVERSARY:
+ e_contact_set(contact, E_CONTACT_ANNIVERSARY, e_contact_date_from_string(value->str));
+ break;
+
+ case FLAG_BIRTH_DAY:
+ bday->day = atoi(value->str);
+ break;
+ case FLAG_BIRTH_YEAR:
+ bday->year = atoi(value->str);
+ break;
+ case FLAG_BIRTH_MONTH:
+ bday->month = atoi(value->str);
+ break;
+
+ case FLAG_INVALID:
+ break;
+
+ default:
+ add_to_notes(contact, i, value->str);
+
+ }
+ }
+ }
+ i++;
+ g_string_free(value, TRUE);
+ if(*ptr != '\n')
+ ptr++;
+ }
+ if(strlen(home_street->str) != 0)
+ home_address->street = g_strdup(home_street->str);
+ if(strlen(work_street->str) != 0)
+ work_address->street = g_strdup(work_street->str);
+ if(strlen(other_street->str) != 0)
+ other_address->street = g_strdup(other_street->str);
+ g_string_free(home_street, TRUE);
+ g_string_free(work_street, TRUE);
+ g_string_free(other_street, TRUE);
+
+ if(home_address->locality || home_address->country ||
+ home_address->code || home_address->region || home_address->street)
+ e_contact_set (contact, E_CONTACT_ADDRESS_HOME, home_address);
+ if(work_address->locality || work_address->country ||
+ work_address->code || work_address->region || work_address->street)
+ e_contact_set (contact, E_CONTACT_ADDRESS_WORK, work_address);
+ if(other_address->locality || other_address->country ||
+ other_address->code || other_address->region || other_address->street)
+ e_contact_set (contact, E_CONTACT_ADDRESS_OTHER, other_address);
+
+ if(importer != OUTLOOK_IMPORTER) {
+ if (bday->day || bday->year || bday->month)
+ e_contact_set(contact, E_CONTACT_BIRTH_DATE, bday);
+ }
+
+ return TRUE;
+}
+
+static EContact *
+getNextCSVEntry(CSVImporter *gci, FILE *f) {
+ EContact *contact = NULL;
+ char line[2048];
+ GString *str;
+ char *buf;
+
+ str = g_string_new("");
+ if(!fgets(line, sizeof(line),f)) {
+ g_string_free(str, TRUE);
+ break;
+ }
+
+ if(gci->count == 0 && importer != MOZILLA_IMPORTER) {
+ if(!fgets(line, sizeof(line),f)) {
+ g_string_free(str, TRUE);
+ break;
+ }
+ gci->count ++;
+ }
+
+ str = g_string_append (str, line);
+
+ if(strlen(str->str) == 0) {
+ g_string_free(str, TRUE);
+ return NULL;
+ }
+
+ contact = e_contact_new();
+
+ buf = str->str;
+
+ if(!parseLine (gci, contact, &buf)) {
+ g_object_unref(contact);
+ return NULL;
+ }
+ gci->count++;
+
+ g_string_free(str, TRUE);
+
+ return contact;
+}
+
+static gboolean
+csv_import_contacts(void *d) {
+ CSVImporter *gci = d;
+ EContact *contact = NULL;
+
+ while ((contact = getNextCSVEntry(gci, gci->file))) {
+ e_book_add_contact(gci->book, contact, NULL);
+ gci->contacts = g_slist_prepend(gci->contacts, contact);
+ }
+ if(contact == NULL) {
+ gci->state = 1;
+ }
+ if(gci->state == 1) {
+ csv_import_done(gci);
+ return FALSE;
+ }
+ else {
+ e_import_status(gci->import, gci->target, _("Importing..."), ftell(gci->file) *100 / gci->size);
+ return TRUE;
+ }
+}
+
+static void
+primary_selection_changed_cb (ESourceSelector *selector, EImportTarget *target)
+{
+ g_datalist_set_data_full(&target->data, "csv-source",
+ g_object_ref(e_source_selector_peek_primary_selection(selector)),
+ g_object_unref);
+}
+
+static GtkWidget *
+csv_getwidget(EImport *ei, EImportTarget *target, EImportImporter *im)
+{
+ GtkWidget *vbox, *selector;
+ ESource *primary;
+ ESourceList *source_list;
+
+ /* FIXME Better error handling */
+ if (!e_book_get_addressbooks (&source_list, NULL))
+ return NULL;
+
+ vbox = gtk_vbox_new (FALSE, FALSE);
+
+ selector = e_source_selector_new (source_list);
+ e_source_selector_show_selection (E_SOURCE_SELECTOR (selector), FALSE);
+ gtk_box_pack_start (GTK_BOX (vbox), selector, FALSE, TRUE, 6);
+
+ primary = g_datalist_get_data(&target->data, "csv-source");
+ if (primary == NULL) {
+ primary = e_source_list_peek_source_any (source_list);
+ g_object_ref(primary);
+ g_datalist_set_data_full(&target->data, "csv-source", primary, g_object_unref);
+ }
+ e_source_selector_set_primary_selection (E_SOURCE_SELECTOR (selector), primary);
+ g_object_unref (source_list);
+
+ g_signal_connect (selector, "primary_selection_changed", G_CALLBACK (primary_selection_changed_cb), target);
+
+ gtk_widget_show_all (vbox);
+
+ return vbox;
+}
+
+static char *supported_extensions[4] = {
+ ".csv", ".tab" , ".txt", NULL
+};
+
+static gboolean
+csv_supported(EImport *ei, EImportTarget *target, EImportImporter *im)
+{
+ char *ext;
+ int i;
+ EImportTargetURI *s;
+
+ if (target->type != E_IMPORT_TARGET_URI)
+ return FALSE;
+
+ s = (EImportTargetURI *)target;
+ if (s->uri_src == NULL)
+ return TRUE;
+
+ if (strncmp(s->uri_src, "file:///", 8) != 0)
+ return FALSE;
+
+ ext = strrchr(s->uri_src, '.');
+ if (ext == NULL)
+ return FALSE;
+
+ for (i = 0; supported_extensions[i] != NULL; i++) {
+ if (g_ascii_strcasecmp(supported_extensions[i], ext) == 0) {
+ if (i == 0) {
+ delimiter = CSV_FILE_DELIMITER;
+ }
+ else {
+ delimiter = TAB_FILE_DELIMITER;
+ }
+ return TRUE;
+ }
+ }
+
+ return FALSE;
+}
+
+static void
+csv_import_done(CSVImporter *gci)
+{
+ if (gci->idle_id)
+ g_source_remove(gci->idle_id);
+
+ fclose (gci->file);
+ g_object_unref(gci->book);
+ g_slist_foreach(gci->contacts, (GFunc) g_object_unref, NULL);
+ g_slist_free(gci->contacts);
+
+ e_import_complete(gci->import, gci->target);
+ g_object_unref(gci->import);
+
+ g_free (gci);
+}
+
+static void
+csv_import (EImport *ei, EImportTarget *target, EImportImporter *im)
+{
+ CSVImporter *gci;
+ EBook *book;
+ FILE *file;
+ EImportTargetURI *s = (EImportTargetURI *) target;
+
+ book = e_book_new(g_datalist_get_data(&target->data, "csv-source"), NULL);
+ if(book == NULL) {
+ g_message("Couldn't Create EBook");
+ e_import_complete(ei, target);
+ return;
+ }
+
+ file = g_fopen (g_filename_from_uri(s->uri_src, NULL, NULL), "r");
+ if (file == NULL) {
+ g_message("Can't open .csv file");
+ e_import_complete(ei, target);
+ g_object_unref(book);
+ return;
+ }
+
+ gci = g_malloc0(sizeof(*gci));
+ g_datalist_set_data(&target->data, "csv-data", gci);
+ gci->import = g_object_ref(ei);
+ gci->target = target;
+ gci->book = book;
+ gci->file = file;
+ gci->count = 0;
+ fseek(file, 0, SEEK_END);
+ gci->size = ftell(file);
+ fseek(file, 0, SEEK_SET);
+
+ e_book_open(gci->book, TRUE, NULL);
+
+ gci->idle_id = g_idle_add (csv_import_contacts, gci);
+}
+
+static void
+outlook_csv_import(EImport *ei, EImportTarget *target, EImportImporter *im)
+{
+ importer = OUTLOOK_IMPORTER;
+ csv_import(ei, target, im);
+}
+
+static void
+mozilla_csv_import(EImport *ei, EImportTarget *target, EImportImporter *im)
+{
+ importer = MOZILLA_IMPORTER;
+ csv_import(ei, target, im);
+}
+
+static void
+evolution_csv_import(EImport *ei, EImportTarget *target, EImportImporter *im)
+{
+ importer = EVOLUTION_IMPORTER;
+ csv_import(ei, target, im);
+}
+
+static void
+csv_cancel(EImport *ei, EImportTarget *target, EImportImporter *im) {
+ CSVImporter *gci = g_datalist_get_data(&target->data, "csv-data");
+
+ if(gci)
+ gci->state = 1;
+}
+
+
+static EImportImporter csv_outlook_importer = {
+ E_IMPORT_TARGET_URI,
+ 0,
+ csv_supported,
+ csv_getwidget,
+ outlook_csv_import,
+ csv_cancel,
+};
+
+static EImportImporter csv_mozilla_importer = {
+ E_IMPORT_TARGET_URI,
+ 0,
+ csv_supported,
+ csv_getwidget,
+ mozilla_csv_import,
+ csv_cancel,
+};
+
+static EImportImporter csv_evolution_importer = {
+ E_IMPORT_TARGET_URI,
+ 0,
+ csv_supported,
+ csv_getwidget,
+ evolution_csv_import,
+ csv_cancel,
+};
+
+EImportImporter *
+evolution_csv_outlook_importer_peek(void)
+{
+ csv_outlook_importer.name = _("Outlook CSV or Tab (.csv, .tab)");
+ csv_outlook_importer.description = _("Outlook CSV and Tab Importer");
+
+ return &csv_outlook_importer;
+}
+
+EImportImporter *
+evolution_csv_mozilla_importer_peek(void)
+{
+ csv_mozilla_importer.name = _("Mozilla CSV or Tab (.csv, .tab)");
+ csv_mozilla_importer.description = _("Mozilla CSV and Tab Importer");
+
+ return &csv_mozilla_importer;
+}
+
+EImportImporter *
+evolution_csv_evolution_importer_peek(void)
+{
+ csv_evolution_importer.name = _("Evolution CSV or Tab (.csv, .tab)");
+ csv_evolution_importer.description = _("Evolution CSV and Tab Importer");
+
+ return &csv_evolution_importer;
+}
Index: addressbook/gui/component/addressbook-component.c
===================================================================
RCS file: /cvs/gnome/evolution/addressbook/gui/component/addressbook-component.c,v
retrieving revision 1.140
diff -u -p -r1.140 addressbook-component.c
--- addressbook/gui/component/addressbook-component.c 25 Nov 2005 13:09:37 -0000 1.140
+++ addressbook/gui/component/addressbook-component.c 12 Dec 2005 14:18:01 -0000
@@ -483,6 +483,9 @@ addressbook_component_init (AddressbookC
klass = g_type_class_ref(e_import_get_type());
e_import_class_add_importer(klass, evolution_ldif_importer_peek(), NULL, NULL);
e_import_class_add_importer(klass, evolution_vcard_importer_peek(), NULL, NULL);
+ e_import_class_add_importer(klass, evolution_csv_outlook_importer_peek(), NULL, NULL);
+ e_import_class_add_importer(klass, evolution_csv_mozilla_importer_peek(), NULL, NULL);
+ e_import_class_add_importer(klass, evolution_csv_evolution_importer_peek(), NULL, NULL);
}
}
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]
