Profile

Cover photo
Lenny Cunningham
Attended Patterson High School
Lives in Lafayette, La
161 followers|243,091 views
AboutPostsPhotosYouTubeReviews

Stream

 
Anyone else having issues with SM saying it has removed software from a Windows machine, but never actually has?
1
Add a comment...
 
Prep-Work ;)
7
1
Margaret Kuzmicz's profile photoSimon Tompson's profile photoBrandon Svec's profile photoEsteban Gomez's profile photo
3 comments
 
Looks good.  Lucky you have flush t-bar and ceiling tile.  I recently installed over 100 on beveled ceiling tiles where the mounts wouldn't work on the t-bar so I had to do them right through the tile with bolts and wing nuts ;)
Add a comment...
 
After seeing a post about a particular Chromebook being release for Canada. Thought I would ask this now. About to be deploying some Chromebooks to a base in Canada. Is there anything special I should know?

Must they be specific ordered Chromebooks?
Any other pertinent info?

Thanks
1
Add a comment...
 
Noticed two new things so far today in Apps Script GDE.  Under Publish there is now "Test add on".  And under Resources Libraries is no longer tagged with experimental. 
6
1
Frédéric Morel's profile photoWeb Apps R&D's profile photoFaustino Rodriguez's profile photoBruce Mcpherson's profile photo
4 comments
 
the "Test as add-on..." is promising
not sure if it would allow for other users (users group) to access for testing
Add a comment...
 
#Barcode  scanning with #appsscript  and #Chromebook

Sorry for delay but finally getting around to making copies of our medical inventory system, and redacting what I needed to.

Attached is link to a folder that includes 3 spreadsheets that are copies of the ones in the video.
https://drive.google.com/drive/#folders/0B_mOEVr803HMbEZpd09kb3JoVlE/0B_mOEVr803HMTFBBandvdmtXZEU

Disclaimer this was specifically built for handling medical inventories and doing that with #googlesheets .  Purpose was to be able to make changes on a "Master Inventory" and then with the use of apps script push changes out to separate identical spreadsheets, one per station.

This becomes very difficult with out the use of apps script because you can't simply importRange() a column into multiple sheets, then go and add or remove a row item.  By doing this all the associated data for that row is now offset.  Using the master sheet there is a menu for performing this action with the use of scripts.

Second is keeping the same look.  The master has templates of the separate areas that are inventoried, and you can create your look and formulas you need in there, and push that formatting out to all the separate spreadsheets, with the "Push Formatting"

The scanner:
Almost any wired, wireless, or bluetooth scanners seem to work.
All they do is act like a keyboard, when you scan a barcode it transfers it into key strokes just as if you typed it on the keyboard, then follows it with an enter key command.  So using HtmlService all you need to process a scan is a text box and some jQuery.

$('#barcode').keyup(function(event) {
        if (event.keyCode == 13) {
          var barcode = $(this).val();
       //do something with barcode data/////////
}


Setup
1. Each location spreadsheet has a "setup" sheet.  The Master sheet ID and the name of that location need to be set, that's it.  It will import the rest of the info it needs from the master.

2. The master has a "setup" sheet also, that needs the keys from each locations spreadsheet, and their respective names.

Enjoy picking it apart, feel free to ask questions, and send recommendations.
31
18
Bas Moed (ESP)'s profile photoVitali Neumann's profile photoJose Alzueta Mancoeduca's profile photoAGUSTIN GARCIA (Freelancer Excel)'s profile photo
12 comments
 
Thank you Lenny,
I really appreciate how you've tidied up the code (no more ScriptsLib!), and added a generous portion of comments. I've learned a lot just by going through your work line by line, so I look forward to chewing through this version. I don't mean to be punny but you certainly are a life saver!
Add a comment...
 
Is it possible to create 3 vlans. Where 1 & 2 can communicate with 3 but 1 & 2 can't with each other?
1
Team One Solutions's profile photoLenny Cunningham's profile photoFabio Cellini's profile photo3anetwork com's profile photo
8 comments
 
yes, using pvlan technology or VACL. pvlan is more safe.
Add a comment...
Have him in circles
161 people
Carmen Picou's profile photo
Annemie De Lange's profile photo
Troy Delahoussaye's profile photo
Dennis Bull's profile photo
Patrick Barber's profile photo
Ivan Kutil's profile photo
Elsa Goepp's profile photo
Brad Matheson's profile photo
Thomas Falterman's profile photo
 
I've posted a couple times guess it's time to introduce myself and then finish with a question.

I work for a Helicopter Rescue company we staff and train units all over the world. I'm a flight medic by trade, and IT guru by hobby. Our company is exponentially growing, and IT is becoming a full time job. Looking forward I have laid plans out for standardizing our network equipment. Meraki is the obvious answer. We have embraced the cloud with +Google for Work Apps and the cloud seems the only logical solution for our hardware needs.

That being said I've started rolling out equipment to sites and being I'm not formally trained Id like your input for the subnet addressing scheme. Does the following make sense and/or possibly cause any issues down the road? Snipett from our network Ops Manual.

"Location based subnets

Using 10.0.0.0 subnet for company network will allow a logical seperation of network subtnets for the possible amount of locations that we could encounter.

Mesa
10.0.10.0
Fourchon
10.1.10.0
Galveston
Hangar
10.2.10.0
Day Apt
10.2.20.0
Night Apt
10.2.30.0

Nova Scotia
10.3.10.0

France
10.4.10.0

Device reserved ranges for subnets
Print Server(s)
.100
Printers - start and continue sequentially
.101 >
Access Control
.150 >
Control By Web (Thermometers, Alert Signals)
.200 >"

Thanks for great product, community, and feedback.


1
1
GBR Networks's profile photoSimon Tompson's profile photoomar awad's profile photo
2 comments
 
Thanks for the introduction +Lenny Cunningham I can't imagine too many quiet days in your line of work! My only comment on this is about broadcast domains. The larger the number of devices using the same range, the more potential impact to overall performance.

I hope you find this community useful :-)
Add a comment...

Lenny Cunningham

Problem/Coding Help  - 
 
Is anyone else experiencing 404s with google drive.com hosted html files? I have a feeling it's to do with this restructuring of urls. 
1
Bruce Mcpherson's profile photoLenny Cunningham's profile photoFaustino Rodriguez's profile photo
5 comments
 
there was an issue with Drive reported yesterday in the dashboard
Add a comment...
 
+Google +Google Drive
Will Classroom ever be available for others besides Edu? I see its potential in the corporate world for in house training and continuing education for certain industries.

13
2
José Vera's profile photoEric Criens's profile photo
Add a comment...
 
Anyone else have to constantly delete and re-install this for it show Office Apps, when trying to open their respective documents?
Open Drive files directly from your browser in compatible applications installed on your computer.
3
Add a comment...
 
Import +ForeFlight flight logs into  #googlesheets  

I might be the only one in this community with a need for this, but I'm not too selfish to share. I had a need to get flight logs generated in Foreflight from our pilots into our system.  So wrote this #appscript  to extract the data from a Foreflight generated email.

Step1: Make a copy of this spreadsheet. Open the script editor and run getFlightPlanEmails() to authorize.  Then set it on a trigger for how ever often you want it check your email.

Step2: Email a flight plan from Foreflight to your gmail address except add "+flights" before the @. example "maverick+flights@gmail.com"

It currently just returns some info, and then a JSON object containing each leg, but you could split() that data how ever you please in the sheet or in another script.
3
Lenny Cunningham's profile photoAsh Clarke's profile photo
3 comments
 
Great, thanks for sharing
Add a comment...
 
Finally some daytime shots for yall.
5
Will Griffin's profile photo
 
nice pics from the best...i mean westbank
Add a comment...
People
Have him in circles
161 people
Carmen Picou's profile photo
Annemie De Lange's profile photo
Troy Delahoussaye's profile photo
Dennis Bull's profile photo
Patrick Barber's profile photo
Ivan Kutil's profile photo
Elsa Goepp's profile photo
Brad Matheson's profile photo
Thomas Falterman's profile photo
Education
  • Patterson High School
    1996 - 2000
Basic Information
Gender
Male
Work
Occupation
Flight Paramedic/Rescue Specialist
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Lafayette, La
Public - a month ago
reviewed a month ago
Public - 6 months ago
reviewed 6 months ago
Called, they advised they had a screen in stock for my iPhone5. Dropped it off at lunch and they had it ready by 3. Even took the the time to clean up my camera lens, that appeared blurry at first. Thanks for the quick and fantastic work.
Public - 7 months ago
reviewed 7 months ago
9 reviews
Map
Map
Map
This particular location is the main office, not an actual restaurant.
Public - 6 months ago
reviewed 6 months ago
By far the best customer service I've had at any Popeyes restaurant.
Public - 7 months ago
reviewed 7 months ago
Public - 9 months ago
reviewed 9 months ago