regarding importing jobs from datastage manager

vijaykumar · Post by **vijaykumar** » Fri Jan 05, 2007 1:25 pm

Hi Gurus,
my team mate has exported some of the jobs in xml format.
i need to import these jobs. These jobs are in XML FORMAT.
he exported the jobs as zipfile. i unzipped, extracted all the jobs which are in XML format into new folder which i created.
i went to manager and tried to import the jobs using datastage manager.
i did import---->Datastage components(xml)---> i specified the path.
i checked-import only selected components.
when i try to import iam getting error-
ERROR LOADING FILE,LINE 0, SOURCE=''
REASON=THE FOLLOWING TAGS ARE NOT CLOSED, DS EXPORT,JOB ,RECORD,COLLECTION, SUBRECORD.is there something i have to do so that i can import or tell my mate to export the jobs again.

plz help me Gurus.

cheers;
vijay

narasimha · Post by **narasimha** » Fri Jan 05, 2007 1:36 pm

If I were you, I would ask them to resend, rather than break my head with the error.
If the successive exports had the same problem, then would start looking into resolving it.
Or you can wait for somebody here, who has resolved such an issue.
Its your call.

I_Server_Whale · Post by **I_Server_Whale** » Fri Jan 05, 2007 1:42 pm

There is this POST. But, I guess it deviates from the issue here.

Like Narasimha suggested, I would say, request for a resend. If that doesn't work, then get back.

Whale.

vijaykumar · Post by **vijaykumar** » Fri Jan 05, 2007 1:44 pm

Hi Gurus,
i tried to export another job, i exported successfully, where can i view the exported job. i mean where is the exported job stored which folder.
beacuse once i can view this exported job,i want to view this job in my designer. plz help me gurus.

cheers;
vijay

us1aslam1us · Post by **us1aslam1us** » Fri Jan 05, 2007 1:48 pm

Vijay, You need to tell us where have you stored the Export?. When you do an export it will ask for a location where it should get stored.

I_Server_Whale · Post by **I_Server_Whale** » Fri Jan 05, 2007 1:49 pm

Can you work on framing your questions? That would be appreciated.

vijaykumar wrote:Hi Gurus,
where is the exported job stored which folder.

vijay

In the path you mention(In the text field "Export to File"), when you export it. The job you exported will always be available in your repository. The job does not vanish once you export it.

Whale.

vijaykumar · Post by **vijaykumar** » Fri Jan 05, 2007 2:01 pm

Hi Gurus,
iam sorry, i used the word export instead of import.

i imported these jobs. These jobs are in XML FORMAT.
these jobs are stored in zipfile. i unzipped, extracted all the jobs which are in XML format into new folder which i created.
i went to manager and tried to import the jobs using datastage manager.
i did import---->Datastage components(xml)---> i specified the path.
i checked-import only selected components.
now i successfully imported the jobs.
when i try to import it just asks the path where i want to import from.
where are these jobs which are imported stored.
i want to call these jobs which i imported into my designer component.
plz help me gurus and sorry for that i used the word export instead of import.

plz help me gurus.

cheers;
vijay

chulett · Post by **chulett** » Fri Jan 05, 2007 2:11 pm

So... you've successfully imported them but can't find them? That's not all that unusual as the Import doesn't show you the Category, you have to know it. And if you don't know, ask whomever you got the export from. We sure can't tell you.

Or try this from the Administrator:

Code: Select all

SELECT CATEGORY FROM DS_JOBS WHERE NAME = 'JobName';

us1aslam1us · Post by **us1aslam1us** » Fri Jan 05, 2007 2:12 pm

Path will be your xml export file in your new folder(which was created by you when you unzipped the extract). When you do the import, you jobs will be available in the designer.

vijaykumar · Post by **vijaykumar** » Fri Jan 05, 2007 2:18 pm

Hi Gurus,
i tried to import these jobs,after loading all the components, iam getting message
import from c\documents\temp header.dsx

name type status
p_header job-design not present.

i clicked ok. but iam not able to view the job which i imported in my repository.plz gurus help me, i want to call this job in my designer so that i can analyze the design.plz help me.

cheers;
vijay

ray.wurlod · Post by **ray.wurlod** » Fri Jan 05, 2007 2:19 pm

When DataStage compoents are exported, the person performing the export specifies the pathname of the export file (whether DSX or XML format). That is where it (the export file from which you need to import) is stored.

Saama · Post by **Saama** » Fri Jan 05, 2007 2:26 pm

hi gurus,
can't we view in designer the job which they created.one of my friend said that as we import the job it is stored in saperate category in the designer and thereby i can view the job which i imported.
is this is not possible in datastage to view the job in designer, i mean cant i view in designer.

cheers;
vijay

chulett · Post by **chulett** » Fri Jan 05, 2007 2:28 pm

vijaykumar wrote:i checked-import only selected components.
now i successfully imported the jobs.

My answer was based on your assertion that you 'successfully imported the jobs'. [sigh] You really do make it difficult to help you at times, you know.

I_Server_Whale · Post by **I_Server_Whale** » Fri Jan 05, 2007 2:46 pm

Saama wrote:one of my friend said that as we import the job it is stored in saperate category in the designer and thereby i can view the job which i imported.

No, They won't go into a seperate category. They will go into the category in which they were originally in.

Also, If you had the designer open during the import, you won't see the imported jobs unless you refresh your repository view.

Also, last but not least, but certainly with an intention to help you, you refer to yourself as "i" instead you should be using "I".

"I", when referring to oneself cannot be in lower case "i".

Whale.

ray.wurlod · Post by **ray.wurlod** » Fri Jan 05, 2007 2:53 pm

Maybe "i" isn't very tall?