Connect contacts/phonebook Yeastar S50 to FOP2 database

[Victor_Maxx]

Hi Nicolas,
Clear explanation, I will ask them.. What is in your opinion the best (and quickest) way to fill the fop2 phonebook?
Kind regards,
Victor

[nicolas]

Hi,

You have an export/import options in the sandwich menu in the contacts window, you can import a CSV file with a format like this:

firstname,lastname,company,address,email,phone1,phone2
John,Doe,Enron,Some Address,some@email.com,5551234,12345678
Mary,Poppins,Astra Corp,Other Address,other@email.net,12650348,

[Victor_Maxx]

Super.. Thanks, I will give it a try!

[Victor_Maxx]

Hi Nicolas,
I've created an Excel (O365) File with the above fields, but saving it as .csv doesn't work. At the import FOP2 gives a warning that there are no field to import. Do you have an tutorial to create such an .csv from Excel?
Thanks
Victor

[nicolas]

Hi,

I posted a valid example of a file in my first reply, check your csv from excel, verify that separator fields are like the example, if not convert them, add the header on the first line indicating each field, and try again.

[Victor_Maxx]

Hello Nicolas,
The problem was that Excel used ";" as a seperator instead of ",", now the csv file could be imported. Importing them into the 'Contacts' was successfull, 132 records added but none of the imported contacts are shown in the contacts list!

[nicolas]

Do you have the 1st header line as in the example?

[Victor_Maxx]

This is the first line:
firstname,lastname,company,Address,email,Phone1,Phone2,Other Number

[nicolas]

You might want to check if you have entries in the visual_phonebook mysql table, with the command

mysql -u root -p asterisk -e "select count(*) from visual_phonebook"

You need to enter mysql root password to get the result.. does it show 132 records or similar? or zero?

[Victor_Maxx]

This command gives this error:
Error 1049 (42000): Unknown database 'asterisk'

[nicolas]

mysql -u root -p fop2 -e "select count(*) from visual_phonebook"

[Victor_Maxx]

Hello Nicolas,
This is the output from that command:
count(*)
1
This is the user which I entered manually in fop2..
So, it seems that the import didn't succeed regardless of the succesfull import of 132 records (green) message

[nicolas]

Hi,

Can you send me in private your csv file so I can try it myself?

[Victor_Maxx]

Hello Nicolas,
Did you receive the file?
Victor

[Jay]

Hello Nicolas,
How are you?
I'm sorry I have a concern why I cannot login my server http://ipaddress/fop2 with credentials created on FOP2 manager http://ipaddress/fop2/admin, I check database and it's added there. The only way to login is to use the details I added in file /usr/local/fop2/fop2.cfg with format like 123:123:all, I have been struggling for this case for some days but still didn't figure it out, hope you can assist me on this