Computer programming Archives

Anonymous

Asked: August 6, 2022Computer programming

How to update SEO Focus keyphrase programmatically of woocommerce product?

Hi Could please tell me how to add or update SEO Focus keyphrase programmatically? I used this code but it doesn’t work: Read more

Best Answer

Anonymous

Added an answer on August 6, 2022 at 1:46 pm

This answer was edited.

Hi, I think Yoast SEO removed metakeywords. Please see this aricle : Meta keywords Why we don't use them - and neither should you use this key instead : _yoast_wpseo_focuskw You can update it like any post meta. This is the syntax: //the value of the focus key word $myFocusKeyword = "focus keyword eRead more

Hi,

I think Yoast SEO removed metakeywords. Please see this aricle :

Meta keywords Why we don’t use them – and neither should you

use this key instead :

_yoast_wpseo_focuskw

You can update it like any post meta. This is the syntax:

//the value of the focus key word
$myFocusKeyword = "focus keyword example"; 
 //wrtie the value to postmeta key _yoast_wpseo_focuskw
$updatedKeyword = update_post_meta($post_id, ‘_yoast_wpseo_focuskw’, $myFocusKeyword);

//the value of the focus key word

$myFocusKeyword = "focus keyword example";

//wrtie the value to postmeta key _yoast_wpseo_focuskw

$updatedKeyword = update_post_meta($post_id, ‘_yoast_wpseo_focuskw’, $myFocusKeyword);

I tested it and it works fine.

regards

See less

Share
Share

1 User

1 User

Anonymous

Asked: July 31, 2022Computer programming

How to Send Email in Excel Using VBA?

Hello, I have an excel file that is updated automatically from some websites. This files contains products prices. I want to send automatically an email when the price drop under a value. Is there a way How to send email using VBA Excel?How to Send Email in Excel Using VBA? Thanks for your help

Anonymous

Added an answer on July 31, 2022 at 3:22 pm

This answer was edited.

Hello, You need to give access Outlook with VBA, you need to activate the Microsoft Outlook Object Library. To activate it, go to Tools in the VBA editor > References. Activate Microsoft Outlook 16.0 Object Library : Then in a module use this subroutine: Sub sendAnEmail(ByRefRead more

Hello,

You need to give access Outlook with VBA, you need to activate the Microsoft Outlook Object Library.

To activate it, go to Tools in the VBA editor > References.

Activate Microsoft Outlook 16.0 Object Library :

Then in a module use this subroutine:

Sub sendAnEmail(ByRef DomainName As String, ByRef SendTo As String, ByRef EmailSubject As String, ByRef EmailBody As String)

    'refer to outlook application
    Dim EmailApp As Outlook.Application
    Dim Source As String
    'launch outlook application
    Set EmailApp = New Outlook.Application
    'refer to a new outlook email
    Dim EmailItem As Outlook.MailItem
    'create a new outlook email
    Set EmailItem = EmailApp.CreateItem(olMailItem)
    
    EmailItem.To = SendTo 'the email adress who the email is sent to
    EmailItem.Subject = EmailSubject 'write your email subject in this variable
    EmailItem.HTMLBody = EmailBody
    Source = ThisWorkbook.FullName
    'send the new email
    EmailItem.Send
End Sub

Sub sendAnEmail(ByRef DomainName As String, ByRef SendTo As String, ByRef EmailSubject As String, ByRef EmailBody As String)

'refer to outlook application

Dim EmailApp As Outlook.Application

Dim Source As String

'launch outlook application

Set EmailApp = New Outlook.Application

'refer to a new outlook email

Dim EmailItem As Outlook.MailItem

'create a new outlook email

Set EmailItem = EmailApp.CreateItem(olMailItem)

EmailItem.To = SendTo 'the email adress who the email is sent to

EmailItem.Subject = EmailSubject 'write your email subject in this variable

EmailItem.HTMLBody = EmailBody

Source = ThisWorkbook.FullName

'send the new email

EmailItem.Send

End Sub

To test the code, call this code using a buton:

Sub testSendEmail()
    Dim SendTo, EmailSubject, EmailBody As String
    SendTo = "myemail@example.com"   ' put the email adress that will receive the email
    EmailSubject = "This is a send email test from Excel"  ' write your subject
    EmailBody = "This email is sent from Execl using Microsoft outlook library" ' put the body
    sendAnEmail DomainName, SendTo, EmailSubject, EmailBody  ' call the subroutine by passing the parameters
End Sub

Sub testSendEmail()

Dim SendTo, EmailSubject, EmailBody As String

SendTo = "myemail@example.com" ' put the email adress that will receive the email

EmailSubject = "This is a send email test from Excel" ' write your subject

EmailBody = "This email is sent from Execl using Microsoft outlook library" ' put the body

sendAnEmail DomainName, SendTo, EmailSubject, EmailBody ' call the subroutine by passing the parameters

End Sub

Test:

I hope this will help you.

Good luck!

See less

Share
Share

Be the first one react

Gwennavia

Asked: August 8, 2022Computer programming

How to calculate the difference between two dates using PHP language?

Hello I have two date : Read more

Anonymous

Added an answer on August 8, 2022 at 11:57 pm

Please use this code: $first_date = new DateTime("2022-01-01"); $second_date = new DateTime("2023-02-02"); $difference = $first_date->diff($second_date); echo "<difference> = " . $difference->y . " years, " . $difference->m." months, ".$difference->d." days " . "<difference in dRead more

Please use this code:

$first_date = new DateTime("2022-01-01");
$second_date = new DateTime("2023-02-02");
$difference = $first_date->diff($second_date);
echo "<difference> = " . $difference->y . " years, " . $difference->m." months, ".$difference->d." days " . "<difference in days> =" . $difference->days . " days ";

$first_date = new DateTime("2022-01-01");

$second_date = new DateTime("2023-02-02");

$difference = $first_date->diff($second_date);

echo "<difference> = " . $difference->y . " years, " . $difference->m." months, ".$difference->d." days " . "<difference in days> =" . $difference->days . " days ";

It works as you expect

See less

Share
Share

1 User

1 User

Anonymous

Asked: August 8, 2022Computer programming

How to concatenate strings together in PHP?

Hi everyone, I am new in PHP. I have this function which convert all alphabetic characters to uppercase: Read more

Best Answer

Anonymous

Added an answer on August 8, 2022 at 11:06 pm

This answer was edited.

Hi, This is the syntax to concatenate strings: $text1 = "hello"; $text2 = "world"; $text = $text1 . ' ' . $text2; For your code, use this: function UppercaseText($text_list) { $GlobalText = ""; $TableSize = sizeof($text_list);; for ($i = 0; $i < $TableSize; $i++) { $BigText[] = strtoupper($text_lRead more

Hi,

This is the syntax to concatenate strings:

$text1 = "hello";
$text2 = "world";
$text = $text1 . ' ' . $text2;

$text1 = "hello";

$text2 = "world";

$text = $text1 . ' ' . $text2;

For your code, use this:

function UppercaseText($text_list) {
	$GlobalText = "";
	$TableSize = sizeof($text_list);;
  	for ($i = 0; $i < $TableSize; $i++) {
    $BigText[] = strtoupper($text_list[$i]);
    $GlobalText .=  strtoupper($text_list[$i]);
    if ($i != $TableSize-1) {
    $GlobalText .= " ";
    }
  }
  //return $BigText;
  return $GlobalText;
}
$text_list = ['the', 'train', 'was', 'late'];
var_dump(UppercaseText($text_list));

function UppercaseText($text_list) {

$GlobalText = "";

$TableSize = sizeof($text_list);;

for ($i = 0; $i < $TableSize; $i++) {

$BigText[] = strtoupper($text_list[$i]);

$GlobalText .= strtoupper($text_list[$i]);

if ($i != $TableSize-1) {

$GlobalText .= " ";

}

//return $BigText;

return $GlobalText;

}

$text_list = ['the', 'train', 'was', 'late'];

var_dump(UppercaseText($text_list));

Have a good day

See less

Share
Share

Be the first one react

Marie

Asked: August 9, 2022Computer programming

How do I use a global variable inside a function using Python?

Hi I have a variables that is declared outsides fucntions. How can I use and change these variables inside function usign Python? thank you

Best Answer

Gwennavia

Added an answer on August 9, 2022 at 9:40 am

Follow this example to create a variable outside functions, and use it inside the functions: MyVariable = 99 #this is a global variable def changeAndPrint_GlobalVariable(): global MyVariable #use global variable in this function with "global" keyword print('Global variable "MyVariable" before changeRead more

Follow this example to create a variable outside functions, and use it inside the functions:

MyVariable = 99 #this is a global variable

def changeAndPrint_GlobalVariable():
    global MyVariable  #use global variable in this function with "global" keyword
    print('Global variable "MyVariable" before change = ', MyVariable) # the global variable is printed
    MyVariable = 1  #change the value of the global variable is printed
    print('Global variable "MyVariable" after change = ', MyVariable) # the global variable is printed

def changeAndPrint_LocalVariable():
    MyVariable = 77 #this is a local variable
    print('Local variable "MyVariable" = ', MyVariable) #the local variable is printed

changeAndPrint_GlobalVariable() #call the function
changeAndPrint_LocalVariable() #call the function

MyVariable = 99 #this is a global variable

def changeAndPrint_GlobalVariable():

global MyVariable #use global variable in this function with "global" keyword

print('Global variable "MyVariable" before change = ', MyVariable) # the global variable is printed

MyVariable = 1 #change the value of the global variable is printed

print('Global variable "MyVariable" after change = ', MyVariable) # the global variable is printed

def changeAndPrint_LocalVariable():

MyVariable = 77 #this is a local variable

print('Local variable "MyVariable" = ', MyVariable) #the local variable is printed

changeAndPrint_GlobalVariable() #call the function

changeAndPrint_LocalVariable() #call the function

This code will print:

Global variable "MyVariable" before change =  99
Global variable "MyVariable" after change =  1
Local variable "MyVariable" =  77

Global variable "MyVariable" before change = 99

Global variable "MyVariable" after change = 1

Local variable "MyVariable" = 77

See less

1 User

Share
Share

1 User

1 User

Anonymous

Asked: August 9, 2022Computer programming

How to flatten a list of lists in python?

Hi, I want to convert a list using python. I have a list of list like this: Read more

Anonymous

Added an answer on August 9, 2022 at 9:02 am

Hello this code may help you: def flatten_list(original_List): flat_list = [] for sub_list in original_List: for element in sub_list: flat_list.append(element) return flat_list #test original_List=[['a', 'b', 'c', 'd','e'], ['f', 'g', 'h', 'i'], ['j', 'k', 'l'], ['m', 'n', 'o']] print('original listRead more

Hello

this code may help you:

def flatten_list(original_List):
    flat_list = []
    for sub_list in original_List:
        for element in sub_list:
            flat_list.append(element)
    return flat_list

#test
original_List=[['a', 'b', 'c', 'd','e'], ['f', 'g', 'h', 'i'], ['j', 'k', 'l'], ['m', 'n', 'o']]
print('original list = ', original_List)
print('flat list = ', flatten_list(original_List))

def flatten_list(original_List):

flat_list = []

for sub_list in original_List:

for element in sub_list:

flat_list.append(element)

return flat_list

#test

original_List=[['a', 'b', 'c', 'd','e'], ['f', 'g', 'h', 'i'], ['j', 'k', 'l'], ['m', 'n', 'o']]

print('original list = ', original_List)

print('flat list = ', flatten_list(original_List))

See less

Share
Share

1 User

1 User

Anonymous

Asked: August 29, 2022Computer programming

Is there a system variable to check if fanuc robot is moving?

Hello, Is there a solution to check if fanuc robot is in motion? I want to share this inormation with PLC. thanks for help.

Anonymous
Added an answer on August 29, 2022 at 8:23 pm
This answer was edited.
Hi, In system variables you can find this variable: $MOR_GRP[1].$ROB_MOVE To share the state of robot is moving you can use a an output in a routine executed in a background logic. For example : DO[100] = $MOR_GRP[1].$ROB_MOVE Run this program in background logic: The output DO[100] will be updatedRead more
Hi,
In system variables you can find this variable:
$MOR_GRP[1].$ROB_MOVE
To share the state of robot is moving you can use a an output in a routine executed in a background logic.
For example :
DO[100] = $MOR_GRP[1].$ROB_MOVE
Run this program in background logic:
The output DO[100] will be updated and will get the robot motion status.
I hope this help you.

See less
React
1
Share
Share
Share on Facebook
Share on Twitter
Share on LinkedIn
Share on WhatsApp

Be the first one react

Anonymous

Asked: January 8, 2023Computer programming

How to monitor printers status on a network using VBscript?

Hi,I am new to VBScript, I am trying to get all the printers status on a network. Is there a script to do that? thank youRead more

Anonymous

Added an answer on January 8, 2023 at 1:47 pm

This answer was edited.

here is the code if you need to check if a printer is connected to nework: Set objWMIService = GetObject("winmgmts:\\.\root\cimv2") Set colItems = objWMIService.ExecQuery("SELECT * FROM Win32_Printer WHERE Name = 'HP DeskJet 2720E'") For Each objItem in colItems If objItem.Network = True Then WScripRead more

here is the code if you need to check if a printer is connected to nework:

Set objWMIService = GetObject("winmgmts:\\.\root\cimv2")
Set colItems = objWMIService.ExecQuery("SELECT * FROM Win32_Printer WHERE Name = 'HP DeskJet 2720E'")

For Each objItem in colItems
    If objItem.Network = True Then
        WScript.Echo "HP DeskJet is connected to the network"
    Else
        WScript.Echo "HP DeskJet is not connected to the network"
    End If
Next

Set objWMIService = GetObject("winmgmts:\\.\root\cimv2")

Set colItems = objWMIService.ExecQuery("SELECT * FROM Win32_Printer WHERE Name = 'HP DeskJet 2720E'")

For Each objItem in colItems

If objItem.Network = True Then

WScript.Echo "HP DeskJet is connected to the network"

Else

WScript.Echo "HP DeskJet is not connected to the network"

End If

This script uses the Windows Management Instrumentation (WMI) service to query for printers with the name “HP DeskJet”. It then checks the value of the Network property for each printer to determine whether it is connected to the network. If the Network property is True, the script outputs a message indicating that the printer is connected to the network. If the Network property is False, the script outputs a message indicating that the printer is not connected to the network.

I hope this helps!

See less

Share
Share

1 User

1 User

Anonymous

Asked: August 15, 2022Computer programming

How I sort worksheets by alphabet using vba Excel?

I have an excel files which contains many sheets. for evey sheet, the name is equal to name of student. How Sort worksheets by alphabet using vba Excel? thank you

Best Answer

Anonymous

Added an answer on August 15, 2022 at 8:17 pm

hello, try this code it will help you: Private Sub CommandButton1_Click() Application.ScreenUpdating = False 'disable screen update for performance Dim i, j As Integer Dim SheetsCount As Integer SheetsCount = Sheets.Count For i = 1 To SheetsCount - 1 For j = i + 1 To SheetsCount If Sheets(j).NameRead more

hello,

try this code it will help you:

Private Sub CommandButton1_Click()
    Application.ScreenUpdating = False 'disable screen update for performance
    Dim i, j As Integer
    Dim SheetsCount As Integer
    SheetsCount = Sheets.Count
    For i = 1 To SheetsCount - 1
        For j = i + 1 To SheetsCount
            If Sheets(j).Name < Sheets(i).Name Then
                Sheets(j).Move before:=Sheets(i)
            End If
        Next j
    Next i
    Application.ScreenUpdating = True 'enable screen update
End Sub

Private Sub CommandButton1_Click()

Application.ScreenUpdating = False 'disable screen update for performance

Dim i, j As Integer

Dim SheetsCount As Integer

SheetsCount = Sheets.Count

For i = 1 To SheetsCount - 1

For j = i + 1 To SheetsCount

If Sheets(j).Name < Sheets(i).Name Then

Sheets(j).Move before:=Sheets(i)

End If

Next j

Next i

Application.ScreenUpdating = True 'enable screen update

End Sub

See less

Share
Share

Be the first one react

Anonymous

Asked: October 23, 2022Computer programming

How do I count the occurrences of all list items using python?

I have a list which contain names of students. Example: Read more

Best Answer
Anonymous
Added an answer on October 23, 2022 at 7:17 am
You can use Counter if you want to do multiple count of the list from collections import Counter list = ['Jones','Adams','Frank','John','Lopez','Jones','Smith','Ivan','Julian','Carlos','Adams','Frank','Jones','John','Ivan'] print(Counter(list)) Result: Counter({'Jones': 3, 'Adams': 2, 'Frank': 2, 'JRead more
You can use Counter if you want to do multiple count of the list
Python
from collections import Counter list = ['Jones','Adams','Frank','John','Lopez','Jones','Smith','Ivan','Julian','Carlos','Adams','Frank','Jones','John','Ivan'] print(Counter(list))
1
2
3
4
from collections import Counter
list = ['Jones','Adams','Frank','John','Lopez','Jones','Smith','Ivan','Julian','Carlos','Adams','Frank','Jones','John','Ivan']
print(Counter(list))

Result:
Python
Counter({'Jones': 3, 'Adams': 2, 'Frank': 2, 'John': 2, 'Ivan': 2, 'Lopez': 1, 'Smith': 1, 'Julian': 1, 'Carlos': 1})
1
2
Counter({'Jones': 3, 'Adams': 2, 'Frank': 2, 'John': 2, 'Ivan': 2, 'Lopez': 1, 'Smith': 1, 'Julian': 1, 'Carlos': 1})

See less
React
0
Share
Share
Share on Facebook
Share on Twitter
Share on LinkedIn
Share on WhatsApp

Be the first one react

Load More Questions

How to update SEO Focus keyphrase programmatically of woocommerce product?

How to Send Email in Excel Using VBA?

How to calculate the difference between two dates using PHP language?

How to concatenate strings together in PHP?

How do I use a global variable inside a function using Python?

How to flatten a list of lists in python?

Is there a system variable to check if fanuc robot is moving?

How to monitor printers status on a network using VBscript?

How I sort worksheets by alphabet using vba Excel?

How do I count the occurrences of all list items using python?

How to solve Data corruption prior to sending to F-IO ...

How to update SEO Focus keyphrase programmatically of woocommerce product?

How to Send Email in Excel Using VBA?

Gwennavia

akhan

Marie

Quereact Latest Questions