Create XML file from IFS 9
I need to generate a XML file in IFS-9.
I would like to setup the system to generate a XML file every time a shipment is created for a customer order.
Can I do that with a custom SQL event or is there some internal support for this kind of action in IFS 9.
I've been looking for resources on how to do this but found nothing.
Any hint is most welcome.
Best regards, Kresten
xml plsql ifs-erp
asked Nov 16 '18 at 6:57
KrestenKresten
131113
add a comment |
I need to generate a XML file in IFS-9.
I would like to setup the system to generate a XML file every time a shipment is created for a customer order.
Can I do that with a custom SQL event or is there some internal support for this kind of action in IFS 9.
I've been looking for resources on how to do this but found nothing.
Any hint is most welcome.
Best regards, Kresten
xml plsql ifs-erp
asked Nov 16 '18 at 6:57
KrestenKresten
131113
add a comment |
I need to generate a XML file in IFS-9.
I would like to setup the system to generate a XML file every time a shipment is created for a customer order.
Can I do that with a custom SQL event or is there some internal support for this kind of action in IFS 9.
I've been looking for resources on how to do this but found nothing.
Any hint is most welcome.
Best regards, Kresten
xml plsql ifs-erp
asked Nov 16 '18 at 6:57
KrestenKresten
131113
I need to generate a XML file in IFS-9.
I would like to setup the system to generate a XML file every time a shipment is created for a customer order.
Can I do that with a custom SQL event or is there some internal support for this kind of action in IFS 9.
I've been looking for resources on how to do this but found nothing.
Any hint is most welcome.
Best regards, Kresten
xml plsql ifs-erp
xml plsql ifs-erp
asked Nov 16 '18 at 6:57
KrestenKresten
131113
asked Nov 16 '18 at 6:57
KrestenKresten
131113
asked Nov 16 '18 at 6:57
KrestenKresten
131113
asked Nov 16 '18 at 6:57
KrestenKresten
131113
asked Nov 16 '18 at 6:57
KrestenKresten
131113
131113
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Yes you could do that with a custom event and an event action in IFS. Custom event just creates an Oracle trigger in the background, but it is integrated with the IFS front end through the event screens.
- Create an Oracle directory tied to the folder where you want the XML file to be created.
- Create a custom event on the shipment table
- Create an event action for your event with the action type of Execute Online SQL, you can put your code in there to write the XML file to the Oracle Directory.
answered Nov 28 '18 at 21:45
Brandon FrenchakBrandon Frenchak
376310
add a comment |
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53332882%2fcreate-xml-file-from-ifs-9%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Yes you could do that with a custom event and an event action in IFS. Custom event just creates an Oracle trigger in the background, but it is integrated with the IFS front end through the event screens.
- Create an Oracle directory tied to the folder where you want the XML file to be created.
- Create a custom event on the shipment table
- Create an event action for your event with the action type of Execute Online SQL, you can put your code in there to write the XML file to the Oracle Directory.
answered Nov 28 '18 at 21:45
Brandon FrenchakBrandon Frenchak
376310
add a comment |
Yes you could do that with a custom event and an event action in IFS. Custom event just creates an Oracle trigger in the background, but it is integrated with the IFS front end through the event screens.
- Create an Oracle directory tied to the folder where you want the XML file to be created.
- Create a custom event on the shipment table
- Create an event action for your event with the action type of Execute Online SQL, you can put your code in there to write the XML file to the Oracle Directory.
answered Nov 28 '18 at 21:45
Brandon FrenchakBrandon Frenchak
376310
add a comment |
Yes you could do that with a custom event and an event action in IFS. Custom event just creates an Oracle trigger in the background, but it is integrated with the IFS front end through the event screens.
- Create an Oracle directory tied to the folder where you want the XML file to be created.
- Create a custom event on the shipment table
- Create an event action for your event with the action type of Execute Online SQL, you can put your code in there to write the XML file to the Oracle Directory.
answered Nov 28 '18 at 21:45
Brandon FrenchakBrandon Frenchak
376310
Yes you could do that with a custom event and an event action in IFS. Custom event just creates an Oracle trigger in the background, but it is integrated with the IFS front end through the event screens.
- Create an Oracle directory tied to the folder where you want the XML file to be created.
- Create a custom event on the shipment table
- Create an event action for your event with the action type of Execute Online SQL, you can put your code in there to write the XML file to the Oracle Directory.
answered Nov 28 '18 at 21:45
Brandon FrenchakBrandon Frenchak
376310
answered Nov 28 '18 at 21:45
Brandon FrenchakBrandon Frenchak
376310
answered Nov 28 '18 at 21:45
Brandon FrenchakBrandon Frenchak
376310
answered Nov 28 '18 at 21:45
Brandon FrenchakBrandon Frenchak
376310
376310
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53332882%2fcreate-xml-file-from-ifs-9%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
