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

No permission to create posts
sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
Create Person Group - respartyseq
September 28, 2010
3:00 am
Avatar
Robert
New Member
Members
Forum Posts:
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Hello,

I'm trying to create Person Groups using webservices.

One of the fields Maximo insists I fill in is the sequence – respartyseq.

 

But I'm not really interested in this field, especially in the future when I'll be adding more users to the group.

 

Is there any way of telling Maximo “just add one to the highest existing sequence”?

I'd like to avoid using code or SQL as much as possible – just the regular MXPersonGroup Web Service.

 

Thanks,

Robert

September 28, 2010
8:16 am
Avatar
Chon
Stoneham, MA USA
New Member
Forum Posts:
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

It looks to me like you are trying to use the Migration Manager object structure.  Instead of using that object structure, you need to create your own object structure for PERSONGROUP.  The persongroup object should only have a few fields in it.

September 30, 2010
12:16 pm
Avatar
Robert
New Member
Members
Forum Posts:
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Ouch…

 

So nothing is ready out of the box then 🙁

 

I'll give it a try.

 

Thanks.

October 1, 2010
12:23 pm
Avatar
david_grimes
New Member
Members
Forum Posts:
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

you may need the following:

 

update maxattribute set restricted=1 where objectname='xxx' and attributename='yyy';

update maxattributecfg set restricted=1 where objectname='xxx' and attributename='yyy';

commit;

 

NOTE: Use this for cases where you need the system to use the seq value that's automatically generated by the database (and the MIF is requiring a value to be provided within the data coming into the system).  For custom tables, the restricted flag can be set at the time the table is originally created.

October 1, 2010
1:06 pm
Avatar
Chon
Stoneham, MA USA
New Member
Forum Posts:
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

You could also restrict or unrestrict attributes from within Maximo if you don't have access to the database

October 1, 2010
4:47 pm
Avatar
Robert
New Member
Members
Forum Posts:
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

So because I set the fields to restricted, Maximo knows that it needs to invent values for them?

 

How is the business logic for the values of the fields defined?

 

I mean, how does Maximo know that respartyseq needs to advance by one for each person?

October 2, 2010
11:47 am
Avatar
Robert
New Member
Members
Forum Posts:
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

I've found this http://www.ibm.com/developerwo…..dID=272720 which seems to have the answer to my question.

 

Haven't had a chance to do any testing myself yet, I'll keep you informed.

Robert

October 4, 2010
2:06 am
Avatar
Robert
New Member
Members
Forum Posts:
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Doesn't work…

 

The autonumber field for RESPARTYSEQ is empty and greyed out, I can't add a sequence for it.

Any other ideas?

October 4, 2010
8:50 am
Avatar
Chon
Stoneham, MA USA
New Member
Forum Posts:
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

Have you tried creating your own object yet?

October 5, 2010
3:12 am
Avatar
Robert
New Member
Members
Forum Posts:
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Chon said:

Have you tried creating your own object yet?


I created a new object, by duplicating the migration manager object and changed “consumed” to integration instead of migration.

 

I kept the same java class.

October 5, 2010
7:33 am
Avatar
Chon
Stoneham, MA USA
New Member
Forum Posts:
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

So what is your ultimate goal?  Is it to insert a new person group thru web services?  I can write up a quick tutorial on that if that is the case.

October 5, 2010
7:46 am
Avatar
Robert
New Member
Members
Forum Posts:
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

🙂

 

My ultimate goal is to create Persons, Persongroups, Users & Usergroups through webservices.

 

Thanks.

October 5, 2010
8:02 am
Avatar
Chon
Stoneham, MA USA
New Member
Forum Posts:
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

Maximo 7 right?

October 5, 2010
8:16 am
Avatar
Chon
Stoneham, MA USA
New Member
Forum Posts:
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline
October 5, 2010
8:40 am
Avatar
Robert
New Member
Members
Forum Posts:
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Yes, certainly.

It's a very useful post.

 

I am creating all these objects with webservices, I simply have a few problems with specific things like the sequence numbers in PersonGroup.

 

Robert

October 5, 2010
10:30 am
Avatar
Chon
Stoneham, MA USA
New Member
Forum Posts:
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

I have just created a step by step to create a Person Group object and a web service to import new groups.  Hope this helps!

October 5, 2010
10:39 am
Avatar
Robert
New Member
Members
Forum Posts:
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Thanks Chon,

But like I said, I've gotten past that stage.

 

I can create PersonGroups without any trouble. The problem is that I have to put the value of respartyseq into the XML.

I'm trying to avoid that and let the system autonumber the sequence for me.

October 5, 2010
12:15 pm
Avatar
Chon
Stoneham, MA USA
New Member
Forum Posts:
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

Do you want it to auto increment or is a NULL value enough for you?  If you want it to auto increment, then you would probably have to write a cust java User Exit class.  If you don't care or just want a NULL value in the seq, then you could always go into the database configuration and set the RESPPARTYSEQ field to NOT REQUIRED.  Out of the box that field is required.  I just tried it and I could import but the sequence value is set to NULL.

October 5, 2010
3:45 pm
Avatar
Robert
New Member
Members
Forum Posts:
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

I tried that too, but I'm worried about the null value.

 

Doesn't the sequence number have any meaning?

Won't there be problems down the line?

 

I'd rather not go into writing Java…

October 5, 2010
4:02 pm
Avatar
Chon
Stoneham, MA USA
New Member
Forum Posts:
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

I believe the sequence number is really used to set the order of importance of who's responsible.  If that doesn't matter, then the sequence number may be irrelevant.  But don't quote me on that one. I would fully test it before moving it to production.

One question, how come you cannot set that sequence number from whatever system is sending this information?

Without writing java code, it probably won't be possible unless the sender is the one setting the sequence value.

No permission to create posts
Forum Timezone: America/New_York

Most Users Ever Online: 54

Currently Online:
13 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 0

Members: 0

Moderators:

Admins:

Forum Stats:

Groups: 1

Forums: 8

Topics: 1580

Posts: 4296

Newest Members:

david_grimes, Robert, vkumar, Jeffery Dean, maximomax, Chon

Administrators: