This morning I purged the visual phonebook data in order to import a new, current phonebook list. There are a few problems now:

1) I can't import a csv file from the fop2 website, I get a "connection was reset" error and can no longer see the buttons for import, export, add, etc.

2) I worked around the import issue by doing an inline import in MySQL from the terminal. Now all my data's in the database, but none of it shows in the phonebook in FOP2.

After the successful back-end import, I can add users and they show up, but not the data that was imported into the MySQL database. When I look in the MySQL database, I can see the latest row I've inserted from the web front-end, and I don't see any differences in data formatting, etc. It inserts the new name at the next available ID# and everything.

I even tried truncating the table again, adding a new record from the web front-end and then importing the data from terminal, the imported data still doesn't show up.

Any ideas?

edit: private is set to "no" for all records.

OK, I guess I can't set a context for these numbers?

I removed the context, but dialing doesn't work, because the numbers need a 9+1 before them in order to dial. Is there some way that I can add that without it showing up in the phonebook?