Import json file to make flows

[Shubham Kandpal]

Hello 

What i am trying to achieve

Excel file content  ---------> Json file format--------->import in rapidpro--------> Create the flow

basically automate the work to create flow directly from excel sheet 

What i had done

I want to automate flow making using the import option given in rapidPro . Till now i had a minimum json file which after importing makes a single message flow . I had also found out to give connection between two messages by keeping uuid same . But the problem is i am not able to found the docs to create a json file and just import it to make a chat bot flow 

Do any one know how to automate flow making from excel ?

[Rowan Seymour]

I've not heard of anyone making flows from Excel files, but all the docs for the flow spec are at https://textit.com/mr/docs/

-Rowan

--
You received this message because you are subscribed to the Google Groups "rapidpro-dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rapidpro-dev...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rapidpro-dev/d3e8c38f-c0e1-46f0-897b-c02cc5cb9a23n%40googlegroups.com.

--

Rowan Seymour | +593 979099233 | @rowanseymour

[Danny Parsons]

Hi Shubham,

We've recently been working on these kinds of things in some of our work. We've created an Excel authoring system for RapidPro which has a simple format for defining flows. The format consists of rows which define messages/controls with a predefined set of columns to fill in. This was inspired by the XLS Form authoring system for ODK, and we wanted to create a simple format which would make it easier to author, edit and update sets of flows within large projects. The Excel files can then be converted to Json files ready for import into RapidPro.

We're using this system in some of our projects which includes defining multiple flows linked to each other, but it's also still under active development and being refined. Our code for this is all open source and we're planning to officially release the system under an open source licence once it's been refined and properly documented. We would be happy to share this with you earlier and explain how we use it if it might be useful to you and you would like to try it out for your project.

Please get in touch if you'd like to know more or discuss.

Thanks,

Danny

To view this discussion on the web visit https://groups.google.com/d/msgid/rapidpro-dev/CAEhK25qbV%2ByKyk4u03KPCCcRn0mH2gTn3ciAOv0oHopLyrUV_g%40mail.gmail.com.

[Shubham Kandpal]

Hi Danny

I am also working on it to achieve such thing but i am stucked in some part. I am interested in knowing the system you are developing and please provide the docs for the same.

[Ramesh Krishnamoorthy]

This is great news Danny and thanks for sharing it. Shubham and I would be really interested in knowing further details on how to use this. If we can help in anyway, our knowledge is limited at this point, let us know.

Thx

K. Ramesh

[Donald Lobo]

Hey shubham

this came up as a "nice to have" with some of the conversations with NGOs for Glific (which uses a forked version of RapidPro's amazing flow editor)

We prototyped a CSV -> flow json for a fixed (but extensible) menu structure for this some time ago. You can peek at the code here:

https://github.com/glific/glific/tree/master/lib/glific/csv

lobo