pull information from a spreadsheet(Collection)

[luis.g...@ferreyros.com.pe]

Hello I hope you can help me ; I want to get this information in a spreadsheet and to display it on the interface ; I have understood that I have to download the spreadsheet in CSV format ; but then as under RMP and also how I can invoke the existing information in my spreadsheet and display it in my interface

Thank you

[Bidisha Das]

Hi,

You can directly download the spreadsheet on RMP in CSV format using Add file option in Files tab in Project and then use ${import_objects("file id", "Collection name", ",", "true")} in Process to save the file content in collection.File id will be automatically generated when you add file to the project.

After that,you can configure a Report widget on Web Interface to display the Collection data.Make sure the property name of the fields in Report is same as you save in collection.

Thanks & Regards

Bidisha

[Luis Guerra Palacios]

But   ${import_objects("file id", "Collection name", ",", "true")} the place where I have that ? I have to create a composite API ? connectors for spreadsheets in RMP have disappeared

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to a topic in the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this topic, visit https://groups.google.com/a/runmyprocess.com/d/topic/supportforum/A990w-nNnTo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CAMGV9zsE2CDpkA0%2BxdkmH%3DDasCCwJeXCUTWxGduAa1G3kwi%3D1w%40mail.gmail.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

" Este mensaje ha sido elaborado únicamente para uso de la persona o entidad a la que es remitido, ya que puede contener información personal, confidencial y, de acuerdo a ley, no puede ser difundido. Si el lector de este mensaje no es el destinatario señalado, o la persona responsable para entregar el mensaje a quien está dirigido, advertimos que cualquier divulgación, retransmisión o copia de esta comunicación está estrictamente prohibida. Si usted ha recibido esta comunicación por error, por favor sírvase informarlo de inmediato al remitente por correo electrónico o teléfono y borrar inmediatamente el mensaje original. Finalmente, se deja establecido que el mensaje remitido con nuestro dominio (terminación".... @ferreyros.com.pe") en caso no se refiera a información directamente relacionada con nuestro giro profesional y propósitos del mismo, deberá entenderse como la opinión del remitente, bajo responsabilidad individual de éste, y sin que involucre o comprometa a nuestra organización con dicha opinión o comentario ".

[Bidisha Das]

Hi,

Yes,you can use Connectors for that.But currently, we are re-building the Google connectors as Google's authentication scheme has changed and that is why we have removed the old deprecated connectors from the library.We will publish the new connectors soon and then,they will be available in your account.

So,for the time being, do as I have mentioned above.You need to run the code in a Process after you download the CSV file.It will import the entire data from excel and save into collection.You can then use a report widget on Web Interface to display the collection data.

Thanks & Regards

Bidisha