Skip to Content
Author's profile photo Chethan Lingaraju

Objects in ATL file

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”

01.PNG

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

02.PNG

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

03.PNG

Configure your right click menu:

1. Start -> run

2. type shell:sendto and press enter

04.PNG

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

05.PNG

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:

Keywords Object types
CREATE FUNCTION Function
CREATE DATABASE DATASTORE Datastore
CREATE __AL_PROJECT Project
CREATE  DATAFLOW Dataflow
CREATE PLAN Workflow
CREATE SYSTEM_PROFILE System Configuration
CREATE SESSION Job
CREATE __BODI_SUBVARSTORE Substitution parameter
CREATE FILE DATASTORE File
CREATE TABLE Table
CREATE __SAP_EXTRACTOR Extractor

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

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Deepak Mohanty
      Deepak Mohanty

      Thanks!

      Author's profile photo Bhanu Prakash
      Bhanu Prakash

      Helpful one chethan thanks!

      Author's profile photo Former Member
      Former Member

      Dear Chethan,

      Very nice and helpful article.

      Author's profile photo Deepthi Ramani
      Deepthi Ramani

      Where can I see the VB script please?

      Author's profile photo Simone Crespi
      Simone Crespi

      Hi everybody, I can't find the file ATL Objectlist Generator?

      Thanks

      Simone