Import from excel

[bigfoot53]

Hello Everyone,
what is the best way to inport excel data into a test environment , would likr to get vendor account list , GL, Chart of accounts, item master,
I have tried G00PCIE and get not found error, is their a better way ?

thanks
B

 

[Mpeter]

Hello,

I Suggest you to write a CL program with : CPYFRMIMPF and then import the file to an Intermediate file ( Z files) and the perform the validations in the RPG and then Insert then imto JDE files. This way the data which sits in the JDE tables will be a valid data and there will be no Data issues in the future.

Hope this helps.

Thanks
Mark Peter
A7.3 , Cum 12

 

[bigfoot53]

Hello,
thanks for the info i am not fermilliar with that command could you expand on it some more ?
i have a CSV file to be imported for example for the chart of accounts .

thanks
Bruce

 

[Mpeter]

Hi,

Create a folder on your machine and store your CSV file in that folder.

1) CPYFRMIMPF : Copy from Import file... This command expects the path from which you need to copy say(/HOME/AS400) and then pass this variable to the CPYFRMIMPF and then specify the traget location to which file you need to copy.

Take F4 to see all these options.

Once you copy the file then you can Call the RPG for futher process and then delete the Excel file after processing in the CLP.

Hope this helps.

Thanks
Mark Peter
A7.3, Cum12.

 

[bigfoot53]

ok
i used this command and get error, how do i find the error message ?
the CSV file is located in QDLS/IMPORTS
===> CPYFRMIMPF FROMFILE(QDLS/AB001.CSV IMPORTS) TOFILE(YPRODDTAMA/F0101) STRDLM(',')

Copy command ended because of error.
thanks
B

 

[TerryWin]

Look at your job log via DSPJOBLOG.

 

[bigfoot53]

says command processor

 

[TerryWin]

I don't understand your reply. You need to post relative portions of your joblog.

Do you know how to review your joblog by using the F10/F18 keys to see the command results and error messages?

DSPJOBLOG
Press F10=Display detailed messages
Press PageUp to see your last entries...

 

[bigfoot53]

I restarted my session and now it shows logfile correctly, the error is
Message . . . . : File AB001 in library QDLS not found.
Cause . . . . . : The requested function did not find the file in the
specified library.
Recovery . . . : Do one of the following, and then try the request again:
-- Change the file or library name.
-- If *LIBL was specified, add the library that contains the file to the
library list (ADDLIBLE command).

 

[Mpeter]

Hi,

It seems like the file doesnot exist in the Library.
Please try adding the Library using the ADDLIBLE or EDTLIBL and then try the function.

Please let me know if you need any further information.

Thanks
Mark.