​clear list of children via impex

[former_member1013544]

Hi there!

I'm working on an impex who will update a CMSNavigationNode, and I need to clear the current list of children, before put another children's list.

I'm new about creation of impex files and her sintax, how can I make it?

Here i's my current impex:

INSERT_UPDATE CMSNavigationNode;uid[unique=true];$contentCV[unique=true];name;title;parent(uid, $contentCV);children(uid,$contentCV)[mode=append];links(uid, $contentCV);&nodeRef;parentPOS;
;PersonalDetailsNavNode;;Personal Details;Minha Conta;MyAccountNavNode;;;PersonalDetailsNavNode;1
;AddressBookNavNode;;Address Book;Meus Endereços;MyAccountNavNode;;;AddressBookNavNode;2
;OrderHistoryNavNode;;Order History;Meus Pedidos;MyAccountNavNode;;;OrderHistoryNavNode;3
;SignOutNavNode;;Sign Out;Sair;MyAccountNavNode;;;SignOutNavNode;4

Thanks for your time!

[AlexGourdet]

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get most out of your community membership, please consider include a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

• Profile https://developers.sap.com/tutorials/community-profile.html
• Tips for Questions: https://community.sap.com/resources/questions-and-answers
• Consider to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,

Alex

[adiputera]

You don't need to clear the content of children first, just remove [mode=append] from your impex file when you want to replace existing children.

[mode=append] will append to current children, without append mode, impex will replace current children

INSERT_UPDATE CMSNavigationNode;uid[unique=true];$contentCV[unique=true];name;title;parent(uid, $contentCV);children(uid,$contentCV);links(uid, $contentCV);&nodeRef;parentPOS;
;PersonalDetailsNavNode;;Personal Details;Minha Conta;MyAccountNavNode;newChildren1,newChildren2;;PersonalDetailsNavNode;1

[deepak_madan7]

You can use UPDATE instead of INSERT_UPDATE which will update with the latest list that you provide.