[freeside] Import

[Ivan Kohler]

On Fri, Jul 30, 1999 at 06:12:59AM -0600, Ben Leibig wrote:
> I just ran an import, and some accounts ended up in the wrong service.  What
> I would like to do is change the TYPE of service of an account while leaving
> pertinant info the same.
> 
> Ie some accounts where are supposed to be mail only came out as shell/login
> accounts.
> 
> I need to change the package from 56k PPP (#1) to email only (#9)
> 
> Additonally all the system accounts came out as radius inclusive accounts.
> I need to change a bunch of accounts from 56k PPP (#1) to shell only (#8)
> 
> I'm not sure if i just need ot change the service number,

I think you want to change the service part (svcpart), not the service
number (svcnum).  See htdocs/docs/schema.html

> or also the shell(and in the case of removing radius the slipip.

>  Can someone give me some hints on how to do this using mysql?

<http://w3.one.net/~jhoffman/sqltut.htm>
man mysql

-- 
Ivan Kohler <ivan at sisd.com> - finger for PGP key - <moc.dsis at navi> Relhok Navi
Open-source billing and administration for ISPs - http://www.sisd.com/freeside
20 4,16 * * * saytime # please don't be surprised if you find me dreaming too