Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
chethan_lingaraju
Active Participant

Hello Readers

Ever wanted to know the list of objects in your ATL file before importing?

Custom built VB-Script can do this for you.

Usage:

1. Select all your ATL files, Right click -> "Send to" and choose "ATL Objectlist Generator"

2. Within seconds, a folder with the name "Logs" will be created and you will get task completion notification.

3. Logs folder will have a CSV file containing the names of objects which were in the ATL files.

Configure your right click menu:

1. Start -> run

2. type shell:sendto and press enter

3. Extract the text file from the attachment, paste it there and rename txt extension to vbs.

And you are ready to use !


Explanation:

You must already know that ATL is just a plain text file containing object definitions.

Object definitions will all start with CREATE command and keywords specific to particular object types.

Script opens ATL files in read-only mode, searches for listed keywords and extracts the object name following the keyword.

Keyword List:

KeywordsObject types
CREATE FUNCTIONFunction
CREATE DATABASE DATASTOREDatastore
CREATE __AL_PROJECTProject
CREATE  DATAFLOWDataflow
CREATE PLANWorkflow
CREATE SYSTEM_PROFILESystem Configuration
CREATE SESSIONJob
CREATE __BODI_SUBVARSTORESubstitution parameter
CREATE FILE DATASTOREFile
CREATE TABLETable
CREATE __SAP_EXTRACTORExtractor

With the object list generated, deleting the imported objects becomes much more easier.

Optionally you can have a message box displayed if ATL file contains datastore definitions.

No more blind imports,

Cheers

5 Comments
Labels in this area