XPath code Generator – Web Tools

Background

Wanted to quickly review freely available online tools for generating Xpath from XML documents.

Sample XML Documents

Will use these XML documents as samples :-

  1. Microsoft
    • Docs. / NET / C# Guide / Programming guide / Programming concepts / LINQ
      • Sample XML File: Customers and Orders in a Namespace
        Link

 

Tools

  1. Xmltoolbox
    • XPath Generator
  2. Qutoric
  3. XPather.com

 

In depth

Xmltoolbox

XPath Generator

Author

Xmltoolbox is authored by Ole Bille.

Usage

Outline
  1. Launch web browser
  2. And, go here ( http://xmltoolbox.appspot.com/xpath_generator.html )
  3. Paste the XML text into the canvas
  4. In the loaded canvas, click on the elements you want evaluated
  5. Please review and capture the generated Xpath results

 

Screenshots

xpathgenerator.20181217.0344AM

qutoric

PathEnq

Usage

Outline
  1. Launch web browser
  2. And, go here ( http://www.qutoric.com/xslt/analyser/xpathtool.html )
  3. Invoke the Choose File button at the bottom of the screen
  4. Select the file to be evaluated
  5. In the loaded canvas, click on the elements you want evaluated

 

Screen Shots

xmlSource.20181217.0319AM

xmlSource.20181217.0322AM

 

XPather.com

Author’s Guideline

  1. This web app enables you to query XML/HTML documents with your browser in real time. It can generate queries for you too!
    • You can enter your xpath query in the top-left panel and it will be instantly executed against this document.
    • To generate an xpath query for a specific element, please hold CTRL and hover over it. An xpath is generated.

Usage

To generate an XPath, please paste the XML into the canvas.

Once the XML is available and accessible, please move your cursor to the screen area, hold down the Ctrl button while hovering or selecting the XML tag or body.

Samples

Sample #1

xpather.com.20181217.0308AM

Deficiency

  1. Supports Element, but not attribute

 

 

 

 

 

Visual Studio – Error – “Could not load file or assembly ‘netstandard, Version=2.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51’ or one of its dependencies.”

Background

Upon preparing Visual Studio to be able to develop mobile applications courtesy of Xamarin, ran into a blocking issue right away.

Set the Stage

Setting the stage for our error is easy  and it goes :-

  1. Launch Visual Studio
  2. Elected to design new Project
  3. Chose Project based on Mobile / Xamarin
  4. The system prepares the baseline project
  5. Attempted to build the project

Error

Error Image

CouldNotloadfileorassemblynetstandard.20181207.0340AM.PNG

Error Text


Could not load file or assembly 'netstandard, Version=2.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies.

Troubleshooting

Microsoft .Net Version

Review the version of Microsoft .Net that is installed.

Windows Explorer

Launched Windows Explorer and entered %windir%\Windows\Microsoft.NET\Framework64 as targeted folder.

Image

WindowsExplorer.20181207.0401AM

Explanation

We have a Version 4 version of Microsoft .Net installed; The baseline version # is v4.0.30319.

Please keep in mind that patches to his baseline might be installed, as well.

 

Registered Files

Registered File – netstandard.dll

Accessed %windir%\Windows\Microsoft.NET\Framework64  to determine if the referenced Assembly, netstandard.dll is present.

Confirmed it is not.

Remediation

Microsoft .Net Version

Goal

Installing .net framework 4.7.1 and above will help!

Artifacts

Availability

Please access https://dotnet.microsoft.com/download ( Link ) and see if there are newer versions of .Net than the one you have installed.

As of this morning, 2018-12-07, here is what is available.

Image

DotNetArtifacts.20181207.0826AM

Explanation

The latest .Net Framework, not the .Net Core, is 4.7.2.

 

Product :- v4.7.2

Image

DotNetArtifacts.4.7.2.20181207.0832AM.PNG

Explanation
  1. .Net Framework 4.7.2
    • Products
      • Build apps – Dev pack
      • Run apps – Runtime

We chose the Developer pack ( offline installer ).

Installer

Install

Images
License Terms

licenseTerms.20181207.0417AM.PNG

Setup Successful

setupSuccessfully.20181207.0426.PNG

 

Restarted Machine

Restarted Machine

Validation

Assemblies

Assembly – netstandard.dll

Windows Explorer

Accessed Windows Explorer and targeted C:\Windows\Microsoft.NET\Framework64\v4.0.30319

Steps

Took the following steps :-

  1. Folder View
    • Columns
      • Added Date Created
    • Sort/Order
      • Ordering by Date Created
Image

WindowsExplorer.20181207.0843AM.PNG

Explanation
  1. netstandard.dll now included

 

Visual Studio

Project Build

Launched Visual Studio, loaded our mobile project, and it compiled successful with a couple of non-blocking warnings.

Image

newProject.errorList.noerrors.20181207.0516AM.PNG

Explanation

  1. As we do not have a Mac attached expected this warning.

 

Referenced Work

  1. xamarin
    • xamarin/Xamarin.Forms
      • Xamarin.Forms.Build.Tasks.GetTasksAbi build error #2667
        Link
    • forums.xamarin.com
  2. David Kean
    • Twitter ( @davkean )
      • Folks this is a bug in the Xamarin task – it’s making the assumption netstandard is in the GAC.
        Link

Microsoft – Access Database Viewer

Background

Have a database that I need to review.

Unfortunately it is a Microsoft Access Database and I do not have Access installed.

And, so googled for opportunities.

Sample Databases

You likely want to try things out against sample databases before hand.

Here are some sample databases that are available online.

  • Microsoft Office Access 2010
    • Links
      • Download Sample Databases
        Link

 

Tools

Here are some sample databases that are available online.

  • Online
    • Maklabu GmbH
      • MDB Opener
  • Desktop
    • Alex Nolan
      • MDB Viewer Plus

Windows Perspective – Linux File Transfer Using Secure Copy Protocol

Background

In this post wanted to go over some of the options available to transfer files between two hosts.  One running Windows and the other running Linux.

For this post we will assume that our working computer is Windows.

Technology

Secure Copy Protocol ( SCP )

Wikipedia

Link

Secure copy protocol (SCP) is a means of securely transferring computer files between a local host and a remote host or between two remote hosts. It is based on the Secure Shell (SSH) protocol. “SCP” commonly refers to both the Secure Copy Protocol and the program itself.

The SCP is a network protocol, based on the BSD RCP protocol, which supports file transfers between hosts on a network. SCP uses Secure Shell (SSH) for data transfer and uses the same mechanisms for authentication, thereby ensuring the authenticity and confidentiality of the data in transit. A client can send (upload) files to a server, optionally including their basic attributes (permissions, timestamps). Clients can also request files or directories from a server (download). SCP runs over TCP port 22 by default.

Options

  1. Command Line
    • pscp
  2. GUI
    • winscp

Practice

pscp

Developer

pscp is developed and maintained by the Putty’s team.  Originating developer is Simon Tatham.

Download

pscp is available here.

Installation

No installation; a lone binary.

Usage

Browse Remote File System

Syntax

pscp -ls login@[remote-host]:[remote-folder]
Usage
pscp -ls root@hrdb-dev:/app/microsoft/sqlServer/backup/hrdb

Output

pscp.ls.20181203.0852AM

Copy

Receive a File
Syntax

pscp login@host:/[remote-folder] [local-directory]

Usage

pscp -r root@hrdb-dev:/app/microsoft/sqlServer/backup/hrdbdev01 c:\Microsoft\SQLServer\Backup

Output

pscp.receive.20181203.0910AM.PNG

Explanation
  1. Copying file

 

Send a File
Syntax

pscp [local-directory] login@host:/[remote-folder] 

Usage

pscp C:\Microsoft\SQLServer\Backup\blog.bak root@hrdbdev01:/app/microsoft/sqlServer/backup/hrdbdev01

Output

pscp.send.20181203.0941AM

Explanation
  1. File Sent

 

winscp

Developer

Martin Přikryl the developer of winscp.

Download

winscp is available here.

I prefer the Portable version and that is available here.

Installation

For the portable version, no install necessary just download and invoke.

Usage

Configuration

Site Manager

Please access site configuration through following the menu option Session\Site\Site Manager.

winscp.configure.20181203.1009AM.PNG

Session

winscp.use.backup.20181203.1013AM

Referenced Work

  1. SSH.COM
    • Home > SSH > PuTTY > putty-manuals > PuTTY User Manual (putty-0.68-manual)
      • Chapter 5: Using PSCP to transfer files securely
        Link

Damon Thompson – 2018/November

Videos

  1. Damon Thompson Ministries
    • The Full Armor of God
      • Profile
        • Carolina Revival – 9/9/18. Put on the full armor of God. I do not want any armor on me that isn’t on Him. He is giving you grace to let the old armor melt off and to quit seeing yourself as susceptible and to surrender to being vulnerable.
      • Videos
        • Segment – Partnering with a lie
          Link
        • Full
          Link

In depth

Damon Thompson Ministries

The Full Armor of God

  1. Where I am, you will be also
    • Scripture ( John 14:1-3 )
      • Do not let your hearts be troubled. You believe in God; believe in Me as well.
      • In My Father’s house are many rooms. If it were not so, would I have told you that I am going there to prepare a place for you?
      • And if I go and prepare a place for you, I will come back and take you to be with me that you also may be where I am.
  2. Where I am, you will be also
    • Scripture ( John 12:26 )
      • 26 If anyone serves Me, he must follow Me; and where I am, My servant will be as well. If anyone serves Me, the Father will honor him.
      • 26  Now My soul is troubled, and what shall I say? ‘Father, save Me from this hour’? No, it is for this purpose that I have come to this hour.…
    • I rescue that from dispensation-lism
  3. In My fathers house there are many mansions
    • You know what that mansion means
      • Speaking Places
  4. Sit here until I make your enemy a foot stool
    • Most quoted verse in New Testament from the Old ( Psalm 110 )
  5. Garden
    • Smell like home
    • Back into the Garden again
  6. Show me your glory
    • All of his goodness to pass by
    • I will lead your people, but will not go until you promise you will go with us
    • Church History
      • A man who had flirted with paganism most of his life
    • A man who had killed a man
      • Scripture
        • 18 Then Moses said, “Now show me your glory.”
          19 And the Lord said, “I will cause all my goodness to pass in front of you, and I will proclaim my name, the Lord, in your presence.
        • I will have mercy on whom I will have mercy, and I will have compassion on whom I will have compassion.
  7. Happy is the man whose sins are forgiven
    • Not even could the accusations can be uttered again
    • Muzzled the mouth of the accuser
    • Feel hope today
    • Scripture
      • Psalm 32:1-2
        • The Providence of God
          • 1David. A Maskil. Blessed is he whose transgressions are forgiven, whose sins are covered.
          • 2Blessed is the man whose sin the LORD does not count against him, in whose spirit there is no deceit.
      • Romans 5:5
        • 5and hope does not disappoint, because the love of God has been poured out within our hearts through the Holy Spirit who was given to us.
  8. Hope
    • Hope from a posture of wishing
  9.  Repent
    • Change your thought
  10. Protect
    • Protect yourself because people will wound you
    • Shield of Faith
  11.  Truth
    • What kind of shield do you need
      • Confidence
      • Belt in the gird-on of truth
    • We mess ourselves up when we tie ourselves up in a lie
  12. What we do
    • Wish and called it faith
    • Fantasized and called it Hope
  13.  Masculine
    • Masculine definition of Christianity
      • Got here by mercy
    • Strutted our way here
    • Truth that ties the righteousness to you
    • Truth to divorce ourselves from the lie
    • Righteousness that does not fit within religion
  14. Access to Heart
    • The issue is the wrong people held on to my heart
  15. Righteous generates its own faith
    • The faith we have did not come from someone roped in righteousness
  16. Relatable dimensions
    • You only know how deep you are based on what relates to you
    • Deep calls out to Deep
    • Shallow cries out to shallow
    • Large Church
      • You want to have a large church, minister Soul to Soul
      • Soul inclusive of mind, will, and emotion
    • Small Church
      • Spirit to Spirit
    • When Adam sinned he exalted his soul
    • Desire
      • By souless-ness
    • Soul
      • Spirit soul switches place
      • Unable to govern
      • Spirit now governs the Soul
        • Produces law of Limitation
      • Govern by Mind
      • Name every species in the World
      • Exaltation
        • Use Mind for what the Spirit desires
  17. Insurance
    • I have Insurance
    • But, I have not had Insurance

youtube-dl :- Convert Downloaded Video to Audio

Background

By default artifacts downloaded from YouTube comes across as video.

Lineage

  1. YouTube – Upload – “Stuck at Processing 95%”
    Date Published :- 2016-Jan-29th
    Link
  2. ClipConverter is not available for videos containing music
    Date Published :- 2018-Nov-18th
    Link

youtube-dl

For example, youtube-dl downloads comes across as mp4.

Let us convert our downloaded video to audio.

Better yet, let us have youtube-dl perform a conversion post the download.

Prerequisites

Please download the following:-

  1. FFMpeg
    • Original author(s) :-
      • Fabrice Bellard
    • Definition
      • Wikipedia
        • Link
        • FFmpeg is a free software project consisting of a vast software suite of libraries and programs for handling video, audio, and other multimedia files and streams. At its core is the FFmpeg program itself, designed for command-line-based processing of video and audio files, and widely used for format transcoding, basic editing (trimming and concatenation), video scaling, video post-production effects, and standards compliance (SMPTE, ITU). FFmpeg includes libavcodec, an audio/video codec library used by many commercial and free software products, libavformat (Lavf), an audio/video container mux and demux library, and the core ffmpeg command line program for transcoding multimedia files.
        • FFmpeg is part of the workflow of hundreds of other software projects, and its libraries are a core part of software media players such as VLC, and has been included in core processing for YouTube and the iTunes inventory of files. Codecs for the encoding and/or decoding of most of all known audio and video file formats is included, making it highly useful for the transcoding of common and uncommon media files into a single common format.
    • Download Sites

Script

Download Singular

Script – dlvideo.cmd


set "_app=youtube-dl.exe"
set "_format=mp3"
set "_quality=0"

set "_option=--extract-audio --audio-format %_format% --audio-quality %_quality% --keep-video "

%_app% %_option% %1

Sample Invocation


dlvideo https://youtu.be/csmart

Output

convert_20181119_0654AM.PNG

Download List

Outline

  1. Prepare text file
    • urllist.txt
      • Lists URL
  2. Prepare Script
    • dlvideoInList.cmd
      • for ( Commands )

Script – dlvideoInList.cmd

@echo off

setlocal enabledelayedexpansion

set "_filename=youtubeURLList.txt"

for /f "tokens=*" %%a in ('type %_filename%') do (

set line=%%a

echo !line!

call dlvideo.cmd !line!

)

endlocal

Sample Invocation


dlvideoInList.cmd

 

Quotes

VideoHelp

Home / Forum / Video / Video Conversion / Need help with ffmpeg

Link
Sorry, no clue what the other folks in this forum do.
Personally I would probably post in the ffmpeg developer mailing list and ask if there’s someone interested.
(I know that Fiona Glaser did consultant jobs a while back, but I’m not sure if she is still doing that. Side note: Don’t get confused DarkShakiri, Jason Garrett-Glaser, Fiona Glaser are all the same person.)

Dedicated

Dedicated to Fiona Glaser.

For the pretentious, Girls code and they do it well too.