This entry was posted on Friday, February 5th, 2010 at 4:58 pm and is filed under General CRM. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
Sharepoint & CRM 4 – Automatic Company Folder Creation with Sharepoint
Looking at the problems with file storage and CRM i yet again find myself looking for a better way to manage files and file storage through the wonderful CRM Interface. The main premise again sticking to the slogan of everything all in one place.
For this situation we have seperate network fileservers that handle our data storage on the network, and it wouldn’t make sense putting all that information into the CRM Database. Not to mention it isn’t indexable or searchable, so the value add for that would be really low.
The problem that i have ran into is that i do not want to have to change coding that i had previously from another post when my clients switch from Sharepoint Services and full sharepoint server in their Microsoft CRM implmenetations. So i have devised a different way to handle this that will also assist with future CRM 4 (IFD) and offsite Sharepoint Installations.
I first created a custom attribute in Microsoft CRM named SPFOLDER, and placed it on the company tab in Microsoft CRM. This was a simple bit flag that i will use for a CRMworkflow to determine if folders have already been created on our sharepoint server or not for a particular company.
For displaying on the company form you can add a simple check to see if the bit flag is set to yes or no. If it is set to true, then show the folder on the server through a simple iframe in CRM, named SPFiles. (as in the example below)
if (crmForm.all.sti_spfolder.DataValue == true)
{
crmForm.all.IFRAME_SPFiles.src = “http://fileserver/Client%20Data/Forms/AllItems.aspx?RootFolder=%2fClient%20Data%2f” + crmForm.all.accountnumber.DataValue;
}
if (crmForm.all.sti_spfolder.DataValue == false)
{
crmForm.all.IFRAME_SPFiles.src = “http://crmserver1/SPIntegration/default.aspx?accid=” + crmForm.all.accountnumber.DataValue;
}
I have structured the folder storage by account number because we have multiple names for some companies that are similar so i found account numbers work best, but you could adjust for whatever makes sense in your organization. In this example we use Dynamics GP inhouse and it is connected with CRM so the information is populated automagically!!!
So now that we have a simple way to handle how to display the sharepoint data, we simply need to have an event to create the folder structure.
Using a simple http webrequest we can generate these folders into Sharepoint from the data we have, and this will allow us to display the customers specific data folders as well.
HttpWebRequest request = (System.Net.HttpWebRequest)HttpWebRequest.Create(”http://fileserver/Client%20Data/” + lbl_CustomerName.Text + “”);
request.PreAuthenticate = true;
CredentialCache credentials = new CredentialCache();
NetworkCredential netCredentials = new NetworkCredential(”sharepoint”, “Pass@word1″, “MEDTECH”);
request.Credentials = netCredentials;
//Send Request
request.Method = “MKCOL”;
HttpWebResponse response = (System.Net.HttpWebResponse)request.GetResponse();
response.Close();
This will allow you to create company specific storage areas in Microsoft CRM. I have included some pictures as well to display how this looks in CRM on my machine.
89 Responses to “Sharepoint & CRM 4 – Automatic Company Folder Creation with Sharepoint”
Leave a Reply
You must be logged in to post a comment.
July 2nd, 2010 at 2:43 am
Buy:Zocor.Female Pink Viagra.Ventolin.Female Cialis.Prozac.Cozaar.Lipitor.Nymphomax.Zetia.Lipothin.Acomplia.Advair.Wellbutrin SR.Aricept.Amoxicillin.Seroquel.Benicar.SleepWell.Buspar.Lasix….
July 15th, 2010 at 1:52 pm
Buy:Mega Hoodia.Arimidex.Synthroid.Prednisolone.Retin-A.Human Growth Hormone.Actos.Prevacid.Valtrex.Nexium.Petcam (Metacam) Oral Suspension.Zovirax.Accutane.Zyban.Lumigan.100% Pure Okinawan Coral Calcium….
August 29th, 2010 at 8:59 pm
wrangler http://vaire-gvmv.BABYCLOTHESNUT.INFO/tag/wrangler+50+goodyear/ : goodyear…
50…
December 6th, 2010 at 8:14 am
buy@Amoxicillin.com” rel=”nofollow”>.…
Buy:Viagra Super Active+.Viagra Soft Tabs.Viagra Professional.Maxaman.Tramadol.Cialis Super Active+.Super Active ED Pack.Cialis.VPXL.Soma.Cialis Professional.Levitra.Viagra Super Force.Cialis Soft Tabs.Viagra.Propecia.Zithromax….
December 17th, 2010 at 2:19 pm
████████►BUY VIAGRA◀███████…
████████▲▲▲▲▲▲▲▲▲████████…
December 21st, 2010 at 1:35 am
buy viagra canada…
Buygeneric drugs…
December 22nd, 2010 at 1:42 pm
dosage of amoxicillin for respiratory disorder…
Buygeneric drugs…
December 22nd, 2010 at 10:40 pm
cephalexin dosage for dogs…
Buygeneric drugs…
December 23rd, 2010 at 6:34 pm
order cialis in canada online…
Buyno prescription…
December 24th, 2010 at 2:29 am
Cialis discount…
Buyno prescription…
December 24th, 2010 at 11:50 pm
abilify and siezures…
Buynow…
December 27th, 2010 at 10:47 am
Accutane@official.site” rel=”nofollow”>.…
Buywithout prescription…
December 29th, 2010 at 4:06 am
Aldactone@official.site” rel=”nofollow”>.…
Buygeneric drugs…
December 29th, 2010 at 8:56 pm
Amoxicillin@official.site” rel=”nofollow”>……
Buyno prescription…
December 30th, 2010 at 6:17 am
allopurinol@and.coumadin” rel=”nofollow”>……
Buygeneric drugs…
December 30th, 2010 at 5:42 pm
avodart@in.usa” rel=”nofollow”>.…
Buyno prescription…
December 31st, 2010 at 5:59 am
ashwagandha@supplement.now” rel=”nofollow”>……
Buygeneric meds…
December 31st, 2010 at 9:06 am
Azor@official.site” rel=”nofollow”>……
Buygeneric pills…
December 31st, 2010 at 12:52 pm
atarax@and.hives” rel=”nofollow”>.…
Buygeneric drugs…
January 2nd, 2011 at 3:16 pm
Chantix@official.site” rel=”nofollow”>.…
Buydrugs without prescription…
January 3rd, 2011 at 10:22 pm
abilify@anxiety.now” rel=”nofollow”>.…
Buygeneric drugs…
January 4th, 2011 at 3:43 pm
generic@Cialis.now” rel=”nofollow”>.…
Buynow…
January 4th, 2011 at 5:41 pm
generic@Levitra.now” rel=”nofollow”>..…
Buyno prescription…
January 8th, 2011 at 1:39 pm
dicyclomine@and.imodium” rel=”nofollow”>……
Buygeneric drugs…
January 9th, 2011 at 1:46 am
i@am.pregnant.how.often.can.i.take.25mg.of.phenergan.safely” rel=”nofollow”>……
Buygeneric drugs…
January 12th, 2011 at 1:51 am
purchase@effexor.now” rel=”nofollow”>.…
Buyno prescription…
January 21st, 2011 at 3:32 am
Depakote@official.site” rel=”nofollow”>……
Buyit now…
January 21st, 2011 at 5:06 am
Depakote@official.site” rel=”nofollow”>..…
Buygeneric meds…
January 21st, 2011 at 4:13 pm
depakote@classification.now” rel=”nofollow”>..…
Buygeneric drugs…
February 3rd, 2011 at 6:44 am
lisinopril aspirin interaction…
Buywithout prescription…
February 3rd, 2011 at 10:33 am
Zyvox…
Buydrugs without prescription…
February 3rd, 2011 at 4:15 pm
Zyrtec…
Buydrugs without prescription…
February 3rd, 2011 at 7:58 pm
side effects zyprexa overdose breathing autonomic…
Buyno prescription…
February 3rd, 2011 at 10:32 pm
xeloda…
Buynow…
February 4th, 2011 at 2:50 am
xeloda bleeding…
Buygeneric meds…
February 4th, 2011 at 2:01 pm
what is the shelf life of zyrtec…
Buynow it…
February 4th, 2011 at 2:47 pm
e-code for zometa…
Buyit now…
February 4th, 2011 at 7:04 pm
Zoloft…
Buygeneric drugs…
February 5th, 2011 at 10:38 pm
Voltaren…
Buyno prescription…
February 6th, 2011 at 6:46 am
what works better for afib than amiodarone…
Buygeneric drugs…
February 6th, 2011 at 10:00 am
Clindamycin…
Buywithout prescription…
February 6th, 2011 at 3:37 pm
cats zanaflex…
Buydrugs without prescription…
February 7th, 2011 at 12:05 am
xopenex coupon…
Buyno prescription…
February 7th, 2011 at 2:00 am
zyprexa increase eps complaints…
Buyno prescription…
February 7th, 2011 at 3:27 am
Xenical…
Buynow…
February 7th, 2011 at 6:53 am
Xalatan…
Buywithout prescription…
February 7th, 2011 at 11:17 am
Vitamin E…
Buynow…
March 3rd, 2011 at 12:54 am
Zyrtec…
Buyno prescription…
March 3rd, 2011 at 4:31 am
Zofran…
Buygeneric pills…
March 3rd, 2011 at 3:07 pm
can you take zoloft and blood pressure medication together…
Buynow…
March 3rd, 2011 at 7:42 pm
Zyrtec…
Buyit now…
March 4th, 2011 at 6:38 am
Zyrtec…
Buygeneric meds…
March 5th, 2011 at 3:03 am
zyprexa relprevv j-code…
Buygeneric drugs…
March 5th, 2011 at 9:56 am
stopped taking prozac realized i like him…
Buygeneric drugs…
March 5th, 2011 at 11:56 pm
Rogaine…
Buyno prescription…
March 6th, 2011 at 5:03 am
dermatological side effects of rogaine…
Buywithout prescription…
March 6th, 2011 at 10:28 am
Prozac…
Buynow it…
March 6th, 2011 at 12:47 pm
provera 10 days perimenopause…
Buygeneric drugs…
March 6th, 2011 at 10:51 pm
Orlistat…
Buyit now…
March 7th, 2011 at 12:42 pm
Synthroid…
Buygeneric pills…
March 8th, 2011 at 5:23 am
Seroquel…
Buywithout prescription…
March 8th, 2011 at 8:02 am
Prozac…
Buyno prescription…
March 9th, 2011 at 3:09 am
Synthroid…
Buywithout prescription…
March 9th, 2011 at 7:38 pm
natural orgasm enhancer…
Buygeneric meds…
March 9th, 2011 at 9:03 pm
Zyprexa…
Buyno prescription…
March 10th, 2011 at 1:58 am
Purim…
Buyno prescription…
March 10th, 2011 at 11:08 am
Patanol…
Buynow it…
March 10th, 2011 at 1:48 pm
Rogaine…
Buygeneric meds…
March 10th, 2011 at 5:58 pm
Retin A…
Buygeneric meds…
March 10th, 2011 at 8:11 pm
Prozac…
Buygeneric meds…
March 28th, 2011 at 10:03 am
Pyridium@Pyridium.Pyridium” rel=”nofollow”>……
Buygeneric meds…
March 28th, 2011 at 7:50 pm
Tylenol@Tylenol.Tylenol” rel=”nofollow”>……
Buygeneric meds…
March 28th, 2011 at 9:28 pm
Topamax@Topamax.Topamax” rel=”nofollow”>.…
Buyit now…
March 28th, 2011 at 11:00 pm
Tetracycline@Tetracycline.Tetracycline” rel=”nofollow”>……
Buyno prescription…
March 28th, 2011 at 11:47 pm
Zoloft…
Buynow it…
March 29th, 2011 at 4:37 am
Prozac@Prozac.Prozac” rel=”nofollow”>……
Buynow…
March 29th, 2011 at 4:35 pm
Pulmicort@Pulmicort.Pulmicort” rel=”nofollow”>..…
Buyit now…
March 29th, 2011 at 11:12 pm
Prozac@Prozac.Prozac” rel=”nofollow”>……
Buygeneric drugs…
March 30th, 2011 at 1:15 pm
Strattera@Strattera.Strattera” rel=”nofollow”>……
Buynow it…
March 30th, 2011 at 8:37 pm
Cymbalta@Cymbalta.Cymbalta” rel=”nofollow”>.…
Buyit now…
March 30th, 2011 at 11:52 pm
Prozac@Prozac.Prozac” rel=”nofollow”>.…
Buywithout prescription…
March 31st, 2011 at 12:50 am
Cozaar@Cozaar.Cozaar” rel=”nofollow”>.…
Buynow it…
March 31st, 2011 at 11:07 am
Cipro@Cipro.Cipro” rel=”nofollow”>..…
Buygeneric meds…
March 31st, 2011 at 12:21 pm
Cialis@Cialis.Cialis” rel=”nofollow”>..…
Buyno prescription…
April 1st, 2011 at 12:07 pm
do@you.need.to.fast.for.prograf.levels” rel=”nofollow”>……
Buywithout prescription…
April 1st, 2011 at 1:38 pm
.…
Buydrugs without prescription…
April 1st, 2011 at 7:34 pm
cms@coverage.of.pulmicort.respules.j7627” rel=”nofollow”>.…
Buygeneric pills…
April 1st, 2011 at 11:53 pm
dapple@hydrocortisone.cream” rel=”nofollow”>……
Buyit now…
April 2nd, 2011 at 6:29 am
purpose@of.advair” rel=”nofollow”>.…
Buygeneric meds…