PlaySMS and integrating users from an AD, adding contacts through .csv and group management

anton · July 3, 2015, 7:29am

how do you add contact ? through add button ? through import ?

anton

Robin_Karlsen · July 3, 2015, 7:39am

My account -> phonebook -> import

Example data:
Aase Lund, number, ,OS-SKOLE-5A,name of parent <- tags
Christan Lund, number, , OS-SKOLE-6B,name of parent
Johannes Lund,number,OS-SKOLE-3A,name of parent

Will result in:
Aase Lund, , OS-SKOLE-3A + OS-SKOLE-5A + OS-SKOLE-6B (+ OS-SKOLE-1B <- no idea why this shows, none of the 3contacts in the test csv file has that group code in it…), name of parent

anton · July 3, 2015, 7:43am

change this line to FALSE:

github.com

antonraharja/playSMS/blob/master/web/plugin/feature/phonebook/import.php#L142


			$mobile = trim($d[1]);
			$email = trim($d[2]);
			if ($group_code = trim($d[3])) {
				$gpid = phonebook_groupcode2id($uid, $group_code);
			}
			$tags = phonebook_tags_clean($d[4]);
			if ($name && $mobile) {
				// fixme anton - temporary - contacts not unique
				// if ($c_pid = phonebook_number2id($uid, $mobile)) {
				if (FALSE) {
					if ($gpid) {
						$save_to_group = TRUE;
					}
				} else {
					$items = array(
						'uid' => $uid,
						'name' => $name,
						'mobile' => sendsms_getvalidnumber($mobile),
						'email' => $email,
						'tags' => $tags 
					);

if (FALSE) {

anton

Robin_Karlsen · July 3, 2015, 7:51am

Problem persists. Added to that, the group codes seems random now, with only one group being correct:

Aase Lund, , BERG-SKOLE-1A + BERG-SKOLE-4A + OS-SKOLE-5A (only one thats correct), name of parent

I tried deleting the contact and re-added and it resulted in a simular result, only OS-SKOLE-5A was correct with two other groups than the two above. So they do seem to be selected randomly of the groups in the database.

EDIT: double-checked the values of the confirmation screen before importing, and that information is correct, so there shouldnt be a problem with the data at all.

EDIT2: the random groups probably won’t be a problem if we manage to get the entries to be seperate though, as each contact will only get one group then, instead of one getting accidentally more than one.

anton · July 3, 2015, 8:08am

I suppose all these changes can’t get things right, so I suggest you get some help to completely modify playSMS phonebook

current playSMS:

tag wasn’t for parent’s name, it must not have spaces, a dot or whatever non-latin chars
group code also the same, just like tags
contact must be unique

sanitizing tags making it not working properly, sanitizing group code making it not searchable, and I have no idea what happens when you made contact not unique

I guess all those changes must be dealt properly, cannot be done through this topic, I can only suggest changes, but won’t be able to test them

other thing you can do is to post those changes on github issues, so that someone, or maybe me, can do it properly next time

anton

anton · July 3, 2015, 8:24am

but hey I think I did it, I meant I have tested and it looks like this is what you want:

just grab all php files in plugin/feature/phonebook in github and replace yours

anton

Robin_Karlsen · July 3, 2015, 8:29am

Ok, cool, will test it now. I’ll give you a reply within a few minutes!

anton · July 3, 2015, 8:34am

oh 1 thing you need to know when you import, the first line was for title

here’s my example:

skole.csv (172 Bytes)

anton

Robin_Karlsen · July 3, 2015, 8:48am

Hm, even tried with your test-file so our data is exactly the same. Still doesnt work, I’ll double check that the files has changed properly. Cause when you add the contacts in that group you get 3 seperate entries in the phonebook itself right?

anton · July 3, 2015, 8:50am

not here, I tested, looks good on my server.

I had to clear up the db tables to make sure.

anton

Robin_Karlsen · July 3, 2015, 8:53am

I’ve deleted all contacts except for 7 as those are phone numbers not part of the files, its the numbers of the people working at the IT-department. Hm.

Robin_Karlsen · July 3, 2015, 8:55am

Which version are you running on? I’m running on 1.0

anton · July 3, 2015, 8:57am

the latest, the master version from github

should also work with playSMS 1.0 (with updated phonebook php files)

anton

Robin_Karlsen · July 3, 2015, 8:58am

I copied the entire phonebook folder, not sure why it wouldnt work then. I’ll manually check the files to make sure theyre updated

anton · July 3, 2015, 8:59am

the import:

the end result:

“July Lund” was an entry that I added manually through add contact button

Robin_Karlsen · July 3, 2015, 9:05am

Good to see it work on your end. Checked the files, they all are edited accordingly to github.

Do you think it could be the database? What did you mean by “clear up the db tables” earlier? To what degree did you clear them?

anton · July 3, 2015, 9:06am

I empty featurePhonebook, featurePhonebook_group, featurePhonebook_group_contacts

anton

Robin_Karlsen · July 3, 2015, 9:19am

I deleted all rows in all 3 databases, added the 3 groups. Imported CSV-file and only the first row shows still. That contact only has one group though, not 3. No changes in the latest version should make the difference right?

I’ll be away for like 30mins now, as it is lunch time

If you want I can probably give you access to the through the use of teamviewer if theres any interest in doing that. If so I’ll send you an id to connect to as a PM.

anton · July 3, 2015, 9:22am

try empty it again, use my csv file, and then get screenshots like I did

just drag the screenshot image file to the posting area to share image

anton

Robin_Karlsen · July 3, 2015, 9:50am

Back from lunch there you go:

Edit: tried adding a contact manually, nothing got added.

Topic		Replies	Views
Import Contacts After migration to 1.4.2 Help	1	493	January 14, 2020
[solved] Feature Request - Phonebook & Organize Messages Help	6	664	April 27, 2020
How to import contact in subscribe? Help	3	1159	August 29, 2016
Assing Contacts to User Help	0	439	November 15, 2018
Multiple Groups for phone book entries? Help	2	815	July 20, 2015

PlaySMS and integrating users from an AD, adding contacts through .csv and group management

Related topics