Understanding the filters

[marrold]

Hi,

I'd love to be able to merge contacts from a CSV (Feature codes, external numbers etc).

I've got as far as reading from the file and inserting into the list returned to the phones, but I need to filter them based on the search query.

Could you provide any insight on the various filters in the code? In my mind it would be almost exclusively ((&(telephoneNumber=*)(displayName=%))) AND but the current code supports GE, LE etc. What are these used for?

Thanks

[iamacarpet]

Hi @marrold ,

I believe the Polycom phones we had on site sent queries with GE/LE rather than = or with a limit.

Honestly, it's been a while since we've used this ourselves, so I'm only going from memory, as we've since switched away from FreePBX & desk phones to Teams & G Voice.

I wonder if you'd have any luck importing the CSV into an in-memory SQLite DB on startup, or if there is a way to insert dummy extensions into the FreePBX DB so they can be looked up alongside the other extensions?

Sorry I can't be more help.

Regards,
iamacarpet

[marrold]

I believe the Polycom phones we had on site sent queries with GE/LE rather than = or with a limit.

Do you remember the model? I have a Polycom so I can try it out and spot the differences.

insert dummy extensions into the FreePBX DB

I think this would probably cause issues. I try to avoid messing with FreePBX as it tends to come back to haunt you.

I'll keep experimenting, thanks