Phrase set import

[former_member212503]

I successfully imported phrase and phrase set in application server through cg3z . Also phrase was imported successfully through T code cg31 but when I tried to import phrase set using the same t code cg31 , it gave me an error message like below

[Ralph_P · Accepted solution]

Hi Krishna,

I'm not sure whether your question is answered in the meantime. So let's summarize:

1. The library date in your transfer file cannot be older than the library date in the system. That is the entry CATDATE in the transfer file.
2. If you want to import phrase set assignments, in the import parameters check the field phrase set assignment
3. I am not sure whether you can create phrase sets that way, I think you cannot. So they have to already exist in the target system.
4. You merge phrases to bring them from tha passive library (e.g. CED) into the active one (e.g. CUST). Only phrases in the active library can be assigned to a phrase set! Since it is also good practive to only import into a passive library, the way forward is:
   1. Import phrases into passive library
   2. Merge phrases into active library
   3. assign phrases to phrase sets via import
5. If you want to update phrases, import them again into the passive library (where the old version of the phrase already exists), then merge them again. You do not have to re-assign the changed phrase to a phrase set.

Ralph

[former_member212503 · Accepted solution]

Thank you Ralph,

I will try this way .

Regards,

K G

[former_member212503 · Accepted solution]

Hello Ralph,

While doing the phrase set assignment for below activity , do we use phrase file  or phrase set file from the application server .

1. assign phrases to phrase sets via import- which file to use > I guess phrase set right ? If we have date issue then can we change the date in  the file or do we have to change the date in the config in the library . let me know the best approach as I am having issue while doing phrase set assignment which says the date in the file is older then what we have in the system for the Library .

regards,

K G

[Ralph_P · Accepted solution]

Hi Krishna,

for importing phrase set assignments you certainly need the phrase set assignment file. But first the phrases have to be imported and merged.

You cannot (or at least should not) change the catalogue date in the system; always change the date in the import file.

Ralph

[former_member212503 · Accepted solution]

Hello Ralph,

There are actually 3 dates in the system . Do you think we have to change all three dates or only CATDATE. Also for one scenario if we have already phrases present in CED , then we might not want do full import right . In that case after we do update ,  how can we merge the upated one and not the existing one and do phrase set assignment ?

Regards,

K G

[Ralph_P · Accepted solution]

Hi Krishna,

CATDATE is the right one.

From what I heard: NEVER DO A FULL IMPORT! Admittedly, I'm not sure why, that's just what I was told repeatedly.

Regarding the merge of the updated phrases: Simply create a hitlist in CG12 containing only those phrases that were updated (and all those that are new) and merge them. Then you can import the phrase set assignments.

Ralph

[former_member212503 · Accepted solution]

Also I tried to change the  date in upload file making it more recent than the library file but looks like it has some incorrect Delimiter +EOF error showing now .

Regards,

K G

[Ralph_P · Accepted solution]

Hi Krishna,

Hmm, for one, judging by your earlier screenshot you opened the file with Excel. Bad idea as now you have all these #NAME? entries. If you want to open the file use a text editor.

Then: Seems to me you tried to import the fileas a dat-file. That doesn't work. You need to change the file name extension from .dat to .pit, so the system can recognize it as a phrase file. .dat is for specifications only.

Ralph

[former_member212503 · Accepted solution]

Thank you Ralph.

Regards,

K G

[christoph_bergemann]

Dear S P

we are not useing import to assign phrase sets. Only an idea:

Data for the Phrase Library - Basic Data and Tools (EHS-BD) - SAP Library

I believe the import file must specify a phrase library. It seems to nbe a "conflict" in date information. Check the link.

C.B.

Check:

[Former Member]

Dear S P,

To my knowledge, SAP does not have an option to export and import phrase sets. SAP allows to export and import ONLY phrases and while doing it, we can decide if phrase set assignment to the phrases to be exported and imported or not, along with the phrases.

While exporting phrases using CG12 transaction, if you select 'Phrase Set Assignment' option, then the phrase set(s) assigned to the selected phrase(s) will be written into the data transfer file, as shown below.

+EC

+BV   $ESTPJ

PHRSEL                         Z_TEST_PHRASE_SET

PHRID                          Z_TEST_PHRASE

ORD                            9999

+EV

While importing phrases using CG31 transaction, if you select 'Phrase Set Assignment' option, then the the phrase set(s) from the data transfer file will be loaded into the target system for the phrases.

Regarding the message you received, as C.B said, there could be an issue with the date for phrase library. You can find the phrase library date in the data transfer file, as shown below.

+BV   $TCG61

CATPIN                         CUST

CATDIST                        TEST

CATDATE                        20070101

CATVERS                        1.0

NUMRNGE                        ESN_PHRID

+EV

CUST is the phrase library here.

The system compares the phrase library date between the data transfer file and the target system. The system gives the information message after the date check. I believe the phrase library date in the data transfer file is older than the phrase library date in the target system.

You can compare the phrase library dates in the file and the system or you can still click on 'Continue' button, then the system will display the dates from the file and system on the same screen.

You can then verify the phrase library and carry out the import activity.

Thanks and Regards,

Kannan Veerapandian.

[former_member212503]

Hello Kannan,

Correct me here . I changed the  earlier than the date in the load file and it worked that way . So phrase and phrase set will load through cg3z and we use cg31 to import phase and while loading phrase we click phrase set assignment that way all the phrases will get assigned to Phrase set from the Application Server and bring into EHS . Am I right as I was not able to assign to phrase set through CG31 . Can you help me in this .

Regards,

P S

[former_member212503]

Quick Qn to C . B .

When we do merge , the phrase which is merged will be under Cust Library right . I was not able to find the phrase set assiged to the phrase which has passive library . I What I though initially was if we merge phrases then the same phrase library eg CED would get the same phrase the phrase set assigned but I have to search in CUST and put CED* to see the phrase set assigned . Does this how phrase set gets assigned through cg31 and assign to the active library .

Regards,

P S

[former_member212503]

To  C B / Kannan ,

For the date mismatch I changed the date in the active phrase Library to old dood practice ata and imported but was that a good pratice . If we want to upload old version of phrase library then what seetings we need to do to import that . Any Idea ?

Regards,

P S

[Former Member]

Hello S P,

If you are not able to assign to phrase set through CG31, please verify if you have done the below steps correctly.

1. While exporting phrases using CG12 transaction, did you select 'Phrase Set Assignment' option?

2. If you had done the step 1 correctly, then the phrase set(s) assigned to the selected phrase(s) would have been written into the data transfer file. Please check if the phrase sets are available in the load file (as mentioned above), which you use in CG3Z.

Regards,

Kannan Veerapandian.

[christoph_bergemann]

Dear Krishna

IMport of phrase: some general remarks:

let us use the worst" exmaple color; e.g. you have define the color "Greene" (instead of "green") (it is a very bad example); no you received a correction and you would do the upload.

a.) you do not change the library; it is just an update of phrase text

b.) for phrases you have other "options" in regards of "change management" (e.g. change number)

So the library from customizing point of view is always the saem; either an active or passive library; it does not make sense to update the "date" of the library only becuase of geh fact that you import phrases

Different story is if you do not "update" phrases via import buit import new ones. From user etc. perspective the same is true: why shoulkd I update the "date" of library ? There is no direct link of new phrase to the libraryr; therefore netgher had the need to change the "Date" of library

Some is true if you update "phrase sets";

Coming back to something different: you can do uploads uf phrase in "active" and "passive" catalog; by design there is only one active catalog; it depends now a little but about your "daily" practise;

Let us make a fictive example: your active library is called "ACTIVE" and you get phgrase update by data provider; you do not upload the update to active direct but to passive catalog. E.g. like "SAP".

Then you check the content and "merge" passive with active

The whole processs (you use or you have designed9 is based on your needs; but in the upper case (that means yiou use passive catalog for update) then there might be some good reason to use different "date"; but if so (if I remember correct) you need to create new passive catalog. And this does not make sense on long term;

As this processis completely company specific no clear guidance is possible

C.B.