[Date Prev] [Date Next] [Prev in Thread] [Next in Thread] [Date Index] [Thread Index]

Re: Importing Data Intelligently to ARS Asset Module



Title: RE: Importing Data Intelligently to ARS Asset Module
**
On a Modify All you should get a dark green screen.  Do the same change you did individually (to the field you were not using) and then press save.  The Modify All screen will update all of the records you selected (in the results list) with your changed value.
 
Fred
-----Original Message-----
From: Mougis, Phil [mailto:phil.mougis@ACS-INC.COM]
Sent: Monday, September 30, 2002 6:59 PM
To: ARSLIST@LISTSERV.QMXS.COM
Subject: Re: Importing Data Intelligently to ARS Asset Module

**
Thanks for the many suggestions...
 
I just tried the Modify All suggestion.. but unfortunately... since there is nothing changed.. I get a Dark Green Screen.. and it looks like nothing is happening..
when I did the saves one - by - one .. I simply made a change to a field I wasn't using.. and then was able to click the save button... ARGH..
 
Not familiar with Filters yet.. but my colleague (who just got back from Remedy training) hopefully will be....
 
Phil
-----Original Message-----
From: Sprenger, Janie : CO IR [mailto:JSprenge@LHS.ORG]
Sent: Monday, September 30, 2002 7:44 PM
To: ARSLIST@LISTSERV.QMXS.COM
Subject: Re: Importing Data Intelligently to ARS Asset Module

**
For the long term--if your main Asset records are already in the DB when you import the components, then I would add a Filter that fires on Merge and adds the Asset Eid to the component as it goes into the DB. 
 
-----Original Message-----
From: Mougis, Phil [mailto:phil.mougis@ACS-INC.COM]
Sent: Monday, September 30, 2002 4:36 PM
To: ARSLIST@LISTSERV.QMXS.COM
Subject: Re: Importing Data Intelligently to ARS Asset Module

**
Janie... you are just full of ideas...
 
As background.. we are loading our new Remedy 5 system up from inventories and audits performed over the past year.. so as a one time shot..the approaches we have discussed are acceptable...
 
Unfortunately.. I still need a more elegant approach..
 
Our longer term goal (which means next month) is to run a daily import of all purchases.. translating them into assets...with corresponding components..
so I have to solve this problem for an ongoing series of imports.. which ultimately need to be automated..
 
Regarding ESCALATION - We are quite inexperienced... escalation is an unknown.. but does sound promising.. wonder if I can set the escalation to automatically resave a record 30 seconds after an initial import..
 
Phil
 
-----Original Message-----
From: Sprenger, Janie : CO IR [mailto:JSprenge@LHS.ORG]
Sent: Monday, September 30, 2002 7:14 PM
To: ARSLIST@LISTSERV.QMXS.COM
Subject: Re: Importing Data Intelligently to ARS Asset Module

**
Since I'm just full of ideas today...  You could also create an escalation to modify all the component records... 
 
-----Original Message-----
From: Mougis, Phil [mailto:phil.mougis@ACS-INC.COM]
Sent: Monday, September 30, 2002 4:00 PM
To: ARSLIST@LISTSERV.QMXS.COM
Subject: Re: Importing Data Intelligently to ARS Asset Module

**

I am replying to Janie and Garron here...

Janie
I got the general gist of your intial comments.. and in fact you  did hit on my problem.. only trouble is I don't know the corresponding ID.. to reference when I am generating the import files...

My sense is some form of auto re-save.. or reload may be the answer...

Garron,
You may be onto something....
If we re-import the same component file asking the file to Update...
Only problem I have seen in re-importing entries.. the import doesn't recognize that the items are already in the system (since I normally will not be inserting the Entry_ID (which I don't know at the time import file is generated)

Phil
___________________________________________________________________________
Sounds like some hidden reference field(s) don't get set properly somehow.
Check your logs to see what happens when you save the ones you already have
in the system. See if there is some flag or hidden field that gets set with
something. Once you know what filter sets the values and what they should
be, you can either have an escalation run to do the same for all your other
records, or change the filter qualification so that it will work properly on
the import, re-import the components, and change the qualification back if
necessary.

HTH,
Garron Christie
Kemtah Group @
Sandia Natl Labs


-----Original Message-----
From: Sprenger, Janie : CO IR [mailto:JSprenge@LHS.ORG]
Sent: Monday, September 30, 2002 6:47 PM
To: ARSLIST@LISTSERV.QMXS.COM
Subject: Re: Importing Data Intelligently to ARS Asset Module


**

My apologies,  after further review it appears that the Main Asset ID is the
Asset ID not the Entry ID; however, the Main Asset Eid is the Entry ID of
the main Asset record, and that is the field linked to the table on the
Components tab in the Asset record.
How many records are you looking at having to change?

Janie

-----Original Message-----
From: Phil Mougis [mailto:phil.mougis@ACS-INC.COM]
Sent: Monday, September 30, 2002 2:57 PM
To: ARSLIST@LISTSERV.QMXS.COM
Subject: Importing Data Intelligently to ARS Asset Module


**

Hi,

A colleague of mine submitted this question to the group.. but we have yet
to find a clear answer...

We are attempting to import a series of Assets and their corresponding
Components into Remedy.

Good News - We have no problem getting the assets into Remedy.. and
similarly no problem getting the components in either.

Bad News - When you subsequently look at the Assets... you don't see the
corresponding Components...

Here is the annoying thing... this occurs even though the components have
the correct referrence (to their corresponding Main Asset ID field).

But what is weird is when you bring up the individual Components.. and Re-
Save them (with no changes to the data), they appear linked correctly to
the Asset.

Unfortunately, you need to re-save every single component.. one by one..

Has anyone solved this problem? or does anyone have a suggestion for how we
might resolve it?

Worse case scenario.. is there a function for selecting a series of records
and resaving them all... Perhaps a command line funtion (run as a batch
process?)

Help..

Phil

____________________________________________________________________________
_____________
To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@arslist.org
You may also control your subscription options, including UNSUBSCRIBE, at
http://www.ARSLIST.org

_________________________________________________________________________________________
To UNSUBSCRIBE, email the message "unsubscribe arslist" to: listserv@arslist.org
You may also control your subscription options, including UNSUBSCRIBE, at http://www.ARSLIST.org

_________________________________________________________________________________________ To UNSUBSCRIBE, email the message "unsubscribe arslist" to: listserv@arslist.org You may also control your subscription options, including UNSUBSCRIBE, at http://www.ARSLIST.org This posting was submitted via the Web interface _________________________________________________________________________________________ To UNSUBSCRIBE, email the message "unsubscribe arslist" to: listserv@arslist.org You may also control your subscription options, including UNSUBSCRIBE, at http://www.ARSLIST.org This posting was submitted via the Web interface
_________________________________________________________________________________________ To UNSUBSCRIBE, email the message "unsubscribe arslist" to: listserv@arslist.org You may also control your subscription options, including UNSUBSCRIBE, at http://www.ARSLIST.org This posting was submitted via the Web interface _________________________________________________________________________________________ To UNSUBSCRIBE, email the message "unsubscribe arslist" to: listserv@arslist.org You may also control your subscription options, including UNSUBSCRIBE, at http://www.ARSLIST.org This posting was submitted via the Web interface
_________________________________________________________________________________________ To UNSUBSCRIBE, email the message "unsubscribe arslist" to: listserv@arslist.org You may also control your subscription options, including UNSUBSCRIBE, at http://www.ARSLIST.org This posting was submitted via the Web interface
_________________________________________________________________________________________ To UNSUBSCRIBE, email the message "unsubscribe arslist" to: listserv@arslist.org You may also control your subscription options, including UNSUBSCRIBE, at http://www.ARSLIST.org This posting was submitted via the Web interface