Story 2 - Mapping Google spread Sheet to Jira (CSV -----> XML) Description - Jiras will be created according to the information exists in the Google spread sheet
Steps 1. Open Developer Studio and Create Maven Multi Module Project 2. User creates ESB Proxy service with ESB project inside the Maven Multi Module project 3. Add Google spread sheet connector operators (login,create spread sheet and create work sheet) into the proxy service. 4. Add Jira connector operators (Init and Query) into Proxy service. 5. Add data mapping mediator into the proxy service. 6. Double click on the data mapper mediator, then the "mapping configuration create dialog" will be opened. 7. User specify the mapping file name and create registry resource project to save the mapping configuration file.(Once user done this step, data mapping editor will be opened). 8. Right click on the input data container in the data mapping editor (left side white box in the editor), and import the input Avro schema (which was created according to Salesforce data structure also user can import from the remote registry 9. Right click on the output data container the data mapping editor (Right side white box in the editor), and import the output Avro schema(which was created according to Google spread sheet data structure) also user can import from the remote registry 10. Do the mapping by connecting input and output fields also relevant operators also added . 11. Go back to the proxy service and add jira connector operators to the Proxy service. 12. Create Composite Application Project inside the Maven Multi Module Project 13. Add the Registry Resource Project and ESB project into Composite Project 14. Build the maven multi module project 15. Deploy the CAR in ESB sever 16. Invoke the proxy service. Above story will be demonstrated during data mapping weekly progress review meeting on Thursday (17/04) Thanks /Jasintha On Wed, Apr 2, 2014 at 1:27 PM, Srinath Perera <[email protected]> wrote: > In 8 and 9 you can select data from type registry as well. > > --Srinath > > > On Wed, Apr 2, 2014 at 12:57 PM, Jasintha Dasanayake <[email protected]>wrote: > >> Story 1 - Mapping SaleForce to Google spread Sheet (XML --> CSV) >> >> Steps >> >> 1. Open Developer Studio and Create Maven Multi Module Project >> 2. User creates ESB Proxy service with ESB project inside the Maven >> Multi Module project >> 3. Add Google spread sheet connector operators (login,create spread >> sheet and create work sheet) into the proxy service. >> 4. Add Salesforce connector operators (Init and Query) into Proxy >> service. >> 5. Add data mapping mediator into the proxy service. >> 6. Double click on the data mapper mediator, then the "mapping >> configuration create dialog" will be opened. >> 7. User specify the mapping file name and create registry resource >> project to save the mapping configuration file.(Once user done this step, >> data mapping editor will be opened). >> 8. Right click on the input data container in the data mapping editor >> (left side white box in the editor), and import the input Avro schema >> (which was created according to Salesforce data structure >> 9. Right click on the output data container the data mapping editor >> (Right side white box in the editor), and import the output Avro >> schema(which was created according to Google spread sheet data structure) >> 10. Do the mapping by connecting input and output fields >> 11. Go back to the proxy service and add Google Spreadsheet connector >> operators(login,import csv) to the Proxy service. >> 12. Create Composite Application Project inside the Maven Multi >> Module Project >> 13. Add the Registry Resource Project and ESB project into Composite >> Project >> 14. Build the maven multi module project >> 15. Deploy the CAR in ESB sever >> 16. Invoke the proxy service. >> >> >> Above story will be demonstrated during data mapping weekly progress >> review meeting on Monday (07/04) >> >> Thanks and Regards >> /Jasintha >> >> >> *Jasintha Dasanayake * >> >> *Software EngineerWSO2 Inc. | http://wso2.com <http://wso2.com/> lean . >> enterprise . middleware* >> >> >> *mobile :- 0711368118 <0711368118> * >> >> _______________________________________________ >> Architecture mailing list >> [email protected] >> https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture >> >> > > > -- > ============================ > Srinath Perera, Ph.D. > http://people.apache.org/~hemapani/ > http://srinathsview.blogspot.com/ > > _______________________________________________ > Architecture mailing list > [email protected] > https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture > > -- *Jasintha Dasanayake* *Software EngineerWSO2 Inc. | http://wso2.com <http://wso2.com/>lean . enterprise . middleware* *mobile :- 0711368118*
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
