ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login
    1. Topics
    2. gjacobse
    3. Posts
    • Profile
    • Following 2
    • Followers 5
    • Topics 711
    • Posts 9,609
    • Groups 1

    Posts

    Recent Best Controversial
    • Windows Easy Transfer (Wizard)

      It's long after the fact, but has anyone used the WET to move someone from a XP pro system to 7Pro?

      I used WET a few months back and when restored the person's mail, contacts and calendar were lost (Outlook). I've done some checking and even re-ran the import and still not finding the .pst files.

      Just looking at the Modify your Selection options, you can get to the Doc&Settings/$user, but it only shows Desktop, MyDocs, Fav, Start menu, nothing below that.

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: Change your GMail password - 5 million accounts leaked

      Oh joy,.. I only have 6 gMail accounts... or is it 8? I don't remember.

      Has anyone opened the file to search it?

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: Chef Enterprise Now Free Up to 25 Nodes

      Guess I need to learn more about it, but am not sure if it would help us.
      But maybe right now isn't the time to look into it as I need to deal with the Domain, AD and security issues first.

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: Rack / Table For Tower Servers

      Better then what I have / had.

      Last office was a folding table with a HP ML350 on it... The other new Dell PE2900 was on the floor,.. the firewall - same place.. floor. With the 2 APC UPS 1500s.

      Oh - the sprinkler head was right above it all.. Poor design / placement for the network infrastructure.

      New office has 2 buildings in a H floor plan. End of each main hall is a utility closet, half with the HVAC, other half....well. stuff.

      Of the 12 closets I have 7 servers sitting in them,.. no real ventilation on each.. It's a plan to deal with it, and a rack is planned...

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: Bundled Patch Cables for Cable Management

      @scottalanmiller said:

      I'd use velcro instead.

      Good point. If you had to remove just one cable you're in for a bit of work to pull it out of the spiral stuff.

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: Bundled Patch Cables for Cable Management

      Interesting concept,.. but something you can easily do after a trip to ACE Hardware, LOWEs or Home Depot..

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: Excel 2007 vs 2010

      @ajstringham said:

      @g.jacobse said:

      I'm not sure how much I can offer - it's a protected sheet, we are only allowed to enter some data. But there are 4 date fields and a day calculated from that.

      Start Date; Release Date; First date of month, last date of month.

      Here is the formula which is in column "K":

      =IF(ISBLANK(H5),"",IF(ISBLANK(G5),"Enter START DATE to calculate",IF(AND(MONTH(EOMONTH($A$2,1))>MONTH(G5),MONTH(G5)>=MONTH($A$2)),IF(ISBLANK(F5,EOMONTH($A$2,0)-G5+1,H5-G5),"START DATE MUST BE >= "&TEXT($A$2,"mm/dd/yyyy"))))

      Column Fields:
      e= Arrival Date
      f= Release Date
      g=Start date
      h= end date
      k=#of days formula above

      Based on what I've tried,.. the formula works as long as you don't enter anything in the Release date. Once you enter the release date, the #of days drops by 1.

      I'm told it works 'correctly' on one computer. I've tried two computers here one with 2010 and one with 2007 and get the same result. count is off by 1 (30 days rather than 31).

      I believe the MONTH variable is 30 days. That's probably where the issue is.

      I can see that being the case. However: Why would it work on one computer and not on any other.

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: Excel 2007 vs 2010

      Something I might should have done (it's more advanced Formulas than I know) - is copy the formula into a new clean workbook.

      I do get an error: You've entered to many arguments for this function.

      I also see that the formula in row 5 calls Row2 Col 1 which is current begin date of the month.

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: Excel 2007 vs 2010

      I'm not sure how much I can offer - it's a protected sheet, we are only allowed to enter some data. But there are 4 date fields and a day calculated from that.

      Start Date; Release Date; First date of month, last date of month.

      Here is the formula which is in column "K":

      =IF(ISBLANK(H5),"",IF(ISBLANK(G5),"Enter START DATE to calculate",IF(AND(MONTH(EOMONTH($A$2,1))>MONTH(G5),MONTH(G5)>=MONTH($A$2)),IF(ISBLANK(F5,EOMONTH($A$2,0)-G5+1,H5-G5),"START DATE MUST BE >= "&TEXT($A$2,"mm/dd/yyyy"))))

      Column Fields:
      e= Arrival Date
      f= Release Date
      g=Start date
      h= end date
      k=#of days formula above

      Based on what I've tried,.. the formula works as long as you don't enter anything in the Release date. Once you enter the release date, the #of days drops by 1.

      I'm told it works 'correctly' on one computer. I've tried two computers here one with 2010 and one with 2007 and get the same result. count is off by 1 (30 days rather than 31).

      posted in IT Discussion
      gjacobseG
      gjacobse
    • Excel 2007 vs 2010

      Would there be any differences in how formulas are processed between 2007 and 2010?

      I've got a spreadsheet which I'm guessing was created in 2010 and being used in 2007. It's saved in .xlsx format, but the formula isn't calculating correctly in 2007. And for <me> in either 2007 or 2010....

      posted in IT Discussion excel
      gjacobseG
      gjacobse
    • RE: Deepin 2014

      It looks like a sweet setup.

      reading the About page triggers a voice in my head - is it safe / secure?

      I know that question smacks of complete distrust and such, I'm not a real conspiracy nut; but i/m generally cautious of software....

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: Twenty Old Tech Sounds

      I imaging with the progression of things, that the Click of a hard drive head crash will be one we add to that list some time in the next 10 - 20 years. As SSHD increase in capacity... we'll use SATA less.

      *click, click whir; click, click whir"

      posted in IT Discussion
      gjacobseG
      gjacobse
    • (xx)HD Test / Wipe tool(s)

      My brother asked me about how I would test and wipe a hard drive..,.. Any type. He has some old SCSI type, as well as PATA and SATA drives.

      Other then spending hours with only one computer going from back and forth with a drive or spending upwards to $1800, is there a way to test a drive to see if it's still 'trustworthy' or toast,.. and then wiping them.

      This is a personal level thing - he's picked up a stack of drives and want to be able to either use them or destroy them with no or little cost.

      posted in IT Discussion sshd hdd sata scsi
      gjacobseG
      gjacobse
    • RE: O365 Migration: Push

      Just deleted the script and created it again - it works,.. but extra steps.

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: UniFi: Admin panel

      @JaredBusch said:

      In the system tab there is a button to download/export the current config.

      Do that for the one you want to keep. Then reinstall on the new hardware. When you first open the webpage on the new controller there is an option to import a backup. Do that. You will retain all settings from that config.

      That has been done. I don't know the version I'm running currently, but I'll check. In the meantime,.. I'll pre-download the newest version and go from there.

      Thanks Jared.

      posted in IT Discussion
      gjacobseG
      gjacobse
    • UniFi: Admin panel

      I've managed to end up with two laptops with UniFi data on them, and for different sites. This is because of "I need to do this and my laptop won't' having to loan out this one.

      I want to start fresh,.. and not kill my configs, but if I have to that's okay too. My goal is to set all the APs with the same information, and at some point controllable from my main office (via vpn).

      Where are the config files? Looking on this system, they aren't where I would expect. My Docs or in the PGM folder.

      posted in IT Discussion unifi ubiquiti
      gjacobseG
      gjacobse
    • RE: O365 Migration: Push

      @JaredBusch

      Sadly - not everyone has gotten started in O365 yet... we are still in transition.

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: O365 Migration: Push

      @JaredBusch said:

      coming from pop3 what is there to migrate? this is used to migrated from another exchange server.
      When you import a PST locally it ups everything.

      I guess I am confused on what you are migrating.

      While we can setup as POP, Seems that many are setup as iMAP. Anyone I set up has been as iMAP since many moved around to different computers.

      Many only us the webmail interface, so all their mail is still abled to be pulled.

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: O365 Migration: Push

      @JaredBusch
      Pretty much. There was - or at least so I thought a 'triangle' in the options ( Add, Edit, Delete, Refresh). To 'push start' or manually start it.

      Seems one of my items hasn't run since Saturday, I've not had new mail in two days now.

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: O365 Migration: Push

      @Dominica; I am doing this from the GUI. I haven't had the time, interest, or motivation to consider Powershell.

      It just seemed interesting that I was able to do the manual start last week via the GUI, and this week I can't seem to locate it.

      posted in IT Discussion
      gjacobseG
      gjacobse
    • 1 / 1