[freeside-users] repairing inventory

[Ivan Kohler]

On Tue, Nov 18, 2008 at 07:35:25PM -0800, Nick Schmalenberger wrote:
> Hello,
> I have freeside v1.7.3 with HTML::Mason 1.35-3, perl 5.8.8,
> apache 2.2.3-4+etch4, debian etch, postgresql 7.5.22, and
> libpg-perl 2.1.1-3. Freeside works mostly fine and we have an
> inventory of ip addresses that are assigned to services in the
> svc_acct table representing xen virtual private servers. The
> problem is that most of the ip addresses allocated by freeside
> are different from what is being used in production and many
> addresses being used in production are not in inventory. I have
> been able to add addresses to the inventory using the batch
> upload feature and then I was able to correct the ip address for
> the service in the database by hand like so:
> UPDATE svc_acct SET slipip='newipaddress' WHERE
> svcnum='theuserssvcnum';
> UPDATE inventory_item SET svcnum=NULL WHERE
> svcnum='theuserssvcnum';
> UPDATE inventory_item SET svcnum='theuserssvcnum' WHERE
> item='newipaddress';
> 
> However, I wasn't sure if there wouldn't be any other
> consequences

Nothing jumps out as causing a problem with that, but I didn't think 
about it very hard either.  As with any manual change, there's nothing 
in the history tables.

> if this wasn't the complete way to accomplish this and 
> it seemed like the "Manual provisioning from inventory"
> choice in the service definition would do what I want.
> However, that choice is commented out in lines 67-70 of
> httemplate/edit/part_svc.cgi in cvs FREESIDE_1_7_BRANCH and HEAD
> with the explanation "need to template-ize httemplate/edit/svc_*
> first", so what needs to be done for this?

httemplate/edit/svc_* need to be template-ized so they recognize and 
process any field as a 'manual inventory" field.

> Is it still necessary or can that be uncommented?

It is still necessary.

-- 
_ivan