CSV extension import issue - required columns are not found

[Alexandre Takacs]

Hello

Trying to import a CSV file into the our PABX and I get the error "required columns are not found".

The file was actually exported from the same instance and simply amended in excel.

I enclose it for your review...

Any help most welcome !

 

[YiannisH_3CX]

Hello @Alexandre Takacs

Please note that i would advise against posting a csv file with all the extension information included.
Having said that i did not see anything wrong with your csv file. Can you provide screenshot of the error you are getting? Also is your PBX configured to use 2 digit extensions?

 

[Alexandre Takacs]

Thanks for your reply - you may have a point with the data although the most sensitive one were actually obscured. The PABX does indeed use 2 digits extensions.
The message I got was just "required column are not found" (without any specifics as of what was expected and missing).
Interestingly trying to import the "censored" version I posted here yields different results:

I will investigate further but any suggestion most welcome

 

[YiannisH_3CX]

Are these extensions already present in the management console or are you just trying to import them?

 

[Alexandre Takacs]

Thanks for your continued interest.
Those are new extensions.
In any case I eventually "simply" manually created them (there was a dozen new extension to create, I would have preferred to import but manual creation through the GUI was quick enough)

 

[YiannisH_3CX]

Glad to see that a solution was found although not the desired one. Please let us know if you face any more issues or have any questions regarding 3CX.