Alpha Video Training
Results 1 to 5 of 5

Thread: copy selected records to usb flash drive

  1. #1
    Real Name
    Francis Dizon
    Join Date
    Jan 2006

    Default copy selected records to usb flash drive

    hi to all,

    What's the best approach in exporting selected records into USB flash drive, then upload those records into another computer with the same application from that usb drive?

    tia for suggestions

  2. #2
    Real Name
    Garry M Flanigan
    Join Date
    Jul 2004
    Melbourne, Australia

    Default Re: copy selected records to usb flash drive

    Export records as say a csv file then import.
    I tend to export/import using purpose written xbasic scripts but you may well be able to use the genies to achieve what is required. You have not provided much info so it is hard to be specific.

  3. #3
    "Certified" Alphaholic
    Real Name
    David Kates
    Join Date
    Apr 2008
    Unionville, ON

    Default Re: copy selected records to usb flash drive

    What about creating a "tranfer" table on the flash drive. Then create a "copy" operation to copy records to that table.

    You can then attach that table to the destination database and run another copy operation to get the records from the flash drive.

  4. #4
    "Certified" Alphaholic Clunes's Avatar
    Real Name
    Mark Pearson
    Join Date
    Jan 2010
    Brisbane, Queensland, Australia

    Default Re: copy selected records to usb flash drive

    I would consider creating an export file using the operation process (CSV is a good one). Then I would convert this a xbasic scipt. I would then modify the script for the user to select a drive and create a file name to save the file to. You can do this using the the browse for folder() function to get the directory, then ui_get_text() to allow the user to name the file. Replace the export file name with this variable and it will export to it.

    To import the file back, do a similar approach.
    Mark Pearson
    Youtube channel

  5. #5
    Real Name
    Eric Ruff
    Join Date
    Aug 2007
    Pleasant Grove, UT

    Default Re: copy selected records to usb flash drive

    Are you concerned at all about protecting the data, being that you will be copying tables (potentially sensitive) to a USB drive that could be used for other purposes? If so, consider this:

    It's a totally free (personal or commercial) encryption package that is fast, simple, and quite secure. You can create a folder (and you can assign a drive letter to refer to that folder, if you wish) and then whatever you copy into it is secure. This works for any drive, including USB "thumb" drives.
    Last edited by EJR; 11-15-2010 at 05:46 PM. Reason: typos
    There are three kinds of people in the world: those who can count, and those who can't.

Similar Threads

  1. Run A5v10 runtime from USB memory device or drive
    By Mike Wilson in forum Alpha Five Version 10 - Desktop Applications
    Replies: 4
    Last Post: 04-03-2010, 10:01 PM
  2. Running Alpha 5 V9 from External USB Drive
    By WaltMorgan in forum Alpha Five Version 9 - Desktop Applications
    Replies: 20
    Last Post: 09-17-2009, 04:31 AM
  3. U3 Flash Drive
    By forskare in forum Alpha Five Version 7
    Replies: 6
    Last Post: 11-22-2006, 08:37 PM
  4. Configure USB Flash Drive in Win98SE?
    By MoGrace in forum Alpha Five Version 6
    Replies: 6
    Last Post: 06-21-2006, 06:55 PM
  5. Build table of all folders on a selected drive
    By crimmelcp in forum Alpha Five Version 7
    Replies: 3
    Last Post: 02-16-2006, 10:36 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts