labft's RPA

Happy Automation :)

๐Ÿ Excel RPA ์ž‘์—…์„ ์œ„ํ•œ Python Scripts ์™€ Pandas

UiPath python script ํ˜ธ์ถœ, parameter์ „๋‹ฌ, dataframe2datatable

pythonScript ์‚ฌ๋ฌด์—…์— ์žˆ์–ด์„œ excel์€ ๋‹ค์–‘ํ•œ ๋ถ„์•ผ์—์„œ ํ™œ์šฉ๋˜๊ณ  ์žˆ๊ณ , ์‚ฌ๋ฌด ์ž๋™ํ™”๋ฅผ ์œ„ํ•œ RPA์—์„œ๋„ excel์ด ๋งŽ์ด ์‚ฌ์šฉ๋ฉ๋‹ˆ๋‹ค. UiPath์—์„œ๋„ ๋‹ค์–‘ํ•œ excel ์ฒ˜๋ฆฌ ๊ธฐ๋Šฅ์ด ์žˆ์ง€๋งŒ ๋ฐฉ๋Œ€ํ•œ ๋ฐ์ดํ„ฐ๋ฅผ ๋น ๋ฅด๊ฒŒ ์ฒ˜๋ฆฌํ•ด์ค„ ์ˆ˜ ์žˆ๋Š” Pandas๋ฅผ ํ™œ์šฉํ•ด๋ณด์•˜์Šต๋‹ˆ๋‹ค. ๋˜ python์œผ๋กœ ...

๐Ÿ‘Š ์ž๋™ํ™” RPA์—์„œ ์ค‘์š”ํ•œ๊ฑด ์‚ฌ๋žŒ์ด ์ฒ˜๋ฆฌํ•˜๊ณ  ์‹ถ๋‹ค๋ฉด Action Center(์›จ๋น„๋‚˜)

robot, studio, orchestrator ๋ฅผ ์‚ฌ์šฉํ•œ Action Center

UiPath ์•ก์…˜์„ผํ„ฐ(human in the loop) ์•ก์…˜์„ผํ„ฐ๋Š” ์‚ฌ๋žŒ์ด ๋กœ๋ด‡ ํ”„๋กœ์„ธ์Šค์— ์‚ฌ๋žŒ์ด ์Šน์ธํ•˜๋Š” ๋ถ€๋ถ„์„ ๋งŒ๋“ค์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ์ด๊ฒŒ ์™œ ํ•„์š”ํ•˜๋ƒ๋ฉด.. ๊ฒฐ์ œ์™€ ๊ฐ™์ด ์ค‘์š”ํ•œ ํ”„๋กœ์„ธ์Šค๋ฅผ ๋กœ๋ด‡ ๋ชจ๋‘ ์ฒ˜๋ฆฌํ•œ๋‹ค๋ฉด ์˜๋„์น˜ ์•Š๊ฒŒ ์ผ์ด ์ž˜๋ชป๋  ์ˆ˜ ์žˆ๊ธฐ ๋•Œ๋ฌธ์ž…๋‹ˆ๋‹ค. ์•ก์…˜์„ผํ„ฐ๋ฅผ ํ†ตํ•ด ์‚ฌ๋žŒ์ด ์ฒ˜๋ฆฌํ•  ๊ฒƒ์„ ๋‚˜๋ˆŒ ์ˆ˜...

๐Ÿšข UiPath Log ๋ฐ์ดํ„ฐ ์‹œ๊ฐํ™”

Elastic search์™€ Kibana๋ฅผ ํ™œ์šฉํ•œ ๋ฐ์ดํ„ฐ ์‹œ๊ฐํ™”

On-premise ํ˜•ํƒœ์˜ Orchestrator ์„œ๋ฒ„ ํ™˜๊ฒฝ์„ ๊ตฌ์ถ•ํ•˜์˜€๋‹ค๋ฉด ์ด์ œ cloudํ™˜๊ฒฝ๋ณด๋‹ค ๋” ๋‹ค์–‘ํ•œ ๊ฒƒ์„ ํ•ด๋ณผ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. UiPath์—์„œ ์œ ๋ฃŒ๋กœ ์ œ๊ณตํ•˜๋Š” insights ๋ฅผ ์‚ฌ์šฉ ๊ฐ€๋Šฅ Orchestrator ๋กœ๊ทธ์ธ Custom tenant ๊ด€๋ฆฌ SSL์„ ํ†ตํ•œ ๋…๋ฆฝ๋œ ํ™˜๊ฒฝ...

๐ŸŒ DNS ์„ค์ • ๋ฐ SSL ๋ฐœ๊ธ‰

DNS ์„ค์ •, SSL ๋ฐœ๊ธ‰

์ด์ „์— ํฌ์ŠคํŒ…์—์„œ ์ž์ฒด ์ƒ์„ฑ์œผ๋กœ ๋งŒ๋“  ์ธ์ฆ์„œ๋กœ ์„ค์น˜ํ•˜์˜€์ง€๋งŒ ๋‹ค๋ฅธ PC์—์„œ ์ ‘๊ทผ์ด ๋ถˆ๊ฐ€ํ•˜์—ฌ ์ธ์ฆ์„œ๋ฅผ ๋‹ค์‹œ ๊ตฌ์„ฑํ•˜์˜€์Šต๋‹ˆ๋‹ค. ssl ์ธ์ฆ์„œ๋Š” domain์„ ๋ฐ”ํƒ•์œผ๋กœ ๊ตฌ์„ฑํ•ด์•ผ ๋‹ค๋ฅธ ์›น์—์„œ Orchestrator ์ ‘๊ทผ์ด ๊ฐ€๋Šฅํ•ฉ๋‹ˆ๋‹ค. ๋„๋ฉ”์ธ ์ฃผ์†Œ ๋ฐœ๊ธ‰๊ณผ DNS ๋ ˆ์ฝ”๋“œ ๋“ฑ๋ก ์ „ ๊ธฐ์กด์— ๊ตฌ๋งคํ•œ ๋„๋ฉ”์ธ์ด...

๐Ÿซ Process Mining(์›จ๋น„๋‚˜)

UiPath Process Mining

ํ”„๋กœ์„ธ์Šค๋งˆ์ด๋‹ ๋ฐ์ดํ„ฐ๋ฅผ ํ†ตํ•ด์„œ ์ธ์‚ฌ์ดํŠธ ํ•˜๋Š”๊ฒŒ ๋ชฉ์ ์ž„ process gold๋ฅผ ์ธ์ˆ˜ํ•˜๋ฉด์„œ RPA๊ฐ€ ํ”„๋กœ์„ธ์Šค ํ˜์‹ ์„ ์–ด๋–ป๊ฒŒ ์ด๋ฃฐ์ง€ ์ง์ ‘ ๋ˆˆ์œผ๋กœ ๋ถ„์„ํ• ์ˆ˜ ์žˆ๋„๋ก ๊ตฌ์„ฑ ๊ณต์‹์ ์ธ ์ด๋ฆ„์€ uipath process mining ๊ตญ๋‚ด ๊ธฐ์—…์€ PI๋ฅผ ํ†ตํ•ด ์–ด๋–ป๊ฒŒ ์—…๋ฌด๊ฐ€ ํ˜๋Ÿฌ๊ฐ€๋Š”์ง€์— ๋Œ€ํ•ด์„œ ์ธ์‚ฌ์ดํŠธ ...

โ›ต UiPath On-Premise Orchestrator ์„œ๋ฒ„ ์„ค์น˜-3

Orchestrator ์„ค์น˜ / ๋ผ์ด์„ผ์Šค ์ ์šฉ

๋ถ€๊ฐ€๊ธฐ๋Šฅ ๋ถ€๊ฐ€์ ์œผ๋กœ ํ•„์š”์— ๋”ฐ๋ผ์„œ ๊ทธ๋ƒฅ ๋„˜์–ด๊ฐ€๋„ ๋˜๋Š” ๋ถ€๋ถ„๋“ค์— ๋Œ€ํ•œ ์ •๋ฆฌ์ž…๋‹ˆ๋‹ค. Elatic search์˜ ๊ธฐ๋ณธ port๋Š” 9200์ด๊ธฐ ๋•Œ๋ฌธ์— 127.0.0.1:9200 ์ž…๋ ฅํ›„ ๋„˜์–ด๊ฐ‘๋‹ˆ๋‹ค. elastic ์•ˆํ• ๊ฑฐ๋ฉด ๊ทธ๋ƒฅ ์Šคํ‚ตํ•ด๋„ ๋ฉ๋‹ˆ๋‹ค. ์ถ”ํ›„์— orchestrator ๊ฒฝ๋กœ์˜ web.confi...

๐Ÿ„โ€โ™‚๏ธ UiPath On-Premise Orchestrator ์„œ๋ฒ„ ์„ค์น˜-2

Database ์„ค์ •

Mssql ์„ค์น˜ ์‚ฌ์ง„ ํ•˜๋‹จ ์ฒจ๋ถ€๋œ link์—์„œ Expresss ์„ค์น˜ https://www.microsoft.com/ko-kr/sql-server/sql-server-downloads SSMS ์„ค์น˜ ์„ค์น˜๊ฐ€ ์™„๋ฃŒ๋˜์—ˆ๋‹ค๋ฉด ์ด์ œ Mysql์˜ workbench์™€ ๊ฐ™์€ Mssql์˜ SSMS ๋ฅผ ...