Uploading Data From Excel to the iSeries

[iseriescobol]

I have just added an artcile to my blog about uploading data from Excel to the iSeries. I hope this is helpful.

http://www.iseries-cobol.com/blog/2007/05/21/uploading-data-from-excel-to-the-iseries/

[tintin]

Re: Uploading Data From Excel to the iSeries

I can not do below step

"The second is the Transfer Data to the iSeries. Before you click that icon, go to the bottom right hand corner of your data, and click that cell. Then press the Transfer Data to iSeries icon and you will get this screen:"

where i can get this screen.

tintin

[bryce4president]

Re: Uploading Data From Excel to the iSeries

Go to the the last column of the last row that contains data. This serves basically 1 purpose, and that is so that when you do this next step you won't have to remember what cell it is because it will populate it for you. Just follow this example blindly for a minute and you will see what I'm talking about.

1. Click the last cell as mentioned above.
2. Click the menu Data
3. From that menu choose Transfer Data To iSeries
4. Now a box will pop up. The title bar should say Transfer to iSeries Request
5. If your first row is column headings then click the check box.

.... Follow the rest of iSeriesCobol's example. If you have any more problems just report back again...

[tintin]

Re: Uploading Data From Excel to the iSeries

Dear.
Thanks for your detail explain so much.

ask you some thing:

1. they give me only *OBJ of PF or LF after compile.

I want to know source file? how to know?

2. I am only user client .
Can I create Library,userprofile for programming, make source:QDDSSRC.....,RPGSRC. manager all file.ok?

Tinitn

[tintin]

How to goto main menu AS400

Dear...
My company give me auser pass to signon, but that not to main menu AS400.
How to Main menu AS400.
Thanks

[tintin]

Re: Uploading Data From Excel to the iSeries

Dear
I post data from excel so at the final contfirmation screen click NEXT msg happen:


"The process can not process the file because it is being used by another process"

tintin

[DeadManWalks]

Re: Uploading Data From Excel to the iSeries

This implies that you ( or someone) has the file open ( in use) somewhere on the system. From a command line you could type wrkobjlck MyFile *File, to see who.

[tintin]

Re: Uploading Data From Excel to the iSeries

Thank you,
I will do now and reply my resut later.

tintin

[bryce4president]

Re: Uploading Data From Excel to the iSeries

do you have command line access on your AS400? If you don't then you won't be able to create those source libraries.

[tintin]

Re: Uploading Data From Excel to the iSeries

Dear ..
My data posted :

I can not read it....hix hix hix......

I do not know why? I have checked CCSID and apply-> OK




Display Report
Query . . . : VAIT01/CCCCC Report width . . . .
Position to line . . . . . Shift to column . . . .
Line ....+....1....+....2....+....3....+....4....
MA TEN MOTA
000001 _ Ñ > Ç À Í > Å ø Ç Í ? > Å
000002 _ ` > Å ? Ä Ç / > Ç
000003 È Ç Í ? > Å È Ç / > Ç ø Ç Á È
000004 À Í > Å Ç / > Ç ø Ç ? > Å
000005 % Ñ Á > _ Ñ > Ç È Ñ > Ç

[bryce4president]

Re: Uploading Data From Excel to the iSeries

Try it without checking CCSID. I know here we need to check it or else our data looks like that. Maybe your setup is different...

[tintin]

Re: Uploading Data From Excel to the iSeries

without checking are the same........How can i do?

I can not post data by hand........hix hix.....hix......

[bryce4president]

Re: Uploading Data From Excel to the iSeries

have you looked at the data in the file while it is on the 400? does it look ok in the PF when you do a WRKQRY?

[tintin]

Re: Uploading Data From Excel to the iSeries

Data in WRKQRY, because this file i can not see data in PF.

How to see data directly in PF.

Because this file someone give me OBJ not source and not cpmpile by me.

I can not see source, data struct.

help me.
Tintin

[bryce4president]

Re: Uploading Data From Excel to the iSeries

Here is what I would do....

Create a new physical file to your specifications. You should be able to tell the field sizes you need from doing a WRKQRY on the file that already exists. Create the source from that information. Then when you are bringing your file up from Excel to the PF bring it up to the new file you created. One tip about uploading from Excel to the iSeries is that you need to make sure you change all Unicode fields in Excel to Character fields or they will be useless. And you can also make sure the field sizes are the same as on your source file that you created. Any more questions based on this stuff let me know. I don't really see any other options for you at this point...