Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.
Claim your profile
Articles by Igor Krupitsky
PDF To Excel
Download PdfToExcel.zip Introduction This application will convert PDF to Excel by using the following steps: Convert PDF to JPG using Ghostscript Let user select table(s) to export to Excel Extract the selected images and resize them to confirm to the vison API (2,000px max for OpenAI and 1,092px max for Anthropic) Use OpenAI or Anthropic Vision API to convert image to HTML Convert HTML files to one Excel file using VBA Using the code Get Anthropic API key...
AI Book Translator
Download BookTranslator.zip Introduction If you have a pdf file, the text file needs to be generated by opening the pdf file in Word and copied and pasted to a text file. Open the text file in a text editor that has line numbers such as Notepad2. Open the file in and remove text that would not be read like: table of contents, footnotes, index and references. Each paragraph must be on one line. This app will translate a book by sending each line to OpenAI or Anthropic.
Google Audio Book Creator
This application lets you create an audio book using Google TTS API. The application will generate mp3 file for each paragraph and then merge them together. Introduction This application lets you create an audio book using Google Text-to-Speech AI API. The application will generate mp3 file for each paragraph and then merge them together. The Google Text-to-Speech AI is $16 per 1 million characters. First 1 million characters FREE. An average 200 page audiobook is about 0.2 million characters.
OpenAI Image Editor
Download OpenAiImageGenerator.zip Introduction This application is my attempt to create a smallest client app to edit images using OpenAI dall-e-2 API. The app lets you replace some areas of a pre-existing image based on a text prompt. The image has to be a square PNG file with three sizes: 256x256, 512x512, or 1024x1024. The application will convert your image tile to this format and size using ResizeImage() function.
Using OpenAI ChatGPT and Anthropic Claude in Excel VBA
Download OpenAI_Anthropic.zip Introduction This Excel Macro enabled file provides the smallest possible example of how to use Chat GPT and Anthropic Claude in your Excel Macro. Background This is a sequel to my earlier article, Chat GPT in VB.NET and C#. Using the code Get Anthropic API key https://console.anthropic.com/settings/keys Paste the Key to cell B1 Get OpenAI API key https://platform.openai.com/settings/profile?tab=api-keys Paste the Key to cell B8 Here is the code.
OpenAI Text to Speech in Browser
Introduction This program is implemented as a JavaScript Bookmarklet that uses OpenAI TTS API. It should work in any browser including Chrome, Edge and Firefox. Using the code First get API Key from Open AI https://platform.openai.com/account/api-keys Copy the code below to notepad and replace "YOUR OPEN AI API KEY HERE" with your key Create a bookmark in your browser. (You can do this by dragging any URL to the Bookmark bar.) Right click on the bookmark and click "Edit".
Searchable PDF app
Download PDF_OCR.zip - 3.2 MB Introduction This tool is using Tesseract to do the OCR (optical character recognition). The tool is also using Ghostscript to convert non-searchable PDFs to TIFF files so that can be converted to searchable PDFs. The tool also provides an option to merge converted PDF files into one. The tool is using iTextSharp library to see if the PDF is searchable or not.
PDF OCR tool
Download PDF_OCR.zip - 3.2 MB Download PdfOcrVbs.zip - 1.9 KB Introduction This tool is using Tesseract to do the OCR (optical character recognition). The tool is also using Ghostscript to convert non-searchable PDFs to TIFF files so that can be converted to searchable PDFs. The tool also provides an option to merge converted PDF files into one. The tool is using iTextSharp library to see if the PDF is searchable or not.
CSV to SQL Server
Download source files - 193.5 KB Introduction I developed this application to help me migrate CVS files to SQL Server. It was too much trouble importing the files using SSIS and SSMS import flat file feature. The application assumes that the first row contains column names. I hope someone else will also find this code useful.
Audio Book Creator
Download ElevenLabsExe.zip - (App Exe) 27.MB Download ElevenLabs.zip (Source Code) - 28.1 MB Introduction This application lets you create an audio book using Eleven Labs API. Eleven Labs API allows only 5,000 characters per request. The application will generate mp3 file for each paragraph and them merge them together. If you have pdf file, the text file needs to be generated by opening the pdf file in Word and copy and pasting to a text file.
Chat GPT plus Eleven Labs in JavaScript
Download source code - 3.1 KB Introduction This application is my attempt to create a client app to talk to Chat GPT in JavaScript. My goal is to demonstrate use Chat GPT API with speech-to-text and Eleven Labs text-to-speech capabilities. This means that you can talk to your browser and your browser will talk back to you with a human like voice. Background This article is a sequel to my previous article “Chat GPT in JavaScript”.
Chat GPT in JavaScript
Download ChatGPT.zip Introduction This application is my attempt to create a smallest client app to talk to Chat GPT in JavaScript. My goal is to demonstrate use Chat GPT API with speech-to-text and text-to-speech browser capabilities. This means that you can talk to your browser and your browser will talk back to you. Using the code Get OPENAI_API_KEY from https://beta.openai.com/account/api-keys. Open ChatGPT.jsand add the API Key key to the first line.
Chat GPT in VB.NET and C#
Quote: Q: Sorry it gives an error Error CS0021 Cannot apply indexing with [] to an expression of type 'object' A: It looks like the issue you're experiencing is due to the fact that the oJson variable is of type 'object', which doesn't support indexing using the [] syntax. To fix this issue, you'll need to cast the oJson variable to a type that does support indexing, such as a dynamic type or a specific JSON library type (e.g. JObject from Newtonsoft.Json).
Chat GPT in VB.NET
Download source code - 4.7 MB Introduction This application is my attempt to create a smallest client app to talk to Chat GPT. Chat GPT is an AI your application can talk to. Using the code Get OPENAI_API_KEY from https://beta.openai.com/account/api-keys Open App.config (or bin\Debug\ChatGPT.exe.config) and add the API Key key to it. Here is the code. Basically it uses HttpWebRequest to post JSON to OpenAi endpoint: https://api.openai.com/v1/completions.
Phone Chat with Web Sockets
Download Phone.zip - 934 KB Introduction This application is my attempt to create a smallest voice chat application using Web Sockets. I am trying to use the least amount of code to show how to use Web Sockets. Web Sockets is the technology that lets you push the data from the web server to web browser.
Chat App
Introduction This application is my attempt to create a smallest chat application using Web Sockets. I am trying to use the least amount of code to show how to use Web Sockets. Web Sockets is the technology that lets you push the data from the web server to web browser. Background To use Web Sockets your web server needs to have ASP.NET 4.5 or higher and WebSocket Protocol installed under Add Roles and Features > Server Roles > Web Server > Web Server > Application Development > WebSocket Protocol.
Compare Two Excel Files
Download CompareExcel.zip Introduction Drag and drop two excel files to compare. The changes will be highlighted in yellow. Use ExcelCompare.vbs to compare cells. If your excel files might have new rows or columns use ExcelRowCompare.vbs Using the code ExcelRowCompare.vbs compares rows, column and cells. You can modify the code to exclude some worksheets or to save the file at the end. The script might take long time to run depending on the size of the files.
MS Access Queries to SQL Server Converter
Introduction Download AccessToSql6.zip Tool for Migrating MS Access Queries to SQL Server. It should be used when the Access Queries are using SQL server linked tables. To use this application select Access file, Select a view and click SQL. Click Save All to save all Access queries as SQL files to a folder. The result SQL will be created using CTE (Common Table Expressions) in case the Access query that is using other Access queries.
Unmerge Excel File
Download Unmerge.zip Introduction Drag and drop anexcel file on top of VBS file to unmerge . Before unmerge: After unmerge: Using the code This script will unmerge merged ranges that are one cell wide and mary rows deep.
Compare 2 Excel Files
Introduction Download ExcelCompare2.zip. Drag and drop two excel files to compare. The changes will be highlighted in yellow. Using the code You can modify the code to exclude some worksheets or to save the file at the end. The script might take long time to run depending on the size of the files.
Holidays Table and GetWorkDays Function in SQL Server
This article will show how to create a Holidays table and how to use this table to get the number of workdays between two dates. Download source code - 2.2 KB Introduction This article will show you how to count workdays in SQL Server. Using the Code When a holiday will fall on Saturday, move it to Friday and when it falls on Sunday, move it to Monday.
Holidays table and GetWorkDays function in SQL Server
This article will show how to create a Holidays table and how to use this table to get the number of workday between two dates. Introduction This article will show you how to count workdays in SQL server. Download GetWorkdays.zip Using the code When a holiday will fall in Saturday move it to Friday and when it falls on Sunday move it to Monday.
Merge Many Excel Files into one VBS
This MergeExcel.vbs will merge Many Excel files into one. Double click to run it. It will read MergeExcel.txt file located in the same folder and imports all worksheets into one workbook. Download MergeExcel2.zip Using the Code Before you can run the script, you need to setup the configuration (MergeExcel.txt) file. In Windows Explorer, hold shift and right-click on the file you want to merge, select "Copy as path". Paste the path into MergeExcel.txt file.
Merge excel files into one using VBS Script
Merge excel files into one on Excel file. The script is using VBA to import worksheets from each file on one workbook. Download PDF - 1.7 KB Introduction Merge excel files into one on Excel file. The script is using VBA to import worksheets from each file into one workbook. Add file to me merged to MergeExcel.txt and double click MergeExcel.vbs to run it. Using the Code MergeExcel.txt - contains the list of files to be merged. Open Windows Explorer hold shift and right click on the excel file.
Merge many Excel Worksheets into one using VBS
This MergeSheets.vbs will merge Many Excel worksheets into one. Drag and drop an excel file on top of this script file to merge worksheets. The first data row must contain column names. Download MergeSheets.zip Using the Code You can drag and drop excel files on top of this script file to merge them. The first data row must contain column names. Columns with no column name will be skipped. The script will create a new "Combined" sheet at the begining.
Merge Many Excel files into one VBS
This MergeExcel.vbs will merge Many Excel files into one. Double click to run it. It will read MergeExcel.txt file located in the same folder and imports all worksheets into one workbook. Download PDF - 1.7 KB Introduction This VBS script will merge many excel files into one. Using the Code Before you can run the script you need to setup the configuration (MergeExcel.txt) file. In Windows Explorer hold shift and right-click on the file you want to merge, select "Copy as path".
DBF to SQL Server
Download DbfCopy.zip Introduction I developed this application to help me migrate DBFs to SQL Server. I hope someone else will also find this code useful. Background This application is fairly simple: you select the folder where DBF database files reside, select the SQL Server database you want to copy the tables, select the tables you want to copy and click "Copy tables". The application will create tables in the SQL server database and copy the data.
Windows Search ASP.NET
Introduction This application shows how to search Windows Index in ASP.NET. Windows Search builds a full-text index of files on a computer. This application lets you search by file contents and file attributes. Download WindowsSearch.zip Using the code The code uses OleDb Search.CollatorDSO provider to communicate with the Windows Search service on the local or remote computer.
Convert all files to searchable PDFs
Introduction This program will convert office, text and image files to PDFs. To use this program drag your file(s) or forders onto the script file. Files in sub-folders will be converted too. Download PDF.zip Using the code The script uses office automation to convert Excel, Word, Text and Power Point documents. The script uses free Tesseract library (by Google) to convert images to PDF.
Multiple File Upload with Progress Bar and Drag and Drop
Introduction This ASP.NET application will let you upload multiple files manually or via drag and drop. It will show progress bar for each file as it uploads. Once uploaded, you can browse and delete these files. Background This application is based on the sample provided by Craig Buckler. Using the Code To use this application: Download Upload2.zip and unzip it to C:\inetpub\wwwroot\Upload. Give everyone (or the IIS anonymous user) access to C:\inetpub\wwwroot\Upload\upload folder.
Folder Tree with Multiple file upload with progress bar and drag and drop
Download source code - 586 KB Introduction This asp.net application will let you upload multiple files manually or via drag and drop. It will show progress bar for each file as it uploads. A zip file can be extracted after the upload. Once uploaded you can browse and delete these files and folders. Background This is a sequel to my earlier article Multiple file upload with progress bar and drag and drop.
Barcode Scanner
Download source code - 4.36 MB Introduction This Windows application lets you scan image in a given folder (and subfolders) and generate CSV file based on the output. This article uses the BarcodeImaging.dll library developed by Berend Engelbrecht to scan barcodes: Reading Barcodes from an Image - III Background I found that BarcodeImaging.dll library does pretty decent job but for some cases I needed to use Byte Scout (Bytescout.BarCodeReader.dll) library (which cost $20 and is slow).
International Date Formats
Please Sign up or sign in to vote. This is a sequel to an article I wrote 8 years ago about number formats in .Net. This one is about number formats in .Net. Here is the code lists all of the number formats out there in VB.NET: This code converts "1/2/3" to date using different cultures. Here is the table this VB.NET code returns: 2/1/2003 is the most common 2/3/2001 is second 1/2/2003 is the least common format and is used by US.
Paradox to SQL Server
I developed this application to help me migrate Paradox database to SQL Server. I hope someone else will find this code also useful. This application uses the "Paradox database native .NET reader" library developed by Petr Briza. It is fairly simple: you select the folder where Paradox database files reside, select the SQL Server database you want to copy the tables, select the tables you want to copy and click "Copy tables".
Paradox to SQL Server
I developed this application to help me migrate Paradox database to SQL Server. I hope someone else will find this code also useful. This application uses the "Paradox database native .NET reader" library developed by Petr Briza. It is fairly simple: you select the folder where Paradox database files reside, select the SQL Server database you want to copy the tables, select the tables you want to copy and click "Copy tables".
ASP.NET page to process SSAS cubes
ASP.NET page that let you process an SSAS (SQL Server Analysis Services) cube database. SQL Server Analysis Services is usually processed daily but sometimes you want to give your users the ability to refresh the database on demand. This page lets you do that. If there are any problems during the processing the page will show you the error text. This page is using the following third party components: The Cube.aspx will let process the cube asynchronously by using jQuery's $.get.
Resizable and nested modal dialogs using jQuery UI and Bootstrap
The goal of this project is to show how to create nested modals that can be resized. Each modal is created from another page using an iframe. This approach lets you dynamically load as many modal as you need. Download bsModal.zip. Unzip this file to a virtual directory and point your browser to Default.htm. The code is contained in BsModal.js file. The code is using four external libraries: This article is a sequel to my previous article Nested modal dialogs using Bootstra.
Multiple file upload into a database with progress bar and drag and drop
This asp.net application will let you upload multiple files to a SQL Server database via drag and drop. It will show progress bar for each file as it uploads. Once uploaded you can browse, sort and delete these files. This is a sequel to my earlier article Multiple file upload with progress bar and drag and drop. To use this application: 1. Download Upload.zip and unzip it to C:\inetpub\wwwroot\Upload. 2. Open SQL Server Management Studio and create "Upload" database.
Nested modal dialogs using Bootstrap
The goal of this project is to show how to create nested modals. Each modal is created from another page using an iframe. This approach lets you dynamically load as many modal as you need. Download bsModal.zip. Unzip this file to a firtal directory and point your browser to Default.htm. Most code is contained in BsModal.js file. This file will let you: The code is using three external libraries: To use this code, include BsModal.js file in the page that creates the first dialog.
MySQL Data importer
I needed to import data from MS SQL Server to MySQL. I first tried to use MySQL Workbench but ran into some problem. So I wrote a tool to copy table schema and data to MySQL. You can download it here: CopyTable.zip. I have tested the tool against MS SQL Server and Access databases. Not all data types are supported. You can modify the application to support other data types and databases (like Oracle). Here is the main code. Here is the code for AppRegistry.vb module.
DataTable from Excel
This article shows how to get DataTable out of an Excel file. It has two functions: GetDataTableFromExcel2007() function uses ICSharpCode.SharpZipLib.dll. Please download and it here: http://icsharpcode.github.io/SharpZipLib GetDataTableFromExcel2007() uses SharpZipLib library to to read Excel (xlsx) file. Second parameter (iColHeaderRow) tells the function where the column header row is located. If column headers are located on the first row pass 1. If the Excel file has no rows pass 0.
Show More
loading
Actions
Is this you?
As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.Get in touch with Igor
Contact Igor, search articles and posts on X, monitor coverage, and track replies from one place.
Learn more about Muck Rack