Hi, Folks: I have great news. This issue is fixed with a no-name patch. It was suppose to be included in patch 17, but didn't make it. The issue is not officially fixed until it is included in a new patch. Tech support will be escalating this and hope that it will make it in 6.3, patch 18.
Talk at ya later, Michelle -----Original Message----- From: Lucero, Michelle - IST contractor Sent: Monday, July 24, 2006 11:50 AM To: '[email protected]' Subject: RE: Fallback Mapping - Does it work in 6.3 Yep, that's in my original report to Tech support and in my original email way below (albeit kind of long) I'm receiving, "Record 1 : Required field cannot be reset to a NULL value -- Create Date (ARERR 326)", Although I have "Try Fallback Mapping before alerting user" selected, and although I have a Define Fallback mapping defined. The fallback appears to work on all other Required fields besides core fields. Thanks, Michelle -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Monday, July 24, 2006 11:36 AM To: [email protected] Subject: Re: Fallback Mapping - Does it work in 6.3 Out of curiosity ... You do have your Import Preferences Error Handling for Bad Records set to use the Fallback value? -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lucero, Michelle - IST contractor Sent: Monday, July 24, 2006 10:38 AM To: [email protected] Subject: Re: Fallback Mapping - Does it work in 6.3 Hi, Michiel: No go. I uninstalled Admin Tool 6.3, patch 12 and installed Admin Tool 6.3, patch 17. I exported data in .csv format and purposely removed the date/time value from the Create Date column from 2 out of 5 records. I defined fallback mapping to set Create Date field with $ TIMESTAMP$. It yields the same error message: Record 1 : Required field cannot be reset to a NULL value -- Create Date (ARERR 326) For grins, I then hardcoded 07/24/2006 10:30:00 as a fallback mapping value for Create Date. Same results: Record 1 : Required field cannot be reset to a NULL value -- Create Date (ARERR 326) So, it still doesn't work. I haven't tested 7.0 yet. Thanks, Michelle -----Original Message----- From: Lucero, Michelle - IST contractor Sent: Monday, July 24, 2006 9:45 AM To: '[email protected]' Subject: RE: Fallback Mapping - Does it work in 6.3 Hi, Michiel: Remedy Tech Support and I are still working this issue. They've asked me to install ARAdmin 6.3, patch 17. I'll be testing a data import in a few minutes. I'll keep you posted. Thanks, Michelle -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michiel Beijen Sent: Sunday, July 23, 2006 6:59 AM To: [email protected] Subject: Re: Fallback Mapping - Does it work in 6.3 In the release notes there is only one thing that points to Import and actually it is listed under "Server" SW00235418 fix memory leak in ARImport I think you have logged SW00244816 - is this correct? This is still marked as "Work In Progress". We'll wait, I guess. Regards, Michiel On 7/23/06, Lucero, Michelle - IST contractor <[EMAIL PROTECTED]> wrote: > Hi, Michiel: > > I was sent a pre-patch 17 admin Tool/import tool, that was suppose to > address this issue. However, something was wrong with the file they > provided. The fix was suppose to be in 6.3, patch 17. However, I > haven't had a chance to install nor test. > > You might want to check the release notes for patch 17. > > Sorry, I couldn't be of more assistance. > > Thanks, > Michelle > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Michiel Beijen > Sent: Thursday, July 20, 2006 9:59 AM > To: [email protected] > Subject: Re: Fallback Mapping - Does it work in 6.3 > > Michelle, > > Did you got this issue fixed? I just happened to stumble into it today > as well, and we tried to use fallback on a non-core field. > > Regards, > Michiel > > On 5/8/06, Lucero, Michelle - IST contractor > <[EMAIL PROTECTED]> wrote: > > Thank you. That's the definitive answer I was looking for. > > > > However, my tech support person believes that it should. And has now > > been submitted as a bug. I couldn't find anywhere in the > documentation > > that states that core fields can or can't use fallback mapping. > > > > I will follow-up with tech support. > > > > Michelle > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of Steinigans-Hillemann, Joerg > > Sent: Wednesday, May 03, 2006 1:36 AM > > To: [email protected] > > Subject: Re: Fallback Mapping - Does it work in 6.3 > > > > Michelle, > > > > I've had the same problem and my support told me that the fallback > does > > not work on the system fields 'modified by', 'modify date' and 'create > > date'. > > > > Joerg > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] Behalf Of Lucero, Michelle - IST > > contractor > > Sent: Tuesday, May 02, 2006 5:13 PM > > To: [email protected] > > Subject: Re: Fallback Mapping - Does it work in 6.3 > > > > > > Yes, there are multiple workarounds. I simply want to know if the > > fallback mapping really works. More, specifically if it works on core > > fields. > > > > Michelle > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen > > Sent: Tuesday, May 02, 2006 10:11 AM > > To: [email protected] > > Subject: Re: Fallback Mapping - Does it work in 6.3 > > > > Is it possible to update the .CSV file by adding the current timestamp > > for missing values? Then, try to import? > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of Lucero, Michelle - IST > > contractor > > Sent: Tuesday, May 02, 2006 11:08 AM > > To: [email protected] > > Subject: Fallback Mapping - Does it work in 6.3 > > > > Hi, Friends: > > > > I am attempting to import a .CSV file into a brand new (empty) form. > > One of the columns has data in about 85% of the rows. In the cases > > where the data in that column is empty, I want to use fallback > mapping. > > > > I have defined a fallback for the Create Date field and have set it > with > > $ TIMESTAMP$ I have updated the preference setting under > > File/Preference/Error Handling to "Try Fallback Mapping before > alerting > > user". > > I have marked required fields as optional during import (possibly > > irrelevant in this case as it produces the same behavior whether > checked > > or not) > > > > The error that occurs is one that I would expect to receive should I > not > > have a fallback mapping defined: > > "Record 3 : Required field cannot be reset to a NULL value -- Create > > Date (ARERR 326)" > > > > Although, there are work-arounds to this, I simply want to know if > > anyone has successfully used fallback mapping with a .CSV file in 6.3? > > One of the obvious work-arounds I used was to create another date/time > > field. But, my curiosity got the better of me and I made it required. > > I was able to use the fallback mapping with this date/time field. I > > mapped it to the same column that I used for Create Date. So far it > > works for non-core, Required fields. > > > > Specifically, has anyone successfully defined fallback mapping for a > > core date/time field? > > > > ARS Server 6.3, patch 11 > > Remedy Admin/Import Tool 6.3, patch 12 Windows 2003, SQL Server 2000 > > Remedy User Tool 6.3, patch > > > > Thanks in advance, > > Michelle > > > > ESM Mission: "To provide the most accurate, timely, and actionable > > information to our customers so that they can effectively support the > > Mary Kay IST environment". > > > > > ________________________________________________________________________ > > _______ > > 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 > > > > > ________________________________________________________________________ > > _______ > > 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 > > ________________________________________________________________________ _______ > 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 ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
