API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 21st, 2019
51
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PowerShell 4.38 KB | None | 0 0
raw download clone embed print report
  1. INFO:root:Starting script
  2. INFO:root:.zip files: [PureWindowsPath('C:/Users/LuizRocha/Desktop/Remessa-Lote 11 - Copia/Remessa/03 12 2018-20181217T151033Z-001.zip'), PureWindowsPath('C:/Users/LuizRocha/Desktop/Remessa-Lote 11 - Copia/Remessa/11 12 2018-20181217T151025Z-001.zip'), PureWindowsPath('C:/Users/LuizRocha/Desktop/Remessa-Lote 11 - Copia/Remessa/13 12 2018-20181217T151029Z-001.zip'), PureWindowsPath('C:/Users/LuizRocha/Desktop/Remessa-Lote 11 - Copia/Remessa/17 12 2018-20181217T163719Z-001.zip'), PureWindowsPath('C:/Users/LuizRocha/Desktop/Remessa-Lote 11 - Copia/Remessa/24 10 2018-20181217T151008Z-001.zip'), PureWindowsPath('C:/Users/LuizRocha/Desktop/Remessa-Lote 11 - Copia/Remessa/26 11 2018-20181217T151020Z-001.zip'), PureWindowsPath('C:/Users/LuizRocha/Desktop/Remessa-Lote 11 - Copia/Remessa/29 11 2018-20181217T151015Z-001.zip')]INFO:root:Number of .xlsx files: 7 from folder Remessa
  3. Authentication successful
  4. INFO:root:Script finished
  5. PS C:\Users\LuizRocha\Desktop\Remessa-Lote 11 - Copia> py -3.7  merge.py
  6. INFO:root:Starting script
  7. INFO:root:.zip files: [PureWindowsPath('C:/Users/LuizRocha/Desktop/Remessa-Lote 11 - Copia/Remessa/03 12 2018-20181217T151033Z-001.zip'), PureWindowsPath('C:/Users/LuizRocha/Desktop/Remessa-Lote 11 - Copia/Remessa/11 12 2018-20181217T151025Z-001.zip'), PureWindowsPath('C:/Users/LuizRocha/Desktop/Remessa-Lote 11 - Copia/Remessa/13 12 2018-20181217T151029Z-001.zip'), PureWindowsPath('C:/Users/LuizRocha/Desktop/Remessa-Lote 11 - Copia/Remessa/17 12 2018-20181217T163719Z-001.zip'), PureWindowsPath('C:/Users/LuizRocha/Desktop/Remessa-Lote 11 - Copia/Remessa/24 10 2018-20181217T151008Z-001.zip'), PureWindowsPath('C:/Users/LuizRocha/Desktop/Remessa-Lote 11 - Copia/Remessa/26 11 2018-20181217T151020Z-001.zip'), PureWindowsPath('C:/Users/LuizRocha/Desktop/Remessa-Lote 11 - Copia/Remessa/29 11 2018-20181217T151015Z-001.zip')]INFO:root:Number of .xlsx files: 7 from folder RemessaINFO:root:Duplicate row: 112, cpf: 003.050.422-89, key: 53071769INFO:root:cpfs left after removing singles: {'003.050.422-89': [50759672, 53071769]}INFO:root:looping cpf dict values: 003.050.422-89
  8. INFO:root:looping keys value: 50759672
  9. INFO:root:Contratos key found row: 110, value: 50759672
  10. INFO:root:Contratos updated row: 110, value: 5075967253071769
  11. INFO:root:Contratos updated row: 110, cell value: 5075967253071769
  12. INFO:root:Envolvidos key found row: 111, value: 50759672
  13. INFO:root:Envolvidos updated row: 111, value: 5075967253071769
  14. INFO:root:Envolvidos updated row: 111, cell value: 5075967253071769
  15. INFO:root:Débitos key found row: 610, value: 50759672
  16. INFO:root:Débitos updated row: 610, value: 5075967253071769
  17. INFO:root:Débitos updated row: 610, cell value: 5075967253071769
  18. INFO:root:Débitos key found row: 611, value: 50759672
  19. INFO:root:Débitos updated row: 611, value: 5075967253071769
  20. INFO:root:Débitos updated row: 611, cell value: 5075967253071769
  21. INFO:root:looping keys value: 53071769
  22. INFO:root:Contratos key found row: 111, value: 53071769
  23. INFO:root:Débitos key found row: 612, value: 53071769
  24. INFO:root:Débitos updated row: 612, value: 5075967253071769
  25. INFO:root:Débitos updated row: 612, cell value: 5075967253071769
  26. INFO:root:Débitos key found row: 613, value: 53071769
  27. INFO:root:Débitos updated row: 613, value: 5075967253071769
  28. INFO:root:Débitos updated row: 613, cell value: 5075967253071769
  29. INFO:root:Débitos key found row: 614, value: 53071769
  30. INFO:root:Débitos updated row: 614, value: 5075967253071769
  31. INFO:root:Débitos updated row: 614, cell value: 5075967253071769
  32. INFO:root:Débitos key found row: 615, value: 53071769
  33. INFO:root:Débitos updated row: 615, value: 5075967253071769
  34. INFO:root:Débitos updated row: 615, cell value: 5075967253071769
  35. INFO:root:Débitos key found row: 616, value: 53071769
  36. INFO:root:Débitos updated row: 616, value: 5075967253071769
  37. INFO:root:Débitos updated row: 616, cell value: 5075967253071769
  38. INFO:root:Débitos key found row: 617, value: 53071769
  39. INFO:root:Débitos updated row: 617, value: 5075967253071769
  40. INFO:root:Débitos updated row: 617, cell value: 5075967253071769
  41. INFO:root:Débitos key found row: 618, value: 53071769
  42. INFO:root:Débitos updated row: 618, value: 5075967253071769
  43. INFO:root:Débitos updated row: 618, cell value: 5075967253071769
  44. INFO:root:Envolvidos deleted row 112
  45. INFO:root:Contratos deleted row 111
  46. Authentication successful
  47. INFO:root:Script finished, time: 2019-03-21 10:14:13.115272
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!