Thanks for everyones responses .. I am not sure I ever communicated properly
what my real problem was ... I was bring over data from ITSP 4 into ITSM 7.
I already had my company data in a cs with assignee group as one of the
fields. The problem is when you import into v7 it automatically takes the
assignee group values you imported and creates group records in the Group
form for those records. So my group form was being populated multiple
times for the same group. For some reason it wasn't properly resolving the
assignee groups I imported and the is out of the box code automatically sets
the assignee groups to Public. I tracked it down and the problem was the
data in the form CTM:SysGroupPermissions (I don't remember the exact name of
the form, but something like that) didn't match the data in the Group form.
Basically the resolution was reimport groups, then reimport into the
CTM:SysGroupPermission form, and then import into the company form. Thought
this might help somebody else if they run into this problem
Kevin
From: Kelly Deaver <[EMAIL PROTECTED]>
Reply-To: [email protected]
To: [email protected]
Subject: Re: Import Question
Date: Tue, 3 Oct 2006 04:36:17 -0700
**
To answer your latest question -
Importing Company data is one of the very first things you should do
because just about every other table references the "Company" filed as part
of its data. For example - in PCT:ProductCatalog, the Manufacturer field
must match a valid Company were Company Type = Manufacturer.
To import Company you need -
Company, Company Type, Status
---------------------
Kelly Deaver
Director, ITSM Practice
Xinify
[EMAIL PROTECTED]
-------- Original Message --------
Subject: Re: Import Question
From: Kevin Shaffer <[EMAIL PROTECTED]>
Date: Mon, October 02, 2006 3:37 pm
To: [email protected]
Let me rephrase the question because I have tracked back my issue to
Filters
that are firing that seem to overwrite my values that I am importing in ...
I guess my question now is has anyone imported data into the COM:Company
table on v7 and have the data mappings defined or is there a pre-req of
what
data should be in the system before importing company data
>From: "Halstead, Robert" <[EMAIL PROTECTED]>
>Reply-To: [email protected]
>To: [email protected]
>Subject: Re: Import Question
>Date: Mon, 2 Oct 2006 15:22:26 -0400
>
>Usually, when I do an import I take out all the quotes out of the file.
>Though I usually use excel to edit cvs files, excel puts qoutes around
>everything. Not sure if this is your problem.
>
>
>Bob Halstead
>Advanced Services "The superior man cannot be
>known in little matters,
>Bresnan Communications The small man may not be
>entrusted with great concerns,
>Billings, Montana but he may be known in
>little matters."
>Office: (406) 869-5624
>Confucius, The Confucian Analects
>Cell: (406) 697-8083
>
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
>Sent: Monday, October 02, 2006 12:59 PM
>To: [email protected]
>Subject: Re: Import Question
>
>Kevin,
>
>Based on the supplied information I can not tell if it is a bug or a
>human error. :)
>
>A few question to try to short it out.
>
>Can you supply a sample data value for a row or three?
> Are you using group ID format or English string formats?
>
>Have you looked at what a CSV file, that was exported using the User
>Tool, looks like for the values your trying to import?
>
>
>You might have better luck with an ARX formatted file.
>
>--
>Carey Matthew Black
>Remedy Skilled Professional (RSP)
>ARS = Action Request System(Remedy)
>
>Love, then teach
>Solution = People + Process + Tools
>Fast, Accurate, Cheap.... Pick two.
>
>
>
>On 10/2/06, Kevin Shaffer <[EMAIL PROTECTED]> wrote:
> > ARS 7.x
> >
> > Can you import assignee group from a csv. Everytime I do it, my
> > assignee group always goes to Public, even though my csv file contains
>different
> > values. Is this a bug or am I doing something wrong.
> >
> > Thanks
> >
> > Kevin
>
>________________________________________________________________________
>_______
>UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>
>_______________________________________________________________________________
>UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125_______________________This posting was submitted with HTML in
it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
