Re: JOB: Full-time Remedy Developer & Administrator on ITSM and AR 9.x - ActioNet, Inc. Washington, DC

2017-04-24 Thread Del Wester
**
I'm interested in learning more. My current resume is attached. 
_ARSlist: "Where the Answers Are" and have been for 20 years_

DelWester.doc
Description: MS-Word document
**
Thanks,DelSent from my iPhoneOn Apr 24, 2017, at 8:07 AM, Eric Chasteen  wrote:**
Hello Listers,I am looking for a full-time Remedy Developer and Administrator with 9.x ITSM, and AR platform administrator and developer experience. SmartReporting and MyIT experience preferred. Full-time ActioNet employee with benefits, competitive salary, and paid BMC training.  Located at customer site in Washington, DC. Possible work from remote location. Must be a US citizen with ability to pass Federal Government clearance.  If interested, please E-mail me at echast...@actionet.com with an up-to-date resume.Regards,Eric Chasteen
_ARSlist: "Where the Answers Are" and have been for 20 years_

_ARSlist: "Where the Answers Are" and have been for 20 years_

Re: How to "split" Unrestricted Access

2017-04-24 Thread Mueller, Doug
Irina,

OK, using an older version, I have a number of customers who played the 
following trick to isolate a class of tickets….

Step 1 – Create a new company – say Company-HR.
Step 2 – Remove everyone from Unrestricted Access and tie them to a company.  
So, your IT team will be only in Company but you put your HR team in Company 
AND Company-HR  (so, your HR team can see IT tickets, if that is not OK, do 
this same process creating a Company-IT additional company and do these steps 
for all IT tickets).  NOTE: It is important that people remain in Company as 
that is where their catalog and other things are.  They ARE NOT changing what 
company they are in, they are just being given access to tickets from another 
company.
Step 3 – Add a filter that whenever a ticket is submitted that is an HR ticket, 
you change the Company field from Company to Company-HR.

This leaves everyone in Company so that they can see menus and get catalog 
items and such.  YOU DO NOT create catalog items for the new dummy companies.  
They exist only to allow bucketing and holding tickets.  You may need to 
configure some menus and such for the dummy company(ies) to allow work on the 
tickets, but for the most part you should not have to worry about it.

You are simply redirecting to a dummy company all HR tickets here so that they 
are no longer accessible by somone in Company but only those in Company-HR.  No 
one will have Unrestricted Access so no one can see across company boundaries.


This is really a quick and dirty version of using support group centric with 
hierarchy row level security that is fully supported in 9.1 and later.

I hope this helps,

Doug

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Irina Solarcuka
Sent: Friday, April 21, 2017 11:22 AM
To: arslist@ARSLIST.ORG
Subject: Re: How to "split" Unrestricted Access

**
Hi Doug,
I'm using ITSM 8.1.02
/Irina

2017-04-21 21:02 GMT+03:00 Mueller, Doug 
mailto:doug_muel...@bmc.com>>:
**
Irina,

You did not mention the version of the ITSM applications that you are using.

In the 9.1 release (and I suggest the sp2 or later release), there were some 
adjustments made to the security model of ITSM.   It is configurable to use the 
new vs. old security model (configuration option available in the sp2 and later 
release).

The options are to make the security Company centric (the old model) or to make 
it Support Group centric (the new model).

In addition, the Hierarchical group feature of the AR System is fully supported 
within the ITSM applications.

So, with this approach, what you would do is have support groups that are for 
IT tickets and support groups that are for HR tickets.  You can then link them 
up with parent groups (and you can have multiple levels) and roll up to an 
IT-ALL ACCESS and an HR-ALL ACCESS group respectively.Then, you add IT 
users to IT-ALL ACCESS and HR users to HR-ALL ACCESS and no one has 
Unrestricted Access.

This way, all IT users can access all IT tickets – but no HR tickets.   HR 
users can access all HR tickets – but no IT tickets.

If someone can see across things, they can be in both parent groups – or 
Unrestricted Access.

The key is that what you are trying to accomplish is OOTB functionality with 
the new security model option available in the 9.1 sp2 or later releases.  
Something to look at to see how it can solve your problem at a minimum.  Then, 
something to consider upgrading to is that does indeed solve the problem you 
are looking at.

Doug Mueller

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brian 
Pancia
Sent: Friday, April 21, 2017 6:57 AM

To: arslist@ARSLIST.ORG
Subject: Re: How to "split" Unrestricted Access

**

Irina,



I would recommended cleaning everything up and moving to a multi-tenancy model. 
 Unrestricted Access should be used sparingly and shouldn't be given to 
everyone.  I normally treat that as an admin function or for auditing.  
Multi-tenancy is exactly what you are asking for and is out of box 
functionality, no customizations required.  If you try to customize a solution 
now you will probably regret it in the future.  What happens when facilities or 
security want to come on board and have the same data restriction requirements? 
 Don't over think it and make a complicated solution.  Too many developers 
destroy systems by coming up with solutions that out of box functionality can 
handle.  Think of patches, upgrades, onboarding new customers.



Brian




From: Action Request System discussion list(ARSList) 
mailto:arslist@ARSLIST.ORG>> on behalf of Murnane, Phil 
mailto:phil.murn...@windward.com>>
Sent: Friday, April 21, 2017 8:14:09 AM
To: arslist@ARSLIST.ORG
Subject: Re: How to "split" Unrestricted Access

**

Hello Irina,



Most HR applications I've seen store their 

Re: [Non-DoD Source] Re: need input about data migration after Upgrade

2017-04-24 Thread Misi Mladoniczky
Ok, I see, I think...

So this is the 9.1.02 version of DDM? So these are the files to go from Pre 
9.1.02 to 9.1.02?

Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 
2011)

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs
Find these products, and many free tools and utilities, at http://rrr.se 
(http://rrr.se)
April 24, 2017 12:49 PM, "Jarl Grøneng"  wrote:

** 
See attachments 
Regards, 
Jarl  
2017-04-24 12:31 GMT+02:00 Misi Mladoniczky :

 **
Hi,

In other words it actually points to the .ARM file for mapping.

So how is this structured, do you get a set of config/mapping files for each 
supported version transition?

Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 
2011)

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs
Find these products, and many free tools and utilities, at http://rrr.se 
(http://rrr.se)
April 24, 2017 10:01 AM, "Jarl Grøneng"  wrote:

**
Hi 
This is a DDM instruction file, and you can see that the field mapping using an 
import-tool format. 
PASS_QUALIFICATION
Regards, 
Jarl  

2017-04-20 14:48 GMT+02:00 Misi Mladoniczky :
 **
Hi,

So RRR|Chive works in a similar way, where matching ids are the default, 
regardless if it is a custom field or not. Fields can then be mapped/skipped 
specifically.

It sounds like a simple thing to generate rrrchive-config-files based on the 
mapping-files from DDM!? Any chanse of supplying me with a few DDM-config-files 
to allow me to check how much work it would take?

Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 
2011)

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs
Find these products, and many free tools and utilities, at http://rrr.se 
(http://rrr.se)
April 20, 2017 1:49 PM, "JD Hood"  wrote:

**As for custom fields, the in the 7.x version, the default DDM mapping was 
based on matching field IDs, unless a different mapping was specified. So as 
long as custom fields had the same field ID between the systems, the data would 
migrate correctly.

So, with DDM migrating between two forms, it would map based on matching field 
IDs for all fields that were not mapped specifically. So if you looked at the 
mappings for the specifically mapped fields, it only listed the odd-ball fields 
that needed to be mapped because their ID's differed (presumably due to version 
changes). As long as custom fields had the same field ID between the systems 
(or if you manually edited the DDM mapping to include the custom fields if the 
ID's differed), the data would migrate correctly.
Biggest issue I had with DDM is that it was slow, Slow, SLOOOW. 
Thanks, 
-JDHood 
On Thu, Apr 20, 2017 at 6:19 AM, Vinod Gaidhani  wrote:** 
Thanks Misi, seems to be good and overcomes shortcomings of DDM.

Vinod.  
On 20-Apr-2017, at 2:30 PM, Misi Mladoniczky  wrote: 
**
Hi,

One big difference between DDM and RRR|Chive is that DDM just finds all records 
after the date/time you specify and transfer these records.

RRR|Chive will pull all recordids and modify-dates from both system and then do 
transfer/delete as appropriate. No need to specify a date.

Because of this it is easy to use to restore a system after, for example, 
testing.

I have been playing with the idea of using the DDM mapping files in RRR|Chive, 
but have not come around to doing this. So you are pretty much on your own and 
need to do the mapping yourself.

I am not 100% sure about this, but I think that DDM will not copy data on 
custom fields you have added yourself automatically.

I have another tool I like to use when planning migrations to new application 
versions, and this is RRR|DefFieldDiff that will give you an excel sheet of all 
changed data fields. This makes it easy to find differences and plan your data 
massaging.

Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 
2011)

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs
Find these products, and many free tools and utilities, at http://rrr.se 
(http://rrr.se)
April 19, 2017 2:39 PM, "Murnane, Phil"  wrote:
We've used DDM and RRR|Chive successfully on various projects. Misi's 
tool is scriptable and very fast compared to DDM. DDM can schedule code and 
data migrations. Generally both require the Last-Modified date/time field to be 
accurate. Overall, I'

Re: need input about data migration after Upgrade

2017-04-24 Thread Ben Chernys
Hi All,

 

Thanks Misi.  Sorry for the delayed response.  I’ve been working feverishly and 
haven’t spent time on the arslist.  I thank you for your time and efforts 
hosting it.

 

Our data migration product does much more than simple data migration.  It 
allows you to change Support structures, Operating Companies, Categorizations 
etc. during the data migration as well as keeping a new system up to date with 
an old system.  

 

As a simple example, consider the product catalogue.  You may have 5 different 
BMC manufacturers and many times more that of product catalogue entries:  BMC, 
BMC Software, BMC Software Inc, and so on.  In the new system, you would have 
only one BMC manufacturer with all dependent data changed as needed.

 

As a more complex example, the migration package will move Change of type 
Release to the Release module.  Any tasks in the change become Activities.

 

Meta-Update can do anything – period.  It’s chief advantage is its ability to 
do complex things with no programming and especially no API skills.  Any ARS 
Developer / Admin should be able to do what they need to do with an hour 
introductory WebEx.  

 

Consider Meta-Archive – a completely configurable archive solution that 1) 
checks root associations (so that an Incident connected to an open change is 
NOT archived), and 2) can output to Archive forms, CSVs, HTML, another server 
instance.  In production use on ITSM 9.1, 8.1, 7.6.04.  

 

Consider that we had a customer who had all CIs as Computer Systems (due to a 
bad migration) and had worked these a year accumulating leases, changes, 
relationships, etc.  A Meta-Update script of 16 hours was able to move all this 
data to the proper set of classes.

 

Consider that a Proof of Concept script was able to change a mass of login ids 
in an automated way even using a separate SQL server to query so that indexes 
could be applied that were not desired in the production server.  

 

Many more examples and information about the data migration product available 
at www.softwaretoolhouse.com  

 


Cheers,

Ben Chernys
Senior Software Architect
  

Canada / Deutschland
Mobile:+49 171 380 2329   GMT - 7 + [ DST ]

Mobile +1 403  554 0887 
Web:   www.softwaretoolhouse.com

We are a BMC Technology Alliance Partner

 

 

Check out Software Tool House's free Diary Editor and our  Freebies Section for 
ITSM Forms and Fields spreadsheet.

Meta-Update, our premium ARS Data tool, lets you automate your imports, 
migrations, in no time at all, without programming, without staging forms, 
without merge workflow. 

 

Meta-Archive does ITSM Archiving your way: with your forms and your 
multi-tenant rules, treating each root request as a complete tree and checking 
associatuions.  Archive output to different servers, HTML pages with links to 
attachments or archive forms.

 

Pre ITSM 9.1.02?  Clarify?  Roll your own?  No problem!

You can keep your valuable data!


  http://www.softwaretoolhouse.com/  

 

 

 

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: April-19-17 5:56 AM
To: arslist@ARSLIST.ORG
Subject: Re: need input about data migration after Upgrade

 

** 

Hi,

RRR|Chive might help you. It is free to use but low level. You need to know 
exactly what you want to. It uses the modify-date of the records to find which 
ones to add/update/remove, so you need to update that column when working at 
DB-level. Alternatively you can skip updating the modify-date (C6) column and 
RRR|Chive will not touch that record as it would be considered the same in 
source/target. You did not say if the cleaning activity happened in the source 
or target environment...

https://rrr.se/cgi/index?pg=chive

You might also consider talking to Ben Chernys at 
http://www.softwaretoolhouse.com/ as he has ready made scripts for his 
commercial Meta-Update to do ITSM migrations. I have not tried it myself 
though, but Ben should be able to tell you what he can and can not do.

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs
Find these products, and many free tools and utilities, at http://rrr.se


April 19, 2017 9:11 AM, "Amit B" mailto:%22amit%20b%22%20%3craccons...@gmail.com%3e> > wrote:

**

Hello All,

We are in the middle of upgrading our ITSM . I have one question about data 
migration. As we have opted parallel upgrade ,i mean we have build separate 
server and took DB backup from current prod and dump it on new server. So 
currently existing infra is up & running and lot of data cleanup is happening 
based on business requirement but this data cleanup is happening fro

Re: [Non-DoD Source] Re: need input about data migration after Upgrade

2017-04-24 Thread JD Hood
As I recall, it is a regular old .ARM file, same as if you saved a mapping
with the data import tool. The XML just instructs DDM to use a particular
ARM file for the Form.

And in the .arm file, it only lists the field(s) that require manual
mapping when their field-ID's don't match. So the DDM seems to have the
mapping scheme of "map each field by matching field-id *and* map this other
field(s) according to the arm file".

Hope that makes sense. And like I said, this is a bit of a trip down memory
lane, so if you install a recent version of migrator, you will get DDM with
that install and you can inspect the files to confirm.

-JDHood

On Mon, Apr 24, 2017 at 6:48 AM, Jarl Grøneng 
wrote:

> **
>
> See attachments
>
> Regards,
> Jarl
>
> 2017-04-24 12:31 GMT+02:00 Misi Mladoniczky :
>
>> **
>> Hi,
>>
>> In other words it actually points to the .ARM file for mapping.
>>
>> So how is this structured, do you get a set of config/mapping files for
>> each supported version transition?
>>
>> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>>
>> Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs
>> Find these products, and many free tools and utilities, at http://rrr.se
>>
>>
>> April 24, 2017 10:01 AM, "Jarl Grøneng" > <%22jarl%20gr%c3%b8neng%22%20%3cjarl.gron...@gmail.com%3E>> wrote:
>>
>> **
>> Hi
>> This is a DDM instruction file, and you can see that the field mapping
>> using an import-tool format.
>> 
>> > type="data" mode="search" merge-option="update"
>> ignore-required-fields="true" ignore-pattern-matching="true" count="0"
>> disable-related-workflow="true">
>> PASS_QUALIFICATION
>> 
>> 
>> 
>> 
>> > type="2"/>
>> 
>> 
>> Regards,
>> Jarl
>> 2017-04-20 14:48 GMT+02:00 Misi Mladoniczky :
>>
>> **
>> Hi,
>>
>> So RRR|Chive works in a similar way, where matching ids are the default,
>> regardless if it is a custom field or not. Fields can then be
>> mapped/skipped specifically.
>>
>> It sounds like a simple thing to generate rrrchive-config-files based on
>> the mapping-files from DDM!? Any chanse of supplying me with a few
>> DDM-config-files to allow me to check how much work it would take?
>>
>> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>>
>> Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs
>> Find these products, and many free tools and utilities, at http://rrr.se
>>
>> April 20, 2017 1:49 PM, "JD Hood" > <%22jd%20hood%22%20%3chood...@gmail.com%3E>> wrote:
>>
>> **
>> As for custom fields, the in the 7.x version, the default DDM mapping was
>> based on matching field IDs, unless a different mapping was specified. So
>> as long as custom fields had the same field ID between the systems, the
>> data would migrate correctly.
>>
>> So, with DDM migrating between two forms, it would map based on matching
>> field IDs for all fields that were not mapped specifically. So if you
>> looked at the mappings for the specifically mapped fields, it only listed
>> the odd-ball fields that needed to be mapped because their ID's differed
>> (presumably due to version changes). As long as custom fields had the same
>> field ID between the systems (or if you manually edited the DDM mapping to
>> include the custom fields if the ID's differed), the data would migrate
>> correctly.
>> Biggest issue I had with DDM is that it was slow, Slow, SLOOOW.
>> Thanks,
>> -JDHood
>> On Thu, Apr 20, 2017 at 6:19 AM, Vinod Gaidhani > > wrote:
>>
>> **
>> Thanks Misi, seems to be good and overcomes shortcomings of DDM.
>>
>> Vinod.
>>
>> On 20-Apr-2017, at 2:30 PM, Misi Mladoniczky  wrote:
>>
>> **
>> Hi,
>>
>> One big difference between DDM and RRR|Chive is that DDM just finds all
>> records after the date/time you specify and transfer these records.
>>
>> RRR|Chive will pull all recordids and modify-dates from both system and
>> then do transfer/delete as appropriate. No need to specify a date.
>>
>> Because of this it is easy to use to restore a system after, for example,
>> testing.
>>
>> I have been playing with the idea of using the DDM mapping files in
>> RRR|Chive, but have not come around to doing this. So you are pretty much
>> on your own and need to do the mapping yourself.
>>
>> I am not 100% sure about this, but I think that DDM will not copy data on
>> custom fields you have added yourself automatically.
>>
>> I have another tool I like to use when planning migrations to new
>> application versions, and this is RRR|DefFieldDiff that will give you an
>> excel sheet of all changed data fields. This makes it easy to find
>> differences and plan your data massaging.
>>
>> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>>
>>

JOB: Full-time Remedy Developer & Administrator on ITSM and AR 9.x - ActioNet, Inc. Washington, DC

2017-04-24 Thread Eric Chasteen
Hello Listers,

I am looking for a full-time Remedy Developer and Administrator with 9.x
ITSM, and AR platform administrator and developer experience.
SmartReporting and MyIT experience preferred. Full-time ActioNet employee
with benefits, competitive salary, and paid BMC training.  Located at
customer site in Washington, DC. Possible work from remote location. Must
be a US citizen with ability to pass Federal Government clearance.

If interested, please E-mail me at echast...@actionet.com with an
up-to-date resume.

Regards,

Eric Chasteen

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Re: [Non-DoD Source] Re: need input about data migration after Upgrade

2017-04-24 Thread Misi Mladoniczky
Hi,

In other words it actually points to the .ARM file for mapping.

So how is this structured, do you get a set of config/mapping files for each 
supported version transition?

Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 
2011)

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs
Find these products, and many free tools and utilities, at http://rrr.se 
(http://rrr.se)
April 24, 2017 10:01 AM, "Jarl Grøneng"  wrote:

** 
Hi 
This is a DDM instruction file, and you can see that the field mapping using an 
import-tool format. 
PASS_QUALIFICATION
Regards, 
Jarl  
2017-04-20 14:48 GMT+02:00 Misi Mladoniczky :

 **
Hi,

So RRR|Chive works in a similar way, where matching ids are the default, 
regardless if it is a custom field or not. Fields can then be mapped/skipped 
specifically.

It sounds like a simple thing to generate rrrchive-config-files based on the 
mapping-files from DDM!? Any chanse of supplying me with a few DDM-config-files 
to allow me to check how much work it would take?

Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 
2011)

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs
Find these products, and many free tools and utilities, at http://rrr.se 
(http://rrr.se)
April 20, 2017 1:49 PM, "JD Hood"  wrote:

**As for custom fields, the in the 7.x version, the default DDM mapping was 
based on matching field IDs, unless a different mapping was specified. So as 
long as custom fields had the same field ID between the systems, the data would 
migrate correctly.

So, with DDM migrating between two forms, it would map based on matching field 
IDs for all fields that were not mapped specifically. So if you looked at the 
mappings for the specifically mapped fields, it only listed the odd-ball fields 
that needed to be mapped because their ID's differed (presumably due to version 
changes). As long as custom fields had the same field ID between the systems 
(or if you manually edited the DDM mapping to include the custom fields if the 
ID's differed), the data would migrate correctly.
Biggest issue I had with DDM is that it was slow, Slow, SLOOOW. 
Thanks, 
-JDHood 
On Thu, Apr 20, 2017 at 6:19 AM, Vinod Gaidhani  wrote:
 ** 
Thanks Misi, seems to be good and overcomes shortcomings of DDM.

Vinod.  
On 20-Apr-2017, at 2:30 PM, Misi Mladoniczky  wrote: 
**
Hi,

One big difference between DDM and RRR|Chive is that DDM just finds all records 
after the date/time you specify and transfer these records.

RRR|Chive will pull all recordids and modify-dates from both system and then do 
transfer/delete as appropriate. No need to specify a date.

Because of this it is easy to use to restore a system after, for example, 
testing.

I have been playing with the idea of using the DDM mapping files in RRR|Chive, 
but have not come around to doing this. So you are pretty much on your own and 
need to do the mapping yourself.

I am not 100% sure about this, but I think that DDM will not copy data on 
custom fields you have added yourself automatically.

I have another tool I like to use when planning migrations to new application 
versions, and this is RRR|DefFieldDiff that will give you an excel sheet of all 
changed data fields. This makes it easy to find differences and plan your data 
massaging.

Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 
2011)

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs
Find these products, and many free tools and utilities, at http://rrr.se 
(http://rrr.se)
April 19, 2017 2:39 PM, "Murnane, Phil"  wrote:
We've used DDM and RRR|Chive successfully on various projects. Misi's 
tool is scriptable and very fast compared to DDM. DDM can schedule code and 
data migrations. Generally both require the Last-Modified date/time field to be 
accurate. Overall, I'd personally recommend RRR|Chive. 
HTH, 

--Phil  

  From: Action Request System discussion list(ARSList)  on behalf of Nicosia, 
Ryan J. CTR USSOCOM HQ 
Sent: Wednesday, April 19, 2017 8:14 AM
To: arslist@ARSLIST.ORG (mailto:arslist@ARSLIST.ORG)
Subject: Re: [Non-DoD Source] Re: need input about data migration after Upgrade
I have to disagree. We used DDM with great success but it does require admin 
freeze on all deletion activities of your production environment. That said, 
there are ways to get around that as well but purging the form in question on 
your target server and telling DDM to jus

Re: [Non-DoD Source] Re: need input about data migration after Upgrade

2017-04-24 Thread Jarl Grøneng
Hi

This is a DDM instruction file, and you can see that the field mapping
using an import-tool format.

 
   
PASS_QUALIFICATION

 
   


   
  


Regards,
Jarl

2017-04-20 14:48 GMT+02:00 Misi Mladoniczky :

> **
> Hi,
>
> So RRR|Chive works in a similar way, where matching ids are the default,
> regardless if it is a custom field or not. Fields can then be
> mapped/skipped specifically.
>
> It sounds like a simple thing to generate rrrchive-config-files based on
> the mapping-files from DDM!? Any chanse of supplying me with a few
> DDM-config-files to allow me to check how much work it would take?
>
> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>
> Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs
> Find these products, and many free tools and utilities, at http://rrr.se
>
>
> April 20, 2017 1:49 PM, "JD Hood"  <%22jd%20hood%22%20%3chood...@gmail.com%3E>> wrote:
>
> **
> As for custom fields, the in the 7.x version, the default DDM mapping was
> based on matching field IDs, unless a different mapping was specified. So
> as long as custom fields had the same field ID between the systems, the
> data would migrate correctly.
>
> So, with DDM migrating between two forms, it would map based on matching
> field IDs for all fields that were not mapped specifically. So if you
> looked at the mappings for the specifically mapped fields, it only listed
> the odd-ball fields that needed to be mapped because their ID's differed
> (presumably due to version changes). As long as custom fields had the same
> field ID between the systems (or if you manually edited the DDM mapping to
> include the custom fields if the ID's differed), the data would migrate
> correctly.
> Biggest issue I had with DDM is that it was slow, Slow, SLOOOW.
> Thanks,
> -JDHood
> On Thu, Apr 20, 2017 at 6:19 AM, Vinod Gaidhani 
> wrote:
>
> **
> Thanks Misi, seems to be good and overcomes shortcomings of DDM.
>
> Vinod.
>
> On 20-Apr-2017, at 2:30 PM, Misi Mladoniczky  wrote:
>
> **
> Hi,
>
> One big difference between DDM and RRR|Chive is that DDM just finds all
> records after the date/time you specify and transfer these records.
>
> RRR|Chive will pull all recordids and modify-dates from both system and
> then do transfer/delete as appropriate. No need to specify a date.
>
> Because of this it is easy to use to restore a system after, for example,
> testing.
>
> I have been playing with the idea of using the DDM mapping files in
> RRR|Chive, but have not come around to doing this. So you are pretty much
> on your own and need to do the mapping yourself.
>
> I am not 100% sure about this, but I think that DDM will not copy data on
> custom fields you have added yourself automatically.
>
> I have another tool I like to use when planning migrations to new
> application versions, and this is RRR|DefFieldDiff that will give you an
> excel sheet of all changed data fields. This makes it easy to find
> differences and plan your data massaging.
>
> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>
> Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs
> Find these products, and many free tools and utilities, at http://rrr.se
>
>
> April 19, 2017 2:39 PM, "Murnane, Phil"  <%22Murnane,%20phil%22%20%3cphil.murn...@windward.com%3E>> wrote:
>
> We've used DDM and RRR|Chive successfully on various projects. Misi's tool
> is scriptable and very fast compared to DDM. DDM can schedule code and data
> migrations. Generally both require the Last-Modified date/time field to be
> accurate. Overall, I'd personally recommend RRR|Chive.
>
>
> HTH,
>
> --Phil
> --
> *From:* Action Request System discussion list(ARSList) <
> arslist@ARSLIST.ORG> on behalf of Nicosia, Ryan J. CTR USSOCOM HQ <
> ryan.nicosia@socom.mil>
> *Sent:* Wednesday, April 19, 2017 8:14 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: [Non-DoD Source] Re: need input about data migration after
> Upgrade
> I have to disagree. We used DDM with great success but it does require
> admin freeze on all deletion activities of your production environment.
> That said, there are ways to get around that as well but purging the form
> in question on your target server and telling DDM to just pull everything
> over.
>
> Once you get to the point where you are running DDM every few days, the
> errors are easy to identify and clean up and you can re-run a specific
> package as needed.
>
> Ryan
>
> -Original Message-
> From: Action Request System discussion list(ARSList) [
> mailto:arslist@ARSLIST.ORG ] On Behalf Of Mohamed
> Kamruzzaman
> Sent: Wednesday, April 19, 2017 5:50 AM
>