Submit URLs created by our client side rendered Angular site through Google Search Console or will Google automatically find them?

Googlebot now executes JavaScript and can automatically crawl and render pages on client side rendered sites. It sounds like you are already doing so, but to let the crawler do its job you need to:

  • Create a separate URL for each piece of content on your site. Google needs to be able to send visitors directly to the content they searched by directing them to a specific URL for that content. You can route all the URLs to the same handler code in Angular and have your code decide which content is appropriate based no the URL.
  • Render <a href=""> links on pages to link to other pages. You can intercept user clicks on those links and update just the content on the page that needs to change and update the URL using pushState. There is no need to make users completely load the whole page again when navigating. However, Google won’t be able to find all the URLs on the site unless you use regular anchor links in your navigation elements.

It still might be a good idea to create an XML sitemap. Google is very slow about crawling and rendering client side generated sites. An XML sitemap could speed up the process of getting Google to discover and crawl your entire site. Without a sitemap it could take months, but with a sitemap it might take as little as a few weeks.

Just because you have an XML sitemap, you still need to link your URLs together with anchor links. Sitemaps help with URL discovery, but they don’t help with URL reputation or rankings. For good SEO, a sitemap is not sufficient. You need to let Googlebot see the relationships between your pages so that it can calculate Pagerank. See The Sitemap Paradox.

Automatically append database query results to a Google sheet

Looking for conceptual help in automating the appending of data to a Google Sheet. I have a PostgreSQL database currently hosted on Heroku (AWS) that is backing a Ruby on Rails application. What I’d like to do is extract some data from that database like count of USER where created_at is in the last week. I can do the queries in Ruby or SQL or whatever.

The question I have is how to inject (append) rows of this data into an existing Google Sheet every day/week. Is this possible? Should the Google Sheet pull this data from a RESTful endpoint created in the Rails app? OR, could the Rails app push the data into a Google Sheet?

Is this something that can be triggered automatically or are triggers only fired when a user opens a Google Sheet?

Basically looking for any suggestions into how to get results of certain daily DB queries into a Google (or Excel for that matter) spreadsheet.

Thanks for any help!`

ms flow – I’m unable to trigger a Sharepoint designer 2013 workflow automatically when an item is created

I used my user account (not system account) to create ms flow and sharepoint workflow using SPdesigner2013.

I’ll explain the process:

when we send an email to a shared mailbox, the msflow will create an item in stage list and associated designer workflow will create another item in “ticket list”.

Once it’s created, “id” designer workflow will assign an unique id to the created item. But the id assigning workflow is not being triggered automatically but it starts automatically when an item is changed or modified. I need to start automatically when an item is created, I tried the trigger options

I tried maximum troubleshooting as well but it didn’t help, Now I got a workaround to update in sharepoint server with a sharepoint online management powershell command. I’m not sure how to use it. please help me how to initiate it and also other troubleshooting techniques as well. Help me fix this Thanks in advance.

PFB the command: stsadm.exe –o setproperty –propertyname declarativeworkflowautostartonemailenabled –propertyvalue yes

output formatting – How to define some functions automatically?

I want to use Gauss-Seidel iteration to solve this problem.

8 x_{1}-3 x_{2}+2 x_{3}=20 \
4 x_{1}+11 x_{2}-x_{3}=33 \
6 x_{1}+3 x_{2}+12 x_{3}=36

n = 3; 
b = {20, 33, 36}; a = {{8, -3, 2}, {4, 11, -1}, {6, 3, 12}}; 
  i_) := (b((i)) - Sum(a((i, j))*x(j, k), {j, 1, i - 1}) - 
    Sum(a((i, j))*x(j, k - 1), 
          {j, i + 1, n}))/a((i, i))
Thread(Table(x(i, k), {i, 1, n}) == 
  Table(Δx(i), {i, 1, n}))

Table(Hold(x(i, k_) := x(i, k) = Δx(i)), {i, 1, n})

I want to output the above results automatically as the following custom functions:

x(1, k_) := x(1, k) = (1/8)*(3*x(2, k - 1) - 2*x(3, k - 1) + 20)
x(2, k_) := x(2, k) = (1/11)*(-(4*x(1, k )) + x(3, k - 1) + 33)
x(3, k_) := x(3, k) = (1/12)*(-(6*x(1, k )) - 3*x(2, k ) + 36)

So that the following operations can be carried out automatically:

x(1, 0) = 1.; 
x(2, 0) = 1.;
x(3, 0) = 1.;
Table({x(1, i), x(2, i), x(3, i)}, {i, 0, 10})
LinearSolve(( {
   {8, -3, 2},
   {4, 11, -1},
   {6, 3, 12}
  } ), {20, 33, 36})

What can I do to get the custom functions directly in the result?

development – How to get SharePoint 2013 on-premises appregnew.aspx to register my service principal in Azure AD automatically?

I have already run the PowerShell command Connect-SPFarmToAAD on the on-premises farm. (Connect-SPFarmToAAD is document here in detail:

When registering a new app on the appregnew.aspx page of my on-premises farm. I am not seeing it in my Azure AD environment anywhere. Should this work on-premises? Is there some other configuration to the farm that must be done?

I found a manual workaround that I could make a new client id in Azure AD via Azure app registration and give it a secret. Then create that same client id app on the SharePoint side via appregnew.aspx. Finally grant it permissions in appinv.aspx to the site or web I was working on. I didn’t use the same secret which didn’t matter actually, just as long as the ID’s are the same things worked great for the standard ACS token request process.

When doing the appregnew.aspx process on a SharePoint Online I am seeing a new service principal created in Azure AD and things are working as expected.

8 – How do I get the administrator to automatically flag?

I created a module for flagging entities automatically when created or updated.

There are some errors in my code because only nodes work.

If a user “user1” creates a node, the flag will be in his name. I want the flag to be done automatically on behalf of the site administrator.

How do I get the administrator to automatically flag ?


use DrupalflagFlaggingInterface;
use DrupalCoreEntityContentEntityBase;
use DrupaluserEntityUser;
use Drupalcommerce_storeEntityStore;
use Drupalcommerce_productEntityProduct;
use DrupalgroupEntityGroup;
use DrupalnodeEntityNode;
use DrupalcommentEntityComment;

 * Flag user.
function admin_task_notify_user_update(User $account) {
  $flag_id = 'moderate_user';
  $flag_service = Drupal::service('flag');
  $flag = $flag_service->getFlagById($flag_id);
  $flag_service->flag($flag, $account);

 * Flag store.
function admin_task_notify_commerce_store_update(Store $commerce_store) {

    $flag_id = 'moderate_store';
    $flag_service = Drupal::service('flag');
    $flag = $flag_service->getFlagById($flag_id);
    $flag_service->flag($flag, $commerce_store);

 * Flag product.
function admin_task_notify_commerce_product_update(Product $commerce_product) {

    $flag_id = 'moderate_product';
    $flag_service = Drupal::service('flag');
    $flag = $flag_service->getFlagById($flag_id);
    $flag_service->flag($flag, $commerce_product);

 * Flag group.
function admin_task_notify_group_update(Group $group) {

    $flag_id = 'moderate_group';
    $flag_service = Drupal::service('flag');
    $flag = $flag_service->getFlagById($flag_id);
    $flag_service->flag($flag, $group);

 * Flag node.
function admin_task_notify_node_update(Node $node) {

    $flag_id = 'moderate_node';
    $flag_service = Drupal::service('flag');
    $flag = $flag_service->getFlagById($flag_id);
    $flag_service->flag($flag, $node);


 * Flag comment.
function admin_task_notify_comment_update(Comment $comment) {

    $flag_id = 'moderate_comment';
    $flag_service = Drupal::service('flag');
    $flag = $flag_service->getFlagById($flag_id);
    $flag_service->flag($flag, $comment);


Google calendar automatically unchecks Reminders

I’ve been using Google Calendar for a long time and organizing events, reminders and tasks. But Its reminder items occasionally disappears and I have to manually check the Reminder box on the left panel to show them on top. Does anyone know why the Reminder box automatically unchecks itself?

enter image description here

8 – Cannot flag nodes and comments automatically

I created a code to automatically flag nodes and comments. When I put only the code to flag the nodes, it works. But when I add the code to flag the comments it doesn’t work anymore.

Which code should I use ?


function admin_task_notify_entity_update(DrupalCoreEntityEntityInterface $entity) {

  // Flag node.
  if (in_array($entity->bundle(), ('annonce', 'article', 'demande', 'discussion', 'evenement', 'itineraire', 'recette'))) {
    $flag_id = 'report_node';

    $flag_service = Drupal::service('flag');
    $flag = $flag_service->getFlagById($flag_id);

    $flag_service->flag($flag, $entity);

  // Flag comment.
  if (in_array($entity->bundle(), ('annonce', 'article', 'demande', 'discussion', 'evenement', 'itineraire', 'recette', 'produit', 'service'))) {
    $flag_id = 'report_comment';

    $flag_service = Drupal::service('flag');
    $flag = $flag_service->getFlagById($flag_id);

    $flag_service->flag($flag, $entity);


macos – Automatically apply tag to folder based on content

Is anyone aware of a way to automatically apply a given Finder tag to a folder based on its contents?

For example, I can easily run a Finder search for files based on their “Document Container”.
But it seems there is no way to get containers based on files they contain. What I’m trying to do is to apply tag “X” to all folders that contain one or more files with file extension “Y”.
It seems there’s no way to do it directly from Finder but I haven’t been lucky with Automator either as I can’t seem to find a way to select a range of folders based on what they contain.

transactions – Is there a way to automatically send trons from one wallet to another?

Say I have 2 wallets, an older non-encrypted one and a fresh new encrypted wallet with all new addresses. If I have an address in the older wallet that may receive some trons in the future is there away to set it up so that these trons will automatically be sent to an address in the new encrypted wallet.
It is posible to auto transfer tron to new wallet.
If I do same process on tron so, it’s going to work or not.