Create DB in RMP

[maybeg...@gmail.com]

Hi

Do you know how could I create a DB in RMP?

I mean I need to create a "search input widget" and use it to find anything in a DB defined before.

For example: a DB of supliers. Any user can register a web form with the name, address, Code and phone number of the supplier.

But I need that an input widget can compare info with the DB of suppliers, and if the name is the same, autocomplete all the widgets(address, code and phone number).

Could you show me an approach to make this?

I really appreciate it, thanks.

Att:
nes

[Richard Manga]

Hi,

When you want to create a DB in RMP, you just need to create a new collection.

We have an auto-complete widget that allows you to retrieve data as you want.

In the following link, you will find an example that explains exactly what you want to do.

http://docs.runmyprocess.com/Developer_Guide/Web_Interface/Design/Autocomplete_Widget

Regards,

Richard Manga

--
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/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/f112683d-7868-4609-8e4b-e5e4143b65d2%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[maybeg...@gmail.com]

Thanks Richard.

I've created a new collection and I understand how to use the autocomplete widget with the data stored.

But I have a basic question, How could I add info to this collection?, I mean could you show me the easiest way to fill this collection in a basic example?

I don't undestand how the collection works, I know it's a local database for RMP. For example, if I have 2 input fields in a WI, how can I store the info that is registered from an inputtext widget into a determined collection?

I really appreciate it.

att:
Nes

[Richard Manga]

Hi,

If you have two input text fields for example, with variable names "variable_1" and "variable_2", the following code allow you to insert these information inside your collection:

function add_ok(result) {
alert("ok " + JSON.stringify(result));
}

function add_ko(result) {
alert("ko " + JSON.stringify(result));
}

var my_object = {};
my_object.firstname = RMPApplication.get("variable_1");
my_object.last_name =RMPApplication.get("variable_2")


my_object.phone_number = "0666666666";

col_clients.saveCallback(my_object,add_ok,add_ko);

When you use a collection in your web interface, you should click on the tab "Collection" of your web interface design page, and add the collection in your web interface. This will generate automatically and id for your collection (For example, if you add collection "clients" to your web interface, the id generated will be "col_clients").

In the previous example, you will add a record inside your collection "clients". This record has 3 properties: firstname, last_name, phone number.

In the following link, you can find more details about the collections:

http://docs.runmyprocess.com/Developer_Guide/Collection/Collection_JS_Freemarker

Regards,

Richard Manga.

att:
Nes

--
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/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/1444c60c-871b-44af-981f-04e21932e8ea%40runmyprocess.com.

[maybeg...@gmail.com]

Hi Richard.

I did a test but I don't know why I can't visualize the info inside my collection.
I need that the info register in the input fields will be saved when the user click on submit button.

Some image are attached about this.

Thanks!!!
Att: nes

[Richard Manga]

Hi,

From the first screenshot, I see that you insert null values (null = empty) inside the collection. 

So, in your report, there are some rows that are all empty. If you want to put inserted data in the collection, please add a button (register information) that executes script, and associate the scripts that create records in the collection to this button.

Note: The collection report displays the content of your collection (data registered: in your case it's null/empty because you didn't insert any data in the field).

Regards,

Richard Manga.

Att: nes

--
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/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/7df543af-9346-4ec7-af0f-9140bdb98bda%40runmyprocess.com.

[maybeg...@gmail.com]

Thanks for your answer Richard.

I created the button to execute the script, but it still shows nothing on the WI with the report widget that contains the collection.

I attaches more images.

Att:
nes

[Richard Manga]

Hi,

Please can you send me your script?

Regards,

Richard Manga

Att:
nes

--
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/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/0d261e11-4e7d-414e-a2cd-d5b1eeec3032%40runmyprocess.com.

[maybeg...@gmail.com]

Hi Richard
This is the script I put inside my JS register information button.
//

function add_ok(result) {
alert("ok " + JSON.stringify(result));
}

function add_ko(result) {
alert("ko " + JSON.stringify(result));
}

var my_object = {};

my_object.nombre = RMPApplication.get("proveedor_var");
my_object.nit =RMPApplication.get("nit");
my_object.domicilio =RMPApplication.get("domicilio");
my_object.telefono =RMPApplication.get("telefono");

col_proveedores.saveCallback(my_object,add_ok,add_ko);

//

Thanks.
att: nes

[Richard Manga]

Hi,

Your JS is ok. In your web interface, go to the tab "Collections" and check that the collection "proveedores" is added this tab.

If not, add it.

Regards,

Richard Manga.

--
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/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/a9fc217a-5515-4414-a5bf-f525d2ca7ab9%40runmyprocess.com.

[Richard Manga]

Hi,

I added an offer POC (proof of concept) to your account. The problem was that the previous free trial expired.

The free trial will be extended until 23th June.

Can you check if everything is ok now?

Regards

Richard Manga.

[maybeg...@gmail.com]

Thanks for your answer mister Richard

I check the collection tabs in each of the WI, and the "proveedores" as collection is selected, but it still doesn't show anything in the WI report.

Do you know could be the problem?

Thanks.

att:
nes

[Richard Manga]

Hi, 

I make a listCallback (list all objects) in your collection, using the following code:

function ok(result){alert(JSON.stringify(result));}

function ko(){alert("KOOOOOO");}

col_proveedores.listCallback({},{},ok,ko);

In the attached file, you will find the content of all your collection.

The problem was that you didn't include all the properties (columns) of your collection in your report. I did that for you,

So if you open the web interface "Proveedores", you should see all the content of your collection.

Regards,

Richard Manga.

nes

--
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/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/173f916c-25cf-4e9f-a189-d8f50b6b631b%40runmyprocess.com.

[maybeg...@gmail.com]

Thanks Richard

It works now.

I have a question ,how can I sort this info from the latest to the oldest one?, I need that it shows automatically when the WI is opened.
I mean how can I do this in the report widget?

I really appreciate your help.

att:
nes

[Sabine El Rassy]

Hello,

You can add the following code in the Query parameter of your collection report:

{"$query":{},"$orderby":{"your_date_variable_sec":-1}}

Regards,

ᐧ

Sabine EL RASSY

Customer Solutions Engineer

Contact: selr...@runmyprocess.com

Website: Fujitsu RunMyProcess

3 Rue de Gramont 

75002 Paris - France

Mobile   : +33 (0) 6 22 10 64 61

     

Fujitsu RunMyProcess user? Please add a review on GoogleApps Marketplace

Afin de contribuer au respect de l'environnement, merci de n'imprimer ce message qu'en cas de nécessité.

Be environmentally friendly: do not print this email unless it is entirely necessary.

att:
nes

--
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/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/9c399142-10fb-4ff2-b751-1af3bed9e060%40runmyprocess.com.

[maybeg...@gmail.com]

Thanks for your answer Sabine.

So "your_date_variable_sec" should be from another column created like a "timestamp" in the report widget, right?

Or is it more simple? could you show me a simple approach?

Thanks.

[Sabine El Rassy]

You're welcome.

If you don't have a column, you can try the follow:

{"$query":{},"$orderby":{"_id":-1}}

Regards,

ᐧ

Sabine EL RASSY

Customer Solutions Engineer

Contact: selr...@runmyprocess.com

Website: Fujitsu RunMyProcess

3 Rue de Gramont 

75002 Paris - France

Mobile   : +33 (0) 6 22 10 64 61

     

Fujitsu RunMyProcess user? Please add a review on GoogleApps Marketplace

Afin de contribuer au respect de l'environnement, merci de n'imprimer ce message qu'en cas de nécessité.

Be environmentally friendly: do not print this email unless it is entirely necessary.

--
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/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/1cd81a93-6fbd-43cf-9618-a6feefb9976f%40runmyprocess.com.

[maybeg...@gmail.com]

Thanks!!!

It works pretty well.

I'm glad you give me such help :)

att:
nes

[Sabine El Rassy]

You're welcome =)

Regards,

ᐧ

Sabine EL RASSY

Customer Solutions Engineer

Contact: selr...@runmyprocess.com

Website: Fujitsu RunMyProcess

3 Rue de Gramont 

75002 Paris - France

Mobile   : +33 (0) 6 22 10 64 61

     

Fujitsu RunMyProcess user? Please add a review on GoogleApps Marketplace

Afin de contribuer au respect de l'environnement, merci de n'imprimer ce message qu'en cas de nécessité.

Be environmentally friendly: do not print this email unless it is entirely necessary.

att:
nes

--
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/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/95edb72c-33af-483e-96f7-6ca4e3ce0397%40runmyprocess.com.