1 / 12

Efficient Data Transfer Techniques Between SHIMS and Windows

Join Dr. Ken R. Hall to explore effective methods for transferring data between SHIMS systems and Windows platforms. With over 25 years of application development experience, Ken will provide insights into loading and extracting data using PICK files, creating spreadsheets, and utilizing smart terminal emulators. Discover various extraction methods, including the use of BASIC and PERL for advanced data formatting. Participants will learn practical demonstrations and share best practices in data management. Enhance your skills in electronic data reporting and streamline your processes.

isaura
Télécharger la présentation

Efficient Data Transfer Techniques Between SHIMS and Windows

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Moving Data between SHIMS and WindowsCourse 417

  2. Moving Data between SHIMS and Windows Ken R. Hall, Ph.D. Hyland Technology Group, Inc. Portland, Oregon www.hylandtech.com ken.hall@hylandtech.com 503-702-7841

  3. Speaker’s Qualifications • Ken Hall has over 25 years experience developing applications in PICK, Universe, and Unidata. • Ken developed applications for mail order, manufacturing, leasing, publishing, and distribution businesses. • Ken was the I.T. Manager for a major wholesale distributor who used customized SHIMS.

  4. Learning Objectives • As a result of this presentation, you will learn how to: • Load data into a PICK file from the PC • Extract data from PICK to your PC • Create a spreadsheet from a PICK file • We will discuss: • Other data extraction methods available • Terminal emulators that can assist in data transfer

  5. Presentation Agenda • Introduce the functionality of the smart terminal emulator • Demonstrate moving PC data to PICK • Demonstrate moving PICK data to the PC • Creating a spreadsheet using the tools in a smart terminal emulator • Discussion of other methods like using BASIC to extract data and create emailed spreadsheet • Discussion of other terminal emulators that assist in data transfer

  6. Data Transfer with cut & paste • Most terminal emulators have this functionality • Demonstration of taking data off the screen and pasting into Excel • Demonstration of cutting data from Excel and pasting into a record with ED

  7. Tools to move data • Use tools built into AccuTerm • Demonstrate screen capture to a PC file • Demonstrate AccuTerm Data Transfer Wizard

  8. Smart Emulators • Emulators with smart data transfer require installation of software on PICK host • The emulators with this type of wizard are: wIntegrate, ViaDuct-FX, and AccuTerm

  9. Other methods for extracting data • Custom software using BASIC and PERL • Developed for Universe on Linux • BASIC extracts and formats data with parameters for PERL script • PERL script takes tab delimited data and creates formated spreadsheet which is emailed to list of addresses • Great solution of generation of reports in nightly processing

  10. Lets discuss how you do it • What methods have you found that help extract and report in electronic formats? • What has worked well? • What methods should others avoid? • What emulator do you like and why?

  11. Q & A

  12. Thank You!Ken R. Hall, Ph.D.Hyland Technology Group, Inc.www.hylandtech.comken.hall@hylandtech.com503-702-7841

More Related