Multiple Workflows on SP 2010 List Item

I have developed an Incident Reporting site for a client that has multiple workflows attached to a list. There are 11 total workflows here that email out various stages of an Incident. There are also associated user workflows that setup a column with all users associated with the Incident.

I developed this separately, and with a column that flags when the notification is sent. When each notification is sent, I updated the list item to the notification won’t be sent again.

similar to:

If IncidentAwaitingApprovalNotification = “Yes” Email user then Update List Item Current Item: IncidentAwaitingApprovalNotifcation = “No”

The problem with this approach after awhile I noticed is, on this update, it turns around and fires all 10 other workflows AGAIN.

This creates loops, it creates multiple workflows firing at the same time and a lot of issues.

I’ve read online about using set instead of Update List Item, that set doesn’t fire the event listener again to fire another workflow. Is this true?

Currently these workflows are taking over 15 minutes to complete on items.. Sometimes longer.

What would be the best approach to fix this?

SharePoint 2010 using REPLACE and FIND functions multiple times in a calculated field

I’m working on a SharePoint 2010 site where I have a field which contains three letter characters which are separated by a hyphen e.g. AMO-SMF.

I have created a calculation which can FIND and REPLACE one of these at a time, however, there are seven different three letter abbreviation I need to replace with a name. These are as follows:

=IF(ISERROR(FIND("AMO",Result)),Result,REPLACE(Result,FIND("AMO",Result),3,"Amosite"))      =IF(ISERROR(FIND("CRO",Result)),Result,REPLACE(Result,FIND("CRO",Result),3,"Crocidolite"))      =IF(ISERROR(FIND("CHR",Result)),Result,REPLACE(Result,FIND("CHR",Result),3,"Chrysotile"))      =IF(ISERROR(FIND("UMF",Result)),Result,REPLACE(Result,FIND("UMF",Result),3,"Unknown Mineral Fibre"))      =IF(ISERROR(FIND("ORG",Result)),Result,REPLACE(Result,FIND("ORG",Result),3,"Organic Fibre Type"))      =IF(ISERROR(FIND("SMF",Result)),Result,REPLACE(Result,FIND("SMF",Result),3,"Organic Fibre Type"))      =IF(ISERROR(FIND("NFD",Result)),Result,REPLACE(Result,FIND("NFD",Result),3,"No Fibres Detected")) 

Is it possible to perform a loop in SharePoint 2010 calculated fields which will catch all of these instances?

Write to an excel file in document library on SharePoint 2010 using Excel 2016 VBA

I have a piece of VBA code to update another Excel file (file A). The VBA code runs on my local desktop, the file A is in a document library on a SharePoint 2010 server. The code runs fine in Excel 2010 on Win 7. However, when I run the code in Excel 2016 on win 10, the file A never got updated, and I don’t receive any error messages.

This is the code to write the file:

dim wbArc as Workbook dim wsArc as Worksheet  dim fileAddr as String fileAddr = "http://sp.server.com/doc lib 1/Archive.xlsx" Set wbArc = Workbooks.Open(fileAddr) Set wsArc = wbArc.Sheets("Sheet1")  'write some values to wsArc cells  wbArc.Save wbArc.Close True 

in the fileAddr variable, I also tried using shared folder path like \root\shared\folder\doc lib 1\Archive.xlsx, but get same issue.

So, what’s reason for this issue, and how to solve it? Any guidance or hints are appreciated!

Thanks,

Michael

Sharepoint 2010 – Refresh Lists

How Can I refresh 4 lists in PowerShell?

My script doesn’t work.

$  web = Get-SPWeb http://Server/ListLocation $  list = $  web.Lists["Tarefas Geral"] foreach ($  item in $  list.Items) {   $  item.UpdateOverwriteVersion(); }  $  list1 = $  web.Lists["Tarefas"] foreach ($  item in $  list1.Items) {   $  item.UpdateOverwriteVersion(); }  $  list2 = $  web.Lists["Tarefas 2"] foreach ($  item in $  list2.Items) {   $  item.UpdateOverwriteVersion(); }  $  list3 = $  web.Lists["Tarefas Jobs"] foreach ($  item in $  list3.Items) {   $  item.UpdateOverwriteVersion(); } 

SharePoint 2010 – REST – retrieve group members

I am building a form using REST and am trying to create a drop down based on a person/group field.

'..ListData.svc/listNameFieldName' does not seem to work for those field types and accessing '..ListData.svc/UserInformationList' does not identify group members.

Is there a way for me to access this information via REST? If not, would using JSOM/SPServices provide a solution?

Migrate Classic Auth 2010 Content DB to Claims Auth in SharePoint 2013, MigrateUsersToClaims return false

I am doing a two hop upgrades from SP2007 to SP2013. For testing I first upgraded a small content db from 2007 to 2010. The 2010 web application is still using classic auth.

Next I attach the 2010 db to 2013. I run Test-SPContentDatabase it show the inconsistency between claim and classic auth but the UpgradeBlocking show FALSE so I go ahead to mount the DB and upgrade.

The site collection is show up in the SP2013 farm, I can then upgrade the site to 2013 look and feel. I can login , view the content and also assign AD user permission too.

I learn from here (https://samlman.wordpress.com/2015/03/01/converting-a-classic-auth-content-database-to-claims-auth-in-sharepoint-2013/) perhaps I should convert the DB to Claims Auth, but the MigrateUsersToClaims return False in the result.

So I don’t understand, Is it using Claim in the migrated site collection?

Is the MigrateUsersToClaims necessary ?

MissingSiteDefinition – Migrate sharepoint 2007 to 2010

I migrated Sharepoint 2007 to 2010, but some sites do not open, i run the Test-SPContentDatabase command, the MissingSiteDefinition error is displayed for the following TemplateId: 75801, 75802, 75803, 75806, 75813, 75817 and 75818

So, i ran the following command: STSADM -o enumallwebs -databasename WSS_Content and the following result was generated:

<?xml version="1.0"?>  -<Databases>  -<Database DataSource="SQL2008\SQL2008" Name="WSS_Content" SiteCount="3">  -<Site InSiteMap="True" OwnerLogin="administrator" Id="66ae0d80-c0ad-4612-8246-9706fa16c23a">  -<Webs Count="2"> <Web Id="04aa537a-0ae2-4271-a913-96714d967b62" TemplateId="1" TemplateName="STS#0" LanguageId="1046" Url="/sites/administration"/> <Web Id="0c1ce964-62d1-4ec5-9b6a-ef4d882a197c" TemplateId="75806" TemplateName="Unknown" LanguageId="1046" Url="/sites/administration/Sector1"/>  </Webs> </Site>  -<Site InSiteMap="True" OwnerLogin="administrator" Id="20aa7454-80e5-4bc1-9bc5-a784c9d1cf17">  -<Webs Count="25"> <Web Id="39930c2d-a158-4e86-9a5f-2910f05f36e1" TemplateId="1" TemplateName="STS#0" LanguageId="1046" Url="/"/> <Web Id="5ba50ae3-2075-4eee-9842-d980ef3ba45b" TemplateId="75802" TemplateName="Unknown" LanguageId="1046" Url="/contacts"/> <Web Id="13336897-2b9f-4695-9e52-0f37194eff0e" TemplateId="1" TemplateName="STS#1" LanguageId="1046" Url="/engineering"/> <Web Id="c073ec4b-ec4e-4084-945d-2307479fe7f8" TemplateId="75801" TemplateName="Unknown" LanguageId="1046" Url="/engineering/gc"/> <Web Id="cdb98f08-cfcd-4f8a-b603-7136bc08edd6" TemplateId="1" TemplateName="STS#0" LanguageId="1046" Url="/engineering/gcnew"/> <Web Id="bfe5cb1e-a6a1-4850-90b7-0e72f828f613" TemplateId="75818" TemplateName="Unknown" LanguageId="1046" Url="/Conference"/> <Web Id="93e30184-01ac-4eac-b7ee-144d73eabcd5" TemplateId="75817" TemplateName="Unknown" LanguageId="1046" Url="/checking"/> <Web Id="f1cb918d-370a-4eb6-b4c1-c88a016a57a7" TemplateId="75813" TemplateName="Unknown" LanguageId="1046" Url="/rep/proc"/> <Web Id="e345d76e-138f-4480-86e5-6914554651b7" TemplateId="75803" TemplateName="Unknown" LanguageId="1046" Url="/dev"/> <Web Id="b9636c3f-e1a8-4f38-86d8-71df5a16048e" TemplateId="9" TemplateName="BLOG#0" LanguageId="1046" Url="/dev/blog"/> <Web Id="0e85e10e-a916-4d65-af97-efb6039b8635" TemplateId="1" TemplateName="STS#0" LanguageId="1046" Url="/dev/Control"/> <Web Id="370bb595-14d7-4ded-8ffd-6f439b36d259" TemplateId="9" TemplateName="BLOG#0" LanguageId="1046" Url="/dev/Control/blog"/> <Web Id="6573ee2c-bd5f-4865-b398-db0eee3185f3" TemplateId="1" TemplateName="STS#0" LanguageId="1046" Url="/dev/sctr"/> <Web Id="207523cc-8ad0-48c5-b1ec-79b6384f8b7a" TemplateId="9" TemplateName="BLOG#0" LanguageId="1046" Url="/dev/sctr/blog"/> <Web Id="6ad7c6cc-f968-47e7-98e7-af402b861f72" TemplateId="1" TemplateName="STS#0" LanguageId="1046" Url="/dev/dim"/> <Web Id="945e28d8-4cc6-47e7-b1cf-83e048130e16" TemplateId="9" TemplateName="BLOG#0" LanguageId="1046" Url="/dev/dim/blog"/> <Web Id="408eaff0-4fff-4592-98f3-151c8509021c" TemplateId="1" TemplateName="STS#0" LanguageId="1046" Url="/dev/dec"/> <Web Id="9d6c895c-bcb9-4d29-a90d-88af64bff1b2" TemplateId="9" TemplateName="BLOG#0" LanguageId="1046" Url="/dev/dec/blog"/> <Web Id="181498f0-c37b-4a8d-ba13-e450c86caa94" TemplateId="1" TemplateName="STS#0" LanguageId="1046" Url="/dev/dec/sctr"/> <Web Id="d9b7bc31-8c69-4225-88b5-2b011589639f" TemplateId="9" TemplateName="BLOG#0" LanguageId="1046" Url="/dev/dec/fiscaldocuments"/> <Web Id="53e353f4-895e-4b51-80b2-90a252fbe05b" TemplateId="1" TemplateName="STS#0" LanguageId="1046" Url="/dev/rin"/> <Web Id="2920f7aa-b8f9-43bb-ba17-fc41c54e1061" TemplateId="9" TemplateName="BLOG#0" LanguageId="1046" Url="/dev/rin/blog"/>  </Webs> </Site> </Database> </Databases> 

Why only sites with Templatename = ‘Unknown’ do not open

Example: if I try to open the URL with TemplateId=”75813″ following message is displayed:

enter image description here

If I try to open the URLs 75801 or 75802, the message is another: The Webpage can not be found

I know these templates were customized by another company sector.

How can I fix this problem?

Thank you so much…

SharePoint 2010 w3wp high memory usage

Good morning, one of my servers is having sometimes a high memory usage on w3wp and I’m trying to find which of the custom solutions is doing that. We already created a full dump through Process Explorer, but I’m not having luck how to parse it with windbg. So my question is: is it possible through the dump file see how much each solution or dll is consuming memory?