BLFs not being imported from csv

[Milos Boksan]

Hey all

I've created a csv file where I generated info for all user extensions. When I try to import, everything imports correctly, except the BLFs. All BLFs remain empty.

Here is a single line to show the format from the csv that I am using:

"<PhoneDevice><BLFS><BLF ID=""-1"" BLFNo=""1"" BLFType=""BLF"" BLFTypeID=""0"">203</BLF><BLF ID=""-1"" BLFNo=""2"" BLFType=""BLF"" BLFTypeID=""0"">205</BLF><BLF ID=""-1"" BLFNo=""3"" BLFType=""BLF"" BLFTypeID=""0"">202</BLF><BLF ID=""-1"" BLFNo=""4"" BLFType=""BLF"" BLFTypeID=""0"">214</BLF><BLF ID=""-1"" BLFNo=""6"" BLFType=""BLF"" BLFTypeID=""0"">201</BLF><BLF ID=""-1"" BLFNo=""7"" BLFType=""BLF"" BLFTypeID=""0"">204</BLF><BLF ID=""-1"" BLFNo=""8"" BLFType=""BLF"" BLFTypeID=""0"">219</BLF><BLF ID=""-1"" BLFNo=""9"" BLFType=""BLF"" BLFTypeID=""0"">208</BLF><BLF ID=""-1"" BLFNo=""10"" BLFType=""BLF"" BLFTypeID=""0"">216</BLF><BLF ID=""-1"" BLFNo=""11"" BLFType=""BLF"" BLFTypeID=""0"">207</BLF><BLF ID=""-1"" BLFNo=""12"" BLFType=""BLF"" BLFTypeID=""0"">206</BLF><BLF ID=""-1"" BLFNo=""13"" BLFType=""BLF"" BLFTypeID=""0"">210</BLF><BLF ID=""-1"" BLFNo=""14"" BLFType=""BLF"" BLFTypeID=""0"">209</BLF></BLFS></PhoneDevice>"

If I were to isolate one BLF entry here it is

<BLF ID=""-1"" BLFNo=""1"" BLFType=""BLF"" BLFTypeID=""0"">203</BLF>

I found this page:
https://www.3cx.com/docs/bulk-extension-import/
and judging from the instructions there this seems to be correct.

The row before the BLF in my CSV is "GoogleCalendarDisabled" and the rows after the BLF are AI related rows.

Can anyone suggest why this isnt working?
I have 50 extensions with a lot of BLFs to import (15 BLFs each, minimum) and I would prefer not to do it by hand.

Any input is appreciated.
Thanks

 

[Alphabetic]

Are you editing with Excel by any chance?

remove the double quotations, save as csv and try again

 

[Alphabetic]

<PhoneDevice><BLFS><BLF ID="-1" BLFNo="1" BLFType="BLF" BLFTypeID="0">203</BLF><BLF ID="-1" BLFNo="2" BLFType="BLF" BLFTypeID="0">205</BLF><BLF ID="-1" BLFNo="3" BLFType="BLF" BLFTypeID="0">202</BLF><BLF ID="-1" BLFNo="4" BLFType="BLF" BLFTypeID="0">214</BLF><BLF ID="-1" BLFNo="6" BLFType="BLF" BLFTypeID="0">201</BLF><BLF ID="-1" BLFNo="7" BLFType="BLF" BLFTypeID="0">204</BLF><BLF ID="-1" BLFNo="8" BLFType="BLF" BLFTypeID="0">219</BLF><BLF ID="-1" BLFNo="9" BLFType="BLF" BLFTypeID="0">208</BLF><BLF ID="-1" BLFNo="10" BLFType="BLF" BLFTypeID="0">216</BLF><BLF ID="-1" BLFNo="11" BLFType="BLF" BLFTypeID="0">207</BLF><BLF ID="-1" BLFNo="12" BLFType="BLF" BLFTypeID="0">206</BLF><BLF ID="-1" BLFNo="13" BLFType="BLF" BLFTypeID="0">210</BLF><BLF ID="-1" BLFNo="14" BLFType="BLF" BLFTypeID="0">209</BLF></BLFS></PhoneDevice>

 

[Milos Boksan]

I tried that. Excel formats the csv itself. When I remove the double quotations the 3CX reports an invalid csv formatting.

If you go to the link I provided in my original post, you can see how the format is explained:

 

[NikosT_3CX]

@Milos Boksan as I can see it in the end you are missing 2 comma.

/PhoneDevice>",,

Go to an extension on the PBX, setup some BLFs and export the extension.
You will see the exact formar there for multiple BLFs.
Something like this :


<BLFS>
<BLF ID=""-1"
" BLFNo=""1"" BLFType=""Line"" BLFTypeID=""6"" /><BLF ID=""-1"
" BLFNo=""2"" BLFType=""CustomSpeedDial"" BLFTypeID=""2"">*700*102#Conference102</BLF><BLF ID=""890"
" BLFNo=""3"" BLFType=""SharedParking"" BLFTypeID=""3"">SP1</BLF><BLF ID=""908"
" BLFNo=""4"" BLFType=""BLF"" BLFTypeID=""0"">102</BLF><BLF ID=""908"
" BLFNo=""5"" BLFType=""BLF"" BLFTypeID=""0"">102</BLF><BLF ID=""1149"
" BLFNo=""6"" BLFType=""BLF"" BLFTypeID=""0"">150</BLF><BLF ID=""967"
" BLFNo=""7"" BLFType=""BLF"" BLFTypeID=""0"">127</BLF><BLF ID=""932"
" BLFNo=""8"" BLFType=""BLF"" BLFTypeID=""0"">105</BLF>
</BLFS></PhoneDevice>",,

 

[Milos Boksan]

Dear NikosT,

I did not include the commas in the snippet, I just included the single row that describes the BLFs.
Here is an entire row with all the commas for reference copied directly from the .csv file - NOT from excel (I added newlines after each comma for readability, also redacted personal information):

200,
FIRSTNAME,
,
[email protected],
,
,
,
"<role name=""users""> <canSeeGroupMembers>true</canSeeGroupMembers></role>",
DEPARTMENT,
0,
0,
,
0000111122223333,
yealinkT4x.ph.xml,
Yealink T42S,
,
English,
Ring 1,
Ring 6,
"<PhoneDevice ProvType=""0"" Secret="""" PhoneLanguage=""English"" XferType=""BXfer"" RingTone=""Ring 1"" QueueRingTone=""Ring 6"" DateFormat=""WWW MMM DD (Mon Jan 15)"" TimeFormat=""24-hour clock""><CustomQueueRingTones /><mcgroups enabled=""false"" /><DynamicOptions /><LldpOptions /><CodecsPriority><Codec Priority=""1"" PriorityVarName=""codec1"" DisplayText=""PCMU"" PayloadTypeName=""payload1"" payload=""PCMU"">0</Codec><Codec Priority=""2"" PriorityVarName=""codec2"" DisplayText=""PCMA"" PayloadTypeName=""payload2"" payload=""PCMA"">8</Codec><Codec Priority=""3"" PriorityVarName=""codec3"" DisplayText=""G722"" PayloadTypeName=""payload3"" payload=""G722"">9</Codec><Codec Priority=""4"" PriorityVarName=""codec4"" DisplayText=""G729"" PayloadTypeName=""payload4"" payload=""G729"">18</Codec></CodecsPriority><BLFS /></PhoneDevice>",
1,
8210986B-9412-497f-AD77-3A554F4A9BDB,
0,
894106,
1,
1,
0,
0,
0,
0,
0,
1,
0,
0,
0,
0,
0,
0,
0,
60,
,
1,
,
0,
0,
0,
0,
1,
1,
1,
1,
1,
1,
1,
"<PhoneDevice><BLFS><BLF ID=""-1"" BLFNo=""1"" BLFType=""BLF"" BLFTypeID=""0"">203</BLF><BLF ID=""-1"" BLFNo=""2"" BLFType=""BLF"" BLFTypeID=""0"">205</BLF><BLF ID=""-1"" BLFNo=""3"" BLFType=""BLF"" BLFTypeID=""0"">202</BLF><BLF ID=""-1"" BLFNo=""4"" BLFType=""BLF"" BLFTypeID=""0"">214</BLF><BLF ID=""-1"" BLFNo=""6"" BLFType=""BLF"" BLFTypeID=""0"">201</BLF><BLF ID=""-1"" BLFNo=""7"" BLFType=""BLF"" BLFTypeID=""0"">204</BLF><BLF ID=""-1"" BLFNo=""8"" BLFType=""BLF"" BLFTypeID=""0"">219</BLF><BLF ID=""-1"" BLFNo=""9"" BLFType=""BLF"" BLFTypeID=""0"">208</BLF><BLF ID=""-1"" BLFNo=""10"" BLFType=""BLF"" BLFTypeID=""0"">216</BLF><BLF ID=""-1"" BLFNo=""11"" BLFType=""BLF"" BLFTypeID=""0"">207</BLF><BLF ID=""-1"" BLFNo=""12"" BLFType=""BLF"" BLFTypeID=""0"">206</BLF><BLF ID=""-1"" BLFNo=""13"" BLFType=""BLF"" BLFTypeID=""0"">210</BLF><BLF ID=""-1"" BLFNo=""14"" BLFType=""BLF"" BLFTypeID=""0"">209</BLF></BLFS></PhoneDevice>",
,

Now If I just extract the part about the BLFs we get this (Also put newlines in between all tags for readability);

"<PhoneDevice>
<BLFS>
<BLF ID=""-1"" BLFNo=""1"" BLFType=""BLF"" BLFTypeID=""0"">203</BLF>
<BLF ID=""-1"" BLFNo=""2"" BLFType=""BLF"" BLFTypeID=""0"">205</BLF>
<BLF ID=""-1"" BLFNo=""3"" BLFType=""BLF"" BLFTypeID=""0"">202</BLF>
<BLF ID=""-1"" BLFNo=""4"" BLFType=""BLF"" BLFTypeID=""0"">214</BLF>
<BLF ID=""-1"" BLFNo=""6"" BLFType=""BLF"" BLFTypeID=""0"">201</BLF>
<BLF ID=""-1"" BLFNo=""7"" BLFType=""BLF"" BLFTypeID=""0"">204</BLF>
<BLF ID=""-1"" BLFNo=""8"" BLFType=""BLF"" BLFTypeID=""0"">219</BLF>
<BLF ID=""-1"" BLFNo=""9"" BLFType=""BLF"" BLFTypeID=""0"">208</BLF>
<BLF ID=""-1"" BLFNo=""10"" BLFType=""BLF"" BLFTypeID=""0"">216</BLF>
<BLF ID=""-1"" BLFNo=""11"" BLFType=""BLF"" BLFTypeID=""0"">207</BLF>
<BLF ID=""-1"" BLFNo=""12"" BLFType=""BLF"" BLFTypeID=""0"">206</BLF>
<BLF ID=""-1"" BLFNo=""13"" BLFType=""BLF"" BLFTypeID=""0"">210</BLF>
<BLF ID=""-1"" BLFNo=""14"" BLFType=""BLF"" BLFTypeID=""0"">209</BLF>
</BLFS>
</PhoneDevice>"

As per the page
https://www.3cx.com/docs/bulk-extension-import/
the ID parameter should always be -1

I even tried randomly assigning some IDs. I created a python script to parse this, and I started with an ID od 1000 and had it increment for every BLF entry. The largest ID parameter was somewhere around 1750. The import of such a file produced the same result. The extensions get created and everything gets imported, but the BLF fields remain empty.

Hopefully this provides more info.

Cheers