Jump to content
Sign in to follow this  
BuiSiBach

Read data (one column) from excel and pass to AS400

Recommended Posts

BuiSiBach

Hi all,

I am starting to learning VB, EXCEL and AS400 for my job. No I have so many works which need to connect and get and read data from excel and pass to aS400 like. I need to do the table setup in excel file and now I need to use TABCPY to copy from one physical to another physical file but I dont think the best way to manually copy one by one item. I also have column item in excel now I would like to read this column and pass to command TABCPY. I need help. Thanks for everybody.

[PCOMM SCRIPT HEADER]
LANGUAGE=VBSCRIPT
DESCRIPTION=
[PCOMM SCRIPT SOURCE]
OPTION EXPLICIT
autECLSession.SetConnectionByName(ThisSessionName)
 
REM This line calls the macro subroutine
subSub1_
 
sub subSub1_()
   autECLSession.autECLOIA.WaitForAppAvailable
   
   autECLSession.autECLOIA.WaitForInputReady
   autECLSession.autECLPS.SendKeys "tabcpy"
   autECLSession.autECLOIA.WaitForInputReady
   autECLSession.autECLPS.SendKeys "[pf4]"
   
   autECLSession.autECLPS.WaitForAttrib 5,36,"10","3c",3,10000
 
   autECLSession.autECLPS.WaitForCursor 5,37,10000
 
   autECLSession.autECLOIA.WaitForAppAvailable
   
   autECLSession.autECLOIA.WaitForInputReady
   autECLSession.autECLPS.SendKeys "bcfgdta"
   autECLSession.autECLOIA.WaitForInputReady
   autECLSession.autECLPS.SendKeys "[tab]"
   autECLSession.autECLOIA.WaitForInputReady
   autECLSession.autECLPS.SendKeys "1T3681bactdta"
   autECLSession.autECLOIA.WaitForInputReady
   autECLSession.autECLPS.SendKeys "[tab]"
   autECLSession.autECLOIA.WaitForInputReady
   autECLSession.autECLPS.SendKeys "[tab]"
   autECLSession.autECLOIA.WaitForInputReady
   autECLSession.autECLPS.SendKeys "[tab]"
   autECLSession.autECLOIA.WaitForInputReady
   autECLSession.autECLPS.SendKeys "EMB"
   autECLSession.autECLOIA.WaitForInputReady
   autECLSession.autECLPS.SendKeys "[delete]"
   autECLSession.autECLOIA.WaitForInputReady
   autECLSession.autECLPS.SendKeys "[tab]"
   autECLSession.autECLOIA.WaitForInputReady
   autECLSession.autECLPS.SendKeys "[tab]"
   autECLSession.autECLOIA.WaitForInputReady
   autECLSession.autECLPS.SendKeys "
"
   autECLSession.autECLOIA.WaitForInputReady
   autECLSession.autECLPS.SendKeys "replace"
   autECLSession.autECLOIA.WaitForInputReady
   autECLSession.autECLPS.SendKeys "[enter]"
end sub
Edited by BuiSiBach

Share this post


Link to post
Share on other sites
water

Welcome to AutoIt and the forum!

What exactly is your question?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-10-19 - Version 1.4.10.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-09-01 - Version 1.3.4.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
BuiSiBach

I want to write a script VB (like macro in AS400), run this scirpt it will read data from excel and pass to AS400 command TABCPY

                         Transfer Table Items (TABCPY)                
                                                                      
Type choices, press Enter.                                            
                                                                      
Source Library . . . . . . . . . > BCFGDTA       Character value      
Source Company . . . . . . . . . > 1             A-9, *               
Source Table . . . . . . . . . . > T3681         Character value      
Target Library . . . . . . . . . > BACTDTA       Character value      
Target Company . . . . . . . . .   *             A-9, *               
Target Table . . . . . . . . . .   *STAB         Character value      
Item, Generic*, *ALL . . . . . . > EMB           Character value      It will get item from excel sheet  
Generic Copy . . . . . . . . . .   *NO           *YES, *NO            
MERGE into or REPLACE data . . . > *REPLACE      *MERGE, *REPLACE     
Generate Report  . . . . . . . .   *NO           *YES, *NO            
Report Only  . . . . . . . . . .   *NO           *YES, *NO            

Share this post


Link to post
Share on other sites
Melba23

BuiSiBach,

 

I want to write a script VB

Then I suggest you post on a VB forum - this one is dedicated to coding in the AutoIt language. ;)

M23

  • Like 1

Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind._______My UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×