Who's On?

	Membership:
	Latest: Saef
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5226

	People Online:
	Visitors: 256
	Members: 0
	Total: 256

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

mx10 interface

5 Replies

1 Subscribed to this topic

43 Subscribed to this forum

Sort:

Author

Messages

Matt

New Member

Posts: 3

5/14/2013 6:23 PM

We're currently trying to mockup creating an org hierarchy using attributes on accounting units. Our levels are all messed up in GLNAMES and we aren't going to be fixing that anytime soon.

So my question is, can we somehow externally interface with mx10 to either create a manual or dynamic list? Update that list? I'm not seeing anything out of the box that allows such interaction. Am I missing anything?

John Henley

Posts: 3353

5/14/2013 7:37 PM

I think you should be able to use a combination of the AUMXCONV conversion/interface table and GL162 conversion program to set up the attributes for the desired accounting units, and then use the MX500 list member population program to create a list.

Matt

New Member

Posts: 3

5/14/2013 8:40 PM

We are/plan on using aumxconv to populate the attributes. I'm unfamiliar with mx500 though. After reading about it I think it provides the inverse of what we need. Though I could be wrong. We need a way to create/update lists on a scheduled batch from aumxvalue attributes.

So like...

gl20 / glnames accouting unit = 1111111111

gl20.7 aumxvalue matrix cat = division, matrixvalue = marketing

mx10 / mxlistmbr listtype=acctu, listname = mylist, attribute = division, fromval = marketing, toval=marketing

We need a way to keep that list up to date via external interface.

John Henley

Posts: 3353

5/14/2013 8:56 PM

I think your external interface just needs to keep the attribute values updated, and you can use an automated list, probably will want to use MX123 after re-loading just to make sure, but I don't see why you would even need a manual list. If all you are doing is generating a list based on an attribute value, that's already built in...

Matt

New Member

Posts: 3

5/14/2013 10:25 PM

No we cant unfortunetly...

As what if in that example above the attribute for the AU changes division = "accounting" and there isn't an "accounting" list. We'd need to create a new list programatically somehow using the division attribute where equals accounting.. That's where I was hopeing there was some type of interface into lists/mx10/mxlistmbr.

John Henley

Posts: 3353

5/16/2013 4:48 PM

You can create the list, and based on attribute value, it will populate automatically.
Assuming the DIVISION attribute has been created on the accounting unit (ACCTU object type).
On MX10.2 : create new list for object type ACCTU; call the list ACCTG
On MX10.1, inquire on the new list (object type ACCTU; list ACCTG).
On the first row, Select 'A' for FC, select the DIVISION Attribute, and enter ACCOUNTING as the value
Click Change on the form
On MX10.2, inquire on the new list (object type ACCTU; list ACCTG), and click the Preview button.