Hello guys, itās been so long since I post or reply here, been busy with other projects but always using suitecrm. Iām stuck in a task and I would like your help, sadly my friend @pgr left the community, maybe he know what I need.
I would like to show in a subpanel under Accounts module that particular account balance getting that info from our ERP, IĀ“ve tried to manipulate the custom subpanel but it seems that it always requires an internal relationship. Tried to replicate the āpurchased productsā subpanel
I donāt think a hook can work this time because thereās no data to retrieve internally, only externally.
What Iām doing currently is an iframe that shows the data from another website but is not what I want.
Mike, I tried a iframe for my situation, but it couldnāt load the page presumably because you need to be a logged-in user to view the page. Couldnāt figure out how to format the url to pass the credentialsā¦ grr. I will keep watching this thread for inspiration =)
do you manage the external web page? if you do, you can configure your parameters to pass some hash as login (not a great thing to do). in my example I pass the Account number as a parameter to get the external data shown in SuiteCRM as an iframe, but I want as a subpanel with the format of suitecrm.
Iād say you have to separate problems to solve here:
1. Getting the data from the external system
This will be a classical āwrite PHP to grab data from an APIā problem. If your system provides a good API, you get clean data (JSON for example). If it doesnāt, then you will need to get HTML and parse it to get the data.
2. Showing it in a subpanel
It should be possible, although Iāve never done it. If you canāt find a way to inject an array directly into the subpanel (which should be possible somehow), you can still try writing your data to a temporary table in the database, so you could then tell the subpanel (through the get_subpanel_data function) the SQL it could use to retrieve it.