Skip to main content
All CollectionsKnowledge share from RuptelaSWTrust Track
How to create multiple SIM cards from file in LCM
How to create multiple SIM cards from file in LCM
Updated over 6 months ago

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

mceclip1.png

3- Click on Import sim cards

mceclip0.png

4- Click on Download template file

mceclip1.png

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.

mceclip2.png

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

mceclip3.png

Copy Provider name and go Service Provider module -> press CTRL+F -> paste provider name -> enter -> copy ID -> paste ID into csv file.

mceclip4.png
mceclip5.png

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

mceclip6.png

Save the file.

Now repeat steps 1-3 but this time Choose File and Upload the file you just prepared.

mceclip7.png

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.

mceclip9.png

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.

Did this answer your question?