This website is not affiliated with, sponsored by, or approved by SAP AG.

Data transfer for specification data

All postings related to (EH&S) only

Moderators: Snowy, thx4allthefish, Craig

Data transfer for specification data

Postby psquare » Wed Mar 10, 2010 1:13 am

Hello EH&S guru's,

The standard import transactions for specification data expect so-called ".dat" files.
You can imagine to build up such files can be cumbersom.
I know that technidata can deliver a conversion tool for this. They as a fee,licence for that.

I heard that there are tools in ACCESS available, however I cannot find them.

Does anybody have such a tool?
It would be very helpfull at a project I am working in.

Thx in advance and kind regards,

Psquare
psquare
 
Posts: 220
Joined: Tue Aug 14, 2007 7:45 am

Re: Data transfer for specification data

Postby Craig » Wed Mar 10, 2010 7:18 am

I'm not an EH&S guy, (yet), but I have worked with Access, (if you are talking about MS Access).

I'm not sure exactly what tools you are looking for. I'm assuming you mean you want to build .DAT files for loading to SAP?

What is the source of your files to start with.

If you know the format of the .DAT files you can created load files from Access but you have to basically design and build the process in Access to do that. I often use Access to collect, cleanse and create load files for the QM area. I haven't done anything in EH&S thought with it.

Craig
Craig
 
Posts: 5504
Joined: Sun Oct 20, 2002 11:07 pm
Location: Heading back to the Milky Way...

Re: Data transfer for specification data

Postby psquare » Mon Mar 15, 2010 12:47 am

Hi Craig,

You are right. I normally also do this. I am myself a PM/CS consultant. Within this area it is for me simple to build up load files from the old legacy system to SAP. This because the standard tooling like LSMW is easy to use and also tab-delimited flat files are accepted.

However the standard migration tools for EH&S objects like Phrases, Properties of substances, are using so-called .dat files is a specific structure. In SAP help this structure is explained.

The source data is a tab-delimited flat file. I once read that somebody created a MS-ACESS tool to transfer this data into a .dat file. Can't find it aynore though. So that's why I raised the question of such an access tool.

So I am hoping if somebody is willing to share his tool with me.

Regards,

Psquare
psquare
 
Posts: 220
Joined: Tue Aug 14, 2007 7:45 am

Re: Data transfer for specification data

Postby Craig » Mon Mar 15, 2010 3:22 pm

I haven't heard of anything like that myself, but hopefully someone else here has. But again, I'm not an EH&S guru.

Craig
Craig
 
Posts: 5504
Joined: Sun Oct 20, 2002 11:07 pm
Location: Heading back to the Milky Way...


Return to Environment, Health & Safety (EH&S)

Who is online

Users browsing this forum: No registered users and 1 guest





This website is not affiliated with, sponsored by, or approved by SAP AG.