ML
    • Register
    • Login
    • Search
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    1. Home
    2. Tags
    3. csv
    Log in to post
    • All categories
    • L

      Send CSV file to Slack Channel by bash script through Webhook
      IT Discussion • slack csv bash script webhook api • • Laksh1999

      6
      1
      Votes
      6
      Posts
      797
      Views

      stacksofplates

      @pete-s said in Send CSV file to Slack Channel by bash script through Webhook:

      @laksh1999 said in Send CSV file to Slack Channel by bash script through Webhook:

      @pete-s said in Send CSV file to Slack Channel by bash script through Webhook:

      @laksh1999 said in Send CSV file to Slack Channel by bash script through Webhook:

      Hi
      I am trying to send the assigned tickets in the queue as .csv file to the slack channel. I am able to download the .csv file in the dev desktop through bash script but unable to send that file to the Slack Channel.

      Anyone have tried this before?

      I have checked this

      https://api.slack.com/methods/files.upload

      I have only Webhook URL no other token is there with me as per the suggestion in the above link.

      You must have a token or some kind of authentication, otherwise anyone would be spam slack with files.

      Also the function you are looking at is not a webhook. Webhooks are triggered by an event. And they cause a http request to be sent.

      I accept with your point the csv file which i download is authenticated with the kerberos only.So is that enough and send the .csv file to the slack channel through the webhook ?

      @stacksofplates maybe you can offer some insight?

      At the bottom of the upload API page they give you an example of what you need. You need your API token and the channel ID(s) that you want to send the data to.

      curl -F [email protected] -F "initial_comment=Shakes the cat" -F channels=C024BE91L,D032AC32T -H "Authorization: Bearer xoxa-xxxxxxxxx-xxxx" https://slack.com/api/files.upload

    • J

      CSV... what happens at a lower level?
      IT Discussion • windows filesystem cluster shared volume storage csv microsoft • • Jimmy9008

      6
      0
      Votes
      6
      Posts
      187
      Views

      scottalanmiller

      @Jimmy9008 said in CSV... what happens at a lower level?:

      That makes sense, would a drop from 1GB/s to 100MB/s be expected? Seems huge...

      Depending on the system, yeah, especially with certain kinds of operations.

    • CCWTech

      Print to CSV
      IT Discussion • csv printers • • CCWTech

      21
      0
      Votes
      21
      Posts
      868
      Views

      scottalanmiller

      @Dashrender said in Print to CSV:

      @scottalanmiller said in Print to CSV:

      @Dashrender said in Print to CSV:

      @scottalanmiller said in Print to CSV:

      @Dashrender said in Print to CSV:

      @scottalanmiller said in Print to CSV:

      @CCWTech said in Print to CSV:

      From what I can tell the program we are using has a built in integration for Excel but you have to have Excel and not something like Libre Office.

      Likely using the Excel automation API that is unique.

      I spaced this one.

      I was thinking the application could be lame and trying to call the excel.exe executable directly. That could be solved with a link to LibreOffice executable - assuming the LibreOffice executable accepts the same arguments.

      In theory, yes. But I think it is using an API to make it output to CSV. Otherwise, we'd just expect it to open the file and sit there.

      I assume then that using the API is easier than the application simply outputing to CSV on it's own?

      I doubt it.

      sooooo... they did it why? bad programmers?

      Always, or they just hate the users. But the latter would be crazy.

    • scottalanmiller

      Struggling with Rocket.chat CSV Import
      IT Discussion • rocketchat csv • • scottalanmiller

      4
      2
      Votes
      4
      Posts
      999
      Views

      scottalanmiller

      @bbigford said in Struggling with Rocket.chat CSV Import:

      @scottalanmiller said in Struggling with Rocket.chat CSV Import:

      I often find that the ACT of posting something makes me think about it and fix the issue. The issue was that I was zipping the folder that contained the files rather than making a "flat zip" file. It is working now.

      Ah, so you had to zip the contents is all, rather than zip the folder?

      Yeah.

    • Oksana

      Don’t break fingers with hundreds of clicks – automate Windows iSCSI connections
      Starwind • csv iscsi powershell vsan • • Oksana

      1
      1
      Votes
      1
      Posts
      432
      Views

      No one has replied

    • Oksana

      How to upgrade your Windows Server with zero downtime
      Starwind • failover cluster starwind blog starwind vsan vsan virtual san windows server 2012 r2 windows server 2016 zero downtime cluster shared volumes csv cluster rolling upgrade • • Oksana

      1
      4
      Votes
      1
      Posts
      806
      Views

      No one has replied

    • Oksana

      Strengthening Cluster Shared Volume security with Microsoft BitLocker encryption
      Starwind • bitlocker microsoft encryption data protection starwind blog windows server cluster shared volume csv starwind powershell failover cluster • • Oksana

      1
      3
      Votes
      1
      Posts
      775
      Views

      No one has replied

    • gjacobse

      WordPress: Create Form
      IT Discussion • wordpress excel csv • • gjacobse

      4
      0
      Votes
      4
      Posts
      685
      Views

      stacksofplates

      Use Drupal. It's almost purpose built for this type of stuff. Custom content types and views make anything possible.

    • P

      Powershell - AD permissions all users
      Developer Discussion • powershell csv • • pally

      37
      2
      Votes
      37
      Posts
      7330
      Views

      P

      thanks @dafyre looks good, but I have been doing a bit of reading online and I think I will change the output to make it output the data as rows with each user named with what member they are part of next to there name. two columns. in other words the output would be "Transpose" and then I would use a pivot table to do the rest.

      still working on it, but if anyone knows of an easy way please do share 🙂

      again thank @dafyre

    • P

      Powershell - Network share permissions user level
      Developer Discussion • powershell csv • • pally

      7
      2
      Votes
      7
      Posts
      2451
      Views

      P

      Team,

      I have made some head way, but what I need to know is how do I call the function "MyADGroups" in my script. not sure if the below script is correct, but what it needs to do is check who has access to the parent folder and all the children folders only, if its inherited I do not want to know, which the script does :). but if it is a Group it needs to expand the group and show me the users only.

      I have done a function but I am not sure if it is correct and it will output the data I need.

      $exclude = @( 'CREATOR OWNER' 'NT AUTHORITY\SYSTEM' 'BUILTIN\Administrators' 'HTBPLC\Domain Admins' ) Function Get-MYADGroups($GroupsAD){ Return Get-ADGroupMember -Identity $GroupsAD -Recursive | Where {objectClass -eq "User"} } # Get-ADGroupMember -Identity -Recursive | Get-ADUser -Property DisplayName | Select Name,ObjectClass,DisplayName? $credentials = Get-Credential Get-ADUser -Credential $credentials -Filter * -Properties DisplayName,EmailAddress,memberof,DistinguishedName,Enabled | % { $RootPath = "\\XYZ.net\users\GP\DEPT\IT\" $folders = [array](Get-Item -Path $RootPath) $folders += Get-ChildItem -Path $RootPath -Recurse -Directory $acls = foreach ($Folder in $Folders){ get-acl $Folder.fullname | Select-Object -ExpandProperty Access | Where-Object { -not $_.IsInherited -and $exclude -notcontains $_.IdentityReference } | Select-Object -Property *,@{ 'Name' = 'Folder' 'Expression' = { $Folder.FullName }} }} $acls | Export-Csv -NoTypeInformation -Path C:\NTFS\DEPARTMENTS1.csv

      @DustinB3403 @dafyre can you maybe help me out on this one, should be a quick fix, just need to know if I am on the right tracks.

      Thanks

    • DustinB3403

      Powershell - Network Share Permissions CSV
      Developer Discussion • powershell csv smb script • • DustinB3403

      1
      4
      Votes
      1
      Posts
      865
      Views

      No one has replied

    • gjacobse

      Restructuring Text file to CSV
      IT Discussion • text editor csv excel • • gjacobse

      26
      1
      Votes
      26
      Posts
      4105
      Views

      JaredBusch

      @Carnival-Boy said:

      the wonderful, and under-rated, Microsoft Access.

      Die in a fire heretic!

    • coliver

      Powershell Import-CSV issue
      IT Discussion • powershell import-csv csv • • coliver

      14
      1
      Votes
      14
      Posts
      2914
      Views

      coliver

      I found an even easier way.

      $guid.id

      Since the $guid is a Powershell custom object you can call individual elements of it. This is the first time I've really dug into Powershell but this is a good thing to know.

    • gjacobse

      Data Export from Database
      IT Discussion • microsoft access excel csv • • gjacobse

      17
      1
      Votes
      17
      Posts
      3922
      Views

      scottalanmiller

      @JaredBusch said:

      @scottalanmiller said:

      If you learn a language just to do this, Python would be my recommendation. Specifically well suited to learning, good for doing small scripts of this nature and good for list processing like this. It's just a good fit. But yeah, if you know some other language already, definitely go with that.

      I dislike any whitespace delineated language.

      I do hate that aspect of it, very Fortrany, but it does make readability a clearer priority for the newbies and can have benefits, especially when working in teams of non-full time programmers.