maybeg...@gmail.com
I'm trying to import a xml file into a collection, but I'm not sure how to use the correct code here.
First, I upload the xml file into the system via the file tab in a determinated project.
I've already created a collection, but I'm not sure how to import determinated columns from the xml file into this collection.
I know I need to use:
${import_objects(file_id, collection-name [, separator [, drop]] )}
My questions are:
1.In which section should I use this code to import the xml into de collection in live mode?
2. how could I choose determinated columns?, because I don´t want to use all the info of my xml file, only certain columns.
Thanks in advance
Sabine El Rassy
<entry>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Dont forget me this weekend!</body>
</note>
<note>
<to>John</to>
<from>Ronald</from>
<heading>Reminder</heading>
<body>Buy </body>
</note>
</entry>
<#function get_array my_father my_son>
<#if my_father?is_hash>
<#if my_father[my_son]?exists>
<#if my_father[my_son]?is_sequence>
<#assign my_array = my_father[my_son]>
<#else>
<#assign my_array = [my_father[my_son]?eval]>
</#if>
<#else>
<#assign my_array = []>
</#if>
<#else>
<#assign my_array = []>
</#if>
<#return my_array>
</#function>
<#assign my_xml= file_content(your_file_id,'none')>
<#assign my_json = load(my_xml,"XML")>
${get_array(my_json.entry,"note")}
ᐧSabine EL RASSY
maybeg...@gmail.com
Thanks for your answer. So in order to import my XML spreadsheet file(an excel file) to a collection I need to transform this in a array of Json and then iterate it?
I don't know if is there a simpler approach , I mean if I can choose columns from an excel file, and put the info related with each column inside the collection.
I'm not sure if I made myself understood.
Thanks in advance.
att: nes
Sabine El Rassy
maybeg...@gmail.com
In Order to use the tools that are offered by RMP, I converted the xml spreadsheet file into a .CSV file.
So I need to create a JS widget in the collection WI with this code, right?:
${import_objects(file_id, collection-name [, separator [, drop]] )}
Other question, how can I choose determinated columns to save in my collection database?
Thanks you.
att:
nes
Sabine El Rassy
ᐧmaybeg...@gmail.com
I'll make some test and I'll notify you.
Att:
nes
maybeg...@gmail.com
I made some test, but I don't know how to make it working.
I mean, my approach is :
Import a Csv file into a collection ( the simplest way ).
My question is:
At the time I create the composite api, where do I need to configure it to "trigger" and adding the related info?
I need to make this because I'm using an autocomple widge, and it's required to show all the info to the final user, using the info stored in this collection.
I attached some images related to this issue.
att:
nes
maybeg...@gmail.com
The .xml file was converted into .csv file, and then uploaded via a upload widget.
Next with a process ( server side) I can import this .csv file into a collection.
But I have other issue when I tried to show the info in the WI report.
I posted it.
maybeg...@gmail.com
I can give you a complete feedback if you want a more specific explanation.
For purposes to learning.
Thanks.
Sabine El Rassy
ᐧSabine EL RASSY
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/4a6f5751-d7cf-4b93-8ca3-92216b7ae18a%40runmyprocess.com.
--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.