Bulk Extension Import Failing

[Cajun McCartney]

We are testing out 3CX free license for our environment to see if it meets our needs and so far the only issue we have is that we can't do imports of extensions. Here's what I did:

1. Went to https://www.3cx.com/docs/bulk-extension-import/, followed the steps and grabbed the template
- Filled out the template with the information and received the attached error_1.txt
- Tried importing just the template file that was downloaded from 3CX without editing it and that failed.

Since that didn't work we tried the following

2. Deleted all extensions in the console > created a new fresh extension > Exported to csv
- We then edited that file, saved it without changing the formatting, Import failed with same error
- Tried again but this time saving as a CSV (DOS) and this failed with the same error as well.

Final test

3. Deleted all extensions, created a fresh one, exported the csv AND then without opening or touching the file at all, we deleted the extension from the console and immediately imported the untouched export and it failed with the errors in the attached error_2.txt

We have tried this on two different 3CX servers/environments and it never works. Tried multiple CSV and Excel formats, but the fact that it won't even accept the files it exports or the templates on the 3CX page tells me there is an issue.

Anyone else have this issue or know a work around? I saw some forums about having semicolons when it should have a comma and some stuff about opening it in a text editor and making sure the commas were there and nothing seems to be working.

 

[Cajun McCartney]

I did, I tried right after your suggestion and I get the same below error. Also tried downloading the 3CX Template, Opened the template, selected the cells, Format Cells changed to text, saved and tried importing. Same thing over and over. This happened with the first environment I built and again with this one. Not sure why the files I download/import don't work, but the one that mariosM gave me worked.

Even tried editing the one that he mariosM gave me that worked originally, I changed one extension and when importing it failed.

Your import file has errors. Note that not all rows were imported.
Below is a list of row numbers that failed and in brackets you can see the column header that caused the failure.
Click here for more information on how to generate your CSV file correctly.
2 (WebMeetingFriendlyName) ,
3 (WebMeetingFriendlyName) ,
4 (EmailAddress) ,
5 (WebMeetingFriendlyName) ,
6 (WebMeetingFriendlyName) ,
7 (WebMeetingFriendlyName) ,
8 (WebMeetingFriendlyName) ,
9 (WebMeetingFriendlyName) ,
10 (WebMeetingFriendlyName) ,
11 (WebMeetingFriendlyName) ,
12 (WebMeetingFriendlyName) ,
13 (WebMeetingFriendlyName) ,
14 (WebMeetingFriendlyName) ,
15 (WebMeetingFriendlyName) ,
16 (WebMeetingFriendlyName) ,
17 (WebMeetingFriendlyName) ,
18 (WebMeetingFriendlyName) ,
19 (WebMeetingFriendlyName) ,
20 (WebMeetingFriendlyName) ,
21 (WebMeetingFriendlyName) ,
22 (WebMeetingFriendlyName) ,
23 (WebMeetingFriendlyName) ,
24 (Number),
25 (WebMeetingFriendlyName)

 

[Marari]

I did, I tried right after your suggestion and I get the same below error. Also tried downloading the 3CX Template, Opened the template, selected the cells, Format Cells changed to text, saved and tried importing. Same thing over and over. This happened with the first environment I built and again with this one. Not sure why the files I download/import don't work, but the one that mariosM gave me worked.

Even tried editing the one that he mariosM gave me that worked originally, I changed one extension and when importing it failed.

Ok. Try one more thing for me. Just humor me.

- Start with a clean list. Create ONE extension - it doesn't matter what number you make it.
- Export the list.
- Delete the extension you created.
- Open the list in NOTEPAD.
- Make a few changes or add another extension following the format EXACTLY as was exported
- Save the CSV file.
- Import it.

Does it work?

 

[Cajun McCartney]

Alright so I figured out the issue or issues. All on me and what the system can take as input.

1. Extension 7000 by default was configured for a conference line and I was trying to import that for another user. I changed the conference line to 8000 and was able to create the user manually.

2. The Web Meeting Name for each user, they had a space in them and the system does not allow a space in Web Meeting name. Tried using an underscore but that didn't work either so I just joined the first and last name to make the Web Meeting name.

3.We had a line marked as "AVAILABLE" in the firstname, lastname, AND email column, since it didn't have a domain on the email, it didn't allow it.

4. Lastly, one of the extensions matched the number that is hardcoded in for the fax number which I'm not sure why I can't change it.

Nothing in the error said anything about numbers in use, which ones were in use, that a value had a space where it shouldn't, etc so I ended up going through and adding every extension manually to see where it error'd out.

Issue number 3 in the above list, that was the final issue, though its odd that if one line in the sheet doesn't work then it won't import any of them.

Thanks for your help