topic Re: Please help!!!! dataload problems for G/L in Application Development and Automation Discussions

Please help!!!! dataload problems for G/L

Former Member — Sun, 17 Oct 2004 15:17:05 GMT

Hi everyone I could really need your help with this.

I have to get a Greek General Ledger dataload into SAP. Unfortunately it contains Greek chracters in the excel file and I copy and paste the entries into notepad and save it as Unicode.

When I try to upload the file the program errors and says that the file is empty?

Has anyone done this before or does anyone have any ideas?

I've saved the file as a unicode .txt file file on windows XP and when you open the .txt file you can see Greek characters.

Yet when I load it into SAP via a custom dataload program I get error:

'Input file /home/gr1adm/dataload/greece/dataload/zinlfi01.txt is empty'. Which is a Message no. ZB 023.

What a Blinder!

Re: Please help!!!! dataload problems for G/L

Former Member — Mon, 18 Oct 2004 08:28:19 GMT

Hi Steven,

A thought, did u check the Regional & language Option in control panel. Just a try....

Re: Please help!!!! dataload problems for G/L

Former Member — Mon, 18 Oct 2004 11:38:32 GMT

Yep,

tried that already!

Come on you dozy guyz! One of you must know!!!

Thanking you kindly.

Re: Please help!!!! dataload problems for G/L

Former Member — Mon, 18 Oct 2004 11:47:30 GMT

Steven,

Did you try LSMW for this load? I was doing all my loads via LSMW for last couple of years. There is a object for G/L and you will have better possibility to see what you are reading from file too. Use tab delimited format, which is easy to make from excel file.

Re: Please help!!!! dataload problems for G/L

Former Member — Tue, 19 Oct 2004 08:55:18 GMT

Hi Steve,

In addition to what others have recommended you could try this:

The codepage for Western European Characters is 850 and for Greece the required codepage is 737.

If you check table TCP00 then this will provide a list of the possible codepages within SAP. If the Greek codepage does not exist here then you'll have problems.

I could not find anything that correlates with the Greek codepage of 737 - I suppose everyone either uses the Windows 1253 or ISO 8859_7 codepage for Greek characters.

I hope this helps.

Hafeez

Re: Please help!!!! dataload problems for G/L

Former Member — Tue, 19 Oct 2004 09:17:45 GMT

Hi Steve,

Phew, I finally managed to find this and I hope you find it useful

We implemented SAP for our Greek business over a year ago and this knowledge was gained after many hours of R&D.

Therefore, please find enclosed the method that we used for Greece and it does work - it took me a week to figure out what was going on and this is the cleanest solution and doesn't involve any messing about with the Windows registry and codepages (which is what the resident network 'Guru' told me I had to do):

Firstly, administration rights will be required on the local PC. Also exit all open programs and save any appropriate data.

- From the PCs desktop go to:

Start~~->Settings~~->Control Panel--->Regional Settings

- This will take you to the 'Regional Settings Properties' selection box. On the 'Input Locales' tab, ensure that 'Greek' is both added as an installed input locale and is available.

- On the Regional Settings tab select 'Greece' and also tick 'Set as system default locale'.

- Click Apply and a drive-selection box will appear.

- Browse the computer for the drive where the Windows NT disk is located and then click OK.

- The appropriate files will then be loaded to the PC and a request to restart the computer will be displayed. Allow the computer to restart and now Greek files can be saved directly from Excel and should also be accepted into SAP.

- Problems with Font sizes may arise and if this causes significant problems then repeat the stated procedure but select 'English (United Kingdom)' as the default locale (obviously if you're based in another part of the world then you'd enter your own local default value), instead of Greek and then follow the screens to re-start the computer.

N.B. you will not be able to create Greek files when English is the default locale. These files can then be uploaded onto SAP without any codepage errors.

Once the information from the Windows NT CD is installed onto the PC, then switches between the Greek and English settings can be done whenever it suits the user.

I hope this helps.

Regards,

Hafeez

Re: Please help!!!! dataload problems for G/L

Former Member — Tue, 19 Oct 2004 11:08:56 GMT

Hi Steve,

Sorry, I forgot to mention that the SAP GUI must be set to language 'EL' and codepage '1704' via:

Properties-->Advanced

There you go! The complete solution - just let me know if you have any questions.

Regards,

Hafeez

Re: Please help!!!! dataload problems for G/L

Former Member — Wed, 20 Oct 2004 09:27:15 GMT

Hi Steve,

The following may be of interest to you:

OSS notes 757038 & 161516.

Just some general information that I thought you might want to know about.

Regards,

Hafeez