Hi Tony, Thanks for pointing me in the right direction.... I was thinking..I can't delete a group that I can't see, so maybe only the search index is corrupted. I rebuild the search index and now the Group:"1234" group is gone from the search results.........but is it really gone...?? Where are the groups stored, I can't seem to grep them in /etc/sipxpbx.
Paul From: Tony Graziano <[email protected]> To: Discussion list for users of sipXecs software <[email protected]> Date: 12-01-2011 11:29 Subject: Re: [sipx-users] Imported .csv with too many quotes, can't delete "group" Sent by: [email protected] rebuild the index and delete the group without searching for it. On Wed, Jan 12, 2011 at 5:25 AM, Paul Scheepens <[email protected]> wrote: I edited a correct .csv in excel (me stupid) saved it and imported it. Unfortunately Excel added a lot of extra quotes, all entries have two double quotes: User name,Voice-mail PIN,SIP password,First name,Last name,User alias,EMail address,User group,Phone serial number,Phone model,Phone group,Phone description,Im Id "1234,""0000"",""pasword"",""First"",""Last"","""","""",""User"",""1234"",""counterpathCMCEnterprise"",""PG-Site"",""First Last"",""1234""" In Job Status I got a warning that "model "PG-Site" does not exist", so far no problem. But unfortunately something was imported, if I search (top-right search box) for 1234 then the config server finds the following: Group:"1234" (with quotes!!) If I click on the link then I get an internal error. This group is not visible anywhere in the GUI. Does anyone know how I can get rid of this database pollution and what other damage could be done? I think it would be good to adjust the import function to prevent this from happening (I am not the only fool working with SipX). Paul _______________________________________________ sipx-users mailing list [email protected] List Archive: http://list.sipfoundry.org/archive/sipx-users/ -- ====================== Tony Graziano, Manager Telephone: 434.984.8430 sip: [email protected] Fax: 434.326.5325 Email: [email protected] LAN/Telephony/Security and Control Systems Helpdesk: Telephone: 434.984.8426 sip: [email protected] Helpdesk Contract Customers: http://support.myitdepartment.net Blog: http://blog.myitdepartment.net Linked-In Profile: http://www.linkedin.com/pub/tony-graziano/14/4a6/7a4 _______________________________________________ sipx-users mailing list [email protected] List Archive: http://list.sipfoundry.org/archive/sipx-users/
_______________________________________________ sipx-users mailing list [email protected] List Archive: http://list.sipfoundry.org/archive/sipx-users/
