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_TopicIcon
Location hierarchy import
August 20, 2010
4:38 am
Avatar
kikkauz
Member
Members
Forum Posts: 16
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Hello

 

I'm trying to figure outwhich is the best method to import from an external system a location hierarchy. The hierarchy will be a 2/3 levels hierarchy. something like:

site

|

+-group1

      |

      +-location

      |

     
+-location

+-location

....

so a physical location can be at the second or at the third level.

Could someone please suggest me which can be the most appropriate way of importing a structure like this?

Thanks in advance!

Francesco

August 20, 2010
9:13 am
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!

August 23, 2010
6:47 am
Avatar
kikkauz
Member
Members
Forum Posts: 16
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Thanks Chon

I'm trying to import data using an interface table.

I created an object structure  that is done by locations and lochierarchy and created the corresponig table and completed all the necessary steps (fyi I already have a process to import assets via interface table and it works).

I tried to import a location for a test and name of the location is XXX721956 but it didn't work and in the message reprocessing I found:

BMXAA2665E - Location XXX721956 is not a valid operating location.

I cannot find any other clue. Do you have any advice for me?

I can easily create manually the location.

thanks in advance.

August 23, 2010
10:19 am
Avatar
kikkauz
Member
Members
Forum Posts: 16
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Hello

I managed to do it but it's really strange. I cannot import the location and the relation in the same transaction (that is to say with the same transid).

If I first make it process the location and the the relation everything works fine.

I cannot understand why. Maybe it's link to the way the DB manage transactions.

 

Thanks anyway

 

Francesco

August 23, 2010
10:34 am
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!

August 24, 2010
4:15 am
Avatar
kikkauz
Member
Members
Forum Posts: 16
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Hello Chon

thanks for your reply. This is exactly how I tried to do.

The parent location exists and the system as well.

The Object Structure is done by LOCATIONS and LOCHIERARCHY thus the corresponding interface table is done by the two tables together.

Following you tutorial I'm inserting the data about the location and about the lochierarchy in 2 different lines. If I use only one transid and transeq 1 for the location and 2 for the hierarchy I get the error. If I use 2 different transid it works perfectly.

As I told in a previous script maybe it's how transactions are configured in the oracle db. I will check and let you know.

 

Best,

 

Francesco

February 14, 2011
4:09 pm
Avatar
qsiraut
Member
Members
Forum Posts: 3
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Chon,

 

I am trying to follow your tutorial/template for loading location hierarchies... I am struggling with the following: how to import a location that has parent in multiple systems? i.e. LOCATION1 is the child of PARENT1 in the PRIMARY system but it is also the child of PARENT2 in the NETWORKSYS (network system).

I can load LOCATION1 as the child of PARENT1 in PRIMARY: it does create LOCATION1 and the link between LOCATION1 and PARENT1.

But if I add another row in the Excel file to load it as the child of PARENT2, it doesn"t work: I mean, no errors, but no relationship created neither!

Can you advise?

I am using MXOPERLOC (with Sync verb) as recommended. 

I am fine with building another structure or using XML load if it helps...

Thanks 🙂

February 14, 2011
4:29 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!

February 14, 2011
4:52 pm
Avatar
qsiraut
Member
Members
Forum Posts: 3
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Thanks for the quick response.

 

In your spreadsheet, there is already the SYSTEMID column....

I just did a quick test: export the MXOPERLOCInterface... since I have relationships between locations in multiple systems (created manually using the UI), I should see the corresponding records... which is not the case. It seems that MXOPERLOC only takes care of the primary system.

 

I think I need to create a new object structure that includes LOCATION and LOCHIERARCHY, but I am not sure which relationship to leverage... so far I wasn't able to export LOCATION & LOCHIERARCHY in the same file in a meaningful manner.

Please let me know if you think of anything, I will let you know my findings if not.

 

Thanks

February 14, 2011
5:07 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!

February 14, 2011
5:11 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!

February 15, 2011
3:24 am
Avatar
qsiraut
Member
Members
Forum Posts: 3
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Chon,

I think I got it to work. FYI, here is what I did:

- Create a new object structure that links LOCATION and LOCHIERARCHY. LOCATION being the parent object and the relationship being LOCHIERLOCONLY (lists all hierarchy entries for a given location, regardless of the system)

- Expose this OS through an Enterprise Service

- Associate it with an external system (MXFLATFILE endpoint in my case)

The object structure should of course include the PARENT and SYSTEMID fields from LOCHIERACHY (mandatory anyway)

 

I'll do more testing, but I was able to import one location that has two parents in two different systems (PRIMARY and SECONDARY network system).

Cheers,

February 15, 2011
9:31 am
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!

February 4, 2015
4:47 pm
Avatar
Shadraq
Member
Members
Forum Posts: 24
Member Since:
May 3, 2016
sp_UserOfflineSmall Offline

I realize I'm posting roughly 18 months late but just in case someone else stumbles onto this article: one thing to keep in mind when designing your Object Structure is that the Location.Lochierarchy object in qsiraut's example needs to have its "Object Order" set to two (2) as opposted to one (1) as is defaulted when clicking "New Row". This will mitigate an error about updating the PRIMARY system.

v7505

January 27, 2016
12:24 am
Avatar
suresh
Member
Members
Forum Posts: 7
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Hello, how do I modify the existing 'Parent' with 'NewParent' field using bulk upload sheet?

Using application import feature and spreadsheet, I'm unable to change the parent field. Please shed somelight.

However manually it is allowed. 

Thanks. 

January 27, 2016
12:49 am
Avatar
suresh
Member
Members
Forum Posts: 7
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

this link has the answer... 

http://www-01.ibm.com/support/.....wg21580211

Thanks. 

Forum Timezone: America/New_York

Most Users Ever Online: 54

Currently Online:
1 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

sun kim: 60

madd0g17: 59

v.barsamov: 51

Maximofresher: 44

cgregory: 42

matta0990: 33

Member Stats:

Guest Posters: 0

Members: 13573

Moderators: 0

Admins: 3

Forum Stats:

Groups: 1

Forums: 8

Topics: 1528

Posts: 4195

Newest Members:

Alan Drake, Ibrahim Abdalla, denwercarlyson, workspaceboyyy, kennylittleboy, Lori Wilson

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