Log In
Sign up
Home
Topic RSS
Related Topics
3:00 am
August 7, 2013
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
8:16 am
March 2, 2009
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.
12:16 pm
August 7, 2013
Offline
Ouch…
So nothing is ready out of the box then 🙁
I'll give it a try.
Thanks.
12:23 pm
August 7, 2013
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.
1:06 pm
March 2, 2009
Offline
You could also restrict or unrestrict attributes from within Maximo if you don't have access to the database
4:47 pm
August 7, 2013
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?
11:47 am
August 7, 2013
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
2:06 am
August 7, 2013
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?
8:50 am
March 2, 2009
Offline
Have you tried creating your own object yet?
3:12 am
August 7, 2013
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.
7:33 am
March 2, 2009
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.
7:46 am
August 7, 2013
Offline
🙂
My ultimate goal is to create Persons, Persongroups, Users & Usergroups through webservices.
Thanks.
8:02 am
March 2, 2009
Offline
Maximo 7 right?
8:16 am
March 2, 2009
Offline
But first, have you seen this post on creating MXPERSON object structure with web services with MIF?
8:40 am
August 7, 2013
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
10:30 am
March 2, 2009
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!
10:39 am
August 7, 2013
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.
12:15 pm
March 2, 2009
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.
3:45 pm
August 7, 2013
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…
4:02 pm
March 2, 2009
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.
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, ChonAdministrators:
