반응형 RPA(english)12 How to remotely access MYSQL on another PC (DB access, Permission granted) For a simple test, DB installed on your local PC is enough. However, if you have more PCs to work on and need to work remotely, it's not easy to have DB separated from each local PC. So, I will tell you how to connect to MYSQL DB installed remotely on another PC. MYSQL remote access method In fact, the method is simple. In the Hostname/IP entry, enter the IP of the computer. However, if you type.. 2022. 6. 29. (MS Power Automate Desktop)RPA to record NASDAQ stock price every day Let's implement an RPA that records NASDAQ stock prices every day. (The scheduler allows you to implement it automatically at any time based on specific conditions. I'll post how to set up the scheduler next time.) order of "flow" is Run Chrome -> Import Data -> Write to Excel 1. Run Chrome Please search for 'CHROME' and drag 'Launch New Chrome' to empty space. https://finance.daum.net/global/qu.. 2022. 6. 24. (MS Power Automate Desktop) DateTime Utilization Let me explain the date/time features of MS Power Automate Desktop. Get current date and time Add to datetime Convert datetime to text 1. Get current date and time Search for 'Date' and drag 'Get current date and time' function to empty space You can get the time of the region you want by clicking 'Time Zone'. But we only need to bring our own desktop PC time. Press "Save" If you run it after th.. 2022. 6. 22. (MS Power Automate Desktop) Image functionality and utilization MS Power Automate Desktop has several features. Before you automate your tasks, learn many functions and then write a flow Efficient (many factors including maintenance and deliverables). There are many elements in the image function as well. So, I will explain it in the following order. It's good to try it yourself. 1. Find the image and double click -> 2. Wait for the desired image -> 3. Actio.. 2022. 6. 20. (MS POWER Automate Desktop) Use blank values Often, blank spaces are required, so an error occurs as soon as you press and type in the Space bar. Most people use the _ symbol because of this problem, but there is a workaround. When Power Automate Desktops encounter display errors, they are usually resolved to %%. Solution 1. Empty value (not sure if it is NULL) %""% 2. Spacing, blank space required %" "% Thank you 2022. 6. 16. (MS Power Automate Desktop) Resolving LIKE Query Errors Most query statements will also work with MS Power Automate if they have completed their operation with MYSQL. However, if you put the LIKE query statement as it is, you can see that an error occurs in the conditions for LIKE. Let's get right to the point and look at the capture screen. Column that finds character data starting with one of the A columns in the test table. MS Power Automate Deskt.. 2022. 6. 16. (MS Power Automate Desktop)4.POWER AUTOMATE DESKTOP TO Query(CREATE, INSERT, DELETE) A connection between POWER AUTOMATE and DB is required to fly the query. Please refer to the article below. 2022.06.13 - [RPA(english)/RPA and SQL(english)] - (Link RPA to SQL) 3. Connect SQL from Flow (Link RPA to SQL) 3. Connect SQL from Flow 1. MYSQL and Heidi SQL must be installed. 2022.06.12 - [RPA(english)/RPA and SQL(english)] - (Link RPA to SQL) 1. Install MYSQL (Link RPA to SQL) 1. Inst.. 2022. 6. 14. 이전 1 2 다음 반응형
