V7.2.1 CRM Dashboard  Topic is solved

Discussions relating to plugin development, and the Jiwa API.

V7.2.1 CRM Dashboard

Postby 2can2 » Thu Dec 12, 2019 9:16 pm

Hi, I want to be able to create another selection on the dashboards for 'CRM Admin Dashboard'. I can then create new st procs to display the same information as the CRM dashboard but NOT be restricted to the Jiwa user. This is for management so they can see the Overall Company Sales funnel, ALL Quotes, etc.
Any help will be appreciated. Thanks.
2can2
Frequent Contributor
Frequent Contributor
 
Posts: 171
Joined: Tue Feb 26, 2008 10:24 am
Topics Solved: 25

Re: V7.2.1 CRM Dashboard

Postby Scott.Pearce » Fri Dec 13, 2019 11:38 am

First, copy and rename the usp_JIWA_Dashboard_Indicator_CRM_* stored procedures. Modify them such that they do not limit the resultset by staff member.

Then, go and look at this sample, and modify it to use your modified stored procs:

viewtopic.php?f=27&t=613
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 742
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 221

Re: V7.2.1 CRM Dashboard

Postby 2can2 » Mon Dec 23, 2019 2:11 pm

Thanks will give it a go.
2can2
Frequent Contributor
Frequent Contributor
 
Posts: 171
Joined: Tue Feb 26, 2008 10:24 am
Topics Solved: 25

Re: V7.2.1 CRM Dashboard

Postby 2can2 » Mon Sep 07, 2020 5:54 pm

Hi, Never did get this additional dashboard created but another client has now requested a similar additional dashboard.
Scott I am not sure what Form I have to add to the Forms to allow this plugin to be added to the menu as a selection.
The plugin states
'An entry will need to be made to the SY_Forms table by opening the Form Maintenance form, and adding the CRM form defined in this plugin. Then quit Jiwa, log back in and add the new form to a menu via the menu maintenance form.'
I can't find any reference to the Form required to be added in this plugin? so can't get any further. When I try and add a form to the Form Maintenance I can't seem to select any forms and not sure where to point it?
Thanks.
2can2
Frequent Contributor
Frequent Contributor
 
Posts: 171
Joined: Tue Feb 26, 2008 10:24 am
Topics Solved: 25

Re: V7.2.1 CRM Dashboard

Postby Mike.Sheen » Mon Sep 07, 2020 6:24 pm

1. Open the Forms maintenance form under System Settings
2. Add a row by selecting the Form Type of Plugin in the drop-down combo
2.png

3. Press the lookup button for the Assembly Full Name - a search window will display showing a list of plugins. Select the CRM Dashboard plugin
3.png

4. in the Class Name drop-down combo, select the CRM class name.
4.png
4.png (8.36 KiB) Viewed 1567 times

5. Save
6. Exit Jiwa and log back in, you can now add this form to a menu via the menu maintenance form.
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2440
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 755

Re: V7.2.1 CRM Dashboard

Postby 2can2 » Fri Sep 11, 2020 12:04 pm

Thanks Mike that worked a treat!
Any chance you have another plugin or can create one for the 'Generic Dashboard' that I can use as a base to modify for a new warehouse dashboard by removing Drs and Sales Graphs, etc?
Thanks
2can2
Frequent Contributor
Frequent Contributor
 
Posts: 171
Joined: Tue Feb 26, 2008 10:24 am
Topics Solved: 25

Re: V7.2.1 CRM Dashboard

Postby Scott.Pearce » Mon Sep 14, 2020 9:55 am

Here you are:

Plugin Generic Dashboard.xml
(390.47 KiB) Downloaded 58 times
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 742
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 221

Re: V7.2.1 CRM Dashboard

Postby 2can2 » Tue Sep 15, 2020 9:50 am

Fantastic, thanks.
2can2
Frequent Contributor
Frequent Contributor
 
Posts: 171
Joined: Tue Feb 26, 2008 10:24 am
Topics Solved: 25

Re: V7.2.1 CRM Dashboard

Postby 2can2 » Tue Sep 15, 2020 10:31 am

Sorry to trouble you again on this issue. Unfortunately the client is still on V175 so this plugin won't compile. I am not sure what to replace 'manager' with - see error list.
Any chance of this plugin for V175? Ta.

Generic dash V721 errors.PNG
Generic dash V721 errors.PNG (33.75 KiB) Viewed 1505 times
2can2
Frequent Contributor
Frequent Contributor
 
Posts: 171
Joined: Tue Feb 26, 2008 10:24 am
Topics Solved: 25

Re: V7.2.1 CRM Dashboard

Postby 2can2 » Thu Sep 17, 2020 12:45 pm

Hi, is it straightforward to get a plugin for the Generic dashboard for V175 and if so should I just try and edit the V721 one?
Thanks.
2can2
Frequent Contributor
Frequent Contributor
 
Posts: 171
Joined: Tue Feb 26, 2008 10:24 am
Topics Solved: 25

Next

Return to Technical and or Programming

Who is online

Users browsing this forum: No registered users and 7 guests

cron