Description:
In the same manner and before creating multiple objects in bulk, you first need to create the SIM cards to be assigned to them, as it is a mandatory field that cannot be left blank.
Required information:
Compulsory fields:
Field name | Value | Notes |
Service Provider | Service Provider the object's company belongs to. | |
SIM Owner | Company name the object belongs to. | |
Network Provider | SIM card provider. | |
Phone | Phone number. |
Of all the fields above, only Phone needs to be provided by Sales manager/Client, rest can be investigated by Supporter autonomously.
Steps:
1- Login to LCM.
2- Go to SIM cards module.
3- Press Create a new sim card
3- Click on Import sim cards
4- Click on Download template file
After you receive template it is very important – open it and save it like it is - CSV format. Now you ready to fill all information.
Phone numbers you can find in file that you received from sales/client or obtained through ERP. Input under phone column.
Client ID you can find in LCM, go to Clients and into Company name write the client you want to upload objects and press enter. Clients -> fill company name -> enter -> find ID -> write it in client_id column in csv file.
Service Provider ID is next. To find service_provider_id after you have the client id you have to go in to client and check what is his service provider name. Click view/Edit -> find service provider name
Copy Provider name and go Service Provider module -> press CTRL+F -> paste provider name -> enter -> copy ID -> paste ID into csv file.
Last thing is Network Provider under provider_id. You first need to know the name of the Network Provider, which can be identified by checking the first digits of the provided phone numbers:
Teliasonera – MSISDN – 45371004667877
Vodafone – IMSI – 204047106748597
Telenor – MSISDN – 467190003160003
Tele2 – MSISDN – 467191202226671
Telefonica – MSISDN - 345901009649800
Once Network Provider has been identified, input the Network Provider id to the csv file according to the table below:
ID | NAME |
46 | Telia |
45 | Vodafone |
24 | Tele2 LT |
30 | Other |
56 | Fake Provider |
57 | Orange |
755 | Telefonica |
753 | Korek |
754 | Zain |
756 | Telcel |
757 | Movistar MX |
758 | M2M EXPRESS |
759 | Telefónica USA |
760 | CLARO |
761 | Safaricom |
23 | Bite GSM |
25 | Omnitel |
28 | O2 Ireland |
29 | Beeline |
31 | Eurocom |
32 | CBB |
33 | Telenor |
34 | Megafon |
35 | MTS |
36 | Tele2 RU |
37 | Vodacom SA |
38 | Vodacom MOZ |
39 | MTN |
40 | Mascom |
41 | T-mobile HR |
42 | Vip HR |
43 | Tele2 HR |
44 | Movistar |
47 | Tesco mobile |
49 | TeliaSonera |
51 | TestOperator |
55 | Telekom RO |
Save the file.
Now repeat steps 1-3 but this time Choose File and Upload the file you just prepared.
Result:
After you receive answer that all SIM cards was created, please check if you was not wrong with numbers and all information are correct.
Notice how Total Rows is 1 number up from Inserted. This is normal, as the headers did not contain valid info and were discarded accordingly.