Back to connectors… Back to Sage 300...

How do I update a field in Sage with a blank value from the data source? (1 reply)

D Dunn
7 years ago
D Dunn 7 years ago

I have a XML file with three address fields.  If my ARCUS record contains:

123 Main Street

Top Floor

(blank)

and my XML file now contains:

567 Second Street

I'm having a hard time getting the second address line in Sage to be blank.  Right now, in ARCUS, I end up with:

567 Second Street

Top Floor

(blank)

I've tried forcing a blank space on to the end of the field in a Map transform:

trim(%address2) & " "

but that doesn't seem to work.

Any ideas?

D Dunn
7 years ago
D Dunn 7 years ago

Resolved.  Malformed XML.

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