How do I sort a Delimited text file by the second delimitation?
I have a text file that is laid out as such:
aaaa aaa (2000)
bbb bbb bb (2001)
cccc,ccc (1999)
ddd dddddd (2004)
I would like to be able to make a VBScript that sorts the text file and makes a new csv from it that has it in order by (*). That way it would list back:
cccc,ccc (1999)
aaaa aaa (2000)
bbb bbb bb (2001)
ddd dddddd (2004)
I tried a couple times using some other scripts but I am pretty new at this and figured I should reach out for help.
Thank you for any help you could give.
- Edited by philip.terry Tuesday, May 26, 2015 6:23 PM
- Changed type Bill_Stewart Thursday, July 9, 2015 4:51 PM
- Moved by Bill_Stewart Thursday, July 9, 2015 4:51 PM This is not "scripts on demand"
Reply:
The script request form is here:
https://gallery.technet.microsoft.com/scriptcenter/site/requests
This forum is for specific questions rather than script requests.
-- Bill Stewart [Bill_Stewart]
------------------------------------
Reply:
Your file is too odd to be easily converted. You need to use a real file and not one you have made up.
Start by learning how too use VBScript (I recommend skipping vbscript for PowerShell.
Start here: https://technet.microsoft.com/en-us/scriptcenter/dd793612.aspx?f=255&MSPPError=-2147217396
\_(ツ)_/
------------------------------------
Reply:
Here is an example of why it won't work:
PS C:\scripts> $file col1,col2,col3 aaaa,aaa,(2000) bbb,bbb,bb,(2001) cccc,ccc,(1999) ddd,dddddd,(2004) PS C:\scripts> $file|ConvertFrom-Csv col1 col2 col3 ---- ---- ---- aaaa aaa (2000) bbb bbb bb cccc ccc (1999) ddd dddddd (2004) PS C:\scripts> $file|ConvertFrom-Csv|sort col3 col1 col2 col3 ---- ---- ---- cccc ccc (1999) aaaa aaa (2000) ddd dddddd (2004) bbb bbb bb
\_(ツ)_/
------------------------------------
Reply:
I started by making a new delimitation so instead of being in the format of
title (year)
It is now
title~year
I was told this may help in the organizing process as I could move everything after the "~" to the front of the line then just use a basic sort command but I do not know how to move everything after the "~" to the front...
------------------------------------
Reply:
Again: This forum is for specific questions rather than script requests.
As noted, this will be simpler to accomplish in PowerShell than VBScript, but this isn't the right place to ask others to write a script for you. You can request a script here:
https://gallery.technet.microsoft.com/scriptcenter/site/requests
As with this forum, there is no service-level agreement that guarantees someone will take the time to do this for you. If it is critical to business, I recommend hiring a consultant.
-- Bill Stewart [Bill_Stewart]
------------------------------------
Reply:
A comma separted file is a specific structure. You cannot just change delimiters and get one.
All row must have the some number of columns. Delimiters are usually either comma or semicolon but can be pipe or other character. IF you cannot prove this then you will likely need to hire a consultant to help you with this.
http://en.wikipedia.org/wiki/Comma-separated_values
\_(ツ)_/
------------------------------------
Reply:
I doubt anyone else will ever need this script so I think putting it in the repository would be a waste of time. Therefore I'll just post it here:
'--------------------------------------------------------------------- ' This script requires .NET Framework 1.1 or later '--------------------------------------------------------------------- strInputFile = "C:\Path\To\File\input.txt" strOutputFile = "C:\Path\To\File\output.txt" '--------------------------------------------------------------------- ' No need to edit below this line '--------------------------------------------------------------------- Const ForReading = 1 Const Overwrite = True Set objFSO = CreateObject("Scripting.FileSystemObject") Set objInputFile = objFSO.OpenTextFile(strInputFile, ForReading) Set objOutputFile = objFSO.CreateTextFile(strOutputFile, Overwrite) Set objSortedList = CreateObject("System.Collections.Sortedlist") Set objRegEx = CreateObject("VBScript.RegExp") Set objShell = CreateObject("WScript.Shell") objRegEx.Global = True objRegEx.IgnoreCase = True objRegEx.Pattern = "(.*)\((\d{4})\)" Do While objInputFile.AtEndOfStream = False strLine = objInputFile.ReadLine Set colMatches = objRegEx.Execute(strLine) If colMatches.Count > 0 Then For Each strMatch in colMatches strTitle = strMatch.SubMatches(0) strYear = strMatch.SubMatches(1) strEntry = strYear & ";" & strTitle objSortedList.Add strEntry, strEntry Next End If Loop For i = 0 To objSortedList.Count - 1 arrEntries = Split(objSortedList.GetKey(i), ";") objOutputFile.WriteLine arrEntries(1) & "(" & arrEntries(0) & ")" Next objShell.Run("notepad.exe " & strOutputFile) ------------------------------------
Display both married and others in one form
Hello -]
is there a way to display the address contents of Married and others in a form.
I have a column of FamStatus as (1 for single, 2 for married and 3 for all others)
Was able to get the married portion display because I figured that Primary Contact name was different from Spouse FirstName and LastName.
So with Single person, the Primary Contact is the single and you can't compare it to any other information. is there a way I can use Famstatus to resolve my issues?
Any help would be greatly appreciated..
VLAN - Please explain this to me
I have a Win 8.1 Pro workstation. This is my management system so I need to access 2 different VLANs. VLAN1 (untagged) is our data lan and has internet connectivity. VLAN10 is tagged and is our VOIP VLAN. It has no internet connectivity. I need to be able to access both VLANs. VLANs are on separate subnets.
My workstation has a Intel I350-T2V2 NIC which both ports are teamed and is untagged (VLAN1). I'm using a port on the motherboard (I210) for VLAN10 (tagged).
In Network Connections -> Advanced -> Advanced Settings -> I have the NIC Team (VLAN1) set 1st and VLAN10 second.
In Network Connections VLAN10 shows No Internet access; which is what I expect as it doesn't.
When browsing or doing tracerts to internet sites sometimes it goes to the VLAN1 gateway and sometimes it goes to the VLAN10 gateway. I expected it to always use VLAN1 as I have it set 1st.
How do I force it to always use VLAN1 for everything except the VLAN10 subnet?
AppV5 on RDS session hosts - all kinds of issues, am I alone?
Hi,
after months of struggling I am about to have had it with AppV5. A little information:
- A farm of 2008R2 RDS session host servers
- This is a shared farm, shared between several smaller clients / companies
- AppV5 sp3 client installed
- AppV5 full infrastructure, streaming from SMB share
- Only user per user publishing, no system-wide publishing
- Connection groups for several applications, with correct priorities
I keep running into issues with this setup;
When assigning apps to a user, per server the first time an aplication or connection group is started, it's extremely slow especially when Office (2010) is involved. This is discussed in https://social.technet.microsoft.com/Forums/en-US/mdopappv/thread/44944302-d8f3-4df1-b104-9c63345f88e0/#3324f16f-beb1-4fce-8475-6224a01664a6. While I can overcome that with some customizations that's already one thing I am unhappy with.
Then as the AppV5 client service stores user-related data in HKLM\Software\Microsoft\AppV, whenever a user logs of that data is kept on the server. Whenever an application or connection group is updated we run into issues. When he logs on again and happens to land on a server he was on before, the refresh most of the times fails with errors like
That's just an example, error messages vary.
Now I've found that when I remove all the specific user-values from HKLM\Sofware\Microsoft\AppV and have the user logon to that server again or manually do the sync again, everything works flawlessly. For some reason the Sync-AppVPublishingServer is not able to update properly when I don't cleanup that data.
Sync speed. I've asked this before but didn't get a real answer. With AppV4, when a user logs in the shortcuts are there immediately and can be started immediately. When a user has new appilation published, they appear within seconds, and they stay there, in a 'startable state' after user logs in again. Now with AppV5, when a user logs in to a server, all AppV5 shortcuts are 'white' and not startable. Only when the AppV sync has been done the shortcuts get their proper icon and are startable. This sometimes takes up to 10 seconds. Login speed and performance is a key performance indicator in our vision and also from user perspective a very important indicator. Going back from immediately being able to start applications to having to wait for about 10 seconds to do so is appaling according to our users (and I can't blaim them either).
Whenever a connectiongroup has been updated, most of the time when a user logs in he gets the 'Application update - please stop your application and try again' (don't have the exact message by hand now but you'll all recognize it). I think this happens when a user starts the application 'too soon' after logging in. The syc process runs, but I feel the UI bar in the bottom right of the screen is gone after the applications have been synced, but the connection groups still have to update. Anyway, the user then stops their applications and tries again, which sometimes works. However, as user-settings are saved in HKLM, whenever he lands on another RDS the same issue happens again. Again it seems the sync-appvpublishing server is either too slow or not functional enough.
In my testenvironment I have now created a tool that removes a users HKLM AppV references after he has logged off. In my tests that already saved quite some problems but not all.
I feel AppV5 is more 'dedicated' to VDI environments where the profie or AppV part of the registry builds from scratch at every login, not to run on multiuser systems. In addition I think the performance of AppV5 in terms of for example it's synchronizing and filling the registry for an application or connection group is two steps behind AppV4. Especially the way shortcuts are not usable when a user gets his desktop shown after login is beyond believe, how is that an improvement?
I think my question is if there are some people here that run AppV5 on multiple RDS session hosts with applications (and connection groups) published on userbase, and to share their ideas, frustrations , issues and ofcourse solutions.
- Changed type Brandon RecordsModerator Saturday, June 13, 2015 1:45 PM Conversation focuses on best practices and opinions of App-V
Reply:
Yes, I have seen the "network" error before in a similar environment. This was solved by letting the Sync process complete before the user can start applications.
If there are already shortcuts on the system, maybe PreserveUserIntegrationsOnLogin can solve some issues. This skips the "cleanup".
Twitter | Blog | App-V Deployment Whitepaper
If you see a post that helped you please click "Vote As Helpful" and if it answered your question please click "Mark As Answer". This forum post is based upon my personal experience and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.
------------------------------------
Reply:
Thanks for your response. I have tested with PreserveUserIntegrationsOnLogin, it doesn't make a great diference in my environement. The most important part though is that the issues when application membership or connectiongroups have changed still exist per user per server. That specific issue makes it extremely hard to 'sell' this to our users and to myself.
Tell users not to start an application when the shortcuts are already there. I don't know how to PREVENT them from doing it, but I can tell you just asking them is not sufficient :) Still I think that's a bad point to start from in the first place; the sync / refresh process is way too slow in my oppinion, especially when compared to previous AppV versions.
How did you cope with that in your environment?
------------------------------------
Reply:
Thanks for your response. I have tested with PreserveUserIntegrationsOnLogin, it doesn't make a great diference in my environement. The most important part though is that the issues when application membership or connectiongroups have changed still exist per user per server. That specific issue makes it extremely hard to 'sell' this to our users and to myself.
Tell users not to start an application when the shortcuts are already there. I don't know how to PREVENT them from doing it, but I can tell you just asking them is not sufficient :) Still I think that's a bad point to start from in the first place; the sync / refresh process is way too slow in my oppinion, especially when compared to previous AppV versions.
How did you cope with that in your environment?
They used RES Workspace Manager so the RES splash screen was displayed until the Sync was finished.
Can't you add the package globally (with CSC enabled) on the RDS servers and publish them per user?
An alternative could be to use App-V Scheduler
Twitter | Blog | App-V Deployment Whitepaper
If you see a post that helped you please click "Vote As Helpful" and if it answered your question please click "Mark As Answer". This forum post is based upon my personal experience and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.
------------------------------------
Reply:
Thanks for your reply. Sorry, I think I'm overexhausted by now, what do you mean with CSC?
By the way I know I could prepublish packages, but that doesn't prepublish the registry. It might help on the sync issues (which is the most important annoyance of AppV5 imho) but doesn't save the user from an extremely slow session for minutes. As we have users with either Office 2010, 2013 or Libreoffice, I can't publish office globally. Filling the registry of Office (especially 2010) takes minutes on 40-core HP Gen9 servers (I know it's just a single thread process, but I want to make clear we don't have 'pussy' hardware :)). As far as I know I must manually start the connectiongroup or application in order for the registry to start building up, OR put it in myself (like export / import reg file basically, but then more sophisticated).
------------------------------------
Reply:
Thanks for your reply. Sorry, I think I'm overexhausted by now, what do you mean with CSC?
By the way I know I could prepublish packages, but that doesn't prepublish the registry. It might help on the sync issues (which is the most important annoyance of AppV5 imho) but doesn't save the user from an extremely slow session for minutes. As we have users with either Office 2010, 2013 or Libreoffice, I can't publish office globally. Filling the registry of Office (especially 2010) takes minutes on 40-core HP Gen9 servers (I know it's just a single thread process, but I want to make clear we don't have 'pussy' hardware :)). As far as I know I must manually start the connectiongroup or application in order for the registry to start building up, OR put it in myself (like export / import reg file basically, but then more sophisticated).
Sorry, I ment SCS (Shared Content Store).
Keep in mind that scenarios involving multiple App-V 5.0 Office packages deployed on a client are not supported and Office 2013 needs to be published globally.
Twitter | Blog | App-V Deployment Whitepaper
If you see a post that helped you please click "Vote As Helpful" and if it answered your question please click "Mark As Answer". This forum post is based upon my personal experience and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.
------------------------------------
Reply:
Are you using roaming profiles?
The network error you posted was something that took me a while to figure out. It can happens when you launch the eye before the app is published to the user. I have also seen it as a bug pretty SP3. It happens when the app services fills up the access list on the folder. SP3 fixed this bug that was introduced in SP2.
For reference, I have about 2500 users, 60 RDS (Citrix) servers, and around 75 Appv 5 apps. I have had comments from my users that's state they like Appv 5 better than 4 because it's faster And apps seem to work better.
------------------------------------
Reply:
Hi Joe,
thanks for your addition. I agree in AppV5 being (much) better with connection groups, with starting apps, and general maintenance as well. However the fact a user can actually start an application before the sync is done and it screws up the system, is bad design in my opinion. It's not like roaming profiles are new.
While you have 60 RDS servers, you must (?) have seen more issues like I have. For example when you add a new version of an app or a completely new app to a connection group, do users get like random error messages sometimes? As told I have issues which seem to occur because there is data stored for each user in HKLM which ofcourse doesn't roam. So when a has worked with a new app, and then logs on to another server he might as well get some error message again.
Still one of my main issues is that with AppV4 whenever the shortcut was there, the user could start it. It's hard to tell a customer to just wait, even if all shortcuts already exist. That's not an improvement over AppV4.
In an environment with 2500 users I assume you are using some form of profile management software? Do you include / exclude specific parts for AppV5
------------------------------------
Reply:
You stated that you cant publish Office globally, so does that mean that you have Office 2013 published to users? This could be what is causing alot of your slowness. Although 2013 does work "somewhat" when published to users, its not a supported configuration and really slows down the publishing time.
As far as the errors go when launching applications, this is most likely because of "stuff" being left behind from the users sessions that really need to be removed when they log off. What seems to be happening is that your extension points are becoming invalid because they log off their session on server A with entitlement set A, then lets say a week goes by where they log into other servers, meanwhile their set of entitlements changes, and then they hit server A again. Since their older session still contains those older entitlements (in registry and file system), you end up with the bunk icons.
What are you using for profile management?
Do you have any scripts that run when these servers are restarted to clean up App-V?
------------------------------------
Reply:
You are now semi-quoting me as I also noted that when I clean up that mess that's left behind, everything is ok again - on that specific server. The thing is I can't believe WHY AppV can't clean it up itself when it generates so much issues. I have created a cleanup-tool myself that runs when a user logs off, but it bugs sometimes so I have to take another look at that and implement some logging as well. However, as stated I am stunned to see we need profile management tools and cleanup scripts in order to work with a product like this. It's not like this is some old version of it either.
I do not publish Office globally. I know it's not supported with Office 2013, hence Office 2013 is not published in any way as of yet. I am thinking about 2 farms - one with Office 2010 and one with 2013, either through AppV or locally installed (doesn't really matter anymore then). However, the base issue of error messages whenever entitlements / connectiongroups change remains, which makes it VERY unfriendly towards users.
We are just a small company. We cannot afford, nor do I believe we (should) need a profile management software. Hence I currently only have options AD / roaming profiles and any custom scripts or tools I write allow me to do. Currently I don't have any specific profile scripts running. Just regular roaming profiles. The most basic setup and I still run into all these issues.
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
Check out my wiki on this topic: http://social.technet.microsoft.com/wiki/contents/articles/25318.app-v-a-configuration-template-for-deploying-to-stateless-rds-clients-on-citrix-published-desktops-with-citrix-upm-for-profile-management.aspx
We are using essentially the exact same script on startup on our non-provisioned servers as well.
As far as if I feel 'ok' about it out of the box, that's a complicated question. I feel that it's 'ok' out of the box from the perspective of running in a vanilla environment without any types of layering, virtualization, or RDS. Where it becomes a bit more complicated is when any of these elements are added, but that goes with any types of tech. It really comes down to making sure that the user state is happy with the application state on the RDS server.
I started with 5.0 RTM, which was much, much more problematic in these areas, and they've done much to accomodate more complex environments with each hotfix and SP release.
------------------------------------
Reply:
Thanks a lot for your input. Having worked through your script it's funny to see I have every single step of that script in my own tool / script. While I now have a .net tool written for it for convenience, I also have it in a little .bat file in about 10 lines. That doesn't do the extensive logging but apart from that it's functionally the same. I'm personally still keen on bat and vbs for it's speed and I can do most stuff with it. In addition I also trigger my scripts from scheduled tasks, especially the one that cleans up all user-related AppV keys in HKLM. I've modified the tasks to allow them to pass parameters, and the tool I wrote accepts these parameters to find out which user triggered the logoff event and then does its thing. Funny to see how there are so many ways to basically the same solution.
What I don't exclude though is the AppData\Roaming\Microsoft\AppV\Client\Catalog directory. Actually I have been successfully trying to eliminate the 'white icon' issue. An important part of our user-experience is fast login times. They and I don't want all kinds of things to run, I want to be able to login and start my applications right away. I've been succesful in doing so - leaving the right stuff in opposed to excluding it makes logging in blazing fast and applications start immediately. I only have to find out when assignments have changed, because then I will have to do a 'complete sync'.
Anyway, for stability reasons I will first walk through your blog again and apply it to my test environment and see how that goes. I will keep you informed, and thanks again, your blogs might prove a good one for me.
------------------------------------
Reply:
I will concede that moving from a closed VFS to a state-separated NTFS-based one created a learning curve - especially for user data.What we have found is the various profile management solutions can vary and how they handle items.
I will also concede that when the user data for an application was encapsulated into one location as a PKG file, it simplified incorporation.
Remember that the AppV Catalog and Package Data are still separate - but the applications file\registry info is also separate with the files using NTFS and the registries using the real registries: This is the concept of the CoW in play. be mindful of all CoW locations in both the registry and the file system.
I find that Registry CoW data is often forgotten in roaming scenarios. I try to spell out these importations here:
http://blogs.technet.com/b/gladiatormsft/archive/2015/04/17/app-v-5-on-the-app-v-5-virtual-registry.aspx
Also check out this white paper:
https://technet.microsoft.com/en-us/library/dn659478.aspx
Hope this provides some clarity.
Steve Thomas, Senior Consultant, Microsoft
App-V/MED-V/SCVMM/Server App-V/MDOP/AppCompat
http://blogs.technet.com/gladiatormsft/
The App-V Team blog: http://blogs.technet.com/appv/
The MED-V Team Blog: http://blogs.technet.com/medv
The SCVMM Team blog: http://blogs.technet.com/scvmm/
"This posting is provided "AS IS" with no warranties, and confers no rights. User assumes all risks."
------------------------------------
Office 2013 Colour Schemes
- Changed type Jaynet Zhang Friday, February 15, 2013 9:25 AM
Reply:
Hi,
We have passed this information to the product group for consideration for a future product or update. We are sorry that at this time we have no other option to change the colors beyond what we has already seen.
Jaynet Zhang
TechNet Community Support
------------------------------------
Reply:
Dear,
I do not think continously cut&paste your default answer "We have passed this information to the product group for consideration for a future product or update.." is what we would expect from a professional forum like this. If in large companies I hear Execs opposing to upgrading to office2013 beaucse of the lack of options to change colour schemes apart from three shades of grey and them facing potential OHS complaints from medical staff and/or employees, I would not hesitate one second and escalate this up to the level of Balmer. You cannot continue to ignore these valid remarks provided by (so far) very loyal users. I think 99.9% of Office use is on corporate /academic / private desktop computers not on a tablet. Quite honostly on my 3 - 26 inch expensive monitors the least I want is a boring eighties style interface that might (I say might) work on a tablet. In my environment (professionally and privately) I hear nothing but complaints about this dreadful interface (and it's inability to be changed). I cannot imagine that "I will de-install and go back to Office 2010" or : " I will not upgrade" is the kind of response you might want from your most valuable existing user base. I think there is a lot at stake for your Office business unit so if I where you I would take these signals extremely serious and not wait even a week to provide additional templates so that you can put your existing hughe Office user base back in their comforrt zone or there might be no further real future for this product. The future of office is still on a desktop, not a a tablet or surface that (at current) nobody buys.
- Edited by StefanWeckx Friday, February 8, 2013 12:07 PM
------------------------------------
Reply:
Hi,
We have passed this information to the product group for consideration for a future product or update. We are sorry that at this time we have no other option to change the colors beyond what we has already seen.
Jaynet Zhang
TechNet Community Support
I love how the moderators jump into these forums and drop some nutty vague form-letter based response from someone not even in the product group that never answers the question - and then just simply disappear with no additional information. No problem is solved. No additional information is gathered.
Jaynet, thanks for trying to respond here, but you are not being helpful at all. What would be helpful is if you would get a member of the Office team on these forums to start answering and dealing with these issues. That's right, go down to their cubicle in whatever campus office they sit and get them to respond to people who have concerns over the product they developed. This silence and proxy responses from people not in the product group just makes the Office team look like total losers.
------------------------------------
Reply:
What kind of product testing could have possibly allowed you to come to the conclusion that three unreadable color schemes were a sufficient number of choices? You can choose a wider variety of useless backgrounds but you can't offer a color scheme that makes the entire application more pleasing to use?
I have pretty good vision and find the ribbon nearly unreadable in white, light gray and dark gray. 2010's blue allowed for more separation between the menu items and the ribbon - now it looks all jumbled together.
Did you guys circumvent product testing AND fire your entire UI and useability engineers?
- Edited by KevinRSmith23 Tuesday, February 12, 2013 9:33 PM typo
------------------------------------
Reply:
Totally agree with all comments. I just don't understand, and am baffled that new color schemes haven't been added. I've written to my Microsoft reps and let them have it.. it's plain awful.
------------------------------------
Reply:
You can choose a wider variety of useless backgrounds but you can't offer a color scheme that makes the entire application more pleasing to use?
On the subject of useless backgrounds, whose idea was it to position "busy" grey on white text over the top of the buttons in the top right corner? A bit of embellishment is fine on an otherwise bland page, but please don't position them in areas where the user needs to easily see what's underneath or around them.
Until these simple usability problems are resolved, I won't be recommending that my organisation uses Office 2013. It seems that volunteering to pilot it for them was a mistake.
------------------------------------
Reply:
Hi,
We have passed this information to the product group for consideration for a future product or update. We are sorry that at this time we have no other option to change the colors beyond what we has already seen.
Jaynet Zhang
TechNet Community Support
Again with the canned response.. I will keep quoting and reposting this nonsense. Is it that hard for someone to provide a "real" answer ?????
------------------------------------
Reply:
I am waiting for the Microsoft response that says:
Hello from Seattle,
The product group has passed information back to you, the people who are using our software, that the future update to correct this obvious oversight will be fully tested and released not later than April 30, 2013. They also thank you for paying for their multi-million dollar homes all over the Redmond area and assure you that they prefer to continue to have you pay for the result of their very customer focused software so they can continue to afford the increased property tax bills they are now paying.
- Edited by careys Monday, April 15, 2013 11:31 PM
------------------------------------
Reply:
I just finished installing Office 365 and I'm already sorry I did so. The lack of color schemes is the first disappointment, especially since I have a hard time seeing the very light colors or white colored fonts on dark backgrounds. Secondly, I believe all the devices have to be set up under the one user account. Since there is the auto-sync feature for email, this makes sharing among a household of multiple users with at least two devices each not a great feature. I'm not certain I want to abandon my Office 2010 version entirely as yet. I doubt anyone in the house except me will make the switch to 365. But the use of pre-defined and no-option color sets is a definite down side.
------------------------------------
Reply:
------------------------------------
Reply:
Hear, hear. I like keeping up with MS Office, but I fear my eye-floaters are going to make the new moon-coloured Office suite a painful experience. So I'm sticking with Office 2010 until MS get off their arse and start fixing their design mistakes, including capitalized ribbon tab names.
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
This is another blunder by Microsoft. What were you thinking. There is almost no contrast and it make looking at your email incredibly difficult especially when you have 2 or 3 additional mailboxes. Microsoft stop trying to be cool and fix this issue ASAP! We are going blind with these color schemes.
FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS
FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS
------------------------------------
I need help you...
I'm Buy New Server Config HP Proliant ML 150 Gen 9. Inter(R) Xeon (R) CPU E5-2620 v3 2.40GHZ 2400 Mhz, 6 Core (s), Logical Processor(s), Ram - 16 Gb, HDD - 300GB, Raid - 1, OS - 2012,
I'm Install Sql - Sever 2008 R2 Express in this Execute 10000 Record Insert For While loop Pl-SQl Get elapsed Time 43 Sec..
And Same Query Insert Other Simple System (Config - i3 Processor, Ram-4Gb, HDD 250GB) in this execute Got Elapsed Time 2 Sec..
How can Solve this Different Between Hp Server & simple System Elapsed Time ..?
Hoe can Solve Hp Server Get Much time When 10000 Insert Query (While Loop) Execute.?
Regard
Saurabh Mishra. R
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
Mark as answer or vote as helpful if you find it useful | Igor
------------------------------------
Reply:
------------------------------------
Reply:
Often laptops and workstations have disk write caching enabled. If you are inserting row-by-row without an explicit transaction, then your transaction log file must be flushed after every insert. So if you are inserting in a While Loop, be sure to use a transaction, so you can wait to flush the log file after the last row.
David
------------------------------------
Reply:
Glad to help! Please remember to accept the answer if you found it helpful. It will be useful for future readers having same issue.
My Profile on Microsoft ASP.NET
------------------------------------
Reply:
Thank for Suggestion. Im Provide Bulk sms in this par 10 sec 10000 sms Execute in this Insert Row-by-row Query Because par sms check Condition Balance.
How to Improve My insert Query Profarmation? & How can i use flushed after every insert. row - by - row. Pls Suggest me...
------------------------------------
Reply:
------------------------------------
Reply:
Glad to help! Please remember to accept the answer if you found it helpful. It will be useful for future readers having same issue.
My Profile on Microsoft ASP.NET
------------------------------------
Reply:
>How to Improve My insert Query Profarmation? & How can i use flushed after every insert.
Post your code and your table definitions (DDL), and we can advise you.
David
------------------------------------
2007 -> 2013 coexistence issues
Hello Everyone,
I am currently in the process of setting up coexistence for exchange 2007 and 2013. My understanding is that all the internal URL's from 2007 must be configured to be the same in 2013 and then all the DNS records will be changed to point to the 2013 server. The problem I have run into is that all the internal URL's including the SCP use the 2007 server's name. I am not sure how to proceed, can I just use a new internal URL for the 2013 server and change the SCP? Will Autodiscover then just point my existing clients to the 2013 server? I don't think I can repoint the 2007 servers primary DNS record to the 2013 server without causing multiple issues. I tried to create a legacy dns and changed the 2007 server settings described in http://blogs.technet.com/b/meamcs/archive/2013/07/25/part-1-step-by-step-exchange-2007-to-2013-migration.aspx and I ran into all kinds of mail transport issues. We are also using a Barracuda spam firewall appliance and Cisco IronPort secure email.
Exchange 2007
IP address: 10.0.1.2
Server Computer Name: mlsrv.domain.local
Internal URL's : mlsrv.domain.local
External URL's (only setup for owa): mlsrv.domain.com
Exchange 2013
IP address: 10.0.1.3
Server Computer Name: EX13.domain.local
Internal URL's: ???
External URL's: ???
Thanks,
Reply:
------------------------------------
Reply:
I would say is to look at these links:
And the Exchange Deployment Assistant:
https://technet.microsoft.com/en-us/exdeploy2013/Checklist?state=2419-W-AAAEAAAAQACIAAEAAQAAAAA~
I would also like to say, that the native Exchange Mailbox move from Exchange 2007 to Exchange 2013 is an online move, meaning the user stays connected to Exchange until the move request completes and cuts everything over to Exchange 2013. At that point they will receive a prompt to restart Outlook and they will need to restart Outlook to gain access to their mailbox again. While I haven't used a third party tool to perform this work, I would think that the behavior is the same if you use a third party tool.
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread
------------------------------------
email lost
Dear All ,
i have currently exchange 2013 single server and we lost the power for about 12 hours , after that i have restart the exchange server and unfortunately the email during this time is not exist !!!
is this how it should work or there is something wrong ?
Reply:
------------------------------------
Reply:
This is the same response as I mentioned on your other thread:
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread
------------------------------------
Merging informations in a csv file .
Hi folks, i have a csv file and i want to merge the informations in it .
For example the input is like
Name , Number, slot
A , 5 , 7
B , 1 , 10
C , 3 , 6
B , 10 , 2
A , 9 , 2
And i want to sum up Nb and slot for the same users have
Name, Nb, Slot
A, 6, 6
B, 13, 7
C, 4, 10
D, 4, 13
This is just an example, the file i'm using is with reel usernames and around 1000 rows .
Any help will be grateful , i'm quite new in powershell .
Reply:
Sorry the output is not correct , the correct one is
Name, Nb, Slot
A, 14, 9
B, 11, 12
C, 3, 6
------------------------------------
Reply:
$CSV = "Name,Number,slot A,5,7 B,1,10 C,3,6 B,10,2 A,9,2" $Data = ConvertFrom-Csv $CSV $Result = ForEach ($User in ($Data | Group Name)) { [PSCustomObject]@{ Name = $User.Name Nb = ($User.Group | Measure-Object Number -Sum).Sum Slot = ($User.Group | Measure-Object Slot -Sum).Sum } } $Result | ConvertTo-Csv -NoTypeInformation #Output "Name","Nb","Slot" "A","14","9" "B","11","12" "C","3","6" ------------------------------------
Reply:
This is the easy way:
Import-Csv file.csv | group -property name | select name, @{N='Nb';E={$_.Group | (Measure -Sum Number).Sum}}, @{#add sum for slot} \_(ツ)_/
------------------------------------
IPAM not working for DHCP server
Hello,
I have a problem with implementing IPAM.
Here is my configuration:
- DCSRV - DC, DNS
- DHCPSRV - DHCP
- IPAMSRV - IPAM
I went over IPAM configuration steps, GPOs have been created, computer accounts have been associated to the appropriate GPOs.
DCSRV connection works and is in Unlocked state, but DHCPSRV doesn't connect with IPAM. IMAP Access Status is Blocked, DHCP RPC Access Status and DHCP Audit Share Access Status are Unblocked, but Event log Access Status is Blocked. Any idea what is wrong? Ports on firewall are opened.
Thank you!
Best wishes,
Marko
- Changed type Tiger LiMicrosoft employee Tuesday, May 22, 2012 1:23 AM
Reply:
Hi Marko,
Thanks for posting here.
> DCSRV connection works and is in Unlocked state, but DHCPSRV doesn't connect with IPAM.
> but Event log Access Status is Blocked
Have we verified the membership of 'Event Log Readers' security group and the corresponding remote management firewall rules enablement(Remote Event Log Management (RPC) and Remote Event Log Management (RPC-EPMAP))?
Understand and Troubleshoot IP Address Management (IPAM) in Windows Server "8" Beta
http://www.microsoft.com/en-us/download/details.aspx?id=29012
Thanks.
Tiger Li
Tiger Li
TechNet Community Support
------------------------------------
Reply:
Hello,
it was the firewall problem.
Thank you!
Best wishes,
Marko
------------------------------------
Reply:
Hello Marko,
if you have IPAM installed and the first Server discovered, the possibility exist that the GPO was not proceed in a short time. The following means:
- the IPAM GPO configure the Firewall, so DHCP server and IPAM server can communicate
- if the GPO is not run " default GPO update schedule 90min +- , no Firewall Role is automatically adjusted
in some situation the GPO creates the task but the task cannot run if global PowerShell execution policy is set to unrestricted. in this case, no IPAM-GPO created task will be run ever, you can check this in the task scheduler. the reason for that is, the command line insight the scheduled task is the problem , the Task will be run the command " PowerShell.exe -execusionpolicy BYPASS ..." that create a Error, because the System "global" Execusionpolicy cannot overwritten by the command line setting.
we have found some strange addiction.
the solution from Tiger Li is the manual way to solve the problem, the right way should be that the GPO update must be run on the discovered Server. GPUPDATE on the DHCP server would have already helped.
Rgds
------------------------------------
Reply:
Hello,
A colleague and I spent a few hours on this one after receiving all of the same symptoms described above. After verifying all of the GPOs, group membership, and security permissions we noticed the Windows Event Log Collector service was set to manual and stopped.
We starting this service, and then unchecking/rechecking the DHCP option in the IPAM management console the server status switched to unblocked.
If you're receiving a similar error, and notice the 'access denied' warnings in the event log try checking this service.
Hope this helps.
------------------------------------
Reply:
------------------------------------
Reply:
solved it! the reason of this problem is the DHCP group policy dosn't apply to DHCP server. you can go to group policy & see the delegation tab of "IPAMx-DHCP" & add the computer account of dhcp server to list. check that enroll permission must set on Allow.
type gpupdate /force on dhcp server.
Regards
Hadi Hashemi
------------------------------------
Tray icon is not showing up == no toast on mitigation
Hello,
We've deployed EMET on about 40% of our in-house PCs and a vast majority, although having at first, no longer have the EMET Agent tray icon showing up in the Notification Area/System Tray. Because of this, users are not alerted when a mitigation has taken place, and an event is not logged to the event log. To note, EMET_Agent.exe has started and the GPO for Reporting to Event Log, Tray Icon and even Early Warning are enabled.
Any idea why the tray icon wouldn't be showing up?
Thanks,
Matt
Whoops... always useful to make sure that the "EMET Agent Visibility" policy is set to disabled if you want the EMET Agent visible.
The Integrated Windows authentication endpoint is missing on the internal metadata document.
Hi,
Using the Remote Connectivity Analyzer, I'm getting the following error when testing SSO:
Analyzing the ADFS metadata document for configuration problems.
Errors were found while analyzing the ADFS metadata document.
Additional Details
The Integrated Windows authentication endpoint is missing on the internal metadata document.
I have followed the kb articles related to this:
https://support.microsoft.com/en-us/kb/2712957
https://support.microsoft.com/en-us/kb/2647048
I checked all the AD FS endpoints, and I "repaired" the domain. Any idea what else it could be?
Thanks, Chris
- Changed type Frank Shen5 Wednesday, June 10, 2015 8:17 AM Redirected
Reply:
Small addition: here's the part of the /adfs/services/trust/mex document that describes windowstransport:
<wsdl:port name="CustomBinding_IWSTrustFeb2005Async" binding="tns:CustomBinding_IWSTrustFeb2005Async">
<soap12:address location="https://infosys-c1-dc.performisonline.ch/adfs/services/trust/2005/windowstransport"/>
<wsa10:EndpointReference>
<wsa10:Address>https://infosys-c1-dc.performisonline.ch/adfs/services/trust/2005/windowstransport</wsa10:Address>
<Identity xmlns="http://schemas.xmlsoap.org/ws/2006/02/addressingidentity">
<Upn>infosystem@performisonline.ch</Upn>
</Identity>
</wsa10:EndpointReference>
</wsdl:port>
What I don't understand is the part where it says <Upn>infosystem@performisonline.ch</Upn>. I compared this to the /adfs/services/trust/mex document of a working installation. There I don't have the <Upn> element, instead I have a <Spn> Element containing the host name of the ADFS server.
------------------------------------
Reply:
This posting is provided AS IS with no warranties or guarantees , and confers no rights.
Ahmed MALEK
------------------------------------
Reply:
------------------------------------
[Forum FAQ] Create a task list view without timeline using Server Object Model in SharePoint 2013
Introduction:
Need to create a task list view without displaying the timeline using Server Object Model(C#) in SharePoint 2013.
Solution:
We can create a task list view without the timeline from UI by default, but in code, we need to set ViewData property of the SPView object to empty to achieve this.
The code snippet as below:
using (SPSite site = new SPSite("http://sp2013sps/")) { using (SPWeb web = site.OpenWeb()) { SPList list = web.Lists["TaskList"]; SPViewCollection allviews = list.Views; string viewName = "Test View"; System.Collections.Specialized.StringCollection viewFields = new System.Collections.Specialized.StringCollection(); viewFields.Add("Checkmark"); viewFields.Add("LinkTitle"); viewFields.Add("Due Date"); viewFields.Add("Assigned To"); string myquery = "<where><gt><fieldref name='ID' /><value type='Counter'>0</value></gt></where>"; allviews.Add(viewName, viewFields, myquery, 100, true, false); SPView view=list.Views[viewName]; view.ViewData = ""; view.Update(); } } Please click to vote if the post helps you. This can be beneficial to other community members reading the thread.
Reply:
Hello,
Good one!
To avoir any misunderstanding can you just update the code of the query to reflect the case sensitiveness of CAML from
string myquery = "<where><gt><fieldref name='ID' /><value type='Counter'>0</value></gt></where>";
to
string myquery = "<Where><Gt><FieldRef Name='ID' /><Value Type='Counter'>0</Value></Gt></Where>";
Best regards, Christopher.
Blog | Mail
Please remember to click "Mark As Answer" if a post solves your problem or "Vote As Helpful" if it was useful.
Why mark as answer?
- Edited by Christopher ClementEditor Thursday, May 28, 2015 7:46 AM typo
------------------------------------
sharepoint admin blogs
hi,
i need some sharepoint admin blogs for issues and improving knowledge.
thanks,
sri
Reply:
Hi,
I have included a few blog links below that I read :
Maurice Prather http://www.bluedoglimited.com/default.aspx
Wictor Wilen http://www.wictorwilen.se
Ted Patisson http://blog.tedpattison.net/default.aspx
Cheers,
-Ivan
------------------------------------
Reply:
HI Sri,please check the blog for more details on Installation,Updates,Search,Service applications and The solutions for the issues occurred in sharepoint.
http://expertsharepoint.blogspot.de
Anil Avula[Partner,MCP,MCSE,MCSA,MCTS,MCITP,MCSM] See Me At: http://expertsharepoint.blogspot.de/
------------------------------------
SQL Server 2016 CTP 2 is available
Hello community,
The new SQL Server 2016 CTP 2 is now available as a public download at: https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016
I wish much fun with testing the new features: What's New in SQL Server 2016
Olaf Helper
[ Blog] [ Xing] [ MVP]Specific Column is not Searchable in SharePoint 2010
Hi,
I have a SharePoint site, and a list we are not able to get search results for one Column content in a list, for other columns in the same list I am able to search the content. Help me if you have any thoughts.
Reply:
Ib Search service application, Check if the column is mapped to any managed property or not. To appear a column in search results, it should be mapped to managed property. Usually, Sharepoint does that automatically, still worth a try.
Thanks,
Ved
------------------------------------
Reply:
Check you have mapped the managed properties.
https://technet.microsoft.com/en-us/library/ff621097(v=office.14).aspx
It's only automatic for site columns, not columns added directly to a list.
Please ensure that you mark a question as Answered once you receive a satisfactory response. This helps people in future when searching and helps prevent the same questions being asked multiple times.
------------------------------------
Reply:
Hi,
Is this issue happening on this particular site and is that a custom column?
You can check the Searchable Columns option under site settings and If possible, you can try to reset the index, and re-start a full crawl.
Regards,
Reema Bhingarde
------------------------------------
Whats best method to transfer SQL data from multiple DB servers' site to a central DB over the internet
Reply:
Andy Tauber
Data Architect
The Vancouver Clinic
Website | LinkedIn
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.
------------------------------------
Reply:
On-going.
Would require simultaneous data upload/push from multiple remote sites 500+ (hosting SQL 2008 Servers/IIS) to a central repository hosted at an internal network DC via DMZ. Data size of required fields from the DB tables for each site would approx. be 5mb and the format can take form of xml or csv as exported from the SQL DB. Need a design that would provide reliability, integrity and scalability of the infra setup.------------------------------------
SBS 2011 "windows console wont start
I tried to repair it however is says to insert the sbs CD. SBS 2011 was installed using a file downloaded from Microsoft. which is stored on an off line back hard drive.
I am on vacation is there another way around this, our mail server is down
Thanks
Thanks
Reply:
Hi:
Are you sure it is not asking for the SBS Recovery/Repair DVD?
For either, if you have the ISO file you can create the DVD or one of your co-workers can.
But for the mail being down review the event logs and the ESM to see what might be the underlying issue. In Services make sure all the services are started.
Larry Struckmeyer[MVP] If your question is answered please mark the response as the answer so that others can benefit.
------------------------------------
Reply:
yes my apologies, the sbs 2011 was a downloaded file we never got a repair download that I am aware of
Thanks
------------------------------------
Reply:
Hello Ian,
Question is Why do you want to repair SBS ? What went wrong that you are taking this particular step? Could you please explain the issue in detail, so that we can provide you a netter solution. Mail server is down, is it like dead, not booting up ? Crashing ? Unable to send and receive emails with the server being up. etc !!!
If incase of any queries give me a call - 214-347-7988
Binu Kumar - MCP, MCITP, MCTS , MBA - IT , Director Aarbin Technology Pvt Ltd - Please remember to mark the replies as answers if they help and unmark them if they provide no help.
------------------------------------
Sparten - Open all favourates in a folder
Is there a way to open all favourites in a favourites folder as you can in IE?
I have a folder of all my standard web pages in IE, clicking the right arrow when you hover on the folder opens each in a separate tab.
- Changed type Michael_LSModerator Tuesday, June 9, 2015 2:38 AM
Reply:
Hi Paul,
Thanks for the feedback.
It seems that in Spartan, right click the folder, then choose to open in New Tab under Favorites could only open the lasted saved page.
Please take use of the Feedback Tool to submit what you suggested.
Regards
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.
------------------------------------
Unable to install MSXML 6 SP2 (KB973686) setup was interrupted
Hi,
MSXML 6 SP2 (KB973686) setup was interrupted
Setup was interrupted before MSXML 6 Service Pack 2 (KB973686) could be completely install.
Current operating system: Microsoft Windows Server [Version 6.0.6001]
Current MSXML6 version: 6.20.1099.0
I've tried to search for a solution and despite the many threads mentioning the use o Windows Installer CleanUp Utility to remove MSXML 6. I executed the cleanUp Utility and nothing happens since the tool does not detect the installation.
So basically I'm stuck
Regards
RG IT Department
- Edited by rjbgaspar Wednesday, May 27, 2015 12:38 PM
- Changed type Vivian_Wang Friday, May 29, 2015 9:18 AM
Reply:
Might try over here.
https://social.msdn.microsoft.com/Forums/en-US/home?forum=xmlandnetfx
Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows]
Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.
------------------------------------
No comments:
Post a Comment