Whenever I run importdb script (we are remote, so can not get to a unix prompt - therefore Siemens developed scripts for us) I get teh error "No such file or directory"

What am I doing wrong here?


here is the path where I FTP'd teh file to:

/test/apps/test/Mike/20060807.csv


Any ideas? :afro: :werd:

Well that would all depend on the nature of your script.
The script might do one of three things:

1) Expect the file to be in a certain specific place with a specific name
2) Expect the file to be in a certain specific place and use a whilecard for the name
3) Take the full path of the file as a parameter

If its the first two then you'll have to ask them where they want you to place it.
If its the 3rd one then look for a paramer that you can set with the path .

Unfortunately with custom scripts (unless you're developing them) I can't be of much help. Unless! you have the source code to the script in which case we can very likely help.

T

Mil0n023:

Just curious -- which Siemens? I used to work for Siemens Business Services, but it's more likely that you're talking about Siemens Medical Systems.

Siemens Medical..

I got it to import - I was omitting the first part of the path (/j0lt/test/apps..)

But - It bombed out with the following error:

- Was converted to Uppercase.
is incompatible with type Alpha
is too large for field size of 1 (?)

But, field one in the GLTRANSREL file is GTR-RUN-GROUP, Alpha 15

AND I took out all the '-' (hyphens) .... any ideas? :banghead:

Did you get this to work ? If not, here are some suggestions:

I don't think it is complaning about field#1. It is complaining about a field that is defined as alpha(1) or number(1) that you are trying to populate with a larger value.

Embedded commas in a text field (or a formatted numeric field) can cause the columns to go out of sync. If there are any, either get rid of them or make sure that the field (if text) is enclosed in double quotes.

Sometimes it helps to view the csv file in notepad or a text editor rather than in Excel. Excel does some formatting that prevents one from viewing the data as-is.


Ragu

You probably have the fields in the wrong order. the Lawson documentation is not always up to date.
Run a rngdbdump of the gltransrel table, this will give you the order of the fields. Check rngdbdump to your file layout.