DataMagic Technical Column Vol.17

< HULFT Definition Bulk Registration>

Introduction

This time, we will introduce a sample script that allows you to easily set definition information for file transfer software "HULFT."

"HULFT" requires definition information to be created for each transfer file. In most cases, definition information is managed in an EXCEL (CSV) file, but this EXCEL (CSV) file cannot be registered as HULFT 's management information as is.

• You need to prepare a parameter sheet for registering HULFT definition information and register it using the utility.

By using DataMagic, you can register definition information managed in EXCEL (CSV) files directly into HULFT.

This TIPS introduces an example of creating a parameter sheet called "send Management Information" for registering HULFT definition information from a CSV file. Note that in order to use this TIPS, DataMagic must be installed on your computer. For information on where to obtain DataMagic and how to install it, please refer to the separate article "Installing DataMagic."

• DataMagic trial download
• DataMagic for Windows Installation
• DataMagic Manager Installation

How to operate

Step 1 - Prepare the source data

First, prepare the CSV data to be converted. Once the data is ready, save it in the following folder on the PC where DataMagic is installed.
C:\work\SAMPLE17\ (saved with the file name "in")

»Download the source data (Note: The sample file is in zip format. Please unzip it before use.)

Step 2 - Download and configure DataMagic script file

Download the script file below and save it in the folder where DataMagic is installed.
C:\work\SAMPLE17\ (saved as "sample17.igen")

Launch DataMagic management screen and import the downloaded script file into DataMagic. To import, click the [Import Management Information] icon under [Tools] on the start screen. Specify the downloaded file on the Import Management Information screen and click the Import button. The ID SAMPLE17 will then be registered on the Data Processing Information List screen.

»Download the script file (Note: The sample file is in zip format. Please unzip it before use.)

Step 3 - Run DataMagic

Double-click the data processing information ID SAMPLE17 registered in step 2 and check that the file names for the input and output settings are set correctly. Open the data processing information ID SAMPLE17 from the screen and click the "Execute" button at the top of the screen.

Step 4 - Check the execution results

When execution is complete in step 3, a file called "out" will be created in C:\work\SAMPLE17\, which is specified in the output settings. Please check this file using an editor such as Notepad.

lastly

This time we converted the "send Management Information" from HULFT management information, but "receive Management Information," "Detailed Host Information," "Transfer Group Information," and other information can also be easily converted using DataMagic.
Please download DataMagic trial version and try out the technical column explanations.

• The trial version is free to use for 60 days.
• After you sign up for the trial version, you will receive 90 days of free technical support.

• DataMagic trial download

DataMagic Column List

Related Content