Step 3: Preparing the input data file

The data file that will be used for input must have some kind of delimiter or separator. In most cases, you will find that comma-separated variable (.CSV) files are the best choice because they can be edited in Microsoft Excel.

    Requires Free Membership to View

However, they also can be edited with a text editor such as Notepad. On the other hand, you can use a flat-file and a different field delimiter (e.g. the pipeline symbol "|").

Remember, the important thing is to make sure the correct data is in the correct columns and in the correct order.

CSV file being edited in Excel.

Flat-file separated by the | symbol.


 Home: Introduction
 Step 1: Setting the stage
 Step 2: Activating SAPGUI scripting
 Step 3: Preparing the input data file
 Step 4: Recording the data entry
 Step 5: Analyzing the VBS script
 Step 6: Automating the VBS script creation
 Step 7: Running the VBS script program generator
 Step 8: Playing the VBS script to enter the line items
 Step 9: Troubleshooting
 Review: Conclusion and more resources

This was first published in August 2005

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: