Simple converter for anyone doing SQL 'IN' queries.

Latest Version

Version
3.0
Update
September 21, 2024
Size
40.59KiB
Developer
Category
Users
4,000+
Rating
4.77778 ★
Manifest Version
3
Web Store Status
Languages Support
English
See more
Permissions
See more

AspenUtil - SQL 'IN' converter & more Extension

This utility has three features:
1) Prepares a list of values to be used with a SQL \"IN\" query.
2) Converts a date to a timestamp (Unix time or epoch...in milliseconds)
3) Converts a timestamp (in milliseconds) to a date

For SQL 'IN' Queries:
=====================
This utility can be used in any situation where you need to convert a series of values to being comma delimited with single quotes around each value.

INSTRUCTIONS:
Step 1: Take a list of values (for example, copied from a spreadsheet or SQL Query editor) and paste it into the textarea of this extension.
Step 2: Click the \"Convert\" button.
Step 3: If you don't want the single quotes around each value, there's a button for that.

That's it! Your string will be automatically converted and copied to your clipboard!


For Date to Timestamp Conversions:
==================================
Enter a date in the format of your choosing (5/1/2016, or May 1, 2016) and click the \"Convert\" button. You will get back the timestamp (Unix time or epoch) in milliseconds, automatically copied to your clipboard.

Similarly, if you enter a timestamp in milliseconds, it will give you the date.
Read more

Source Manifest.json

{ "background": { "service_worker": "service_worker.js", "persistent": false }, "content_security_policy": {}, "manifest_version": 3, "update_url": "https://clients2.google.com/service/update2/crx", "name": "AspenUtil - SQL 'IN' converter & more", "action": { "default_popup": "index.html", "default_icon": { "128": "assets/icon_128.png", "48": "assets/icon_48.png", "32": "assets/icon_32.png", "19": "assets/icon_19.png" }, "default_title": "AspenUtil-SQL_'IN'_converter_and_more" }, "description": "Simple converter for anyone doing SQL 'IN' queries.", "version": "3.0", "short_name": "SQL 'IN' Converter"}
Read more

How to download and manually install AspenUtil - SQL 'IN' converter & more extension for Chrome

Looking for a way to install AspenUtil - SQL 'IN' converter & more extensions for Chrome, you can search for them in the Chrome Web Store, clicking the "Add to Chrome" button, and following the straightforward process.

However, you may need to install AspenUtil - SQL 'IN' converter & more extensions manually, this article outlines two simple methods to effortlessly install AspenUtil - SQL 'IN' converter & more extensions, whether they come as unpacked folders in compressed formats like .zip or as .crx files.

Method 1: Download AspenUtil - SQL 'IN' converter & more extension and manually install through Drag &Drop

If you ever need to manually install a AspenUtil - SQL 'IN' converter & more extension for Chrome, don't worry, it's a simple process. Just follow these easy steps, and you will have your extension ready to use in no time.

Step 1: Download the AspenUtil - SQL 'IN' converter & more Extension by clicking the "Download CRX" button on the website.

Look for the AspenUtil - SQL 'IN' converter & more extension you wish to install. Go to the website and download the AspenUtil - SQL 'IN' converter & more extension package, which is usually a .CRX file and comes in a zipped file. Here ".crx" file is the format for AspenUtil - SQL 'IN' converter & more extension that contains all the data.

Step 2: Extract &Arrange Files

Once the file is downloaded, extract that file into its own folder. Similarly, give that extension files a permanent home. In other words, keep it in a folder that you don't accidentally delete it because these files will be needed to make that extension work.

Step 3: Go to the Chrome Extensions Page

Open Google Chrome and in the address bar, type chrome://extensions; it will open the Google Chrome extensions page. Make sure that "My extensions" is selected in the sidebar.

Step 4: Drag and Drop the Extension

Now, go to the folder where you extracted the AspenUtil - SQL 'IN' converter & more extension and drag &drop the extension file from there anywhere onto the extension page within Google Chrome.

Step 5: Complete the Installation

Once you drag and drop the extension file, follow the steps that Google Chrome takes you through. Similarly, if the extension file is of .crx file format, you will be required to review the permissions and then add the extension.

Now, you can manage that added extension as you would like to with any other Chrome extension that you added through Chrome Webstore. Its icon will also appear in the Google Chrome Menu on the right side of the address bar once you activate it.

Method 2: Download AspenUtil - SQL 'IN' converter & more extension for Chrome and install in Developer Mode

This is another method to install AspenUtil - SQL 'IN' converter & more extension manually, but the twist is that here, you install by enabling the developer mode option provided in Google Chrome. This mode is commonly used for testing extensions or running unpublished tools.

Step 1: Download the AspenUtil - SQL 'IN' converter & more extension file

Select and download the AspenUtil - SQL 'IN' converter & more extension by clicking the 'Download CRX' button on the website.

Step 2: Extract the downloaded contents

Convert the file to a ZIP file if it is in CRX format then extract the AspenUtil - SQL 'IN' converter & more extension zip file or folder that you downloaded. Make sure you extract it using the same folder name and keep it safely in another folder, so you don't delete it by mistake. The extracted folder will be needed to keep your AspenUtil - SQL 'IN' converter & more extension running.

Step 3: Open Chrome Extension Setting Page

In the address bar of Google Chrome, type chrome://extensions and open the Chrome Extension Page.

Step 4: Enable Developer Mode

After opening the Chrome Extension page, look at the top right side, and you will find the toggle option of "Developer mode."Simply enable that developer mode option.

Step 5: Load the Unpacked Extension

Once you enable the developer mode option, you will see the menu of Load Unpacked, Pack Extensions and Update. From that, select the option "Load unpacked."

Step 6: Select the Extension Folder

Once the pop-up opens upon clicking Load unpacked, select the AspenUtil - SQL 'IN' converter & more extension directory and click on the "Select Folder "button.

Step 7: Confirm and Install

After you select an extension folder of a Google Chrome extension you're installing manually, confirm its installation for the final time and let the installation complete.

Conclusion

Here we've made a step-by-step guide on How to manually install AspenUtil - SQL 'IN' converter & more extension in 2 ways. We hope this guide proves helpful.

Similar Extensions

icon

Search API Query String Parser Extension · Developer Tools 4,000+ 3 ★ 251KiB

icon

RE:DOM dev tools Extension · Developer Tools 4,000+ 1 ★ 207KiB

icon

Tanuki Utilities Extension · Developer Tools 4,000+ 1 ★ 25.43KiB

icon

Scripter debugger extension Extension · Developer Tools 4,000+ 2 ★ 1.04MiB

icon

JSON2Class Extension · Developer Tools 4,000+ 3 ★ 95.44KiB

icon

Utilspoint Extension · Developer Tools 4,000+ 2 ★ 33.33KiB

icon

Atma.js DevTool Extension · Developer Tools 4,000+ 0 ★ 201KiB

icon

SQL Viewer Extension · Developer Tools 4,000+ 5 ★ 232KiB

icon

SQL Format Extension · Developer Tools 4,000+ 15 ★ 110KiB

icon

Saverd Recipe Clipper Extension · Productivity 4,000+ 1 ★ 48.51KiB

icon

Timestamp converter Extension · Developer Tools 4,000+ 1 ★ 69.37KiB

icon

SQL Formatter Extension · Developer Tools 4,000+ 3 ★ 102KiB

icon

stringG Extension · Developer Tools 4,000+ 0 ★ 11.65KiB

icon

Timestamp Converter Extension · Productivity 4,000+ 2 ★ 65.02KiB

icon

sqanything Extension · Developer Tools 4,000+ 5 ★ 2.15MiB

icon

SQLDelimiter Extension · Developer Tools 4,000+ 17 ★ 20.88KiB

icon

BigQuery Mate Extension · Productivity 4,000+ 23 ★ 206KiB

icon

captureCalls Extension · Developer Tools 4,000+ 1 ★ 9.63KiB

icon

Colibri: modify Ajax response Extension · Developer Tools 4,000+ 2 ★ 220KiB

icon

server-spy Extension · Developer Tools 4,000+ 3 ★ 59.55KiB

icon

CoffeeScript Console 3 Extension · Developer Tools 4,000+ 0 ★ 438KiB

icon

DOM-JSON Tree Matcher Extension · Developer Tools 4,000+ 0 ★ 18.58KiB

icon

Not my department Extension · Developer Tools 4,000+ 1 ★ 1.44MiB

icon

Check for .git directory existence Extension · Developer Tools 4,000+ 0 ★ 49.98KiB

User reviews

icon

CHEERASAK KWUANTHONG (Gee) (ID: 000000b5965dd435) Voted 5 ★ - Updated 03/16/2023 good job

icon

Andy Moore (ID: 000000601f703e94) Voted 5 ★ - Updated 11/13/2018 VERY useful extension for sql queries. Does what it promises, does it well, and saves a ton of time!

icon

Andrew Bullock (ID: 000000c1e4bff63d) Voted 5 ★ - Updated 10/18/2017 What did we do before this was out!?!? Works perfectly and has sped up many of my procedures.

icon

Mark Glass (ID: 00000069a3f64705) Voted 5 ★ - Updated 04/12/2016 Most useful chrome extension I have. I use this everyday.

icon

Tim Reed (ID: 000000d7da9f2e36) Voted 5 ★ - Updated 03/28/2016 Simple, fast and easy way to parse values into SQL-ready strings. No muss, no fuss.