Back to forum list… Back to How Do I?...

Flatten Transform: [RECORD[@id='rgjlzcrk']] could not be found in document. (2 replies)

Arline Welty
5 years ago
Arline Welty 5 years ago

Looking for help here. Not sure why this flatten transform is failing me. 

I am trying to flatten a simple hierarchy with 2 levels: 1. Customer 2. Orders for that Customer.

I want to update optional fields at the order level in Sage. I first tried to just map the 'Child' records of 'Orders' to the Sage 300 connector, and though the connector reported success, the order optional fields in Sage were not updated.

So I thought maybe there was an issue since I wasn't mapping the 'parent' level of the hierarchy (Customers) to anything in Sage. 

I tried to introduce a flatten transform to flatten out the records and just get one row per Order.

The parent level of the hierarchy was named by IMAN as rgjlzrck. That is the 'Customer' level.

The child level of the hierarchy is 'Orders.'

I have added & removed the Flatten transform a few times but keep getting the same results.

When I just click 'refresh' to view the results of the Flatten transform where rgjlzrck is selected as the top row I get this error:

[RECORD[@id='rgjlzcrk']] could not be found in document.

If I close & re-open the transform I get:

Error whilst loading transform definition.

Error - Record [rgjlzcrk] is invalid.

 

How could this be, as [rgjlzcrk] is the IMAN-assigned name for the parent?

Parent/Child screenshot is attached- this is the map transform that precedes the Filter transform that I'm having issues with.

 

https://www.realisable.co.uk/wp-content/uploads/2019/04/ParentChild.jpg
Support
5 years ago
Support 5 years ago

Arline, try this:

  1. Add the Flatten transform.
  2. Change the Flatten ID drop (if it needs changing).
  3. Press Refresh.
  4. Then change the Transform ID (don't do this before pressing refresh).
Arline Welty
5 years ago
Arline Welty 5 years ago

Thank you- when I did it in that order IMAN did not complain. 

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close