Skip to: Site menu | Main content

Email Facebook LinkedIn Twitter Google

Blog...

HOW-TO: Generate Large Files

Simple Windows command-line to generate files for testing:

fsutil file createnew <filename> <length in bytes>

Transfer Contacts from LG VX9200M to iPhone 4

Accidently wiped contacts on wife's new iPhone 4 (previous phone was an LG V9200M)

NOTE: Using the same steps below should work on any phone that is supported by BitPim

  1. Download / Install BitPim (http://www.bitpim.org/)
  2. Plugin LG phone via USB cable
  3. Choose "Data" on USB device settings (shows on phone screen)
  4. Open BitPim
  5. Select Find Phone (phone with magnifying glass in main BitPim toolbar)
  6. Enter a title for the phone profile when prompted
  7. Select Get Phone Data from main toolbar
  8. Check PhoneBook (Wallpaper selection also retrieves images stored internally and any SD cards)
  9. After Get Phone Data complete, you can verify the phone book entries by selecting the PhoneBook node
  10. Click File > Export > vCards (vCard v2.1 is ok)
  11. After exporting the contacts to VCF you may close BitPim
  12. Open Windows Contacts (Windows 7) (%USERPROFILE%\Contacts)
  13. Select Import > vCard > vCard (VCF file)
  14. Select the BitPim exported VCF file created earlier
  15. Windows Contacts will require you to OK each entry
  16. Plugin the iPhone, should automatically start iTunes
  17. Goto the Info tab from the device info screen
  18. Check Sync Contacts with:
  19. In the selection box select Windows Conctacts
  20. Sync the iPhone

Javascript SCORM API

For anyone that's tried to wade through the mountains of SCORM documentation it can be a little frusrating trying to put all the pieces together.

This is useful if you want to get interaction data out of products like Adobe Captivate, Adobe Presenter, or Articulate.

So I'm providing a very simple SCORM 2004 javascript API that will hopefully be a useful starting point for anyone trying to implement an LMS or SCORM data collector.

<script type="text/javascript">
    window["API_1484_11"] = {
        Initialize: function(parameter) {
            console.log("Initialize: parameter=" + parameter);
            return "true";
        },
        Commit: function(parameter) {
            console.log("Commit parameter=" + parameter);
            return "true";
        },
        Terminate: function(parameter) {
            console.log("Terminate parameter=" + parameter);
            return "true";
        },
        GetValue: function(parameter) {
            console.log("GetValue parameter=" + parameter);
            if (parameter.toLowerCase() == "cmi.completion_status")
                // Default response
                return "incomplete";
            return "";
        },
        SetValue: function(paremter_1,parameter_2) {
            console.log("SetValue: paremter_1=" + paremter_1 + " | parameter_2=" + parameter_2);
            return "0";
        },
        GetErrorString: function() {
            console.log("GetErrorString");
            return "";
        },
        GetDiagnostic: function() {
            console.log("GetDiagnostic");
            return "";
        },
        GetLastError: function() {
            console.log("GetLastError");
            return "0";
        }                
    };
</script>

This script needs to be on the page that launches the SCORM compliant presentation.

Click here to download a demo presentation (MUST BE LAUNCHED FROM A WEBSERVER / WILL NOT WORK IF LAUNCHED DIRECTLY)

Combine/Merge Tables in Access 2010

The following is a very basic merge, it assumes the data structure is the same for all combined tables.

  1. Select the first table within Tables Pane
  2. Copy the selected table (CTRL+C)
  3. Paste the copied table into the Tables Pane (CTRL+V)
  4. The Paste Table As dialog will appears
  5. Ensure the Structure and Data option is selected, select OK
  6. Open the newly copied table in Design View (Right-click > Design View)
  7. Drop all AutoNumber fields, Primary Keys, and Foreign Keys
  8. Save the changes to the copied table
  9. Copy the new table (CTRL+C)
  10. Paste the new table into the Tables Pane (CTRL+V)
  11. The Paste Table As dialog will appear again
  12. Type the name of the table that will recieve the copied data
  13. Ensure the Append Data to Existing Table option is selected, select OK

Using this method Access provids no feedback on the results of the merge.

Quick and dirty!

Change Coldfusion Temporary Files Location Used by GetTempDirectory()

I wanted to change the default location Coldfusion uses for temporary storage when using:

<cffile action="upload">

This meant changing the default location returned by GetTempDirectory()

EDIT %CFusion%\runtime\servers\coldfusion\SERVER-INF\jrun.xml Comment this line:

<attribute name="temporaryDirectory">{jrun.server.rootdir}/SERVER-INF/temp</attribute>

Add this key:

<attribute name="temporaryDirectory">{YourFullTempFolderPath}</attribute>

So that you have this:

<!-- <attribute name="temporaryDirectory">{jrun.server.rootdir}/SERVER-INF/temp</attribute> -->
<attribute name="temporaryDirectory">C:\ExampleCustomTempPath</attribute>

RESTART the Coldfusion Application service

NOTE: Coldfusion will create a subfolder in the temporary directory named wwwroot-tmp

Android Emulator Virtual Hosts with IIS

I do most of my development locally (using my local IIS webserver). My local webserver makes use of host headers to host multiple development sites on a single IP. After reading several articles and blog entries I was unable to find a good solution to allow using host headers with Android. The emulator can access the host machine out of the box on 10.0.2.2, but that will only show you the default IIS site.

Tom Deryckere's article (http://www.mobiledrupal.com/content/using-virtual-hosts-android-emulator) explains how to get host headers working on the emulator, but I didn't want to run terminal commands every time I launched the emulator or keep updating my host file across mulitple emulator images (I'm really lazy.)

The solution was pretty simple and I'm embarrassed that I didn't think of it before. I simply added another binding entry to a new port:

In IIS Manager:

  1. Select the site you want to access
  2. Click 'Bindings' in the right side Actions pane
  3. Click 'Add...' on the Site Binding dialog that is displayed
  4. Give the site a any valid port number that is not currently in use (example 9191)

Now in the Android emulator you can access your site using http://10.0.2.2:9191

Copy Table Schema with SQL Server Management Studio

Quick way to copy the table schema using SQL Server Management Studio:

  1. Right-Click table to copy
  2. Script table as
  3. CREATE To
  4. New Query Editor Window
  5. Find & Replace all instances of the table you are copying with the table you wish to create

NOTE: Pay attention to any Primary Key and Foreign Key indexes listed in the SQL script. They may require updating as well.

Leadership Tulsa

I was accepted to Leadership Tulsa Class 42 in June.

It's a great program designed to develop community leaders. They are attempting to groom/prepare people for volunteering and operating programs that help or enrich the Tulsa community. Last month was "Government Day" where we heard from Tulsa's (then) mayoral candidates and learned the role local, state, and federal goverment plays in community development. This month was "Education Day" we toured several community schools in the Tulsa area and learned about the challenges facing the Tulsa area education system.

Tulsa has some really great educational institutions. I always assumed that the Oklahoma public education system was broken. These schools are really taking steps to ensure that kids actually learn. The state of education is leaps and bounds above what it was five years ago.

There are so many inovative programs that I wish had been available to me when I was in grade school.

[More]

Stopped Again.

This is starting to become more and more frequent:

I'm coding along, making excellent progress on a project only to be stopped dead in my tracks by yet another Coldfusion limitation.

I love Coldfusion, but all the stripped down and half-assed features are starting to get in my way.

[More]

Quick CF Builder Beta 2 Note.

I installed the standalone Beta 1, downloaded Beta 2 today and it noticed the standalone install was disabled. I uninstalled the previous version and the reinstall picked up my workspace. My guess is because it was in the default location (Vista x64 Ultimate):

C:\Users\%USER%\Adobe ColdFusion Builder workspace

More Entries