[SCRIPT] WME Spreadsheet Worker

Discussion for the unofficial, community-developed addons, extensions and scripts built for the Waze Map Editor.

The official index of these tools is the Community Plugins, Extensions and Tools wiki page.

Moderators: Unholy, bextein, Glodenox, JustinS83

Forum rules
Discussion for the unofficial, community-developed addons, extensions and scripts built for the Waze Map Editor.

DO NOT START a new thread unless it is about a new idea. Keep discussion of existing tools within the main thread for that tool.

The official index of these tools is the Community Plugins, Extensions and Tools wiki page.

[SCRIPT] WME Spreadsheet Worker

Postby FastestBeef » Sat Apr 25, 2020 12:06 am

This is a script to make working spreadsheet campaigns (Like the current RRC one) easier. Rather than clicking links and reloading WME each time, this will load up the sheet data and you can just go directly to the next one.

You will need to get an API key for Google Sheets.
  1. Go to Google Cloud Console
  2. Select create a project
  3. Give it any name you want and click create
  4. Click create credentials -> API Key
  5. Click Dashboard on the left
  6. Click enable APIs and Services
  7. Find Google Sheets API and click it
  8. Click Enable.
  9. Done. You should be able to use the script. It may take a few minutes for the changes to take effect

You will still need to update the sheet to mark each row done, but this still makes it much easier.

It is still in very early stages of development, and I am working on it actively. I just wanted to make it available for people to use now.

If you have a sheet that you want me to add to the script, just send me a link and I can add it in.

If you have any questions or feedback, please let me know.
FastestBeef
State Manager
State Manager
 
Posts: 6
Joined: Thu Oct 15, 2015 5:05 pm
Location: Missouri, USA
Has thanked: 7 times
Been thanked: 5 times

Re: [SCRIPT] WME Spreadsheet Worker

Postby jalondon628 » Wed May 13, 2020 1:55 pm

ojlaw wrote:thank you for the awesome tool! would it be possible to add an option that could let editors use this script with their own sheets? like WAL scans. or add their own campaign? thank you for your consideration.


This! Please this!
Joel London (jalondon628)
Texas State Manager
SE FL Area Manager
Ward County, ND Area Manager

[ img ][ img ][ img ][ img ][ img ] [ img ]
jalondon628
State Manager
State Manager
 
Posts: 68
Joined: Tue Mar 07, 2017 4:35 pm
Location: Dallas-Fort Worth, TX, United States
Has thanked: 20 times
Been thanked: 22 times

Re: [SCRIPT] WME Spreadsheet Worker

Postby JustinS83 » Sat Apr 25, 2020 4:01 am

Helps to post a link to the script :lol:
Script Writing Community Coordinator
[ img ][ img ][ img ][ img ][ img ]
JustinS83
Waze Global Champs
Waze Global Champs
 
Posts: 1398
Joined: Wed Dec 03, 2014 4:33 am
Location: Franklin, OH
Has thanked: 354 times
Been thanked: 2508 times

Re: [SCRIPT] WME Spreadsheet Worker

Postby ldriveskier » Sun Apr 26, 2020 4:39 pm

[ img ][ img ][ img ][ img ][ img ][ img ]
USA LC/CM, MAR ARC, GLR LC (resident of Ohio), App Beta Leader
ldriveskier
Coordinators
Coordinators
 
Posts: 904
Joined: Fri Feb 19, 2016 9:05 pm
Location: Northeast Ohio, United States
Has thanked: 1799 times
Been thanked: 1053 times

Re: [SCRIPT] WME Spreadsheet Worker

Postby ojlaw » Tue Apr 28, 2020 1:40 pm

thank you for the awesome tool! would it be possible to add an option that could let editors use this script with their own sheets? like WAL scans. or add their own campaign? thank you for your consideration.
USA County Manager
WI State Manager
IL Large Area Manager
CA, MN, ND, WA Area Manager
[ img ][ img ][ img ][ img ][ img ][ img ][ img ]
ojlaw
Country Manager
Country Manager
 
Posts: 186
Joined: Wed Jul 22, 2015 12:07 am
Has thanked: 107 times
Been thanked: 75 times

Re: [SCRIPT] WME Spreadsheet Worker

Postby ojlaw » Sat May 09, 2020 9:07 pm

Screen Shot 2020-05-09 at 2.03.58 PM.png
keyboard shortcut not working
(19.23 KiB) Downloaded 151 times
would it be possible to make the keyboard shortcuts selection work? my N key is not working for next and when i try to change it in the keyboard shortcuts menu nothing happens. thank you.

edit: for what it's worth i tried doing this with SW as the only script/ extension installed
USA County Manager
WI State Manager
IL Large Area Manager
CA, MN, ND, WA Area Manager
[ img ][ img ][ img ][ img ][ img ][ img ][ img ]
ojlaw
Country Manager
Country Manager
 
Posts: 186
Joined: Wed Jul 22, 2015 12:07 am
Has thanked: 107 times
Been thanked: 75 times

Re: [SCRIPT] WME Spreadsheet Worker

Postby RichardPyne » Tue Apr 28, 2020 2:00 pm

Very useful tool. One more feature request would be a re-center button. I'm finding that I often need to move away from the original point to fix other map issues, then find my way back to the original place.
RichardPyne
Area Manager
Area Manager
 
Posts: 281
Joined: Sat Mar 12, 2016 6:05 pm
Location: Lynndyl, Utah, USA
Has thanked: 337 times
Been thanked: 124 times

Re: [SCRIPT] WME Spreadsheet Worker

Postby SuperDave1426 » Sun May 10, 2020 3:13 pm

Feature request: Is there a way that after a Campaign & "Filter State" (if any) is selected, that there could be a link that would open the actual spreadsheet in another tab? I know which sheet it's using in order for "Next" to work. :-) So any chance a link could be added to make it easier for us to get to said sheet to mark when something has been completed/verified?
SuperDave1426
Country Manager
Country Manager
 
Posts: 947
Joined: Wed Oct 16, 2013 5:27 pm
Location: Nevada, USA
Has thanked: 81 times
Been thanked: 282 times

Re: [SCRIPT] WME Spreadsheet Worker

Postby tunisiano18 » Sat Apr 25, 2020 9:38 am

I've tested it, it's really interesting, but maybe you should add a example spreadsheet to help new users to learn what's needed
Tunisiano18
L5 - CM [ img ] Belgique - GDLuxembourg
[ img ][ img ][ img ][ img ]
tunisiano18
State Manager
State Manager
 
Posts: 96
Joined: Mon Oct 29, 2018 10:02 am
Location: Wallonia Belgium
Has thanked: 50 times
Been thanked: 21 times


Return to Addons, Extensions, and Scripts

Who is online

Users browsing this forum: jangliss, JimboBaggins1966, jm6087, JustinS83