need a way to attach files to a customer's profile

[atilla.gahbro]

we use the notes section to copy and paste the contents of txt files we had been maintaining on our customers on a company server but still can not figure out a way to store files (pdf, xls) files in a customer's profile.

files like network maps, call flows, etcetera

a feature to attach files to a customer's profile would be very helpful.

[Zorro67]

Hi, its a great idea, and already exists as a hack (backend only)
http://forum.whmcs.com/showthread.php?t=14398

Works really nicely.

obviously if a client attaches files in emails you'd need to save to your hard drive and attach in the backend.

A nice addition to this would also be to associate attachments that are send from within tickets, however, thats just my wishful thinking ;)

[atilla.gahbro]

we use another telecom billing system that has an internal support module and they have that feature where we can click on "add to client assets" as they call it

but the app is closed off from everything else we run so we dont use it for support

do you run the hack? does it work well?

we are needing it foir internal use only for the most part so it may be just what we need.

[Zorro67]

Yes Atilla,
Often we get emails from clients (rather than tickets), such as a design brief, that we then send out to 3rd parties, so its great to have that version of the document effectively 'locked off' for that client

happy with it, apart from a couple of small issues (not major)
1. can't yet delete documents from the list, and
2. after uploading the success message shows in the main screen, so have to press the back button.
3. would like to see a list of attachments in the actual summary page, rather than just a 'view documents' link

if I get around to addressing these issues, will repost the code to the original thread (with cedit tot the original poster)

[atilla.gahbro]

zorro,

it sounds like aside from the slight quirkiness its perfect for what we need to do

i looked at tom's original post and in the txt file i see:

***
1. Create table for uploads:

CREATE TABLE IF NOT EXISTS `upload` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL,
`name` varchar(30) NOT NULL,
`type` varchar(30) NOT NULL,
`size` int(11) NOT NULL,
`content` mediumblob NOT NULL,
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=50 ;
***

is this referring to creating a table in mysql or is this actual code that needs to be put somewhere?

[Zorro67]

mysql, done from phpmyadmin

[steveglenn01]

Great stuff. Nice to read some well written posts that have some relevancy!