Excel
How can you select all of the connected data in a spreadsheet?
EX. if they are seperated by a blank column this command will only select the side selected
CTRL+A
Very Common Issue: Rep cannot hear and there is no issues with the headset
Dial74 or Dial23 Https Error that needs to be revalidated
How can I find my ip address on a windows machine?
Settings.
Bonus points for cmd + ipconfig
What command can help install libraries for Python
Pip install
What does the command pwd do
Prints Working Directory
Ex. /root/scripts/textline/logs
How do you fix the row width to something acceptable?
3 answers, more points for better answers
3. Manual drag
2. Double click column divide to auto resize +100
1. CTRL + A, Format, Auto-Fit Column Width +200
Common Issue: Did the rank reset run? I just set Ken Houck to an 8 and everyone else's ranks are messed up. What Happened?
Carlo's didn't close his tab for the inbound group last night and the rank values are still there for yesterday. He changes ken, and all current values are reverted to that times values + ken change
Which devices ips change in here and which don't?
All stations use DHCP. All servers and printers have reserved ips
What library would you use to use apis in python?
requests
What command takes the data from a file and puts it in the command line console. Like a print?
Cat MEOW
When importing a csv or txt file to excel, what step can you do before importing to change the formatting of the data?
Transform. This is done with the migration process
When using the vicidial API what should you put in the "source=" parameter?
The name of your script or function you are doing on the dialer
What can you do if a rep's computer cannot authenticate with your domain credentials
Authenticate with localadmin and use powershell to Reset-MachinePassword or Repair connection.
Or authenticate with localadmin and unjoin and rejoin to domain with 2 restartsWhat is a tool used to automate the timing and schedule of our scripts?
crontab or cronjobs
Where do passwords and keys go before they are deployed in scripts to production?
Doppler
Difference between .csv file and .xlsx file?
csv is just data seperated by commas and newlines. Sometimes wrapped in quotes
xlsx supports formatting and datatyping and must be opened with excel or spreadsheet applications
Where can I find all of the sales numbers used for outbound dialing?
Inbound -> Show DIDs
How do we use our firewall do block reps from getting to certain sites?
URL filter
What helps us deploy our code to a development server as soon as it is commited?
Github actions.
What is the yml file used for
Local git runner installed on server we deploy containers on
What does grep do?
Grabs all lines with your search term and outputs them, must take file or text as input
How an you count the number of rows with the state AL in the row?
=COUNTIF(L:L,"AL")
Carlos called, its memorial day he said did we remember to turn off the dialer. How do we do that?
Go to admin->call times. Click dsi for sales and set todays values to 2400 and check other departments times too
What is trace route or the PingPlotter App used for?
Trace route and pingplotter are used to find the number of hops until our destination and determine the time and the amount of packet loss at each stop.
Used when latency is being experienced by reps to determine how bad our latency is and which machine in the hops it is. And would be nice to flip on another branch like ATT when this happens
What is Node.js's version of pip?
npm install just like pip install
What does chmod do?
It changes the permission of a file for admin, group, or users. Is needed often when making shell scripts and they will no execute ./example.sh if the x bit is not set.
Ex. chmod +x example.sh