Can you clarify step one? I am exporting the following from HPD:Helpdesk to an ARX file.
1 Incident ID 2 Reported Date 3 Submit Date I open the import tool, and load the form and data. I click 'Add all'. From here I would think I would have to change the mappings so that Reported Date = Submit Date, but following your steps I just change the preference settings to update records and click the start import button. It gives me the following errors: AR System Import Tool Fri Aug 15 17:05:59 2008 **** Did not find any matching fields to add as new mappings (ARWARN 4013) **** Import of d:\documents and settings\matthew.crawford\desktop \report.arx started. (ARNOTE 4001) **** Record 1 : The value(s) for this entry violate a unique index that has been defined for this form -- HPD:Help Desk entry:INC000000042965 fields: 1000000161 1000000079 1000000018 1000000019 1000000080 4 1000000427 1000000063 1000000064 1000000065 200000003 200000004 200000005 240001002 1000000869 1000000875 179 7 301735100 301734000 (ARERR 382) **** DATA "INC000000045876" "" 1218122557 On Aug 15, 2:13 pm, Carey Matthew Black <[EMAIL PROTECTED]> wrote: > M.B. > > I am sure there is a way to fix these records. And I would guess that > one way would be to do something like this: > > 1) Export three columns of data from the effected records to an ARX or CSV > file. > Field 1 (maybe called 'Request ID', 'Entry ID', 'Call ID' or some > other name) > 'reported date' > Field 3 (maybe called 'Create Date', 'Create-date', or some other name) > > * Note if you do not want to set 'reported date' = 'Create Date' then > pick any other field you want from the existing record and export that > data instead of Field 3. > > 2) Use the Import tool to *update* the existing records. > Select the form, select the file that you exported above, and "Map all" > * Note: Configuring the Import tool to update existing records is > found in File(menu) --> Preferences (menu item) --> Duplicate Request > ID (tab) menu of the import tool. > > Barring any strange Merge filters on the form then that simple process > should work. > > -- > 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 Fri, Aug 15, 2008 at 1:16 PM, MCrawford <[EMAIL PROTECTED]> wrote: > > Greetings, > > > About 100 tickets have been created with blank/null reported dates. > > This is causing issues with reporting. Most of the tickets were > > associated with a single user. I have removed and re-created his > > account, and the error appears to be resolved. However, I need to > > know if there is a way to fix the erroneous tickets? > > > Thanks, > > > M.B. > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
