Google Sheets formulas that needs to read data from drop down boxes

I am trying to create a master spreadsheet that is pulling information from several other sheets into this one master sheet.
I then plan on using this master sheet to pull statistics.
In the sign up sheets there are drop down boxes for Yes, No. My master sheet will pull all data except the Yes, No from the drop down boxes.

I can not figure out why!!

facebook – Google Sheets importxml help

I am trying to scrape the number of photos statistic from a Facebook group (currently 432,780) at:

https://m.facebook.com/groups/553511078046085?view=info

I have copied the relevant xpath and used the following formula in Google Sheets:

=importxml(“https://m.facebook.com/groups/553511078046085?view=info”,”//*(@id=’u_0_y_OX’)”)

However, it doesn’t work and keeps showing the error message “imported content is empty”

Any ideas what I’m doing wrong?

Thanks in advance.

Push your site Google 1st Page, through Our incredible 380+ High Authority Seo backlinks for $15

Push your site Google 1st Page, through Our incredible 380+ High Authority Seo backlinks

Push your site Google 1st Page, through Our incredible 380+ High Authority Seo backlinks.


if you wish your site remain in ⇒ google 1st Page. but your ranking is still poor after buying to many serivces,

is just because you are looking for only backlinks Quantity not backlinks Quality.

Seoplux Top Rated Level X3 Seller on Seoclerk

we provide you Highest Quality of backlinks

We Exclusively to Create ” 380+ almost Unique Domain” High Authority Backlinks

Links are from :

WEB2.0 Sites (DR upto 90+ with 100% Unique Articles )

Angela Profile Sites (DR upto 90+ with 100% Unique Domain )

Dofollow Blog comments Sites (UR upto 60+ Actual pages with 100% Unique Domain )

Wiki Site. ( High Domain Rating with Almost unique Domain )

.(tagsToTranslate)backlinks

google sheets – Work flow using that employees can use to submit expenses for reimbursement and also request supplies

Can anyone recommend a work flow using some kind of web application that my employees can use to submit expenses for reimbursement and also request supplies? We’re not a large company, around 10 people in the field.

I would like to have a queue of expense reimbursement requests and supply requests from my field workers that my admin people can fulfill. Right now people just text me and I send them money or order them stuff. It’s chaos.

I would like something where my field people can submit a request, sometimes with an image or other document (usually a screen shot of a receipt or perhaps a picture of the supply they need), then my admin people can see the list of requests and order supplies or tell me to send monetary reimbursements.

Later on I would like to be able to have some way of seeing how much money and supplies each employee is using/spending. Such as by running a search or report.

I will do guaranteed ranking your website on google first 1st page with three keyword for $125

I will do guaranteed ranking your website on google first 1st page with three keyword

Dear,
I am Mofazzal . I am a SEOand content writing expert. I can do all the work related toSEO (search engine optimization). .Everyone wants their website on google’s 1st page. I have professional knowledge of total SEO services especially Google’s top ranking. I

have been working as a full-stack search engine optimization expert with 4+ years of experience to improve your website ranking. As an SEO expert, my main goal is to provide high-quality work to my

clients which helps them to stay Top on Google search engine result pages and

initiative quality traffic for which they are investing in my SEO services.

Off-page SEO:

  • Social Bookmarking
  • Answers posting
  • Web 2.0
  • blog comment
  • forum posting
  • Directory submission
  • Image share
  • Slide share
  • Doc share
  • Article submission
  • Video submission
  • Guest post
  • All high DA and PA backlinks for google top ranking.

Why you can choose me :

  • 100% safe and satisfied work.
  • You’ll get full report of the working
  • Customer support 24/7
  • Guaranteed google 1st-page ranking.
  • Powerful Strategy.

FAQ:


Q:what we need?

A: 2 URL and 2 LSI keyword

Note-1: Google 1st page ranking Per keyword-only45$ .Your website’s DA must be within 30. If it is more than 30, the budget has

to be increased , the price has to be fixed after discussion

Note-2:Casino, sexual and any illegal activity sites arenot accepted.

Thanks

.(tagsToTranslate)1stpage(t)quora(t)seo(t)answers(t)backlink(t)traffic

How to know if Google Sheets IMPORTDATA, IMPORTFEED, IMPORTHTML or IMPORTXML functions are able to get data from a resource hosted on a website?

If the content is added dynamically (by using Javascript), it can’t be imported by using Google Sheets built-in functions. Also if the website webmaster have taken certain measures, this functions will not able to import the data.


To check if the content is added dynamically, using Chrome,

  1. Open the URL of the source data.
  2. Press F12 to open Chrome Developer Tools
  3. Press Control+Shift+P to open the Command Menu.
  4. Start typing javascript, select Disable JavaScript, and then press Enter to run the command. JavaScript is now disabled.

JavaScript will remain disabled in this tab so long as you have DevTools open.

Reload the page to see if the content that you want to import is shown, if it’s shown it could be imported by using Google Sheets built-in functions, otherwise it’s not possible but might be possible by using other means for doing web scraping.

According to Wikipedia,

Web scraping, web harvesting, or web data extraction is data scraping used for extracting data from websites.

The webmasters could use robots.txt file to block access to website. In such case the result will be #N/A Could not fetch url.

The webpage could be designed to return a special a custom message instead of the data.


IMPORTDATA, IMPORTFEED, IMPORTHTML and IMPORTXML are able to get content from resources hosted on websites that are:

  • Publicly available. This means that the resource doesn’t require authorization / to be logged in into any service to access it.
  • The content is “static”. This mean that if you open the resource using the view source code option of modern web browsers it will be displayed as plain text.
    • NOTE: The Chrome’s Inspect tool shows the parsed DOM; in other works the actual structure/content of the web page which could be dynamically modified by JavaScript code or browser extensions/plugins.
  • The content has the appropriated structure.
    • IMPORTDATA works with structured content as csv or tsv doesn’t matter of the file extension of the resource.
    • IMPORTFEED works with marked up content as ATOM/RSS
    • IMPORTHTML works with marked up content as HTML that includes properly markedup list or tables.
    • IMPORTXML works with marked up content as XML or any of its variants like XHTML.
  • Google servers are not blocked by means of robots.txt or the user agent.

On W3C Markup Validator there are several tools to checkout is the resources had been properly marked up.

Regarding CSV check out Are there known services to validate CSV files

It’s worth to note that the spreadsheet

  • should have enough room for the imported content; Google Sheets has a 5 million cell limit by spreadsheet, according to this post a columns limit of 18278, and a 50 thousand characters as cell content even as a value or formula.
  • it doesn’t handle well large in-cell content; the “limit” depends on the user screen size and resolution as now it’s possible to zoom in/out.

References

Related

The following question is about a different result, #N/A Could not fetch url

network – Can Ping Google DNS from Firewall, but not from VM behind Firewall

I have the following network setup https://i.ibb.co/wwPLH2H/Network.png

All traffic from 10.0.64.0 / 27 behind FirewallB (firewallsm) reaches 192.168.28.0 / 27 network via the LAN interface of FirewallA (firewallwm), and the same traffic also reaches internet in the same way, as follows:

10.0.64.42 (VM) > FirewallB (LAN) > FirewallA (LAN) > FirewallA (WAN) > Laptop’s Wireless NIC > Wifi Router

Strangely FirewallB (firewallsm) can ping Google DNS but the VM 10.0.64.42 for some reason cannot ping Google DNS. I have set all protocols, ports as allowed on FirewallB (firewallsm) to reach FirewallA (firewallwm).

FirewallA (firewallwm)

Gateway – https://i.ibb.co/bRC8P8G/Firewall-A-GW.png

LAN Interface Rule – https://i.ibb.co/XWSnLRd/Firewall-A-1-dell-Rule.png

WAN Interface Rule – https://i.ibb.co/zZwcnjJ/Firewall-A-2-WAN-Rule.png

FirewallA (firewallsm) logs show 10.0.64.42 traffic is allowed through its WAN

Log – https://i.ibb.co/9cqPSW7/Firewall-A-Packet-log.png

Log – https://i.ibb.co/kVTX31B/Firewall-A-Packet-log-2.png

FirewallB (firewallsm)

Gateway – https://i.ibb.co/pPQC1p8/Firewall-B-GW.png

LAN Rule – https://i.ibb.co/VY9vFVL/Firewall-B-1-dell-Rule.png

tcpdump for 10.0.64.42 VM on FirewallB LAN (em0)

root@firewallsm:~ # tcpdump -i vmx0 host 10.0.64.42 and host 8.8.8.8 and icmp
tcpdump: verbose output suppressed, use -v or -vv for full protocol decode
listening on vmx0, link-type EN10MB (Ethernet), capture size 262144 bytes
06:17:09.324409 IP 10.0.64.42 > dns.google: ICMP echo request, id 1, seq 1, length 40
06:17:13.853917 IP 10.0.64.42 > dns.google: ICMP echo request, id 1, seq 2, length 40
06:17:18.858484 IP 10.0.64.42 > dns.google: ICMP echo request, id 1, seq 3, length 40

tcpdump for 10.0.64.42 VM on FirewallA LAN (em0)

root@firewallwm:~ # tcpdump -i em0 host 8.8.8.8 and icmp -n
tcpdump: verbose output suppressed, use -v or -vv for full protocol decode
listening on em0, link-type EN10MB (Ethernet), capture size 262144 bytes
06:17:09.335331 IP 10.0.64.42 > 8.8.8.8: ICMP echo request, id 1, seq 1, length 40
06:17:13.865408 IP 10.0.64.42 > 8.8.8.8: ICMP echo request, id 1, seq 2, length 40
06:17:23.870819 IP 10.0.64.42 > 8.8.8.8: ICMP echo request, id 1, seq 4, length 40

tcpdump for 10.0.64.42 VM on FirewallA WAN (em1)

root@firewallwm:~ # tcpdump -i em1 host 8.8.8.8 and icmp -n
tcpdump: verbose output suppressed, use -v or -vv for full protocol decode
listening on em1, link-type EN10MB (Ethernet), capture size 262144 bytes

Ping from FirewallB successful in pinging Google DNS

root@firewallsm:~ # ping 8.8.8.8
PING 8.8.8.8 (8.8.8.8): 56 data bytes
64 bytes from 8.8.8.8: icmp_seq=0 ttl=127 time=13.196 ms
64 bytes from 8.8.8.8: icmp_seq=1 ttl=127 time=12.625 ms
64 bytes from 8.8.8.8: icmp_seq=2 ttl=127 time=12.609 ms
^C
--- 8.8.8.8 ping statistics ---
16 packets transmitted, 16 packets received, 0.0% packet loss
round-trip min/avg/max/stddev = 11.705/13.026/15.910/1.111 ms

tcpdump of FirewallA LAN (em0)

root@firewallwm:~ # tcpdump -i em0 host 8.8.8.8 and icmp -n
tcpdump: verbose output suppressed, use -v or -vv for full protocol decode
listening on em0, link-type EN10MB (Ethernet), capture size 262144 bytes
06:22:21.816908 IP 192.168.10.7 > 8.8.8.8: ICMP echo request, id 23594, seq 0, length 64
06:22:21.827095 IP 8.8.8.8 > 192.168.10.7: ICMP echo reply, id 23594, seq 0, length 64
06:22:22.876598 IP 192.168.10.7 > 8.8.8.8: ICMP echo request, id 23594, seq 1, length 64
06:22:22.886317 IP 8.8.8.8 > 192.168.10.7: ICMP echo reply, id 23594, seq 1, length 64
06:22:23.948947 IP 192.168.10.7 > 8.8.8.8: ICMP echo request, id 23594, seq 2, length 64
06:22:23.957978 IP 8.8.8.8 > 192.168.10.7: ICMP echo reply, id 23594, seq 2, length 64

tcpdump of FirewallA WAN (em1)

root@firewallwm:~ # tcpdump -i em1 host 8.8.8.8 and icmp -n
tcpdump: verbose output suppressed, use -v or -vv for full protocol decode
listening on em1, link-type EN10MB (Ethernet), capture size 262144 bytes
06:22:21.817029 IP 192.168.47.132 > 8.8.8.8: ICMP echo request, id 24689, seq 0, length 64
06:22:21.826993 IP 8.8.8.8 > 192.168.47.132: ICMP echo reply, id 24689, seq 0, length 64
06:22:22.876700 IP 192.168.47.132 > 8.8.8.8: ICMP echo request, id 24689, seq 1, length 64
06:22:22.886219 IP 8.8.8.8 > 192.168.47.132: ICMP echo reply, id 24689, seq 1, length 64
06:22:23.949057 IP 192.168.47.132 > 8.8.8.8: ICMP echo request, id 24689, seq 2, length 64
06:22:23.957845 IP 8.8.8.8 > 192.168.47.132: ICMP echo reply, id 24689, seq 2, length 64