10 ай бұрын
Пікірлер
@smithakurup7435 16 сағат бұрын
How to automate for old email attachment?
@puchingballz 4 күн бұрын
any idea on how to setup a filter range for dates, so the date column shows a range of values between a minimum and maximum given?
@theDataCorner Күн бұрын
Hello. Let me check if openpyxl can be used for applying filters.
@jeremyeckardt4494 8 күн бұрын
Anyone know if part 2 of this series is available?
@theDataCorner 6 күн бұрын
Hello Jeremy, I planned the part 2, but never got around doing it. I will look into it. Thanks and do check out other tutorials as well.
@Nocturnal-c2d 9 күн бұрын
Nice video 🤩, And how to create a new folder in OneDrive Business? The problem is that I see only in SharePoint that there is a "Create New Folder" action. Please tell me.
@theDataCorner 6 күн бұрын
Hello, thanks for watching the video. You can simply define the folder name within create file action. If the folder doesnt exist, power automate will create it, else it will access the existing folder. Check out below page for step by step solution: manueltgomes.com/microsoft/how-to-create-folder-in-onedrive-for-business/
@Nocturnal-c2d 6 күн бұрын
@@theDataCorner Alright, thanks a lot, i got it. 🤩
@asian1nvasion 11 күн бұрын
I wish all PDFs were that clean and well formatted. Unfortunately my item descriptions are spread over multiple lines and the library simply doesnt recognise some values from the table.
@theDataCorner 8 күн бұрын
We all wish that, my friend! may be add some regex in there for pattern recognition. There are some libraries where you can pick data between specific coordinates. Experiment around to see what works for you, best of luck!
@muhammedertas6259 12 күн бұрын
What about if the attachment is in the body of the email???
@theDataCorner 11 күн бұрын
Hello Ertas, Do you mean like an embedded image etc?
@RavishankarPathak-i4q 16 күн бұрын
Hey , nicely done but can you please give me your code
@theDataCorner 11 күн бұрын
Hello Ravi, I will check and provide the code. Thanks.
@theDataCorner 9 күн бұрын
Hello, please access the code from below location. codepad.app/edit/841v02vi
@SanjayKumar-o7d2n 28 күн бұрын
I want to set auto reply with unique ticket number and save the all ticket number in excel file .Also asgine the email as per ticket number to my team memebr and also set the ticket status( open ,close etc). How to do this.
@theDataCorner 27 күн бұрын
Hello Sanjay, You can replicate process of auto reply using my below power automate video. Link: kzbin.info/www/bejne/jYXPcpSbr9Kfq9U For saving the ticket number to excel, generate a unique ticket number, save it in a variable, then use the logic in this video to simply add the new ticket number to last row of existing excel file in OneDrive. How does system know what ticket # should be assigned to what team member? Will it be random? also, for ticketing system, you can use microsoft forms to achieve this task. Lot to unpack, let me know if above is helpful or if you have further questions. Cheers!
@SanjayKumar-o7d2n 27 күн бұрын
@@theDataCorner this is my requirmet. Can you please help me in this: 1. Email arrives received in office 365. 2. Create unique ticket numbers and send autoreply to email sender. 3. Attached incoming email as an attachment in excel. 4. I want to add username Sourav, Deepak, Sanjay in “Assigned To column” so that I can assign the email manually one by one after reviewing the email. 5. I want to add open, close, in progress in “Status columns”. By default once the ticket is created, status should be open. Once the user acts on that ticket, the user can change the status manually. 6. I have only office 365. Ticket Number From Subject Date Received Time Assigned To Status Email Attachment
@theDataCorner 23 күн бұрын
Hello I can give it a try. I dont understand point number 3, what needs to be done there? We can use google sheets or Excel online to track ticket status.
@SanjayKumar-o7d2n 20 күн бұрын
@ point number 3- whatever email receuved in office 365, I want to attached in excle with ticket number
@theDataCorner Күн бұрын
You mean the email needs to be embedded in Excel cell? I dont think power automate could do that. We can figure something else for that part, may be a VBA solution.
@theDataCorner 29 күн бұрын
Link to detailed video with explanation: kzbin.info/www/bejne/hqHVlqymd9R2eJY
@JessicaEricaPrudencio Ай бұрын
Hi, you did automate downloading files from a daily basis, is it also possible for a monthly basis?
@theDataCorner 27 күн бұрын
Hello Jessica, What you can do is set flow at start of month, and let it download all attachments to same folder, instead of separate folders. I dont think power automate can look through older emails, since it works on trigger and action logic. A work around would be to use a VBA macro inside Outlook application and use the macro to download all attachments for the month in one go. This wont work on web outlook, but the application version of outlook. Let me know if you need help setting up such a VBA macro. Cheers!
@sunnysun6567 Ай бұрын
Great ! Thanks !
@theDataCorner Ай бұрын
@@sunnysun6567 thanks, I'm glad you found it helpful
@wasiqmahmood7734 Ай бұрын
Hi this is very helpful but where you get these macros please recommend some websites where we get macros and how we can understand its code
@theDataCorner Ай бұрын
Thank you, Wasiq, Most of the macros I have written myself or some copy pasting from the web and are created on a need basis. I observe issues on a daily basis and automate whatever I think can save me time. The web is full of macro codes, you can even tell AI to write a specific code for you and then modify as per requirement. A good channel for VBA deep dive is wise owl, where I learnt the most of VBA I know.
@wasiqmahmood7734 Ай бұрын
@theDataCorner thank you and all the best
@azeem2k Ай бұрын
really helpful video. Thanks for this!
@theDataCorner Ай бұрын
@@azeem2k thanks Azeem, for being a long time and consistent viewer!
@johanneskeller3794 Ай бұрын
Thank you for this useful instruction I have been applying in my daily work for about 3 weeks.
@theDataCorner Ай бұрын
Thank you, I am glad you found it helpful. Happy holiday season!
@Catloaf-0 Ай бұрын
This is awesome, it removes a lot of manual editing I have to do when people feed me data with blank columns in random spots every month that I then have to remove later. Thanks!
@theDataCorner Ай бұрын
Glad to hear it helps you save time! Similar result can be achieved through python pandas, especially if the dataset is big, which power query is slow to handle.
@sharnumuganoor Ай бұрын
Nice video!!👌👍
@theDataCorner Ай бұрын
Thank you. Do check out other videos as well.
@Greay32 2 ай бұрын
Hi, thanks for your videos, hope you can help me, to open specific page of pdf pages..according to data records.
@theDataCorner 2 ай бұрын
Hello. I don't think such a thing is possible with VBA. What exact page you need to open?
@charbel0970 2 ай бұрын
thank you
@theDataCorner 2 ай бұрын
You're welcome
@shareqkhan7319 2 ай бұрын
Good video
@theDataCorner 2 ай бұрын
Glad you enjoyed
@dudewithopinion 2 ай бұрын
Hi, what tool are you using to write and test the code? Thanks.
@theDataCorner 2 ай бұрын
Hello, I am using VS Code and within VS Code, make sure you have extensions by name of *Jupyter* and by Name *Jupyter Cell Tags* installed, read more on link below, they are basically jupyter code cells. code.visualstudio.com/docs/python/jupyter-support-py Hope it helps.
@boy_washington 3 ай бұрын
Thank you for the video. How to implement ActiveWorkbook.FollowHyperlink method, so we can open any file, not just PDF?
@theDataCorner 2 ай бұрын
Hello, Sorry I missed your comment. I will research and let you know what I find. thanks.
@KhoiNguyenQ 3 ай бұрын
Thanks!
@theDataCorner 3 ай бұрын
Welcome! Do you check out other videos as well!
@WinnerSingh 3 ай бұрын
Can you explain this code video slow.
@theDataCorner 3 ай бұрын
Hello. Do you have prior experience with python? If not, I can recommend some beginner lecture videos, as these videos are project based and intermediate level skill is needed to go along.
@WinnerSingh 3 ай бұрын
@@theDataCornerokay and which extension do you installed in vs code to look like this browser view VS code.
@theDataCorner 2 ай бұрын
hello, that is ipynb support in vs code. Please read below for more information on jupyter notebook. code.visualstudio.com/docs/datascience/jupyter-notebooks
@WinnerSingh 3 ай бұрын
I want to ask question. Should we use VScode or change to cursor or storm editor
@theDataCorner 3 ай бұрын
Hello Winner. I would suggest to use Vs code, as a lot of people use it and it has good function overall. If you want something very simple for basic editing then use sublime editor or even IDLE that comes with python installation. Cheers!
@TheCopperMystic 3 ай бұрын
'auto-editor' is not recognized as an internal or external command, operable program or batch file. It is giving me this error please help
@theDataCorner 3 ай бұрын
Hello. Do you have python programming language properly installed? and auto-editor library installed as well? Open command prompt and type python, press enter. Does it give you the version of python installed?
@TheCopperMystic 3 ай бұрын
@@theDataCorner Yes both are installed and I have worked on different other projects as well with python using vs code editor
@theDataCorner 3 ай бұрын
Hello. Try below. 1- go to the folder the video is in, in windows explorer page where there is usually address like C:\Web.. type CMD and press enter. Paste below in CMD, change information as needed. auto-editor fileName.mp4 --margin 0.2sec --export resolve 2- If above doesnt work, try below in same command CMD window opened above: python -m auto-editor fileName.mp4 --margin 0.2sec --export resolve Let me know if any of above works.
@TheCopperMystic 2 ай бұрын
@@theDataCorner Hey, I tried the last command but its hows no module name auto-editor :(
@roxannemingard5893 3 ай бұрын
My attachment in the email is a pdf but it is auto saving as MS-DOS. Why is it saving it in a different format?
@theDataCorner 3 ай бұрын
Hello, Please check answer at the end of page from below link, let me know if it solves your issue. community.plumsail.com/t/power-automate-not-saving-file-extension/13684/3
@ab-bs5dz 3 ай бұрын
Exactly what I want. Thanks
@theDataCorner 3 ай бұрын
Thank you, do check out other videos as well.
@RH-pz1du 4 ай бұрын
Thank you so much! I was getting frustrated with trying to get all the other columns back. There are other tips online (like merging the grouped table with the same table before it was grouped) that just were not working!
@theDataCorner 4 ай бұрын
Thanks. I am glad it helped. Check out other videos as well, they could be helpful as well.
@TheCopperMystic 4 ай бұрын
When I typed the pdf_fils or pdf_files[1] in the editor I didnt get any results. When I typed the pdf_file[0} in the terminal I got an error as the term is not recognized as the name of the cmdlet,
@TheCopperMystic 4 ай бұрын
Sept 28, 2024 7:15:35 AM org.apache.pdfbox.pdmodel.font.PDSimpleFont toUnicode WARNING: No Unicode mapping for .notdef (31) in font YTHFYH+MyriadPro-Regular Sept 28, 2024 7:15:35 AM org.apache.pdfbox.rendering.Type1Glyph2D getPathForCharacterCode WARNING: No glyph for code 31 (.notdef) in font YTHFYH+MyriadPro-Regular Traceback (most recent call last): File "CommandLineApp.java", line 106, in technology.tabula.CommandLineApp.extractTables Exception: Java Exception The above exception was the direct cause of the following exception: Traceback (most recent call last): File "c:\Data Extraction From PDF 24.9.24\main7.py", line 20, in <module> tables = tabula.read_pdf(pdf_files[0], pages="all", multiple_tables = True) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Data Extraction From PDF 24.9.24\.venv\Lib\site-packages\tabula\io.py", line 400, in read_pdf output = _run( ^^^^^ File "C:\Data Extraction From PDF 24.9.24\.venv\Lib\site-packages\tabula\io.py", line 86, in _run return _tabula_vm.call_tabula_java(options, path) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Data Extraction From PDF 24.9.24\.venv\Lib\site-packages\tabula\backend.py", line 73, in call_tabula_java self.tabula.CommandLineApp(sb, cmd).extractTables(cmd) java.lang.java.lang.StringIndexOutOfBoundsException: java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0 PS C:\Data Extraction From PDF 24.9.24>
@theDataCorner 4 ай бұрын
Are you able to send me a similar sample PDF file? so I can test it and let you know. Email it here: [email protected]
@TheCopperMystic 4 ай бұрын
Sept 28, 2024 7:11:05 AM org.apache.pdfbox.pdmodel.font.PDSimpleFont to Unicode Warning: No unicode Mapping for .notdef(31) in font YTHFYH+MyriadPro-Regular Traceback (most recent call last) : File "CommandLineApp.java", line 106, in technology.tabula.CommandLineApp.extractTables Execption : Java Exception The above excdeption was the direct cause of the following exception: tables = tabula.read_pdf(pdf_files[0],pages="all", multiple_tables = True) File "C:\Data Extraction From PDF 24.9.24\.venv\Lib\site-packages\tabula\backend.py", line 73, in call_tabula_java self.tabula.CommandLineApp(sb, cmd).extractTables(cmd) java.lang.java.lang.StringIndexOutOfBoundsException: java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0 PS C:\Data Extraction From PDF 24
@TheCopperMystic 4 ай бұрын
01:40 how did you edit this to make the vs editor having each seperate cells. Please someone let m ekno w
@theDataCorner 4 ай бұрын
Hello. Within VS Code, make sure you have extensions by name of *Jupyter* and *Name: Jupyter Cell Tags* installed, read more on link below, they are basically jupyter code cells. code.visualstudio.com/docs/python/jupyter-support-py
@youngrubic 4 ай бұрын
Thank you i will it try tomorrow
@theDataCorner 4 ай бұрын
All the best
@shoppersdream 4 ай бұрын
Nice, thanks!
@theDataCorner 4 ай бұрын
@@shoppersdream thank you and check out other videos as well.
@janapaneediChakradhar 4 ай бұрын
Hi Bro In this Viedo Full Blur I need Code in this program
@theDataCorner 4 ай бұрын
Hey bro, Code can be accessed from below link, let me know if you have any other questions. codepad.app/edit/yz3801h0
@azeem2k 5 ай бұрын
Automating personalized emails with Python and Excel will save so much time. thanks for the clear video❤
@theDataCorner 5 ай бұрын
You are welcome! Glad it was helpful.
@smithndongla5514 5 ай бұрын
Hello, I have an " org.apache.fontbox.ttf.CmapSubtable processSubtype14 WARNING: Format 14 cmap table is not supported and will be ignored"
@theDataCorner 5 ай бұрын
Hello Smith, Is your PDF scanned or computer generated? The error seems to be related to some font, I have not seen that error before. You can try using camelot, which works in similar way to tabula library, if that doesnt work, you can try using microsoft power query to do same task. kzbin.info/www/bejne/mGm5hZRpnL6CeNE Camelot Code: import camelot import os import pandas as pd # List all PDF files in the current directory pdf_files = [x for x in os.listdir('.') if x.endswith('.pdf')] print(pdf_files) # Initialize an empty DataFrame to store the combined tables combined_df = pd.DataFrame() # Loop through each PDF file for pdf_file in pdf_files: # Extract tables from the PDF tables = camelot.read_pdf(pdf_file, pages='all') print(f"This pdf has {len(ttables)} pages") # Check the number of tables and select the required ones if len(tables) > 4: required_table = pd.concat([tables[2].df, tables[6].df], ignore_index=True, sort=False) else: required_table = tables[2].df # Add the PDF source column required_table['pdf_source'] = pdf_file # Append the required table to the combined DataFrame combined_df = pd.concat([combined_df, required_table], ignore_index=True, sort=False) # Create a copy of the combined DataFrame df_new = combined_df.copy()
@albertojaramillo4881 5 ай бұрын
Thanks this short video help me a lot.
@theDataCorner 5 ай бұрын
Hello Albert, Glad to hear that! make sure to check out other videos on the channel as well.
@j_orpz 5 ай бұрын
Excellent solution - this saves me a ton of time!
@theDataCorner 5 ай бұрын
Thank you, I'm glad you found it helpful. Make sure to check out other videos and leave feedback.
@azeem2k 5 ай бұрын
Awesome. Thanks for the detailed walkthrough of the process ❤
@theDataCorner 5 ай бұрын
Thank you, Azeem, for long time fan of this channel!
@mustaqimjohari4276 6 ай бұрын
hello, i can not can not get the pdf_files[0] there is error saying the term 'pdf_files[0]' its not reconized
@theDataCorner 5 ай бұрын
Hello Mustaqim, Thats strange, can you share the code you are working on? May be you skipped the line where *pdf_files* was defined? Error code means variable named *pdf_files* doesnt exist which is why it cannot recognise it.
@lloydsalazar9940 6 ай бұрын
How to get data from pdf that requires password?
@theDataCorner 5 ай бұрын
Hello Loyd, Please try below answer from *THE ARIN KAMBLE* on this page, seems to be working, I have not tested it myself. learn.microsoft.com/en-us/answers/questions/1725182/how-can-i-export-data-on-excel-from-a-password-pro
@MrSiaa 4 ай бұрын
@@theDataCorner send the print command on that pdf and save it as a pdf again
@theDataCorner 4 ай бұрын
@@MrSiaa I havent tested it, but it might work.
@zvit 6 ай бұрын
"screenshot to image" not in video
@theDataCorner 6 ай бұрын
Hello This seems to be a typo in description, its actually Screenshot to Text (OCR). Thank you.
@ahmed007Jaber 6 ай бұрын
thank you for this. good tricks just wonder if you could share the code in the comments. easier to avoid typos
@theDataCorner 6 ай бұрын
Thank you, Ahmed, Below is the link for the source code. Make sure to check other videos as well. codepad.site/edit/8r4ld901
@ahmed007Jaber 6 ай бұрын
@@theDataCorner thank you. are you on linkedIn?
@ahmed007Jaber 6 ай бұрын
Hi man. thanks for this. possible to share the code in the notes?
@theDataCorner 6 ай бұрын
Hello Ahmed, sure. Code is below, I will add in video description as well. codepad.site/edit/3w48mae6
@sarayumallam9507 6 ай бұрын
send source code and btw getting error like java not found , so help me resolve it , appreciate your work.
@theDataCorner 6 ай бұрын
Hello, if you have java installed already and still getting an error, then please try below steps, the java setup is bit tricky but hopefully a one time setup. from windows start option, search for *Environment Variables* and search for *Edit environment variables*, then follow below steps: **** Under the System Variables click Path and then press the Edit... instead of New. Then in the next screen (Edit environment variable for the Path variable) click New and add the address, e.g. C:\Program Files (x86)\Java\jre1.8.0_201\bin. Press OK and the Path variable will be appended/updated.**** Answer taken from below: stackoverflow.com/questions/54817211/java-command-is-not-found-from-this-python-process-please-ensure-java-is-inst Source code: codepad.site/edit/q9aig7rj
@sarayumallam9507 6 ай бұрын
@@theDataCorner thanks for your time bro , keep it up .
@theDataCorner 6 ай бұрын
Happy to help!
@agimadesimple 6 ай бұрын
Can I add images into my posts?
@theDataCorner 6 ай бұрын
Hello, I will check and advise.
@Timbollew 6 ай бұрын
Good solution. If you want to remove just blank columns you could also transpose then just apply the Remove Rows>Remove Blank Rows which results in a cleaner formula. I do like the flexibility of your solution though to remove columns with only 1 entry.
@theDataCorner 6 ай бұрын
Great idea, Tim, Thank you. And make sure to check out my other videos on the channel as well.
@sethuelijah5342 6 ай бұрын
why the pdf say no preview
@theDataCorner 6 ай бұрын
Can you give me an exact time in the video where it says that? And i will look into it for you.
@AngelStickman 6 ай бұрын
I get a Runtime 429 error on the line with Set OutApp = CreateObject("Outlook.Application") and can not seem to trouble shoot the issue. I have tried early binding and resetting the .DLLs. Any suggestions?
@theDataCorner 6 ай бұрын
Hello Angel, Please try out below. To use early binding, you first need to set a reference to the Outlook object library, Microsoft Outlook xx.x Object Library (xx.x is version number and depends on outlook you have) Below code lines will need to be changed. Dim olApp as Outlook.Application Set olApp = New Outlook.Application answer taken from: stackoverflow.com/questions/60266233/i-am-getting-a-run-time-error-429-trying-to-get-excel-macro-to-send-a-email Please try it out and let me know.