Partially duplicating a record

In a scan-and-shred type of database, I often find myself wanting to duplicate everything except the image or object field. For instance, I may be filing bank statements, where all the details are the same as last time except for the date and the scanned image itself. Here’s a macro that does this.

Set rec=ActiveRecord
AddRecord
Set recNew=ActiveRecord
For Each fld In rec.Fields
 If fld.Definition.Type=cbxFieldTypeText Then
  recNew.Fields(fld.Definition.Name)=fld
  End If
 Next

I save this macro in the “This Database” section, under the name “Partial Duplicate”. Then, to make things easier for myself, I edit the native format of the database, do Tools > Keyboard, and associate Ctrl+D with playing the “Partial Duplicate” macro. Since Ctrl+D is normally Cardbox’s own shortcut for File > Duplicate Record, this means that I don’t have to change my typing habits.

One refinement: one of my fields, called NUMBER, has an auto-numbering validator in it. If I duplicate that field, the new record will have the same serial number as the old – which I don’t want. So I add the following line at the end of the macro:

recNew.Fields("NUMBER")=""

Now the field will be blanked out, and Cardbox will number it automatically when I save the record.

Cardbox and Apple Macintosh

Cardbox is a Windows program. The Mac is not a Windows computer. These two facts have been a source of frustration to many people for a long time.

We have now done extensive work to make sure that Cardbox is compatible with CrossOver Mac, a product that lets Windows programs run on the Mac without the need to install Windows itself.

The Knowledge Base page now has a “Macintosh” section giving advice on installing and using Cardbox with CrossOver Mac.

If you haven’t already got CrossOver Mac, you can download a trial version.

If you already have a Cardbox licence and want to try all this, you’ll need the very latest build of Cardbox, Build 4259, which you can download here.

If you haven’t already got Cardbox – or you want to get a friend with a Mac to try it out – read about our special offer.

If you have any comments or questions, please visit the Feedback on the Mac page on the Cardbox Everywhere blog.

Lightweight e-commerce with Cardbox

A small business, or a business whose main activity is not e-commerce, can run into trouble when selling things on the Web. Either it sells everything through a third party (Amazon for books, Handango for downloads, or even eBay) with high transaction costs, unfavourable contract terms, and hidden risks, or it pays a lot of money for a fully e-commerce-enabled web site when all it really needed was the ability to process a dozen or so transactions a day.

The Universalis case study shows how it is possible to start a small e-commerce business at virtually no cost (just the application fee for the credit card processor) and with virtually no programming (just a single Cardbox macro to process the orders as they come in by email).

This lightweight semi-automated approach is secure, fraud-proof, and requires very little time to manage.

Symbol fonts in Cardbox

When you choose a font in Cardbox, it offers you a choice of all the normal fonts on your computer. By “normal fonts” we mean the ones in which letters look like letters. For instance, w might look like this:

A symbol font is one where the symbols you see don’t look anything like the letters you type. Here is the letter w as displayed in various different symbol fonts:

Cardbox/S3 photographic archive

The Amazon S3 discussion forum has a thread on using S3 for photographic archiving. Cardbox and S3 make an ideal match for this.

You can have a Cardbox database on your computer that indexes all your photographs (on as many criteria as you like) and contains a low-resolution copy of each photograph (“low-resolution” means whatever you want it to mean – thumbnail, or 320×200 or 640×480 or 800×600) so that you know exactly what you’re talking about. Each record will also have a link to your original high-resolution picture stored on Amazon S3: the link can be of a kind that is inaccessible to anyone but you. Our previous post tells you more about using Cardbox in conjunction with S3.
Basically, to do this you’d need nothing more than Cardbox plus your own Amazon Web Services / S3 account.

A few bonuses:

• If you want one of your customers to be able to download a photograph, you can give them a link to the high-res version: the link can expire automatically at a set time.
• If it’s appropriate, you can even give your customers read-only access to one of the databases. This will let them view your low-resolution pictures and identify exactly the ones you want.

We’ve created a simple sample database that will show this in action. This page has a link that lets you download the database, and it has full instructions on how to get going with your own photogaphic archive.

Amazon S3 and Cardbox

The project to add Amazon S3 facilities to Cardbox has been completed. (If you’re not familiar with Cardbox then you can read about it here and get a free 1-month trial licence here).

Amazon S3 is storage for the Internet. Secure, reliable and cheap, it can be used to store any amount of data, at any time, and retrieve it from anywhere on the web. There is no sign-up fee and you pay only for the storage you actually use.

In the new build of Cardbox that is released today, we have incorporated the following features to make use of S3:

The Cardbox Server (used in multi-user and networking systems) can be configured to back up your databases automatically, at specified intervals, to your S3 storage space. There is no interruption in service during a backup, because the Cardbox Server can back up a database even if it is in use. You can have a single backup copy of the latest version of each database, or you can have a separate backup made each time that the database has changed.

Cardbox itself has a new command that lets you view your S3 storage space and upload, download or delete files. Apart from managing the Cardbox Server’s backups, this also allows you to make backups of files on your own computer.

Cardbox’s VBScript macro system has been expanded to allow you to manage your S3 storage space programmatically. This offers interesting prospects for the future: for instance, a photographic database that stores and displays each photograph at a reasonable screen resolution while the original full-resolution images are held in an archive on S3.

Bar codes and Cardbox

Cardbox can print bar codes in various formats: what about reading them?

There are many barcode readers on the market in a variety of shapes and sizes, and we can't really advise you which one to buy (you have to choose what suits you best), but as far as Cardbox is concerned, they all work in essentially the same way. You scan a code, and the reader interprets the code and "types" it in to your computer just as if you had typed it on the keyboard yourself.

One feature that is definitely worth looking for is the ability for the reader to type extra keystrokes before and after the actual interpreted barcode. Manufacturers often refer to these as "preamble" and "postamble" keystrokes.

Amazon S3 and Cardbox

Amazon S3 is storage for the Internet. Secure, reliable and cheap, it can be used to store any amount of data, at any time, and retrieve it from anywhere on the web. There is no sign-up fee and you pay only for the storage you actually use.

This posting describes how we are enhancing Cardbox to take advantage of the facilities that Amazon S3 offers.

If you don’t already know Cardbox, it’s a fast, straightforward database designed for end users. Anything you can list, Cardbox can store. Its particular strengths are powerful text indexing and the ability to attach photographs and scanned documents to every record. Cardbox is used by everyone from individuals and small businesses to multinationals and United Nations agencies, and there are Cardbox users on every continent including Antarctica. The Cardbox web site tells you more.

New sample: looking up Amazon data

The macro for looking up data in Amazon is now complete, and you can read a description and download it from here, together with an empty sample database for you to experiment with.

Anyone who has to maintain a database of books will find this useful (at least if the books are new enough to be listed on Amazon) and the principles behind the macro can be applied in other situations where you want to fill in Cardbox data from an online search.

The Cardbox email archive

It’s done, and I’ve extracted 46,000 emails from our archives and imported them into a Cardbox database. It took 8 minutes in all, and every word in every email is indexed for fast retrieval. The Cardbox database is 231MB in size.

I won’t be posting a public spam database yet because of the trouble of going through it to make sure that nothing private has found its way in accidentally, but if anyone wants to see one then let me know: I’ve now set up a dummy email address specifically for spam and nothing else, and once the spams start coming in I’ll look at making a Cardbox database out of them.