@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

@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.

@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.

@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.

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

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

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

@Carnival-Boy said:

the wonderful, and under-rated, Microsoft Access.

Die in a fire heretic!

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.

@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.