What do you like best about Python?
In our office case, we have linked Python and Smartsheet to perform various tasks. Our team has written the codes in Python to interact with Smartsheet and G-Drive. There are multiple use cases where we use Python in background as well in the form of an user interface for ease of use. It is easy to follow and understand the Python codes that I find it easy and comfortable to make minor changes within the codes to adapt to the new process changes or additions. We use this integrated approach of Python and Smartsheet quite extensively and frequently. Multiple features of Python are being used to perform various tasks like:
1) Clicking photographs - In an UI based python code we enter a date of receipt, upon which the Python code refers a particular Smartsheet, pull the data and number of rows, creates respective folders and starts saving the images in the respective folders while renaming them as per our requirement as we keep clicking the photos is the assets through a camera. This is an integration of Python, Smartsheet and a physical external Camera
2) Batching - In this UI based Python code, we enter a batch number, upon which it reads the data from the respective Smartsheet, creates multiple folders and downloads assets from G-drive and save it in the respective newly made folders. This is an integration of Python, Smartsheet and G-drive
3) Asset update - In this UI based Python script, the assets are compared with Smartsheet data and the processed assets saved in batches in Git folder, upon which new .xml and .json files are written and Smartsheets are updated accordingly. This is an integration of Python, Smartsheet and Git
4) Validation - In this Python script, the processed batches are validated for existence and accuracy of the processed assets within the batch folders. This is an integration of Python, Smartsheet, .xml and .json files
5) Uploading - In this script based Python (no UI), upon completion of the process and validations, the assets are uploaded on a cloud storage. This is an integration of Python, Smartsheet and a cloud storage
Considering the widely available feature and ease of implementation, we were able to automate most of our activities using the integration of Python and Smartsheet. Review collected by and hosted on G2.com.
What do you dislike about Python?
While, our activities are not time bound or use up extensive processing, the widely know issues like slowness, memory allocation or design restriction, they do not bother us as such. Our work gets done, so for now we don't see any issue to be disliked. Review collected by and hosted on G2.com.