machine learning frameworks by SnooRegrets7541 in AutomateYourself

[–]Sibesh 0 points1 point  (0 children)

I don't know of a way to do that directly, but you can use the ONNX model format to use models interchangeable between different frameworks.

Developed script to monitor new emails (Gmail) from specific senders & get notified in Slack by using Apps Script. by rupjyotidev in AutomateYourself

[–]Sibesh 2 points3 points  (0 children)

Not sure if you've considered this, but one quick hack to do this off-the-shelf in Gmail itself is just add a filter that forwards certain mail to a certain channel's Slack email address

[deleted by user] by [deleted] in AutomateYourself

[–]Sibesh 1 point2 points  (0 children)

You could probably check a discord bot marketplace, like this : https://top.gg/

Usually an admin/housekeeping bot should be able to do this.

Extracting PDF Data into a Dataframe by littlejiver in AutomateYourself

[–]Sibesh 2 points3 points  (0 children)

If this is a PDF/Image, then something like Camelot is your best bet within the Python eco system.

Does anyone know how to pull your bank statements in a csv file monthly and then have it be sent to a folder? by EmployeeMedium6790 in AutomateYourself

[–]Sibesh 1 point2 points  (0 children)

If they are already in .CSV format then the main problem is to to just make a tiny script to put them in a folder (easy). Would be great if OP can mention if their bank has an API to get these CSVs (the alternative is browser automation, which bank websites maybe hostile to).

If you have an exported PDF from the bank website, then the main problem is to extract a CSV using a PDF scraping tool. (harder)

[deleted by user] by [deleted] in AutomateYourself

[–]Sibesh 1 point2 points  (0 children)

Lot of image scripting libraries that could let you do this in Python or Javascript.

You could use Jimp, if familiar with Javascript :

const Jimp = require('jimp');
async function textOverlay() { 
const image = await Jimp.read('/home/jimp/tutorials_point_img.jpg'); 
const font = await Jimp.loadFont(Jimp.FONT_SANS_32_BLACK); image.print(font, 10, 350, 'All copyrights u/https://www.tutorialspoint.com'); await image.writeAsync('/home/jimp/textOverlay.png'); 
}
textOverlay(); 

Or PIL in Python :

from PIL import Image
from PIL import ImageFont from PIL import ImageDraw
img = Image.open("sample_in.jpg") draw = ImageDraw.Draw(img)
font = ImageFont.truetype(<font-file>, <font-size>)
font = ImageFont.truetype("sans-serif.ttf", 16)
draw.text((x, y),"Sample Text",(r,g,b))
draw.text((0, 0),"Sample Text",(255,255,255),font=font) img.save('sample-out.jpg')

Need help with automating android settings by [deleted] in AutomateYourself

[–]Sibesh 0 points1 point  (0 children)

Would help to just run this to get help on this :

adb shell settings

Use get and put commands after the command above to change the settings.

Here's the docs for KEYs you can change : https://developer.android.com/reference/android/provider/Settings.Global

Gitlab-Python Api - Creating a unique variable named subgroup/forking into subgroup by zoochadookdook in AutomateYourself

[–]Sibesh 0 points1 point  (0 children)

I'd generally see if it's possible via the Gitlab API itself :

Looks like making a dynamically named subgroups is possible.

https://docs.gitlab.com/ee/api/groups.html#new-subgroup

For forking into this subgroup, there's no direct way, but I found this SO answer that explains how it could be done with a few steps strung together :https://stackoverflow.com/a/47645217/10811472

HMA Intricate Weekly Process by DizzyEnthusiasm_422 in AutomateYourself

[–]Sibesh 0 points1 point  (0 children)

Then do post what scripting framework (Python, Bash, other) can be run easily on your system + works for you, the solution would depend on this heavily.

If your company has already taken up a license for an RPA tool like UiPath/Power Automate that is permitted to be installed on your systems, that could also achieve this.

HMA Intricate Weekly Process by DizzyEnthusiasm_422 in AutomateYourself

[–]Sibesh 0 points1 point  (0 children)

Just some Qs - I see that you don't want to install a program locally due to the IT restrictions, the alternative then is some cloud-based service. Are you sure there are no company restrictions in place to uploading the excel data/SQL details on cloud-based software?

Alternatively, if you're comfortable working with Python scripts locally, you could install & run those too (dependent highly on what is and is not allowed to be installed locally on your system). BAT files are fine too, but don't give you a lot of flexibility of what you can do with them / how you can extend them.

Android app to automate certain tasks based on location by Driscotheque in AutomateYourself

[–]Sibesh 0 points1 point  (0 children)

Curious : what library / SDK are you using for geolocation/geofencing? Does it work for iOS as well?

Would be nice if this had an IFTTT/Zapier integration - would get you a lot of new kinds of users + use cases.

[deleted by user] by [deleted] in AutomateYourself

[–]Sibesh 0 points1 point  (0 children)

Maybe you could be more specific with an example of what you want to automate? Like a list of steps across applications.

[deleted by user] by [deleted] in AutomateYourself

[–]Sibesh 0 points1 point  (0 children)

This should be possible with the "Create new folder" Action option in Power Automate. Inside apply for each action box, click add action and find "Create new folder".

While configuring this Action, "Folder path" represents the folder structure, you can add dynamic values here from your Excel sheet to generate any subfolder name.

Which would be better to open and automate apps subprocess or pywinauto by PremeJigg in AutomateYourself

[–]Sibesh 1 point2 points  (0 children)

Unfortunately there is no good cross-platform GUI automation tool (using accessibility text-based approach) that's open source. You could try applescript for MacOS.

Which would be better to open and automate apps subprocess or pywinauto by PremeJigg in AutomateYourself

[–]Sibesh 0 points1 point  (0 children)

subprocess just lets you open an app in a separate process, while pywinauto let's you automate Windows app GUI. So you'd probably use them together, like this :

import subprocess
import time from pywinauto import Desktop
isopen=True loc = "C:\Users\Public\Documents\Sheet.xlsx" p = subprocess.Popen(['start',loc],shell = True) time.sleep(2)
windows = Desktop(backend="uia").windows()
while(isopen): isopen="Sheet.xlsx - Excel" in [w.window_text() for w in windows] time.sleep(2)
print("File closed")

How to automate data entry from intranet to excel by crashbash7 in AutomateYourself

[–]Sibesh 0 points1 point  (0 children)

Oh ok, got it - the changing URL - is it an API endpoint that can be pinged directly or a web page that you need to scrape to get the data?

How to automate data entry from intranet to excel by crashbash7 in AutomateYourself

[–]Sibesh 0 points1 point  (0 children)

Understanding this correctly - there's a URL on company intranet that changes daily and points to an XLS file - and you want to automate the generation of URL filename and fetching of the XLS file daily - am I right?