This is how they explained it to us to do. BTW the converting from a , to a ; step is incorrect as the phone does not like that at all.
The phone is a Fanvil X3S
1 Like
I would suggest opening the CSV in excel instead of a text editor, and making sure the columns are lined up correctly.
You should be able to save as a CSV, but change the comma to a semi-colon in there as well, but ultimately, it looks to me like the columns aren’t lining up properly. For example, where they have you put in work is essentially an empty column with no data from the sample they provide.
I’m not sure about the work column, but you definitely are going to want their phone number under the mobile column.
1 Like
when i open the csv file in excel it dumps all the data in on cell… so there will be many rows but all the data for each unit will be in one cell…
1 Like
Is that the file that already has the semicolon change?
Usually Excel will ask about the layout of a CSV file when you open it, including the delimiter (comma or semicolon in this case)… Not sure off the top of my head how you can force that dialogue to open…
1 Like
ja…mmmm there was something like that… i clicked dont show this again… ugh ok let me try this on my desktop where i havent screwed up the excel… ok scratch that cant do that because my software is linked on both pc’s ugh
2 Likes
Do you have the option available in your file option for importing legacy text wizard like in this website?
2 Likes
oh ja found that. it looks like this:
it does this now:
but i have never used excel like this…this is way way to much effort for updating the contacts on a phone
1 Like
When you export from Google, can you specify which columns you want? If so, it might be easiest just to download Name, Work and Mobile columns…
1 Like
That’s the first thing that jumped out at me in the “explaination”. What’s with all those empty columns? There must something like 20 ,s between work and mobile,
1 Like
so all the data is saved on google and it is save like this:
So when i download that info as a CSV it adds all this extra info
1 Like
If you can get the CSV you download direct from Google to open in Excel, delete all the columns you don’t need. It’ll help keep things clean and manageable while you work on the changes for the phone system.
1 Like
Google sheets exports the entire sheet to csv, no option to change.
You’d have to create an new sheet with just the items you need.
2 Likes
The way this is set up is way too complicated. Imagine leavng this in the hands of someone who doesnt really know how to work a pc…im not saying i know a lot but i can manage.
There has to be a simpler way to integrate google with this voip phone
1 Like
Anything here that helps?
Don’t understand where all those extra columns are coming from.
2 Likes
I stand corrected…
…but only for a little while:
…but significant risks to the system remain and loadshedding could again be implemented at short notice
2 Likes
Sorry if this doesn’t help: but i know you can change an option in regional date/time settings which works with excel that determines what is used to separate values “, ; .” etc. Don’t know if you want to give that a shot and see if your excel sheet looks better
Currently loadshedging so i can’t snip the correct setting now
1 Like
all the extra commas come from google.
Thanks for the phone manual but this will now necessitate having to update details in 2 places(google contacts and an excel spreadsheet) and this also means that the chances of messing up something in one or both also increases.
The idea we had was to update just the google contacts and then download it and export it to the phone.
in other words wait till the weekend then we turn the power off again
1 Like
Hmm, 05:00 in the morning. This means I don’t have to walk down the stairs when I go to work tomorrow, or when I get back home for that matter.
2 Likes
I could probably automate something like that for you, depending on the phone’s capabilities. But the two on their own are incompatible without some data structure manipulation.