Solved Import CSV contact files

Discussion in '3CX Phone System - General' started by ltifoski, Sep 13, 2017.

Thread Status:
Not open for further replies.
  1. ltifoski

    Joined:
    Jul 29, 2017
    Messages:
    38
    Likes Received:
    0
    Dear,

    I try import the csv file with my contacts in 3CX phone system 15. But i get error stating that the mobile column is missing. However, it is correct and unrecognized. Can you help me?

    Thank you.

    Lucas Tifoski.
     
  2. AndreasPo_3CX

    AndreasPo_3CX Support Team
    Staff Member 3CX Support

    Joined:
    Aug 10, 2017
    Messages:
    138
    Likes Received:
    12
    Hello @ltifoski ,

    Can you post a sample of your csv with sensitive information changed? Make sure to include the column headers.
     
  3. ltifoski

    Joined:
    Jul 29, 2017
    Messages:
    38
    Likes Received:
    0
    This is a example:
     

    Attached Files:

  4. AndreasPo_3CX

    AndreasPo_3CX Support Team
    Staff Member 3CX Support

    Joined:
    Aug 10, 2017
    Messages:
    138
    Likes Received:
    12
    From the screenshot it looks fine, although I meant that you could paste it as text here so i can try it.
    What you could try though is the following:
    1. Add a dummy contact through the management console
    2. Export contacts
    3. Open the exported file and paste your contacts in that file
    4. Try importing that file and see if it is accepted

    This will ensure that the column header format is correct.
     
  5. ltifoski

    Joined:
    Jul 29, 2017
    Messages:
    38
    Likes Received:
    0
    I've tried it this way and it did not work. Is there any other way?
     
  6. ltifoski

    Joined:
    Jul 29, 2017
    Messages:
    38
    Likes Received:
    0

    I've tried it this way and it did not work. Is there any other way?
     
  7. AndreasPo_3CX

    AndreasPo_3CX Support Team
    Staff Member 3CX Support

    Joined:
    Aug 10, 2017
    Messages:
    138
    Likes Received:
    12
    @ltifoski
    I have sent you a PM, please check your inbox.
     
  8. ltifoski

    Joined:
    Jul 29, 2017
    Messages:
    38
    Likes Received:
    0
    Dear!

    I solved the problem:

    The problem is; in the .csv file when it should only be,

    I solved the problem by opening the file with notepadd ++ and substituting; per ,
     
  9. AndreasPo_3CX

    AndreasPo_3CX Support Team
    Staff Member 3CX Support

    Joined:
    Aug 10, 2017
    Messages:
    138
    Likes Received:
    12
    Glad the issue is resolved!
     
Thread Status:
Not open for further replies.