Can't import file for phonebook, data no longer displays.
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.
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.
Comments
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?
The context is the "panel context", that are normally not used on single tenant installations (nor supported in freepbx fop2admin). If you set a context, you are actually assigning those entries to a specific panel context/tenant.
The problem with the csv import might be due to the file size? Not sure, but maybe there are limits of execution time or upload size? Did you try with a small csv?
Finally, the phonebook does not support dial prefixes, I might add that as an option in a future release as it has been requested a number of times.
(Still wondering why users/people have such a hard time moving out of dial prefixes needed in old pbx)