The mobile phone prefix of a phone number in our country does not always indicate the mobile phone provider; as customers can move numbers between providers (portability).
This project takes an input csv file, and looks up mobile numbers in that CSV against an API that looks up the mobile provider that a particular customer uses. It then presents an analysis of the mobile numbers in that CSV, and an analysis of the mobile provider.
--
API example
1. 1st call send phone number (mdisdn). It returns an id.
# curl -X POST [login to view URL] -H 'Authorization: AccessKey SSdwna1fPL5pCT0J2ecMoobS6A' -d "msisdn=353872227869" -d "reference=YourReference"
{"id":"71e3f581793e4d64a7ea1ad5a2043977","href":"[login to view URL]","msisdn":353872227869,"network":null,"details":null,"reference":"YourReference","status":"sent","createdDatetime":"2018-10-30T10:53:21+00:00","statusDatetime":"2018-10-30T10:53:21+00:00"}
2. 2nd call send phone number (mdisdn). It returns an a details array containing locations_msc, and ported (the fields we will use).
# curl -X GET [login to view URL] -H 'Authorization: AccessKey SSdwna1fPL5pCT0J2ecMoobS6A'
{"id":"71e3f581793e4d64a7ea1ad5a2043977","href":"[login to view URL]","msisdn":353872227869,"network":27205,"details":{"status_desc":null,"imsi":"272057035605903","country_iso":"IRL","country_name":"Ireland","location_msc":"35383","location_iso":"ie","ported":1,"roaming":0},"reference":"YourReference","status":"active","createdDatetime":"2018-10-30T10:53:22+00:00","statusDatetime":"2018-10-30T10:53:24+00:00"}
--
Static data.
The below is used:
- to allow a CSV line to be processed. If the number is not one of these patterns then it is skipped.
- to allow for analysis of the HLR lookup details that are returned from the API call.
$provider ['083-three ']='(35383|083)\\d{7}';
$provider ['085-eir ']='(35385|085)\\d{7}';
$provider ['086-o2 ']='(35386|086)\\d{7}';
$provider ['087-vodafone']='(35387|087)\\d{7}';
$provider ['089-tesco ']='(35389|089)\\d{7}';
-- Parameters to script:
csv - name of input csv file
field - number of field containing phone number to be analyised. 1st is 1.
number - only perform the lookup on a max of this number. The max is the number of successful HLR lookups to perform.
-- Sample Output:
php ./[login to view URL] --csv [login to view URL] --field 4 --number 5
Numbers read: 7
Numbers matching pattern: 6
Numbers whose HLR we could lookup: 5
Numbers which appear as ported: 2
Finished - Analyst of HLRs:
MSISDN
083-three: 20.0%,2
086-o2: 10.0%,10
089-tesco: 70.0%,7
---------------------
100.0%,19
Location Msc5
083-threee: 20.0%,2
086-o2: 20.0%,2
089-tesco: 60.1%,6
---------------------
100.0%,19
Log file of all API calls and responses saved to "HLR-08:55:30-30:10:[login to view URL]".
--
Note that lookups cost e0.015 each so testing should use small numbers (not 100's).
Hello.
My name is Meigire.
I've read your project requirements and I have a few questions:
1. what is location Msc5 analysis. can you explain more.
2. I don't understand the format of the log file naming
3. how large the max number of lookup will be? because, from my experience, we will need to consider memory consumption to avoid the script crashing.
Aside from those questions, I think I can do this in less than 1 week.
Please don't hesitate to contact me to discuss more.
Thank you
€111 EUR 10 napon belül
5,0 (17 értékelés)
4,9
4,9
8 szabadúszó adott átlagosan €174 EUR összegű árajánlatot erre a munkára
Dear client
I m top expert in russia
I have good skills about api
I m flexible in any api
I m using curl,ajax,xhttp,file_get_contents for api
I m ready on your job
for more detail,please contact with me
I have expereinced for 6+ years
thanks to view my proposal
from kashirin:)
Hello,
Hope you are doing well.
I can help with you in your project PHP Script for HLR lookup. I can assure you the quality job.
I have good experience in PHP, RESTful, Software Architecture. We have worked on several similar projects before!
We have worked on 400+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion.
I can assure the 100% job satisfaction.
Thanks,
Hi,
I am very interested to work on your project.
I have 15+ years experience in Web Development using a large variety of programming languages, frameworks, database architecture, APIs, CRMs, ERPs, mobile development, web design, development tools.
There are more then 1000 projects(small/medium/high complexity) successfully implemented and few of them related with yours can be seen on my freelancer.com portfolio.
* * Note that my bid is relative and will be adjusted after detailed estimation of implementation effort/coast **
Let's start our collaboration by sending me all details in a written document which will be used as reference during project implementation
Thank you!
AdiC
Hi there, thanks for detailed project description. I believe I can help with processing the CSV. I have a lot of experience working with CSV files & API connections. I also understand command line PHP
Relevant Skills and Experience
Over 10 years web development experience. Have developed numerous sites and systems in PHP both using frameworks and from scratch. Have written and connected to various APIs & feeds