Importing CSV

Old eGW-users
1

Hi there,

I hope that everyone is well?

I am writing as I am having some issues importing into the Egroupware 1.6 Addressbook. I have an Excel spreadsheet with the relevant headings. I then save it as a CSV file and import it. All of my field names however appear together in one row with a comma seperating them in the Addressbook Fieldname. Am I missing something or is there some problem?

Thanks for your help.

Mark

2

I believe that EGW is looking for a semicolon, “;” , as a default field
separator. In the CSV import dialog there is an option to change the
field separator. You could try changing that to a comma, but i know
others have not had much success with the comma. I used the spreadsheet
in Open Office which allows you to select the field separator when
saving to CSV. I just chose semicolon and EGW ate it right up!
Good luck!

Hi there,

I hope that everyone is well?

I am writing as I am having some issues importing into the Egroupware 1.6
Addressbook. I have an Excel spreadsheet with the relevant headings. I
then save it as a CSV file and import it. All of my field names however
appear together in one row with a comma seperating them in the Addressbook
Fieldname. Am I missing something or is there some problem?

Thanks for your help.

Mark

–
View this message in context: http://egroupware.219119.n3.nabble.com/Importing-CSV-tp2693361p2693361.html
Sent from the egroupware-users mailing list archive at Nabble.com.

Colocation vs. Managed Hosting
A question and answer guide to determining the best fit
for your organization - today and in the future.
http://p.sf.net/sfu/internap-sfd2d

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

–
Thomas E. Plancon
CAD/IS Manager

B K A Architects, Inc.
142 Crescent Street
Brockton, MA 02302

tel: 508 . 583 . 5603 ext 313
fax: 508 . 584 . 2914
www.bkaarchitects.com http://www.bkaarchs.com/

3

Thanks Thomas,

That worked like a dream :slight_smile:

Mark

4

Just an FYI

I had an issue importing into the addressbook in 1.8.

I had all the settings correct in the csv, but it happened that I had to log-out then login again to see all the new entries. Then I had to clean out all the duplicates from the extra attempts.

HTH someone.
regards
Ken