Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Sign up

Sign up | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
Importing / updating people -- updating primary phone number.
September 3, 2010
1:42 pm
Avatar
Dave
Member
Members
Forum Posts: 13
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

I set up everything to import people using the MXPERSONInterface. For the most part things work like I would expect... except for the primary phone number.

 

On the first import the primary phone number gets set.

On the second import if the person's phone number is different I get an index error. It's not marking the other phone numbers as not primary.

 

Is there a way tell the MIF that the number I'm importing it the primary.

 

Being new to the MIF my first thought is to clear the primary flag before I populate the interface tables.

 

Since I don't care/want the old phone number I could just delete the primary phone number record.

 

Is there a way to set this up inside the MIF?

September 3, 2010
2:05 pm
Avatar
Dave
Member
Members
Forum Posts: 13
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

I have the same issue with email address.

September 3, 2010
2:08 pm
Avatar
Chon
Stoneham, MA USA
Admin
Forum Posts: 1090
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

Hello, Please register to see the Admin's answer!

September 3, 2010
2:11 pm
Avatar
Dave
Member
Members
Forum Posts: 13
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

That is what I'm using.

September 7, 2010
6:10 pm
Avatar
Dave
Member
Members
Forum Posts: 13
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

I figured it out. On the intergration table:

PRIMARYPHONE = NULL

PHONENUM = Your cool new phone number

PHONE_ISPRIMARY = 1

 

Same with the email:

EMAIL_ISPRIMARY = 1

 

Then it works like I would expect.

May 6, 2011
5:34 am
Avatar
manasa
Member
Members
Forum Posts: 5
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

hi Chon,

            thnks a lot for your help.. i was looking for updating the values in Maximo Inventory application.After adding the  Addchange value it is allowing me to update the values..

 

cheers

manasaCool

Forum Timezone: America/New_York

Most Users Ever Online: 54

Currently Online:
1 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

madd0g17: 59

sun kim: 59

v.barsamov: 51

Maximofresher: 44

cgregory: 42

matta0990: 33

Member Stats:

Guest Posters: 0

Members: 13527

Moderators: 0

Admins: 3

Forum Stats:

Groups: 1

Forums: 8

Topics: 1526

Posts: 4191

Newest Members:

Sheri Grazier, subha Guin, Rod Burchby, osangole, Kathy Donahoe, Hassie Okeefe

Administrators: Chon: 1090, kristensibilia: 0, Joe Grassia: 0