Vinod Kotiya

Kids USA Visa without interview if parents have US Visa

2024-09-20T12:48:00.000-07:00

This info is missing all over the internet.

Simply apply the VISA through DS-160 form and go to appointment portal https://ais.usvisa-info.com/.

Create profile for kid and enter few information properly here

something like this

So it will not give you schedule interview option and show you send document option.

Counselors will mail you how to submit the documents.

o determine if you qualify for a consular interview waiver, you must first cancel your existing consular appointment. If you do not qualify for an interview waiver after completing the steps below, you will need to schedule a new consular appointment based on current appointment availability.

(Please be aware that if you have never had a visa previously, you must attend an in-person interview and should not take the steps below. Instead, you should prepare to attend the interview appointment you have already scheduled.)

If you choose to proceed, follow these steps to determine eligibility for a consular interview waiver:

Log in to your account and click on the "Continue" button.
Select the "Cancel Appointment" option and confirm the cancellation request. You must cancel your appointment to reset your account and have the interview waiver scheduling condition statements available to you.
At the Applicant Summary page, click on the gear icon and choose the "Edit" option, review your profile, and update as needed on the Edit Applicant page, click the "Save" button. Even if you did not make any changes to your profile, click on the "Save" button. This will allow you access to the interview waiver scheduling condition statements.
Finally, select the condition statements that apply to you and click the "Confirm" button. The system will determine your eligibility for an interview waiver based on your responses.

a. If you qualify for an interview waiver, the system will display information on how to submit your visa renewal application to the Consular Section.

b. If you do not qualify for an interview waiver, you will be instructed to schedule a new appointment for a consular interview.

How to Connect Power BI to JIRA Using REST API Without Third-Party Apps

2024-09-05T12:51:00.000-07:00

After years of delivering successful system integration projects, I'm excited to share this write-up that continues to drive value for many users! Two years ago, I proposed a solution for Microsoft Power BI and Atlassian JIRA integration using the REST API—without relying on any third-party apps. I found no such simple solution available on the internet, so I got a hint from a simple curl command and developed an integration solution from it. This solution is still actively helping professionals to fetch JIRA data into PowerBI. The original post was shared in Atlassian Community here https://community.atlassian.com/t5/Marketplace-Apps-Integrations/How-to-connect-Power-BI-to-JIRA-using-Rest-API-and-without-third/qaq-p/2255960?utm_source=atlcomm&utm_medium=email&utm_campaign=mentions_reply&utm_content=topic#U2804427

Integrating JIRA with Power BI can help organizations access real-time project data, create insightful reports, and manage workflows more efficiently. While many third-party apps offer this functionality, you can bypass them using JIRA’s REST API to establish a direct connection with Power BI. This solution is simple and scalable.

I found no such simple solution available on internet so I got a hint from simple curl command and tried to have integration solution out of it:

curl -D- \
-X GET \
-H "Authorization: Basic YOUR_BASE64_TOKEN" \
-H "Content-Type: application/json" \
"https://DOMAIN.atlassian.net/rest/api/2/issue/ISSUE"

Step 1: Generate Base64-Encoded Authentication Token

First, you need a Base64-encoded token that JIRA will use for authentication.

Open a terminal (or use an online tool like Base64 Encode).
Encode the string: EMAIL:API_TOKENExample: myemail@company.com:your_api_token_hereYou can generate this with a curl command:

echo -n "myemail@company.com:your_api_token_here" | base64

Step 2: Connect Power BI to JIRA

Open Power BI.
Go to Get Data > Web.
Enter the JIRA REST API URL (as used in step 2).
In the headers:

Add Authorization: Basic [Space] YOUR_BASE64_TOKEN
Add Content-Type: application/json.

![Screenshot of Power BI connection screen with headers]

Click OK to establish the connection.

Step 3: Create a Power BI Function to Fetch Data

You’ll now create a Power BI function to retrieve data from JIRA in batches, as JIRA limits the number of records retrieved in a single query. Name it "GetJIRAData"

In Power BI, create a new query and enter the following code:

let
    GetJiraData = (offset) =>
    let    
        myURL = "https://your_domain.atlassian.net/rest/api/3/",
        Jql = "project=WPM",  // Modify this with your actual project key
        Fields = "summary,key,issuetype,status,assignee",  // Add fields as needed
        StartAt = Number.ToText(offset),
        MaxR = "100",
        Source = Json.Document(Web.Contents(myURL, 
            [RelativePath="search?",
                Query = [ jql=Jql, fields=Fields, maxResults=MaxR, startAt=StartAt ],
                Headers = [ Authorization="Basic YOUR_BASE64_TOKEN", #"Content-Type"="application/json" ]
            ]
        ))
    in
        Source
in
    GetJiraData

Replace the placeholder values with actual data (e.g., your domain, API token).
You can modify the Fields variable to fetch additional data from JIRA.

Step 4: Query Iteration for Large Data Sets

Since JIRA limits the number of records fetched per call (usually 1000), you can create an iterative query in Power BI to retrieve all records in batches.

Create another query, naming it JiraData:

let
    JiraData = List.Generate(
        () => [offset = 0, data = GetJiraData(0)],
        each not List.IsEmpty([data][issues]),
        each [offset = [offset] + 100, data = GetJiraData([offset])],
        each [data]
    )
in
    JiraData

Power BI will now iterate through the data in batches of 100 records until all issues are retrieved.

Step 6: Transform and Load Data into Power BI

Once the data is imported:

Transform the data "JIRAData" as needed within Power BI to fit your reporting needs.

Here are few transformation I applied. Start with "Converted to table" and then expand it to get columns.

Create visualizations and reports based on the JIRA data.

#PowerBI #JIRA #SystemIntegration #RESTAPI #DataIntegration #TechInnovation #ProjectManagement

Creating an Azure HTTP Function to Import Custom Events into Outlook through URL/ Custom Calendar Part1

2024-08-25T22:02:00.000-07:00

In this tutorial, you'll learn how to set up your development environment, create an Azure HTTP function using Python, and deploy it to Azure. This function will allow users to import custom events into their Outlook calendar.

Prerequisites

Before you begin, make sure you have the following:

A free Azure account (or an existing one)
Basic knowledge of Python and Azure functions

Step 1: Setting Up Your Development Environment

Create a Free Azure Account
- Visit the Azure Free Account page and click on Start for free.
- Follow the on-screen instructions to set up your account.

Install Azure Functions Core Tools

For Linux users:

bash
wget -q https://packages.microsoft.com/config/ubuntu/$(lsb_release -rs)/packages-microsoft-prod.deb
sudo dpkg -i packages-microsoft-prod.deb
sudo apt-get update
sudo apt-get install azure-functions-core-tools-4

For Windows users, download and install the latest version of Azure Functions Core Tools from the official documentation.

Install Visual Studio Code (VS Code)
- Download and install Visual Studio Code for your operating system.
Install VS Code Extensions
- Open VS Code, go to the Extensions view (Ctrl+Shift+X), and install the following:
  - Python (by Microsoft) - For Python development
  - Azure Functions (by Microsoft) - To create, debug, and deploy Azure functions directly from VS Code
Verify Python Installation
- Ensure Python is installed on your system by running:
```
bash
python --version
```
- If Python is not installed, follow the official guide to install it.

Step 2: Setting Up Your Azure Function Project

Create a Project Directory in VSCode "OutlookAPI"

Create a New Azure Function
- In VS Code, click on the Azure icon on the Activity Bar.
- Click on the Create New Project button (a lightning bolt with a plus sign).
- Choose your current directory for the project location.
- Select Python as the language.
- Choose your Python interpreter (e.g., Python 3.9).
- Select HTTP trigger as the function template.
- Name your function (e.g., HttpTriggerQuick).
- Set the authorization level to Anonymous.
Review the Project Structure
- Your project should now contain:
  - A .vscode folder with configuration settings
  - A __init__.py file where your function code will reside
  - A function.json file with your function configuration
  - A local.settings.json file for local development settings
  - A requirements.txt file listing your project's dependencies

Step 4: Writing the Function Code

This section is where you'll add your custom code to handle the HTTP requests and import events into Outlook.

import logging
from datetime import datetime
from icalendar import Calendar, Event
import azure.functions as func
import uuid

app = func.FunctionApp(http_auth_level=func.AuthLevel.ANONYMOUS)

@app.route(route="EkasminAPI")
def EkasminAPI(req: func.HttpRequest) -> func.HttpResponse:
    logging.info('Python HTTP trigger function processed a request.')

    name = req.params.get('name')
    if not name:
        try:
            req_body = req.get_json()
        except ValueError:
            pass
        else:
            name = req_body.get('name')

    if name:
        logging.info('Generating calendar...')

        # List of events with their details
        events = [
            {
                'summary': 'Event 1',
                'description': 'Description for Event 1',
                'start': datetime(2024, 8, 25, 10, 0, 0),
                'end': datetime(2024, 8, 25, 11, 0, 0),
            },
            {
                'summary': 'Event 2',
                'description': 'Description for Event 2',
                'start': datetime(2024, 8, 26, 10, 0, 0),
                'end': datetime(2024, 8, 26, 11, 0, 0),
            },
            {
                'summary': 'Event 3',
                'description': 'Description for Event 3',
                'start': datetime(2024, 8, 29, 10, 0, 0),
                'end': datetime(2024, 8, 29, 11, 0, 0),
            }
        ]

        # Create calendar
        cal = Calendar()
        cal.add('prodid', '-//My Calendar Application//Ekasmin.com//')
        cal.add('version', '2.0')

        # Log the number of events to be processed
        logging.info(f'Number of events: {len(events)}')

        # Add events to the calendar
        for i, event_data in enumerate(events, start=1):
            logging.info(f'Processing event {i}: {event_data["summary"]}')
            try:
                event = Event()
                event.add('summary', event_data['summary'])
                event.add('description', event_data['description'])
                event.add('dtstart', event_data['start'])
                event.add('dtend', event_data['end'])
                event.add('dtstamp', datetime.now())
                event.add('uid', str(uuid.uuid4()))  # Generate a unique ID for each event
                cal.add_component(event)  # Add the event to the calendar
                logging.info(f'Event {i} added.')
            except Exception as e:
                logging.error(f'Error processing event {i}: {e}')
                continue

        # Convert to iCalendar format
        ical_str = cal.to_ical().decode('utf-8')

        # Log the output to verify all events are added
        logging.info(f'Generated iCalendar file: {ical_str}')

        # Return the iCalendar string as a response with the correct MIME type
        return func.HttpResponse(ical_str, mimetype='text/calendar')

    else:
        return func.HttpResponse(
            "This HTTP triggered function executed successfully. Pass a name in the query string or in the request body for a personalized response.",
            status_code=200
        )

Step 4: Testing the Function Locally

Run the Function Locally
- Press F5 in VS Code to start the local Azure Function runtime.
- VS Code will open a terminal, install any necessary dependencies, and start the function.
- The terminal will display a local HTTP endpoint (e.g., http://localhost:7071/api/HttpTriggerQuick).
Test Using Postman
- Open Postman.
- Create a new GET or POST request to the local endpoint.
- Check the response to verify the function is working as expected.

Step 5: Deploying the Function to Azure

Log In to Azure
- In VS Code, click on the Azure icon and sign in to your Azure account.
Create an Azure Function App
- Click on the Create Function App in Azure button.
- Enter a globally unique name for your function app (e.g., QuickFunction4242).
- Select your Python version and Azure region.
Deploy the Function
- Once the function app is created, right-click on your project in VS Code and select Deploy to Function App.
- Choose the function app you just created.
- Confirm the deployment when prompted.
Test the Deployed Function
- Copy the production endpoint URL from Azure and test it using Postman.
- Verify that your function is running correctly in the cloud.

Step 6: Clean Up Resources

To avoid any charges, delete the resource group associated with your function app after testing:
- Go to the Azure portal, find your resource group, and delete it.

Conclusion

You've now successfully set up your environment, created an Azure HTTP function, tested it locally, and deployed it to Azure. This function can now be used to import custom events into Outlook.

Wait for Part 2 Where I will modify these events by integrating to some other applications.

Azure Apps setting up custom sub domains

2024-06-06T10:05:00.000-07:00

I have noticed that subdomains can be quite unclear on how to add them properly. Basically you have to use TXT record to verify ownership. Delete it and create CNAME record for app URL followed by A record for IP address of azure

Go to custom domain section for setting dev.ekasmin.com

Step 1: Add a TEXT Record for example

Step 2: Open your DNS Management from Go Daddy/Domain Provider. Add the TXT Record

Step 3: In Azure it will switch to CNAME record for dev.ekasmin.com like this

Step 4. Now here is critical part. You can't add TXT and CNAME for same subdomain "dev". So delete the TXT created in Step 2 which has been used for ownership verification. Add CNAME in your DNS Management dev with the URL of app "gray-island-0a3e7441e.5.azurestaticapps.net"

Step 5: Also add an A record for the IP address of "gray-island-0a3e7441e.5.azurestaticapps.net" . use online tool to find IP address.

This will now open your app when you type dev.ekasmin.com

Update JIRA endpoints from Excel Macro using REST API calls

2023-11-16T09:26:00.000-08:00

To update JIRA issue from Excel Macro follow these steps.

1. Create a webhook automation

2. Create a MAcro in Excel to update

'macro to upload data back into Jira

Sub updateJIRAFunc(Key As String)

On Error GoTo eh

Dim objHTTP As Object

'Json = "{ ""key"": ""SCP-1409"", ""duedate"" : ""2018-03-03""}"

Dim Json As String

Json = "{"

Json = Json & """key"": """ & Key & """"

Json = Json & "}"

'MsgBox (Json)

Dim result As String

Set objHTTP = CreateObject("MSXML2.ServerXMLHTTP")

Dim Url As String

Url = "https://automation.atlassian.com/pro/hooks/3b5d3807"

If Left(Key, 3) = "SCP" Then

Url = "https://automation.atlassian.com/pro/hooks/b786e191d456544dc2239ba7b3b"

End If

objHTTP.Open "POST", Url, False

objHTTP.setRequestHeader "Content-type", "application/json"

'objHTTP.setRequestHeader "apikey", ""

objHTTP.send (Json)

result = objHTTP.responseText

'Some simple debugging

' Set the worksheet

Range("I3").Value = result

Set objHTTP = Nothing

Exit Sub

eh:

Range("I3").Value = Err.Description

End Sub

Step3. Run that in a for loop on click of a button

Sub Button1_Click()

'updateJIRAFunc ("OM-24545")

Dim ws As Worksheet

Dim lastRow As Long

Dim i As Long

' Set the worksheet

Set ws = ThisWorkbook.Sheets("Sheet1") ' Change to the sheet's name

' Find the last row with data in the first column

lastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row

'Application.ActiveWorkbook.Worksheets("exportDataToJira").Range("F3:F7") = Format(Date, "yyyy-mm-dd")

'Application.ActiveWorkbook.Worksheets("exportDataToJira").Range("F3:F7").NumberFormat = "yyyy-mm-dd"

'Range("F3:F7").NumberFormat = "yyyy\-mm\-dd"

' Loop through the rows

For i = 4 To lastRow ' Assuming data starts from row 2

' Get inputs from columns

Dim jiraKey As String

jiraKey = ws.Cells(i, 1).Value ' Jira Key is in column A

'newDueDate = Replace(ws.Cells(i, 6).Value, "/", "-")

Call updateJIRAFunc(jiraKey, i)

ws.Cells(i, 4).Value = "1"

Next i

End Sub

Written By

-Vinod Kotiya

Restructure Excel Data like Pivot using Macro: Repeat the row for each column value

2023-09-14T13:46:00.002-07:00

In Excel here is the Sorce Table

And if you want to get data in this format

Use the following MAcro > Developer > Visual Basic > Insert Module

Sub RestructureData()

Dim ws As Worksheet

Dim LastRow As Long

Dim DestRange As Range

Dim Col1Cell As Range

Dim DestRow As Long

' Define the worksheet containing the source data

Set ws = ThisWorkbook.Sheets("Sheet1") ' Change "Sheet1" to your sheet name

' Clear any existing data in columns F and G

ws.Range("F:G").Clear

' Set the initial row for the destination data

DestRow = 2

' Find the last row in column A with data

LastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row

' Loop through each row in the source data

For Each Col1Cell In ws.Range("A2:A" & LastRow)

' Get the value from Col1 (M1, M2, M3)

Dim Col1Value As String

Col1Value = Col1Cell.Value

' Loop through columns B, C, and D (Col2, Col3, Col4)

For i = 2 To 4

' Get the value from Col2, Col3, or Col4

Dim ColValue As Variant

ColValue = Col1Cell.Offset(0, i - 1).Value

' Check if the value is not empty

If ColValue <> "" Then

' Write Col1Value and ColValue to the destination columns

ws.Cells(DestRow, "F").Value = Col1Value

ws.Cells(DestRow, "G").Value = ColValue

' Increment the destination row

DestRow = DestRow + 1

End If

Next i

Next Col1Cell

End Sub

Python or just coding exercises for kids

2023-09-10T20:19:00.001-07:00

Exercise: compare numbers

Ask the user to enter two numbers and tell us which one is bigger.

Exercise: Python Program to Display the Multiplication Table of any number entered.

Exercise: Print the last digit of any number entered. (2 methods)

Exercise: Write a program to check whether an years is leap year or not.

Exercise: Write a program to accept a number from 1 to 12 and display name of the month and days in

that month like 1 for January and number of days 31 and so on

Exercise: Write a program to check whether a number entered is three digit number or not.

Exercise: Write a program to check whether a person is eligible for voting or not.(voting age > = 18)

Exercise: Write a program to check whether a person is senior citizen or not.

Exercise: Write a program to find the lowest number out of two numbers excepted from user.

Exercise: Write a program to find the largest number out of two numbers excepted from user.

Exercise: Write a program to check whether a number (accepted from user) is positive or negative.

Exercise: Write a program to check whether a number is even or odd.

Exercise: Rectangular

Write a script that will ask for the sides of a rectangular and print out the area.

Provide error messages if either of the sides is negative.

Exercise: Calculator

Create a script that accepts 2 numbers and an operator (+, -, *, /), and prints the result of the

operation.

Exercise: Number guessing game - level 0

Level 0

Using the random module the computer “thinks” about a whole number between 1 and 20.

The user has to guess the number. After the user types in the guess the computer tells if this was

bigger or smaller than the number it generated, or if was the same.

The game ends after just one guess

Exercise: Fruit salad

Write a script that will pick 3 fruits from a list of fruits like the one we had in one of the earlier

slides. Print the 3 names.

Could you make sure the 3 fruits are different?

Exercise: compare strings

Ask the user to enter two strings

Then ask the user to select if she wants to compare them based on ASCII or based on their length

Then tell us which one is bigger.

Exercise: one string in another string

Write script that accepts two strings and tells if one of them can be found in the other and where?

Exercise: to ASCII CLI

Write script that gets a character on the command line and prints out the ascii code of it.

Maybe even:

Write script that gets a string on the command line and prints out the ascii code of each character.

Exercise: from ASCII CLI

Write script that accepts a number on the command line and prints the character represented by that

number.

Exercise: Print all the locations in a string

Given a string like “The black cat climbed the green tree.”, print out the location of every “c” charcater

Exercise: Number guessing game

Level 0

Using the random module the computer “thinks” about a whole number between 1 and 20.

The user has to guess the number. After the user types in the guess the computer tells if this was

bigger or smaller than the number it generated, or if was the same.

The game ends after just one guess.

Level 1

The user can guess several times. The game ends when the user guessed the right number.

Level 2

If the user hits ‘x’, we leave the game without guessing the number.

Level 3

If the user presses ‘s’, show the hidden value (cheat)

Level 4

Soon we’ll have a level in which the hidden value changes after each guess. In oredr to make that

mode easier to track and debug, first we would like to have a “debug mode”.

If the user presses ‘d’ the game gets into “debug mode”: the system starts to show the current

number to guess every time, just before asking the user for new input.

Pressing ‘d’ again turns off debug mode. (It is a toggle each press on “d” changes the value to to the

other possible value.)

Level 5

The ‘m’ button is another toggle. It is called ‘move mode’. When it is ‘on’, the hidden number

changes a little bit after every step (+/-2). Pressing ‘m’ again will turn this feature off.

Level 6

Let the user play several games.

Pressing ‘n’ will skip this game and start a new one. Generates a new number to guess.

Exercise: MasterMind

Implement the MasterMind game.

The computer “thinks” a number with 4 different digits.

You guess which digits. For every digit that matched both

in value, and in location the computer gives you a *. For every

digit that matches in value, but not in space the computer gives

you a +. Try to guess the given number in as few guesses as possible.

1 Computer: 2153

2 You: 2467 *

3 You: 2715 *++

Exercise: Count unique characters

Given a string on the command line, count how many differnt characters it has

Exercise: Check if number is prime

Write a program that gets a number on the commnad line a prints “True” if the number is a prime

number or “False” if it isn’t.

The Power of Open Source in the AI World

2023-07-08T19:08:00.001-07:00

Welcome to Ekasmin Consulting Inc. newsletter. In this edition, we explore the significant progress that open source has made recently and why many people are hoping it becomes the preferred choice in the AI community.

Open source has witnessed remarkable advancements that have caught the attention of various stakeholders. Here are some simple reasons why many people support open source models:

1. Developers who prefer not to rely solely on large corporations for their AI solutions.

2. Venture capitalists and AI infrastructure startups that benefit from a diverse range of AI models.

3. Founders and researchers who want to play a more prominent role in shaping the AI landscape.

4. Big tech companies without their own dominant platforms, who want to level the playing field in infrastructure spending.

5. Individuals who desire products that are free from governance or control, regardless of their intentions.

6. Advocates for politically unbiased AI products.

While there is strong demand for open source models, it remains uncertain if they will become the ultimate winners. It's important to approach discussions about open source software with respect, as it holds a special status within the community.

That being said, open source models make sense in specific situations:

1. Larger enterprises, driven by the desire for control and data privacy, may find on-premises open source models valuable. For example, in data warehousing, some companies prefer Databricks over Snowflake due to its data interoperability and flexibility.

2. Certain applications prioritize local processing speed over model quality, such as real-time speech-to-text. These applications can utilize open-source models locally to balance speed with accuracy.

However, when it comes to consumer-facing LLM apps and SaaS products, closed-source, well-maintained, and integrated solutions generally offer higher quality. Open source models are still catching up in terms of performance compared to cutting-edge closed-source models. As expectations for LLM reliability, robustness, and flexibility increase, it is expected that open source models will play a smaller role and capture less value in the market.

The evolution of open source in the AI world presents exciting opportunities and challenges. At Ekasmin.com, we remain committed to staying at the forefront of these developments and helping businesses navigate the ever-changing AI landscape.

Thank you for your continued support and engagement!

Ekasmin.com

We love to Digitalize organizations.

Get In Touch

Vancouver, Canada

+1-77-865-24-924

hello@Ekasmin.com

Is SEO dead with generative AI search?

2023-07-08T19:07:00.002-07:00

Future of Search Engine Optimization and SEO Agencies. A Shift from Keywords to Content Quality.

Newsletter by Ekasmin.com

Highlights from Google's IO Event: Unveiling the Accelerated AI Strategy

During Google's recent IO event, the tech giant showcased its accelerated AI strategy, incorporating artificial intelligence across all its products and services, including Google Search. This development has significant implications for businesses, as it has the potential to reshape the way we interact with search results.

Key Takeaways:

Traditional search results are being transformed by generative AI, providing users with comprehensive and accurate information in real-time.
Businesses relying heavily on search results may be greatly impacted by this shift.
Google AI Search offers users the ability to obtain desired information and clear instructions without sifting through numerous search results.
Adapting to the evolving landscape of AI-powered search is crucial for businesses reliant on Google search for visibility and traffic.
Focusing on creating high-quality content may become the key to gaining visibility on Google Search.
Microsoft's Bing search engine has also made significant progress in leveraging open AI technology.
Shopping-related searches have taken a leap forward, enabling users to receive tailored recommendations based on various factors.
Businesses dependent on search engine traffic must reassess their strategies and find alternative ways to maintain their online presence and generate organic traffic.
Google is a search engine and all it is bothered about is getting more search queries and clicks for ads. It doesn’t give a damn about how people get that information as long as they use Google. So in that respect they don’t give a damn about SEO specialists or SEO agencies. After all, it’s not down to Google to keep SEO specialist in a job.

The Future of SEO and Marketing (A Shift from Keywords to Content Quality.)

As we move forward, the fundamentals of marketing will become more crucial than ever. Being a problem solver and a great marketer with a focus on SEO will be essential for success. The days of strictly being an "SEO Specialist" are gone.

Conclusion: Navigating the AI Revolution in Search

Google's AI-powered search has the potential to revolutionize the way we access information. While it offers users a seamless and accurate search experience, businesses must be prepared to navigate the potential challenges associated with this transformation. Adapting to the changing landscape and finding innovative ways to remain competitive will be crucial.

Stay tuned for more updates on AI advancements for SEO in our next post. If you found this newsletter informative, please like and subscribe for future content.

Cheers!!

Ekasmin.com

We love to Digitalize organizations

Get In Touch

Vancouver, Canada

+1-77-865-24-924

hello@Ekasmin.com

AI Use Case: Training Models with HR Policies for Enhanced Efficiency and Data Privacy

2023-07-08T19:05:00.003-07:00

Welcome to the latest edition of our newsletter, where we explore exciting applications of AI in the business world. In this issue, we delve into the use of AI models in training and addressing data privacy concerns within organizations.

AI has revolutionized various industries, and one compelling use case is training language models like the LLM (Language Model) on vast amounts of data, such as HR policies. Imagine feeding a 500-page HR Policy to an AI model and utilizing its capabilities to answer questions and provide valuable insights.

Recently, we conducted an experiment with a non-OpenAI model, training it on just one page of an HR Policy for interviews. Surprisingly, the model demonstrated promising results, showcasing its potential to streamline HR processes and improve efficiency. By leveraging AI, organizations can benefit from automated responses, accurate information retrieval, and enhanced decision-making.

Moreover, one significant advantage of such models is their ability to address data privacy concerns. Enterprises often deal with sensitive employee information, and utilizing an AI model trained on internal policies can help maintain confidentiality and compliance. By keeping data within the organization's boundaries, potential privacy risks can be mitigated.

Now, let's open the floor to discussion. We would like to hear your thoughts on whether you would prefer such a model over ChatGPT in your organization. Do you believe it could enhance your HR operations and data privacy measures? Share your valuable insights and experiences with us using the hashtags #OpenAI #ChatGPT #AIforEnterprise #AIBusinessSolutions.

We look forward to your contributions and engaging in fruitful conversations.

Wishing you continued success in your AI endeavors!

Best regards,

https://www.Ekasmin.com

Connect chatGPT with Azure Function

2023-04-23T22:05:00.001-07:00

Assuming you have VSCode and Python running. Also active Azure subscription.

Create a Default Boilerplate function

1. Install Azure Functions Core Tools.

2. Install Azure Function Extension and do the login

3. Go to Azure extension and under Resources > Function App Right click to create a new azure function> give a name like "vinGPTAPI" > choose folder >

choose httptrigger and give a name like "triggerGPT", "Function" access.

4. Above will create boilerplate or azure default files in explorer under vinGPTAPI folder

only 2 files, init.py and requirement.txt are important

5. Now deploy the function in azure. Click deploy in workspace

choose your function name "vinGPTAPI" and other easy options like "East US" , resource group.

6. Now expand your function as shown and right click to copy execution url.

7. Paste it into browser and hit enter to see results.

INJECT CHATGPT code

Your default azure function is working properly. Now we will inject the chatGPT API code

only 2 files, init.py and requirement.txt are important and we will edit both.

1. In init.py add

import openai 

it will give error.

2. so add openai in requirement.txt

azure-functions
openai

3 use this code

import logging
import openai 
import azure.functions as func


def main(req: func.HttpRequest) -> func.HttpResponse:
    logging.info('Python HTTP trigger function processed a request.')
    #get params from http requesrt
    prompt = req.params.get('prompt')
    if not prompt:
        try:
            req_body = req.get_json()
        except ValueError:
            pass
        else:
            prompt = req_body.get('prompt')

    if prompt:
        secret_key = 'sk-2s1QbkZp4qgPsssdcsHxkgcOsyBT3BlbkFJBQp85bgeYsi6JxxFItVP'
        openai.api_key = secret_key
       
       
    
        # call caht GPT API
        response = openai.Completion.create(
        model='text-davinci-003',
        prompt=prompt,
        temperature=0.9,
        max_tokens=256,
        top_p=1,
        frequency_penalty=0,
        presence_penalty=0
        )
        #format the response
        answer = response['choices'][0]['text']
        return func.HttpResponse(f"Your answer, {answer}. ")
    else:
        return func.HttpResponse(
             "This HTTP triggered function executed successfully. 
Pass a name in the query string or in the request body for a personalized response.",
             status_code=200
        )

4. Deploy the code again

5. use url and pass the prompt = "any question for gpt" as parameter
-

Written By

Vinod Kotiya

Simple steps to connect chatGPT using openAPI key for python

2023-04-23T16:12:00.000-07:00

Assuming you have python in VScode running.

1. Install openAPI

> pip install openai

2. Get you openAPI key from personal > View API Key and create a new API Key

3. use it in test.py file as follows.

secret = 'sk-21QbkZp4qgPHxkgsdscOsyBT3BlbkFJBQp85bgeYsi6JxxFItVP'
query = 'who is vinod kotiya'
import openai
openai.api_key = secret

response = openai.Completion.create(
  model="text-davinci-003",
  prompt=query,
  temperature=0.7,
  max_tokens=256,
  top_p=1,
  frequency_penalty=0,
  presence_penalty=0
)
print(response)        

Create your own personal ChatGPT using GPT4All laura model

2023-04-23T14:28:00.001-07:00

Option1: Download and Install GIT

Create a folder GPT4All

Open GIT Bash and run these commands

$ git init

$ git remote add origin https://github.com/nomic-ai/gpt4all.git

$ git pull origin master

It will download the GIT repository.

Option2 (Easy one: Without GIT): Download the code in zip format from https://github.com/nomic-ai/gpt4all

Now download the LLaMa Model which is 4GB. Download the gpt4all-lora-quantized.bin file from Direct Link or [Torrent-Magnet].

Go to your GPT4All folder, navigate to chat, and place the downloaded file there.

run the executable to get prompt interface.

Getting started with M365 for your business

2022-12-29T12:13:00.003-08:00

1. Register and subscribe for M365 service.

2. Setup custom domain

5 verify it

6. set email

7. Sign out and religion to connect DNS

8. Done

written by:

Vinod Kotiya

Reflection OBHR

2022-08-07T18:43:00.004-07:00

Reflection Statement

Business Acumen for Technical Leaders :

Organizational Behavior & Human Resource Management

Vinod Kotiya

I would like to start with some important things which I learned in the class which is not only about Organizational Behavior but also Psychological Safety from Dr. Wayne Rawcliffe. I especially liked the comment that we understand the reality of the breakdown of the world. We only see a piece as a construct and think pieces as whole. Reality is complex so we make abstract models. Another thing is don't teach everyone to speak but create leaders to make an environment for others to be heard.

We started with learning a high performance team which includes diversity, EQ, motivations and conflict. Teams are a social system and there are no rules to govern the outcome. Here we learned the concept of 5 conditions:

Real Team: Groups are not teams. Teams are responsible for goals & stable over time.
Compelling Direction: Objectives and demonstration from leaders to achieve the goals.
Enabling structure: Job clarity, motivation, authority and feedback is required.
Supportive context: Reward and recognition. Not always monetary.
Coaching: Motivation at start but consultative and reflective towards end.

The new thing I learned was a topic: Psychology Safety and understood its importance. Normally all institutions and policies have stabilization factors and are very difficult to change. That's why change management comes into effect. Also Rules are for fools and not for high performing teams. Equality in conversation is required along with good listening. There are many interdisciplinary issues which we learned with the case study of Children's Hospital and Clinic.

I have reflected my own experience in this case study about the time in my career when I was empowered to speak up with the few factors which contributed for openness. These were Authority, Team formation, Making roadmap and policy formulation. With all such responsibilities I was comfortable to speak up about all the good ideas and issues comfortably. The work environment when I was assigned the responsibilities out of my domain and expertise prevented me from speaking up. I realize that the task is not important and it will not be affected by my contribution or idea so it is worthless to put any impact. Therefore In my professional life I have to take utmost care to know what my colleagues are thinking and to improve the things within the team environment.

Later we did an amazing simulation where I got the role of a product manager for a newly launched device GlucoGauge of a company Matterhorn. This exercise helped me to understand the cognitive biases in decision making. Initially, I examined the background information and available evidence provided by SVP of Marketing, and determined that the problems associated with inaccurate readings using the monitor were due to consumers misusing the device in the field. Here I learned about confirmation bias which was polarization of views based on information.

I found the user manual not adequate and very generic in nature. Initial report shows that testers were educated and tech savvy therefore the user manual should not be a problem to them. This issue was confirmed with another report that says user confidence increases to use the device after verbal instruction. So this was the area I identified to work upon. So I decided to go with the management allocated budget for consumer training only and not for training the doctors. Since doctors are educated enough to use the device, there was no point in working in that area. When this exercise failed I gave up to use further funds in this so I have not failed in the trap of sunk cost effect.

I was informed the Problem originated from a new strip supplied by the device. Microprocessor component was failing with the new strip but working fine with our old strip..I took immediate action and informed users to switch the brand of test strips. This caused financial impact including 400 employees layoff and here I tried to avoid the framing bias with not much emotionally affected to job loss thing..

When I was asked about the percentage of users getting wrong readings because of mobile app syncing. I kept it way less to 30% compared to 65% data from one doctor which was provided to me without falling into the trap of anchoring bias.

I also learned about status quo traps and overconfidence traps. I learned about some decision making tests to avoid mistakes like the publicity test, reversibility test which is putting myself at the receiving end of a decision. Generalizability test which is how it feels when someone else makes this decision for me. Also ladder of inference which is taking data and adding meaning to existing assumptions is required. Left hand tool is good to know the things which only I know.

I also felt that using such techniques for decision making with a cost where time bound decisions can not be made for a project. Therefore I have to look for a proper balance based on the outcome in my professional life. I will work more upon cognitive bias traps and try to implement them in my decision making. I think this understanding will also be useful in my professional life. I am also working in a startup under e@UBC and I would like to apply these learnings on crucial decisions which I have to make for growth in a couple of months and setting up my team. Overall It was great learning in a short span of time.

References

AMY EDMONDSON, MICHAEL A. ROBERTO, & ANITA TUCKER. (2001, January). Children's Hospital and Clinics. Harvard Business School Publishing.

Duhigg, C. (2016, February 25). What Google Learned From Its Quest to Build the Perfect Team (Published 2016). The New York Times. Retrieved August 7, 2022, from https://www.nytimes.com/2016/02/28/magazine/what-google-learned-from-its-quest-to-build-the-perfect-team.html

LLVM Running your first pass simplified.

2022-06-07T12:12:00.002-07:00

After so much of struggle of many hours finally I found some step guide which can be useful for writing the pass successfully. I hope it will save your time. Dont know why no one make this simple for novice. I assume your llvm build environment is ready and installed with llvm, cmake and ninja. I dont want to mix it up here to make this more complex.

Step1: Create a directory to host your LLVM pass

mkdir ~/llvm-project/llvm/lib/Transforms/test

Step2: Update the CMake file in the Transforms directory

~/llvm/llvm/lib/Transforms/CMakeLists.txt

vim CMakeLists.txt

Add this line add_subdirectory(test)

Now goto your folder test

cd test

Now we will work inside test folder.

Step3 Create a CMake file for your LLVM pass

vim CMakeLists.txt

Add the following to the CMakeLists.txt file

add_llvm_library(LLVMtest MODULE test.cpp

PLUGIN_TOOL opt )

**Step4 **create CPP file for your LLVM pass

vim test.cpp

with following code

#include "llvm/Pass.h"
#include "llvm/IR/Function.h"
#include "llvm/Support/raw_ostream.h"

#include "llvm/IR/LegacyPassManager.h"
#include "llvm/Transforms/IPO/PassManagerBuilder.h"

using namespace llvm;

namespace {
struct test : public FunctionPass {
  static char ID;
  test() : FunctionPass(ID) {}

  bool runOnFunction(Function &F) override {
    errs() << "Hello: ";
    errs().write_escaped(F.getName()) << '\n';
    return false;
  }
}; // end of struct Hello
}  // end of anonymous namespace

char test::ID = 0;
static RegisterPass<test> X("test", "Hello World Pass",
                             false /* Only looks at CFG */,
                             false /* Analysis Pass */);

static RegisterStandardPasses Y(
    PassManagerBuilder::EP_EarlyAsPossible,
    [](const PassManagerBuilder &Builder,
       legacy::PassManagerBase &PM) { PM.add(new test()); });

Step5: Generate the IR file clang++ -O0 -g -S -emit-llvm -o test.ll -c test.cpp

Step6: Now we will move to build folder

cd ~/llvm-project/build

(There is some problem in CMakeCache.txt regarding user name. Find and replace cpen400 with cpen)

vim CMakeCache.txt

:s/cpen400/cpen/g :wr and quit

Step7: Now run the cmake with path as .. will not work

~/llvm-project/build$ cmake ../llvm/lib/Transforms/test

Step8: Now run Ninja

~/llvm-project/build$ninja -j4

Step9: Now it will build full llvm project in 2 hours. Wait for it and move to lib directory to check .so file.

cd lib
ls -l

Step 10: Now to test this pass create a dummy program hello.c in your test directory:

void a(){
  int c = 5;
}

int main()
{
  int d = 1;
  a();
  return 5;
}

Step 11: Now create the IR file using

clang++ -O0 -g -S -emit-llvm -o fun.ll -c fun.c

Step12: Go back to ~/llvm-project/build directory and load the pass using "opt"

cd..
opt -enable-new-pm=0 -load lib/LLVMtest.so -test < ../llvm/lib/Transforms/test/fun.ll > /dev/null

You may see output like

Hello: _Z1av

Hello: main

Written By

Vinod Kotiya

Create a Google cloud Instance from Ubuntu .ova virtual box file

2022-06-06T09:43:00.004-07:00

Steps to create a GCC Instance from .ova file

Step1: Use this command to upload the 9GB .ova file in a bucket. Its fast than browser.

gsutil cp "C:\Users\91965\Downloads\ubuntu18_cpen.ova" gs://ubuntuvof

Step2: Go to Google cloud console. Open Compute Engine > Images and create a new image with source as virtual disk (VMDK,VHD) . It will ask for bucket path where .ova is stored.

Image creation will take 40-50 Minutes.

Step3: Click on Image name and you will see a create instance button at top. Click on it and choose your compute engine configuration. Now your instance will be ready to be connected through ssh.

(Optional) You may need to create ssh key on windows machine command prompt.

ssh-keygen -t rsa -f C:\Users\YOUR USER NAME\.ssh\id_rsa.pub -C UBUNTU_USER_NAME -b 2048

Step4: Open putty and put external ip address to get connected on terminal.

Written By:

Vinod Kotiya

Bash Script to Run multiple jar simultaneously on Ubuntu

2022-02-28T19:36:00.001-08:00

I used the following script to run multiple nodes on single instances. Basically, this script runs the same jar file using for loop on a different port as a parameter.

The below code loop through port number 8001 to 8020

#!/bin/bash
echo "welcome"
ls
echo "this is the whole list of dir"
cd server
echo "entered server folder where jar files are kept"
for i in {8001..8020}
do
java -Xmx64m -Xms64m -jar A6.jar nodes-list.txt $i &
echo "running $i A6.jar"
done

save it as A6.sh

Now to run this use double dots . ./a6.sh

ubuntu@ip-172-31-27-28:~$ . ./a6.sh

This will start all jar instances parallel because & is used in for loop.

Hope this will help.

AWS EC2 Instance Step Guide and deploying JAR on server

2022-01-27T16:32:00.003-08:00

Creating EC2 Instance

Configure your billing alerts first. Take help of any youtube video.

In AWS create free tier EC2 instance of ubuntu with default settings.

Connecting with Instance:

In my case default web console was not launching so i configured the putty as follows:

need to download both puttygen.exe and putty.exe.

The key file you download from the AWS console will be a .pem file. Since putty uses .ppk file extensions for authentication, you need puttygen to convert the .pem file to .ppk format. Do not click generate a key or any other buttons. Just load the pem file and click the save the private key button.

Make Connection
Eg: “ec4-50-18-15.compute-1.amazonaws.com” or if you have given an elastic IP for your instance, then you should enter that elastic IP in the host field.

Now go to connection–>data and type in the user name. which is ubuntu

Now got to SSH–>Auth click on Auth and load the .ppk file you generated using puttygen.

Configure Instance

Once connected with EC2 instance Making ubuntu ready for Java

sudo su
sudo apt update
sudo apt install openjdk-8-jdk openjdk-8-jre

It will install java 8

Deploy JAR

Now create a folder to download the jar and run it.

root@ip:/home/ubuntu# mkdir server
root@ip:/home/ubuntu# chmod 777 server
root@ip:/home/ubuntu# cd server
root@ip:/home/ubuntu/server# wget https://filebin.net/yourjarfile.jar

filebin.net is good to transfer jar files

run your server
root@ip:jaba -jar yourjarfile.jar

Network Setting to access port of server.

Go to AWS EC2 instance
Go to Security and click on security group
Edit inbound rule
Create a new rule custom TCP with your port like 8002 and 0.0.0.0

Now you can access the server from any client

Hope this will help and save your time.

Install Ubuntu LAMP (Linux Apache, Mysql Perl) Server on Windows Server using Hyper-V

2021-08-25T05:45:00.011-07:00

Install Ubuntu LAMP (Linux Apache, Mysql Perl) Server Windows Server on Hyper-V Easily

Download the LAMP ISO http://releases.ubuntu.com/16.04/

Activate Hyper-V

Activate Hyper-V in Windows server roles

Create Virtual Machine

You can get your copy of Ubuntu 18.04 official installation media from here, if you want the desktop edition. Once the download is finished open Hyper-V manager (you can search for it from the start menu).

The first thing you will notice is that your host system will show up in the menu under Hyper-V Manager (in my case, the name is set to linux LAMP).

Now on the right hand column you can see an option to which say New. Click on it and select Virtual Machine… from here on it is a simple setup wizard which most PC users are familiar with.

Since we will not be using the Default options, let’s click on Next. Now give your VM a name and the location where you want to store it (we will let it stay at it’s default value) and click Next.

Next we have to select whether the machine is of Generation 1 or 2. Selecting Generation 1 will cover the widest possible use cases, so let’s stick to that.

For memory, we can go with 2048MB. If you have a larger RAM, consider allocating more memory.

The next step is to configure networking, you get two options, Not Connected and Default Switch. Because we intend on running updates, and downloading new packages, we will go with the Default Switch option and click on Next.

For those who are interested, the Default Switch offers your VM internet connectivity by using the host connection via NAT.

The next step is to connect a virtual hard disk. Here, the default values would work just fine. Although Ubuntu desktop can run on disks as small as 25GB.

The last step is to connect the installation media (the Ubuntu .iso file that we downloaded earlier). Select the option which says “Install an operating system from a bootable CD/DVD-ROM” and then select the Image file suboption, and using the browse option locate the .iso file for Ubuntu installation in your filesystem.

Click next to review your configurations one last time and then Finish to finalize your settings.

Starting and Accessing Your VM

You can now see the newly created VM called Ubuntu in the list of VMs.

Simply right-click on it and select the Start option to start the VM. You will notice that the Hyper-V manager would start showing up the VM’s resource utilization (CPU and memory usage). But no Window would pop up showing the Ubuntu live CD booting.

The first screen you'll see (Figure A), asks you what language you want to use for the installation (not the server itself). Use your arrow keys to select the correct language and hit Enter on your keyboard.

Figure A

Selecting the installation language.

In the next screen you'll be asked to select what you want to do with the installer, run some tests, boot from the hard disk, or rescue a broken system. Using your arrow keys, select Install Ubuntu Server and hit the Enter key on your keyboard.

The next few screens are as follows:

Select the language to be used on the server
Select your location
Detect keyboard layout (Yes/No)
Select the country of origin for your keyboard
Select the layout matching your keyboard

Once beyond these screens, the installer will load additional components (Figure B).

Figure B

Getting ready for the important bits of the installation.

In the following screen (Figure C), you must set the hostname for the server. If the server will use a Fully Qualified Domain Name (FQDN), enter that. If the server is on a LAN-only network (or will be used for testing purposes), you can make up whatever need here.

Figure C

Setting the hostname for your server.

In the next five screens, you must set up a user account. The options are:

Enter the full name for your user account
Enter a username for the account
Enter a password for the user
Verify the password for the user
Encrypt the user's home directory (Yes/No)

Now we configure the clock. The installer (for whatever reason) almost always defaults to America/New York. If that's not your location, tab down until No is selected and hit Enter. You can then select your proper time zone.

We finally come to the disk partitioning. Unless you have any special needs, select Guided - use entire disk (Figure D), and hit Enter.

Figure D

Selecting the partitioning method for our installation.

In the next screen you'll select the disk to be partitioned. If you have more than one disk on the server, make sure to select the correct disk (chances are it will be labeled sda - Figure E) and hit Enter.

Figure E

Installing Ubuntu Server as a VM on VirtualBox makes disk selection easy.

You will now be presented with the partition information and asked if you want to write changes to the disk. Tab down to Yes and hit Enter on your keyboard.

After the partitions have been written, you'll be presented with the option to configure a proxy server. If you don't need to use a proxy, leave this blank and tab down to Continue (Figure F).

Figure F

The optional proxy server configuration.

Next the installation will ask how you want to handle updates. You have the following options to select from:

No automatic updates
Install security updates automatically
Manage system with Landscape

I recommend selecting No automatic updates. If you go this route, know that you will have to manually run regular updates.

Finally, we get to select our software. Since we're setting up a LAMP server, you'll want to use the arrow keys to select LAMP server (Figure G) and then hit the Spacebar on your keyboard (to select the option). I would also suggest adding OpenSSH server, so you can remote into the machine for admin purposes.

Figure G

Selecting the software to be included on the server.

During the LAMP installation, you will be prompted to set a MySQL root user password. Do that (and then verify the password) and then the installation may seem to stall out. Wait for it as it detects where to install the GRUB bootloader. You will then be presented with the options for GRUB. If you only have one disk in the server, you can just tab down to Yes and hit Enter. If you have more than one disk, you'll want to make sure to select the correct disk (most likely it will be labeled sda).

And that's it. You will now be prompted to hit Enter to reboot the server. You can then log in with the user account you created during the installation and start using your new LAMP server.

Temp IP Address Schema

Ensure to create a Virtual Network Switch with External in Hyper-V

Change IP Address

Suppose your host windows server is 10.1.168.1

Your virtual external switch address will be 10.1.168.2

Assign IP 10.1.168.6 to ubuntu VM

sudo ifconfig eth0 10.1.168.6 netmask 255.255.255.0

Assign Gateway

sudo route add default gw 10.1.168.17 eth0

Start Apache Web Server

For Ubuntu users with versions 16.04 and 18.04 and Debian 9.x users, use the following commands in the terminal window to start Apache:

sudo systemctl start apache2

Check status to see whether Apache is enabled with the command:

sudo systemctl status apache2

Confirm on web browser HTTP://10.1.168.6:80 if site is up or not

Updating Linux package via proxy:

To update the Linux

sudo vi /etc/apt/apt.conf

Put your proxy setting. If no username then leaves it blank.

Acquire::http::Proxy "http://username:password@proxyhost:port/";
Acquire::https::Proxy "https://username:password@proxyhost:port/";
Acquire::ftp::Proxy "ftp://username:password@proxyhost:port/";
In my case is used following:
Acquire::http::Proxy "http://:@proxyhost:port/";   //for no id password

Now update and installation will work

sudo apt-get update

Permanent IP Address Schema

Create new file /etc/systemd/network/eth0.network. Name is not importent, just the prefix network. Here eth0 is my network interface.

[Match]

# You can also use wildcards. Maybe you want enable dhcp

# an all eth* NICs

Name=eth0

[Network]

#DHCP=v4

# static IP

# 10.1.169.6 netmask 255.255.255.0

Address=10.1.169.6/24

Gateway=10.1.169.17

DNS=10.0.12.8

Move your previously used /etc/network/interfaces to /etc/network/interfaces.save. The file is no longer needed (for eth0). If some other NICs defined there leave it and just remove all entries regarding to eth0.

1	`root@debdeb:~# mv /etc/network/interfaces /etc/network/interfaces.save`

and enable systemd-networkd unit

1	`root@debdeb:~# systemctl enable systemd-networkd.service`

(OPTIONAL) Define DNS Server. You can add the DNS Server either in the Network section of the NIC adapter config (see above) or in /etc/systemd/resolved.conf
Create a symlink

root@debdeb:~# mv /etc/resolv.conf /etc/resolv.conf.save
root@debdeb:~# ln -sf /run/systemd/resolve/resolv.conf /etc/resolv.conf

and enable systemd resolver

1	`root@debdeb:~# systemctl enable systemd-resolved.service`

Configuring SSH

Type sudo apt-get install openssh-server
Enable the ssh service by typing sudo systemctl enable ssh
Start the ssh service by typing sudo systemctl start ssh
Test it by login into the system using ssh user@server-name

Now connect via Putty form anywhere in the network to work on Linux Server.

MYSQL Troubleshoot:

Some 2002 socket error

sudo /etc/init.d/mysql stop

apt-get remove --purge mysql\*

Then install it again:

apt-get install mysql-server mysql-client

mysql -h 127.0.0.1 -u root -p

- Vinod Kotiya

GIT HUB quick guide

2021-04-04T22:58:00.005-07:00

git architecture

Staging area means files under tracking ready for commit. (will show in green text)

Download the git with gitbash

Right click and Open gitbash on any working directory.

Basic Commands:

git status

To check the status of pwd

git clone url_from_git_hub_clone

It will download the project.

git init

create the git repository. .git folder will be created under pwd.

git add --a or git add .

will add all files in staging area. To ignore file and folder create touch .gitignore

git commit -m "first commit"

It will commit all the staged file

git commit -a -m "Direct commit of tracked file without staging"

It will ignore any untracked new file in working directory and commit the tracked file.

(good to ignore out or bin folder created later after first track)

git rm --cached foldername

remove tracking of file or folder. Good for out or bin folder

git restore --staged filename

To remove from staged(green to red) but still tracking.

git checkout -- filename

Restore the changes as per last commit. You will lost current changes in working file.

git checkout -- f

Restore working directory with last commit.

Branching: Make new branch (i.e. your version of code):

git checkout -b branchname

Show branches

git branch

make the changes

git add .

git commit -m "changes in devbranch"

branch switching (Always switch branch after commit)

git checkout existingbranchname

It will switch branch to master.

git checkout master

To merge branch with master. Run following in master and commit.

git merge branchname

git branch --merged

git branch --no-merged

git branch -v

After merging branches can be deleted

git branch -d branchname

Deleting remote branch

git push -d origin branchname



merge idea branch (c12) to master and get c13.

 Now merge issue2 branch(c11) to master and get c14

Remote

Add your remote repository as origin

git remote add origin https://github.com/vinodkotiya/bifpcl.git

Where to fetch and push

git remote -v

To push all changes in master branch to remote origin

git push -u origin master

To push all branch to origin

git push origin

Generate SSH Key

$ ssh-keygen -t rsa -b 4096 -C "your_email@example.com"

Run SSH agent

$ eval `ssh-agent -s`

Tell agent your key

$ ssh-add ~/.ssh/id_rsa

See SSH Key and copy it

$ tail ~/.ssh/id_rsa.pub

Go to Settings > SSH key in GITHub and paste the above key.

After making any changes locally

git add .

git commit -m "changes and pushing to github"

git push -u origin master

Create and push branchname in remote origin

git push origin branchname

How to merge remote to local
git pull https://github.com/vinodkotiya/bifpcl.git
Pull = Fetch + Merge  fetch remote repository and merge with local

Other useful commands

git log

see the change log. for changes see log -p , log --stat, log --pretty=oneline , =short, =full, --since=2.days

git diff

To see the changes in stagged file and working directory file

git diff --stagged

to compare staging area with last commit.

git rm filename

delete the file and staged

git mv file1 file2

rename and staged

rm -rf .git

delete the git repository

Fork

Fork is GITHUB feature.

You found someone's repo on github. Simply click fork to add it as your remote repo. Clone it locally and work.

What to do if Original Repo changed and you want to sync.

Fetch + Merge can be done in single step Pull.

git remote add upstream url_of_original_repo

git remote -v

Now fetch original repo. It will create new branch called upstream/master

git fetch upstream

Now merge new branch with master

git merge upstream/master

Pull process done. Now push your local changes to your forked version to sync.

git push origin master

What to do if you want to Merge fork Repo to Original one.

You have to create Pull request for original repo owner. Basically owner will fetch your repo as branch. Test it and if found ok then merge with his repo to complete the pull request.

Example

Fork UBCRocket code.

It will add as vinodkotiya/UBCRocket

Now start git bash

git clone https://github.com/vinodkotiya/ubcrocket.git

It will download all data on local machine.

Go to folder

cd ubc*

Edit any file.

touch index.html

Now

git add .

Commit

git commit "page updated"

Push to the forked repository. It will update your version of the forked repository.

git push origin

Click on the new pull request from your git account. Write why you are requesting for pull.

- Written By

Vinod Kotiya

Giving Remote Access on Google Meet to Students Easily

2020-10-31T21:00:00.003-07:00

How to give remote access to your students?

It covers how to give remote control of your computer and mouse to someone else in a Google Meet, or take remote control of their computer and mouse, for a teletherapy session or technology support or such.

Please follow the steps given

Presenter/ Teachers End

1. Install Chrome remote desktop extension https://chrome.google.com/webstore/detail/chrome-remote-desktop/inomeogfingihgjfjlpeplalcfajhgai?hl=en

After installation open https://remotedesktop.google.com/support

2. Now Generate code

2. Send the remote desktop link to student on chat in following format

https://remotedesktop.google.com/support/session/XXX

where XXX is 12 digit unique code

Eg. https://remotedesktop.google.com/support/session/441192092969

(This is what you will be sending to student on chat screen)

Audience/Students End

3. When a student click the link it will ask him to connect your screen will be asked for permission.

-Written By Vinod Kotiya

Automate birthday wish email from Gmail using Google Sheet and GSrcipt

2020-05-16T02:19:00.000-07:00

Automate Bday Wish using gmail

Problem domain: In organisation people have to manually check the birthday from calendar to wish the concern.
A good solution is to set up an automated mailer for the wishes to send by email to your colleagues with CC to HR.

Same automation concept can be utilized in other problem domain.

Let’s Start :

Step 1: Create a new google sheet and save DOB, name, and email of your team/organization/Friends, etc
Choose Drive →Select New →Select Google Sheet
[[If you don't have these details then you can collect it using google form. To create a form, follow these steps:
Choose Drive →Select New →Select more →Select Google Forms]]

Finally you will have a excel sheet which may looks like this.

Copy the url upto slash to use in Google Script.

Step 2: Now create an app script, that sends the email to the birthday person.
Choose Drive →Select More →Select Google Apps Script

Step 3: Now create the script as shown. Source code you can copy.

Here is the source code to copy:
function sendBdayWishes(){
var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/16fbf4eQrFQ4CbMPZVLF-Qk_IZspP2-ex2z1YW0/"); // Sheet Url must have slash at end
var sheet = ss.getSheetByName("Sheet1");// Make Sure Sheet name matches at the bottom
var cDate = new Date(); //Present Day,
for(var i =2 ;i<=sheet.getLastRow(); i++){
//loop through each row
var bDate = sheet.getRange(i,2).getValue(); // get Date from SpreadSheet 2nd column
//now check if any date is matching
if(cDate.getDate()==bDate.getDate()){
if(cDate.getMonth()==bDate.getMonth()){
var name = sheet.getRange(i,1).getValue();

var toMail= sheet.getRange(i,3).getValue() + "," + "vinodkotiya@gmail.com" ; // get email from SpreadSheet 3rd column
var htmlBody = "Dear " + name + "
We wish you an amazing year that ends with accomplishing all the great goals that you have set! No one could do a better job than the job you do. We thank you for all your efforts!

Enjoy your birthday! Cheers! 

-Team BIFPCL" ;
MailApp.sendEmail(toMail,'Happy BirthDay '+name,' ' ,{htmlBody : htmlBody});// send to myself to test
sheet.getRange(i,4).setValue("Bday wishes sent");
}
}
}

}

There is a play button to test the script and remove any errors.
Suggestion: To test the app give a date of birth as present day of testing for your name.

Step 4: Give the Authorization to run the Script
The first time you run it, Google requires you to authorize it. An “Authorization required” window will pop up asking for your permission. Select “Review Permissions.”
It will then ask for a Gmail account. Click on your account name and click “Allow”.
It will run the script and send on an email on the specified date. Now we can automate this process by trigger.

Step 5: Now create the trigger to automate the process.
Click on the Clock button in the App Script code →Click on + Add Trigger
A new window will open. Add a new trigger like this which will run on daily basis at midnight once.

That's it. It will automatically send bday wish to concerned person at 1 AM after triggering daily.

-Written by
Vinod Kotiya

MIT App Inventor with SQLite Database Android App Development for Novice

2020-03-08T22:16:00.002-07:00

I found tinyDB not solved my purpose so I wanted a small relational database like SQLite in MIT App Inventor. MIT AI is great tool to create android app very easily. You can have your own account at http://ai2.appinventor.mit.edu/

You can download SQLite extension for MIT AI from my github page https://github.com/vinodkotiya/aix-SQLite

Installation
Installation may depend on which App Inventor flavor you're using, but I think they're all pretty similar.

Open the "Designer" tab of your application.
At the bottom of the Palette on the left side, open the "Extensions" category.
Click the "Import extension" link.
Select the aix file you downloaded above and click the "Import" button.
Wait a few seconds and you should see a message saying the extension was imported. You should also see a SQLite extension appear in the "Extensions" category.
Drag the SQLite extension into your app and carry on!

Working example is available in Example folder of GITHub.

After adding the extension upload your csv data as insert1.csv in files section.

Now write initialise code. When database doesnot exist on first load database is opened and table is created with importing of insert1.csv. Later on this code will not be executed.

Here is code to see any SQL error using notifier. and search query in a button code.

Source code available at https://github.com/vinodkotiya/aix-SQLite

Written By
Vinod Kotiya

Pull data from Biometric Machine with face and finger recognition to Process and Upload

2020-01-30T04:33:00.001-08:00

Pull data from Biometric Machine to Process and Upload

Here is the code to pull data from multiple biometric machines having face and finger recognition through tcp/ip using same port.

1. Connect with Machines,,
2. Get data and save into Datatable
3. Load csv file havind mapping of Biometric ID with Employee ID
4. Sort the datatable to Process the Data and mark In punch and Out punch in required format.
5. Finally generate the CSV File
6. Alternatively same data can be uploaded directly to HRMS Server database.

Prerequisite:
VB.Net
zkemkeeper.dll
My machines with different brands worked with above dll.
Here is the code

Private Sub btnGo_Click(sender As Object, e As EventArgs) Handles btnGo.Click
        '  Try
        '' Load Bio ID from CSV file
        Dim bio As New Dictionary(Of String, String)
            Try
                Dim sr As New StreamReader("C:\bio\eid.csv")

                Do While sr.Peek <> -1
                    Dim linearray As String() = sr.ReadLine().Split(",")
                    If linearray.Length = 2 Then
                        bio.Add(linearray(0), linearray(1))
                    End If
                Loop
                ''
                '' to get emp no give id like bio("bio id")
                ''
            Catch ex1 As Exception
                MsgBox("Error reading employee number from eid.csv")
                Return
            End Try
            Dim idwErrorCode As Integer
            Dim sdwEnrollNumber As String = ""
            Dim idwVerifyMode As Integer
            Dim idwInOutMode As Integer
            Dim idwYear As Integer
            Dim idwMonth As Integer
            Dim idwDay As Integer
            Dim idwHour As Integer
            Dim idwMinute As Integer
            Dim idwSecond As Integer
        Dim idwWorkcode As Integer
        Dim attDate() As String = txtDate.Text.Split(".")

        Cursor = Cursors.WaitCursor
            If btnConnect.Text = "Disconnect" Then
                axCZKEM1.Disconnect()
                bIsConnected = False
                btnConnect.Text = "Connect"
                lblState.Text = "Current State:Disconnected"
                Cursor = Cursors.Default
                Return
            End If
        Dim finalDT As New System.Data.DataTable()
        finalDT.Columns.Add("bioid", GetType(Int32))
        finalDT.Columns.Add("pdate", GetType(Int32))
        finalDT.Columns.Add("ptime", GetType(Int32))
        finalDT.Columns.Add("eid", GetType(String))
        finalDT.Columns.Add("adate", GetType(String))
        finalDT.Columns.Add("flag", GetType(String))
        finalDT.Columns.Add("atime", GetType(String))
        '   Dim machine() As String = {"10.8.215.4", "10.8.215.5", "192.168.1.201"}
        Dim machine() As String = txtIPs.Text.Split(",")
        For m As Integer = 0 To machine.Length - 1
            '' Connect to machine one by one
            bIsConnected = axCZKEM1.Connect_Net(machine(m).Trim(), Convert.ToInt32(txtPorts.Text.Trim()))
            If bIsConnected = True Then
                btnConnect.Text = "Disconnect"
                btnConnect.Refresh()
                lblState.Text = "Current State:Connected"
                iMachineNumber = 1 'In fact,when you are using the tcp/ip communication,this parameter will be ignored,that is any integer will all right.Here we use 1.
                axCZKEM1.RegEvent(iMachineNumber, 65535) 'Here you can register the realtime events that you want to be triggered(the parameters 65535 means registering all)
            Else
                axCZKEM1.GetLastError(idwErrorCode)
                MsgBox("Unable to connect the first device,ErrorCode=" & idwErrorCode, MsgBoxStyle.Exclamation, "Error")
                '  Return
            End If
            Cursor = Cursors.Default
            ''' Now download data and process
            Dim iGLCount = 0

            Cursor = Cursors.WaitCursor
            axCZKEM1.EnableDevice(iMachineNumber, False) 'disable the device
            If axCZKEM1.ReadGeneralLogData(iMachineNumber) Then 'read all the attendance records to the memory
                'get records from the memory
                While axCZKEM1.SSR_GetGeneralLogData(iMachineNumber, sdwEnrollNumber, idwVerifyMode, idwInOutMode, idwYear, idwMonth, idwDay, idwHour, idwMinute, idwSecond, idwWorkcode)
                    iGLCount  = 1
                    Dim bioid As String = sdwEnrollNumber.ToString()
                    Dim pDate = idwYear.ToString() & idwMonth.ToString().PadLeft(2, "0") & idwDay.ToString().PadLeft(2, "0")
                    Dim ptime = idwHour.ToString().PadLeft(2, "0") & idwMinute.ToString().PadLeft(2, "0")
                    Dim aDate = idwDay.ToString().PadLeft(2, "0") & "/" & idwMonth.ToString().PadLeft(2, "0") & "/" & idwYear.ToString()
                    Dim atime = idwHour.ToString().PadLeft(2, "0") & ":" & idwMinute.ToString().PadLeft(2, "0")
                    '' only add records where date is more than dd.mm.yyyy
                    If idwDay >= attDate(0) And idwMonth = attDate(1) And idwYear = attDate(2) Then
                        finalDT.Rows.Add(bioid, pDate, ptime, "0", aDate, "I", atime)
                    End If
                End While
                ''' data recieved from first machine now disconnect
                axCZKEM1.Disconnect()
                bIsConnected = False
                btnConnect.Text = "Connect"
                lblState.Text = "Current State:Disconnected"
                Cursor = Cursors.Default
            Else
                Cursor = Cursors.Default
                axCZKEM1.GetLastError(idwErrorCode)
                If idwErrorCode <> 0 Then
                    MsgBox("Reading data from terminal failed,ErrorCode: " & idwErrorCode, MsgBoxStyle.Exclamation, "Error")
                Else
                    MsgBox("No data from terminal returns!", MsgBoxStyle.Exclamation, "Error")
                End If
            End If
            '' now connect second machine
            axCZKEM1.EnableDevice(iMachineNumber, True) 'enable the device
            Cursor = Cursors.Default
        Next
        '' Now merge both data
        'finalDT.Merge(finalDT1)
        finalDT.DefaultView.Sort = " bioid, pdate, ptime ASC"
        'Dim dtView = finalDT.DefaultView
        'dtView.Sort = " eid, pdate, ptime ASC"
        'Dim finalDT1 = dtView
        Dim bioidnotFound = ""
        finalDT = finalDT.DefaultView.ToTable
            Dim bioidLast = "0"
            Dim pdateLast = 0
            Dim ptimelast = 0
            For Each r As DataRow In finalDT.Rows
                If bioidLast = r(0) And pdateLast = r(1) Then
                    r(5) = "O"
                Else
                    r(5) = "I" '& eidLast & " " & pdateLast
                End If
            ''find emp id
            Try
                r(3) = bio(r(0).ToString)
            Catch ex As Exception
                r(3) = r(0).ToString
                bioidnotFound = bioidnotFound & r(0).ToString & ", "
            End Try
            bioidLast = r(0)
                pdateLast = r(1)
                ptimelast = r(2)
            Next
        DataGridView1.DataSource = finalDT
        'Dim max As DateTime = finalDT.Select("pDate='2019-01-21'").AsEnumerable().Min(Function(r) r.Field(Of DateTime)("pTime"))
        'txtIP.Text = max.ToString
        ' DataGridView1.DataBindings
        ''' Now write to CSV File
        ''' 
        'Build the CSV file data as a Comma separated string.
        Dim csv As String = String.Empty

        'Add the Header row for CSV file.
        'For Each column As DataColumn In finalDT.Columns
        '    csv  = column.ColumnName & ","c
        'Next

        'Add new line.
        '  csv  = vbCr & vbLf

        'Adding the Rows
        Dim lastrecord = ""
        For Each row As DataRow In finalDT.Rows
            Dim j = 0
            If row(3).ToString.StartsWith("E") Then
                Dim newrecord = ""
                For Each cell As String In row.ItemArray
                    'Add the Data rows.
                    If j > 2 And j < finalDT.Columns.Count - 1 Then
                        newrecord = newrecord   cell.ToString().Replace(",", ";") & ","
                    ElseIf j > 2 Then
                        newrecord = newrecord   cell.ToString().Replace(",", ";")
                    End If
                    j = j   1
                Next
                'Add new line. don't add duplicate rows
                If newrecord <> lastrecord Then csv = csv & newrecord & vbCr & vbLf
                lastrecord = newrecord
            End If
        Next

        'Exporting to Excel
        Dim folderPath As String = "C:\bio\"
            If Not System.IO.Directory.Exists(folderPath) Then
                Directory.CreateDirectory(folderPath)
            End If
            File.WriteAllText(folderPath & "Attendence.csv", csv)

        lbLog.Text = "CSV Generated BioID not Found " & bioidnotFound
        ''' CSV File created.
        '''  Now try to push data to remote SQL server
        '''  
        Dim constring = ""

        'Catch ex As Exception
        '    Dim trace As System.Diagnostics.StackTrace = New System.Diagnostics.StackTrace(ex, True)
        '    MsgBox(trace.GetFrame(0).GetFileLineNumber() & ex.Message)


        'End Try

    End Sub

Final Output in CSV Format
Emp No , Date, Flag(In/Out), time
ENI09283,15/01/2020,I,9:12
ENI09283,15/01/2020,O,18:52
ENI09283,16/01/2020,I,08:53
ENI09283,16/01/2020,O,18:32

Written By Vinod Kotiya