SayPro

Tag: SayPro Google Article List

  • SayPro Google App Script to Scrape Data – Minderlaw 20210221Y

                                 For this Google App Script project, please see spreadsheet [login to view URL] and the attached PDFs. In Worksheet Trademarks, Column E (Application) are a list of Application Numbers. The script logic is listed below.  1. For each Row, go to the URL https://tsdr.uspto.gov/#caseNumber=[Application Number]&caseSearchType=US_APPLICATION&caseType=DEFAULT&searchType=statusSearch . For example, the URL for Row 2 would be https://tsdr.uspto.gov/#caseNumber=4469429&caseSearchType=US_APPLICATION&caseType=DEFAULT&searchType=statusSearch . The attached PDFs show the resulting webpage at https://tsdr.uspto.gov/#caseNumber=4469429&caseSearchType=US_APPLICATION&caseType=DEFAULT&searchType=statusSearch  2. If Worksheet Trademarks Column F (Registration) is blank, fill in the Registration Number. Note that some Applications do not have Registration Numbers.  3. If Worksheet Trademarks Column G (Registration Date) is blank, fill in the Registration Date in the format yyyy-MM-dd. Note that some Applications do not have Registration Dates.  4. If Worksheet Trademarks Column H (Mark) is blank, fill in the Mark. Note that some Applications do not have Marks.  5. For Worksheet Trademarks Column I (TM5 Common Status Descriptor), overwrite the TM5 Common Status Descriptor. Even if Column I is not blank, overwrite the field with the current TM5 Common Status Descriptor.  6. For Worksheet Trademarks Column J (Status), overwrite the Status. Even if Column J is not blank, overwrite the field with the current Status.  7. For Worksheet Trademarks Column K (Next Filing), overwrite the Next Filing in the format yyyy-MM-dd. Even if Column K is not blank, overwrite the field with the current Next Filing date. Note that the Next Filing date is under the Maintenance tab.  8. For Worksheet Trademarks Column L (Filing Type), overwrite the Filing Type. Even if Column L is not blank, overwrite the field with the current Filing Type. Note that the Filing Type is under the Maintenance tab.  9. Note that the USPTO website throttles web traffic. So the script should include some time delay between the USPTO searches.  Please provide a price quote for the above Google Apps Script. Thank you.                                                                                                         Skills: Google App Engine, Web Scraping, Python, Google Sheets, Google Apps Scripts                                                                                                                                                      About the Client:                                                               (                 40 reviews                          )                                                    Los Angeles, United States                                                                                                                                                                                                                                                                                                                                    Project ID: #34691556

  • SayPro Data entry / Articulate Storyline) Build SayPro 130 Articulate Projects using Google Doc and Template

                                 Hello,  I have an articulate template (attached) and 130 documents of data. like this example. [login to view URL]  I need somebody who can copy all the data over and program each project to work correctly.  I have a limited budget for this project so hopping to find somebody looking to build their profile with a great review.  Let me know and we can discuss.                                                                                                            Skills: Data Entry, Articulate Storyline, eLearning Designer                                                                                                                                                      About the Client:                                                               (                 18 reviews                          )                                                    Hove, United Kingdom                                                                                                                                                                                                                                                                                                                                    Project ID: #34687569

  • SayPro Google Tag Media Management

    Google Tag Manager, Analytics in both implementation and data management. Responsible for the day-to-day management of paid digital marketing campaigns