Export data from your CRM with oneSql

I’ve uploaded another movie to our YouTube page today. This one shows an example of how to use oneSql to export contacts from your CRM system.

I have also been testing Mac OSX Yosemite Beta on one of my development computers. Here is a picture of oneSql running on Yosemite. Note the new native  control designs and colours. I think I like it :-)

onesql yosemite beta sql query toolThat’s all for now :-)

chol.technology Banner

New CRM Software: Video Preview

A new video has just been uploaded to YouTube. This video demonstrates how simple and straightforward it is to insert and print a Sales Invoice using blackdogCRM, currently in Beta. (There is only so many hours in the day!) :-)

chol.technology Banner

New Pinterest Account

We now have a Pinterest account. Still in it’s infancy and only a few dozen images so far, but if you want a peek, here it is:

Follow Steven’s board chol.technology on Pinterest.

 

busbannerAffiliate Links

 

Easy to Use SQL Tool | oneSql 101: User Prompts

Visual Guide to oneSql: Part 4, User Prompt Fields

New, Easy to Use, Fast, Cross Platform, Multi-Language SQL Query Tool: oneSqlupf5

upf2

upf3

upf5

upf

busbannerAffiliate Links

 

Easy to Use SQL Tool | oneSql 101: Preferences

Visual Guide to oneSql: Part 3

New, Easy to Use, Fast, Cross Platform, Multi-Language SQL Query Tool: oneSql

 

prefswindow1

prefswindow2

 

prefswindow3

 

busbannerAffiliate Links

 

oneSql Database Tool 1.0: Press Release

[prMac.com] Ripley, Derbyshire. United Kingdom – chol.technology are pleased to announce Version 1 of a brand new MySQL, PostgreSQL, MariaDB and SQLite SQL Query and Data Import / Export program for Mac OSX, Windows and Linux. Three Operating Systems, Four Databases and Five Languages Supported including in addition to English; French, Spanish, Italian and German. Clear and unrestrictive Software Licensing, putting customers needs first.

oneSql is a stand alone, lightweight, no install neededSQL Database Tool for OSX, Windows and Linux.

The target audience for oneSql is initially technical people, Database Administrators, Developers, or ‘power users’ who need a simple, efficient, cross platform SQL Tool on their computer, or in the Utilities folder of their portable USB Drive. DBA’s, System Admins, Developers, Accountants – all have a need for oneSql.

These users may currently have a favourite tool for each operating system platform they use. I’d like to supplement or even replace their existing tools with oneSql. I hope to do this by focusing on the features that are most important to them and eliminating those that seek to overcomplicate competing products.

We have also introduced new functionality that will likely interest those same individuals who can now get additional benefits from using oneSql. For example the ability to put the Mac, Windows and Linux versions of oneSql onto a USB Drive and then connect the drive to virtually any computer and load and use oneSql, without installation, is fairly unique and extremely useful.

With the unique ‘User Prompt Fields’ functionality, use within an organisation can extend far beyond the Technical User and to the desktop of the End User. Scripts written by the Technical User can be run as Reports by the End User without modification as each variable, for example Data Start and Date Finish, is prompted for appropriately. The End User needs to know nothing about SQL or the script.

Benefits Include:

  • One SQL Tool for Mac, Windows and Linux
  • One SQL Tool for SQLite, PostgreSQL, MariaDB and MySQL
  • Unlimited Time Limit for the Trial Edition
  • Unrestricted Features for the Trial Edition
  • Small and Lightweight, Approx 20Mb for all Versions
  • Speed with Reliability
  • Scripts Library to Store Your Scripts for Future Use
  • Easy and Simple to Use
  • No Installation Required
  • Save Time with Data Import Templates
  • Saved Connections Stored Safely using Encryption
  • Get Started Quickly with the Examples Database
  • Productivity with User Prompt Fields
  • Increased Database Security
  • Full Manual Included as a PDF
  • Written and Supported in the United Kingdom
  • Simple, Fair and Inexpensive Licensing
  • Zero Effort Corporate Licensing
  • Corporate Licensing Available
  • 50% Discount for Education Establishments and Students
  • 50% Discount for Charities and Non Profits

Features Include:

  • SQLite, MariaDB, PostgreSQL or MySQL
  • Objects Tab – Tables, Views and Columns
  • Fully Customiseable Results Grid
  • Auto Highlighting of SQL Keywords
  • User Editable SQL Keywords List
  • Built in Script Library
  • Example Database Supplied
  • Export Data in Tab Delimited Format
  • Export Data in CSV (Comma) Format
  • Export Data in CSV (Semicolon) Format
  • Export Data in JSON Format
  • Save and Load SQL External Scripts
  • One Click for Record Count, any Table
  • Quick Query One Click to Fetch 20 Records
  • One Click to Fetch All Records
  • Insert a SQL Template
  • SQL History List – Double Click to Recall
  • Window Sizes and Positions Saved on Exit
  • List View Configurations Saved on Exit
  • Option to prefix Columns with Table Name
  • Option to append a Comma to the Columns
  • User Input Prompts
  • Enhanced Connection Encryption Options
  • Parsing of Multiple Statements
  • Sequential Statement Execution
  • Highlighted Statement Execution

Taking Security Seriously:

There are two choices for how encryption is used to secure your database connection information. The first choice encrypts the connection password in such a way that it is then specific to your computer. If you copy oneSql and the settings files onto another computer then the stored credentials will not work. This choice is ideal for use in a more secure environment, where for example access to databases is only permitted from select computers and / or locations.

The second choice encrypts the connection password in such a way that you can copy the oneSql folder from your computer, put it onto your laptop, or another computer, and your stored credentials will work fine.

This also means that you can copy oneSql onto a USB Drive, run it from that USB Drive on any Mac, Windows or Linux machine you plug it into.

Licensing:

With the development of oneSql came the development of a new Software Licensing scheme, designed to put customers first and to ensure they we never punish the genuine, fee paying customer for the actions of the software pirate. Our customer friendly, super simple software license is shown below:

‘You can copy and use oneSql on your own personal computers with one instance of oneSql allowed to be in use at any one time. You can put oneSql on a USB device and plug that into anyones computer and use oneSql from the USB device for as long as you need. All Licenses are valid for all supported Operating Systems, all supported Languages and all supported Databases.’

Half price licenses are available to Educational Establishments and Students also Charities and Non Profit Organisations.

Software Referral Scheme:

Also new with oneSql is a Software Referral Scheme. Payment will be made to an existing customer thirty days after a new customer makes a purchase based on an existing customers referral, and quoting the existing customers referral ID within forty eight hours of purchase. The payment amount is ten percent of the new customers spend (before taxes) and the payment will be made via Paypal.

Pricing:

oneSql is available from $30 for the Single User Edition

Availability:

oneSql is available now.

Testimonial:

‘I believe oneSql has found its niche; simple and powerful. Unlike many other SQL Tools oneSql is slim and easy to work with’ – Dennis, Beta Tester

Something Different:

We wanted to do something different to mark the release of oneSql, so we have decided that the first 10 people to purchase any edition of oneSql, with the exception of the Single User Standard Edition, will receive a Limited Edition oneSql mug (1 of only 20 in existence) as well as a goody bag of assorted promotional items and 10% cash back after 30 days. We’ll ship these bonus items anywhere in the world.

The first 100 purchasers of oneSql Single User Standard Edition receive 10% cash back after 30 days.

oneSql is dedicated to Alison Fowler RIP. See ‘ya Ali B. We miss you.

onesqlscreenshot1

chol.technology is the trading name for Steven Cholerton. Since the late 1980’s Steven have been heavily involved in Software Development and Information Technology.

He is a Chartered Information Technology Professional, awarded by the British Computer Society, a Fellow of the Institution of Analysts and Programmers, a Certified Ethical Hacker, an Oracle Certified Professional, author of several eBooks and many Commercial Software Products, and a committed and passionate developer of Custom and Bespoke software for Mac, Windows, Linux, iOS and Android.

Steven personally designed and wrote the R10Cipher file encryption software used by Leeds Institute of Molecular Medicine, Cancer Research UK.

###

busbanner

Affiliate Links

oneSql: New Beta Available

There is a new Beta Edition of oneSql available. This update to oneSql adds an Import Data option to the Tools menu. This new menu option opens the Import Data window where you can setup your import structure.

This is done in the Configure tab of the Import Data window. You can select the type of file that you will be importing (delimited by Tab, Comma or Semicolon), you then select the Database Table you wish to import into.

The next thing is to Double Click the Columns that you wish to update.  Double Clicking in the Available Columns list moves the Column to the Selected Columns list. Double Clicking in the Selected Columns list moves the Column back out to the Available Columns list.

You can reorder columns by selecting the column and dragging it within the list.

imp1

Once you have configured the import to match your import file, click the Import tab. Here you can see we have two buttons.  The first button loads your text file into the import list and the second button marked Save creates the necessary import statements behind the scenes and writes your import file to your database.

imp2

Once the import is complete the import list is cleared and you are told how many rows have been processed.

Note the Checkbox options to ignore the first line (if you are using column headings in your source file) and to remove double quotes (often seen in badly formed import files).

The third tab option, Templates, is not yet implemented. This is where you will be able to save your import configurations and give them a name so that you can retrieve them quickly and use them again at a future time. A potentially very useful facility. Let us know if you would find this feature useful.

madewithxojo

If you are interested in becoming a Beta Tester for oneSql, please click here: http://bit.ly/1lq3kk8

oneSQL Legend

 

 

Blogfooter

 Affiliate Links