yogilad / klipboard Goto Github PK

Paste the quick action result back to the clipboard.
This allows

• Avoid opening new tabs
• Bypass the 12KB limit of deep links

Requested by Bassel Saba

Quick actions should have a "Let me parse scheme using KQL" mode (or lines mode).
In this mode Quick actions will send each line of data into a single string column.
The user can parse rows manually.
Fits unstructured data such as logs.

Present to user

• A snippet of the data
• The type of data detected (File Drop List, Text, Table)
• The size of the data or number of files

Windows default notifications seems limited in content size.
https://learn.microsoft.com/en-us/windows/apps/design/shell/tiles-and-notifications/toast-notifications-overview

logger-buffer-202303010822 .json.log

Last X data items (not files) pasted to Kusto

• Download the data to a file, then work on the file

extract a single table from clipboard HTML content

Send the first line of a text file and the text file itself for schema operator,
The first line is a header if it is all strings and it is different then the other lines schema.

Consider limiting the number of rows sent to the "full" schema detection to make it faster (e,g, send up to 100 rows)

Consider using Serilog for background logging
Consider pushing logs to action UX

• Structured query should convert empty string columns to empty strings ""
• Process more rows for schema detection.
• If there's a disagreement use string instead of max property

Copied tables from office products get also represented in HTML table format.
Being able to support that format will help accessing tables from more office products

• Replace disallowed chars with place holders (e.g. underscore)
• Auto complete names for empty column names

Need sign out, better user management and actual connection string sort

• Better UX
• Make into a normal worker
• Drop use of Record type

Prevent running more then one instance of the application

free text query should support multiple KQL parsing macros.
Macros should be named
Macros should appear as sub menu of ingestion command
Free text option and macros should be available for external data and temp table query

Kusto does not support Windows's quotation escaped TSV format, so Tabular data with escaped tabs causes an error about varying column numbers.

Options to fix - provide user with Clipboard Tabular-Data processing options:

1. Default - as today - works for most users
2. Convert TSV to CSV - CPU costly but has Unicode Support
3. Get ASCII / LATIN1 ASCII - works best with English / Numeric data
4. Get Code Page ASCII data - works for local machines (Was unable to figure this out yet)

Example code for converting Tabular data to Latin1CSV:

 var stream = Clipboard.GetData(DataFormats.CommaSeparatedValue) as MemoryStream;
 var bytes = stream.ToArray();
 var data = System.Text.ASCIIEncoding.Latin1.GetString(bytes);

For people running a local copy of Kusto,

• With / Without authentication
• With / Without HTTPS

Use ExcelDataReader to natively process simple excel files
https://products.fileformat.com/spreadsheet/net/exceldatareader/
https://github.com/ExcelDataReader/ExcelDataReader

Assuming this file can be used to store credentials