.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Moving Folders Based on a List

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
I have the need to move a certain set of folders from one directory to another. I've found several posts that explain how to move files from one directory to another, but those didn't quite provide what I needed. Essentially I have a text file that lists 700+ folder names. I need to iterate through those and starting at a certain "root" directory (E:\Folders) move those subfolders in E:\Folders to another root directory (F:\OtherDirectory). Here's what I have so far: I hae a data flow task which is just a flat file connection which contains the list of folders. I then dropped a "For Each Loop" container onto the Control Flow. I then connect the data flow task to the For Each Loop Container. I created a variable that has a scope of Packge with a datatype of String. The name is User::Folder. Within the For Each Loop Editor, I've done the following: In Collection, I chose "ForEach Item Enumerator" as the enumerator. For expression I chose the variable (User::Folder). In Variable Mappings, I chose User::Folder as the variable with an index of 0. Within the For Each Loop Container I drop a File System Task. Here are the settings for that: IsDestinationPAthVariable = FALSE DestinationConnection = connection to the new "root" directory Operation = CopyDirectory IsSourcePathVariable = FALSE SourceConnection = connection to the origi

View Complete Post

More Related Resource Links

how to hide/display controls in NewForm.aspx based on dropdown value in SharePoint list



I have 1 dropdown in my sharepoint list with other columns. If dropdown value equal to 'xyz' i need to display some other controls, otherwise these controls should be hidden.

I know we can achieve this with javascript. If any one can provide code or sample then it will be appreciated. or is there any other alternative methods to do this ........

Thanks & Regards, Neerubee

ListItem Dynamic DropDownList based on custom list entries.

I utilized the following solution to get the drop down list on the page and populate it dynamically, but it doesn't save the selected value back to the SPListItem object. Does anyone have a better solution possibly for this? http://geekswithblogs.net/SoYouKnow/archive/2010/01/21/sharepoint-populating-drop-down-list-field-with-data-from-different.aspx

How do you change the datasource for a list based on another? ie a secondary list being a filtered

I'm actually using Sharepoint 2007, but am hoping this forum will help.  We want to be able to create a list based on a filtered view of another list.  I can create a Filtered List in Designer, but evidently this is saved as a query object on the server and not as another list that can be selected when using the basic Sharepoint tools.  In other words, it's only visible when in Designer.  This means that in order to use this for say a lookup column in another list object, I have to modify the datasource tags for the EditForm and NewForm.aspx pages within Designer.  Also, it means that adding a column would constantly require use of Designer.  We need this to be simple as not all those tasked with administrating pages will know how to do this.  I thought it would be easier if I could simply source a secondary list with the filtered list I created in designer.  In other words, make a secondary list source be that of a queried view of a master list.  Then this list could be used with all the simple tools provided.  Is this possible?  If so... how?

How can I get a user list based on a specific profile property.

Hi,I am trying to query a DB and get a list of users based on a specific boolean property stored in the aspnet_profile for that user.I am aware that it wasn't possible a few years ago (http://forums.asp.net/p/988051/1277359.aspx), but was wondering whether that had changed in recent releases, or it was still not possible without trawling through the entire list of users and testing them one by one.  (My DB may become way to big for that.)Thanks in advance for any help.Regards,Ben

set the Report URL property to a specific report dynamically based on the selection in the list.

Hi I want to use  embedding the Report Viewer Web Part in a Web page, and I know we  should set the Report URL property to a specific report. but  is there a way by which we can set the url  dynamically based on the selection of the report  from  the list How can I customize this  feature Any Help on this is appreciated. Thanks

Dynamic list item title based on date created & regional settings?

I have a list of things that doesn't *need* a title.  However, because sharepoint uses Title for links, RSS etc  I tried generating a title in an event handler.   This would work great if I wasn't basing it on a date field: public override void ItemAdding(SPItemEventProperties properties) { DateTime dt = Convert.ToDateTime(properties.AfterProperties["TestDate"]); properties.AfterProperties["Title"] = dt.ToShortDateString(); base.ItemAdding(properties); } In testing, this sets the title to "8/9/2010" when I selected 8/10/2010 in the date picker.  I figure this is because of the regional settings of my test user.  I can probably correct the title value for 'test user' but that won't fix 'test user in mongolia' who would still see two different values. So What I would like is to have the Title always display the value MyDate in the uesr's locale.  So the field needs to be dynamic not only at edit/update time, but at display time. Does anybody know if this can be accomplished, and more specifically how?

Updating a list item based on the value of a different list item

Ok, I've searched everywhere and have gotten mixed information about whether this is possible with standard Sharepoint functions.  I new at Sharepoint, but I'm doing this to help out the department which is short of help right now.  Here's what I'm intending to do - We need a small ticketing system to track software requests.  I created a basic list that accomplishes this fine.  I created another list with criteria that software must meet in order to be approved called software evaluations.  I made a "choice" column called approval status in both lists that have the following options: Approved, Pending, Rejected.  I'd like the softwarerequests.approvalstatus to mirror whatever the softwareevaluations.approvalstatus column value is.  I created a workflow using SPD and it's seemingly easy to use.  I attached it to the softwarevaluations list and set the following as the matching criteria: if softwareevaluations.approvalstatus = "approved" then softwarerequests.approvalstatus = "approved". It mentions that the values aren't unique, but I accept anyway.  It doesn't do anything and I'm thinking it might be because it doesn't know what "issue" to reference.    I feel I'm all over the place right now, so it might be easier if someone just asks me what you need to know to help.

Auto-populating a field based on SharePoint Contacts List

Hello! Hopefully a quick question for you gurus :) So, I have two relevant fields in my InfoPath 2007 form: A drop-down list called Contact Name, and a text field called Contact Phone Number.  Contact Name is populated through a SharePoint Contacts List, retrieving their Full Name from that list. What I'd love to have happen is, when the user selects a name from the Contact Name list, have the form auto-populate the Contact Phone Number based on the phone number of the selected name from the SharePoint Contacts List. I tried to set a rule in Contact Name to, when the field is Not Blank, populate the Contact Phone Number with the phone number from the Contacts List, but all that does is populate the field with the top-most phone number, not the one matching the selected name. Any way to do this more accurately, and preferably without custom code? (Client has an explicit requirement to not have any custom code on the form or its associated workflow)   Thank you so much!

List Instance based on Asset library

HI Guys, There are three content type associate with Asset library but now i want to create a list instance based on Asset Library but i dont want these three content type i want only the custom content type i have created. I know how to do this in browser interface but i want to do in VS2010. I Know i have to create listinstace item type i did that then i dont know what i have to do in order to hide all out of box content types associate with asset library. Please assist me with thisThanks Ron

New ListItems added as Folders? List defect?

Hi! I have a simple List (not a document library!) which worked fine for a few weeks. Today our customer called me and reported that an error occures every time a new item is created. I figuered  out that the error only occurs when there was already a listitem with the same value in the "title" column. This is a strange thing, because in most cases there are already multiple items with the same value. The error occurs only on newly added items. I did some further research and found out that in Sharepoint Designer all the items are displayed as folders! How can that hapen? This must have been changed by someone because this does not happen before. Is it possible to change the list type? Perhaps our customer did so and damaged the list on this way... Please could someone give me a hint? Thank you very much! Gerrit

Updating an item in one list based on data from another

I thought I understood this fairly well, but it seems that I am missing something.  I have created a change management site that uses a calendar list to mark upcoming changes to our IT systems.  I have also created a second list to track some information about the change items that I don't want to show up on the calendar, such as what the outcome of the change was or if the change process was properly followed.  So I have the calendar list and another list called results.  I know that there needs to be a unique identifier that each list item will have in common, so in the results list I created a column called Change Number.  When a new change item is created in the Change Management calendar a workflow runs that notifies some people that a new change has been submitted, and the last step in that workflow creates a new list item in the results list and sets the Change Number field to be equal to the current item ID field.  That part is working right now.  When I create a new change item I can open the results list and see that there is a new item and it has the proper number in the Change Number field. What isn't working is when I try to take actions in other workflows that use data from both lists.  An example is notifying the creator of the change that it has been approved.  When the list item is changed a workflow starts that

How do you filter a list in a Meeting workspace based on the meeting date?

I have a customer who is using a meeting workspace, and has a list on said workspace (we'll call it "Meeting Instance List"). The workspace houses this list, and of course after each meeting, the workspace, in essence, resets itself in preparation for the next meeting - so it looks like it removes the items from the list, when in actuality, they are there, just on the previous meeting instances. Some of his stakeholders are finding this limiting because they perceive it as losing historical information (you know how some folks can be, if they don't see it, they think it's gone). His solution is to replace the non-series list, with a series list, and incorporate legacy records from another older list. Only problem is, now there's not a way to filter the series list so that it shows items from a parcticular meeting date. For instance - the [Today] variable will only return a current system date value. Surely there ought to be a similar variable that would all you to filter the list based on meeting date, right?

Enable a button based on a list via code behind


I've got a ListView with textboxes inside (bound to a property) and a button behind it.

I'd like to make the button enabled only when:

1) Each TextBox is not empty (each property has got a value)

2) Each TextBox has not got errors

How can I do it via code behind?


Excel 2007 Cubeset function needs to pull list based on part of field value (ie contains, wildcardin


I have a Cube with a field called 'Item Code'.  This field is six characters in length.  The first two characters differentiate what kind of product it is.  I am building my reports with cube functions.  I do not want to use a pivot table to retrieve the list by using the 'contains' or 'begins with' label filters.  Is there a way to use the cubeset function with left, mid, right functions?  I realize that it can be set up in the cube as a separate field, but I am not able to update the cube.  Below are my examples - 'All Products' and 'Product R3189S' work fine, but I need to retrieve 'Products starting with R3'.

=CUBESET("Financials Sales Cube", "[Product Dimension].[Item Code].[All Product Dimension].children", "All Products")

=CUBESET("Financials Sales Cube", "[Product Dimension].[Item Code].[All Product Dimension].[R3189S]", "Product R3189S")

= CUBESET("Financials Sales Cube", "[Product Dimension].[Item Code].[All Product Dimension].[R3****]", "Products Starting with R3")

Thank you in advance.


how to change the view of SharePoint List based on field?


hi all,

I have different sites in my sharepoint application. in every site i have one list, this list have one field called location. When i open this list in purticular site at the time users  will see only the items where the location filed is equal to the site name.

So please suggest me how we can achieve this?



Custom action on click of certain type of folders in a lsharepoint list


We have a Moss 2007 set up and we are trying to have the ability where in we have some folders in a list marked as "confidential"., and when the user clicks on these folder, we want to pop up a disclaimer dialog to the user, and force the user to accept or reject it.

Also we want the ability to throw this popup when the user is directly navigatinig to a certain file that resides in the folder.

Any suggestions would be greatly appreciated.



Create Lookup Site Column based on External List (SharePoint 2010)


I've got an External List and I want to create a Site Column, which is Lookup to a column in my external list. If I tick any of the columns in 'Add a column to show each of these additional fields' and click OK i get the following error message:

[NullReferenceException: Object reference not set to an instance of an object.]
  Microsoft.SharePoint.SPBusinessDataField.IsInDefaultView() +58
  Microsoft.SharePoint.SPBusinessDataField.CreateSpFieldForBdcType(String bdcName, Boolean hidden, Boolean readOnly, Boolean idField, SPAddFieldOptions op) +809
  Microsoft.SharePoint.SPBusinessDataField.AddNeededSecondaryFields(String wssNames, String[] oldNames, String[] newNames, SPAddFieldOptions op) +315
  Microsoft.SharePoint.SPBusinessDataField.OnAdded(SPAddFieldOptions op) +240
  Microsoft.SharePoint.SPFieldCollection.AddFieldAsXmlInternal(String schemaXml, Boolean addToDefaultView, SPAddFieldOptions op, Boolean isMigration, Boolean fResetCTCol) +759
  Microsoft.SharePoint.SPFieldCollection.Add(SPField field) +61
  Microsoft.SharePoint.ApplicationPages.FieldNewPage.Save() +513
  Microsoft.SharePoint.ApplicationPages.FieldNewPage.BtnOk_Click(Object sender, EventArgs e) +46
  System.Web.UI.WebControls.Button.OnClick(EventArgs e) +114
  System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +139
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend