quick integration solution for Sugar docs with Mambo/Joomla

[y2chuck]

I created a really quick and dirty mambo component that will grab a list of documents from Sugar. I have Mambo and Sugar integrated using the Sugar cases/registration/bugs components/modules and it works great. The only issue I had was trying to allow us to manage documents in Sugar but make certain docs available through the portal. Here's what I did:

1) added custom dropdown field to the documents page layout labled "available in portal" (yes/no)
2) created a simple PHP page to connect to the Sugar DB and run a query to get all documents that were supposed to show up in the portal.
3) added this "component" to the Mambo database (no there's no install or config options, it's just in the PHP file)
4) used the Mambo UI to add a link to this component and make it available on extranet pages

I'm not a PHP developer by any stretch of the imagination, but this seemed like something really simple I could do instead of trying to write something complicated using SOAP.

I don't know if anybody will find this useful, but thought I'd share it anyway for other folks like me who are not developers but need this type of functionality through a hack method.

I can post the files if anybody wants them...

[juergen]

Sounds cool, let us have a look

Juergen

[y2chuck]

The files are attached, should be simple to understand. It's not very modular right now, but it'd be easy to split it out and there's no config for the mambo "component"

I couldn't figure out how to add a component in Mambo without building an install package so I just did a 1 row insert on the components table with the applicable parameters.

Then I created a menu link to a component through the mambo UI and it worked. I plan to extend it a bit to add support for client specific documents, but that won't happen until I either have time or really need it.

Hope this helps anybody else who wants something really simple....

[bcurlee]

Have you looked any further at adding the ability to publish document on a user-by-user basis? I'd like to see Sugar have the ability to have nested folder in 'documents' so you could publish a specific folder(s) to a user. I'll look at your code and see what I can figure out. Please let me know if you have any further suggestions or work on this.

[y2chuck]

I haven't looked at that type of functionality. I'm not a developer (used to be an ASP developer, but not for a few years). I just hacked this together to fill a business need.

[Krastek]

I can post the files if anybody wants them...

So, can you post files that are functional. I'm not very familiar with php, but I think files you've posted, are only a small part of that, you have created. Am I wrong??
If you have something I can try, post it. I'll be grateful