On 3/17/06, Sullivan, Neil G CTR USAF AFRL/SNOX
wrote:
> **
>
> Ok folks, here's your laugh for the day:
>
> I screwed up and imported a csv file with the Request ID value of only four
> characters instead of adding the leading zeros. Now my update existing
> records doesn't work. Any ideas on how I can generate a new Request ID
> using the same values without having to export and reimport?
>
> Neil "Sully" Sullivan
> Remedy Developer/Administrator
> AFRL/SNOX
> Wright Patterson AFB, OH 45433
> 937-904-9788

"Now my update existing records doesn't work. Any ideas on how I can
generate a new Request ID using the same values without having to
export and reimport?"

Can you elaborate?

Use sql to fix the data. As long as the EID matches in the T,H,B
tables, things will work as expected, so long as you don't store
references to that EID in any other forms.

I would share the sql to correct the data, but you did not include any
version info/db info with your post.

Axton Grams


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org

**
You know its Friday when....

Which form Neil and like Axton said, which database?

James McKenzie


-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]On Behalf Of Sullivan, Neil G CTR USAF AFRL/SNOX
Sent: Friday, March 17, 2006 12:47 PM
To: arslist@ARSLIST.ORG
Subject: Request ID Repair


**

Ok folks, here's your laugh for the day:

I screwed up and imported a csv file with the Request ID value of only four characters instead of adding the leading zeros. Now my update existing records doesn't work. Any ideas on how I can generate a new Request ID using the same values without having to export and reimport?

Neil "Sully" Sullivan
Remedy Developer/Administrator
AFRL/SNOX
Wright Patterson AFB, OH 45433
937-904-9788

20060125This posting was submitted with HTML in it

20060125This posting was submitted with HTML in it

**

Ok folks, here's your laugh for the day:

I screwed up and imported a csv file with the Request ID value of only four characters instead of adding the leading zeros. Now my update existing records doesn't work. Any ideas on how I can generate a new Request ID using the same values without having to export and reimport?

Neil "Sully" Sullivan
Remedy Developer/Administrator
AFRL/SNOX
Wright Patterson AFB, OH 45433
937-904-9788

20060125This posting was submitted with HTML in it

On 3/17/06, McKenzie, James J C-E LCMC HQISEC/L3
wrote:
> **
> You know its Friday when....
>
> Which form Neil and like Axton said, which database?
>
> James McKenzie


Yea yea yea, I've got an early start on my St Paddys day celebrations. he he he

Axton


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org

**

Axton:

Enjoy but not too much. We want you back on Monday, fully functional.

James McKenzie


-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Axton
Sent: Friday, March 17, 2006 1:39 PM
To: arslist@ARSLIST.ORG
Subject: Re: Request ID Repair


On 3/17/06, McKenzie, James J C-E LCMC HQISEC/L3
wrote:
> **
> You know its Friday when....
>
> Which form Neil and like Axton said, which database?
>
> James McKenzie


Yea yea yea, I've got an early start on my St Paddys day celebrations. he he he

Axton


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org

20060125This posting was submitted with HTML in it

Hi Sully,

You can use our rrrChive-tool to accomplish this with a config similar to
this:
sourceserver = myserver
sourceuser = Demo
sourcepassword =
sourceform = myform
targetserver = myserver
targetform = myform
qual = '1' LIKE "[0-9][0-9][0-9][0-9]"
transfertype = MOVE
entryidmode = 000000000000000
verifydata = YES
verifyattachments = YES
logfile = rrrchive.log
loglevel = INFO
progressbar = YES

This will export, change the entryid, import and your record in one pass.

If you have a unique index or something that would prevent creation of the
target record before the source has been removed. Change the two
verify-options to NO, and the source record will be removed before the
target is imported.

If you are using version 6.x fields, please drop me an email, and I will
supply a version 6.x-compliant version of rrrChive.

Best Regards - Misi, RRR AB, http://www.rrr.se

> Ok folks, here's your laugh for the day:
>
> I screwed up and imported a csv file with the Request ID value of only
> four
> characters instead of adding the leading zeros. Now my update existing
> records doesn't work. Any ideas on how I can generate a new Request ID
> using the same values without having to export and reimport?
>
> Neil "Sully" Sullivan
> Remedy Developer/Administrator
> AFRL/SNOX
> Wright Patterson AFB, OH 45433
> 937-904-9788
>
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org