Read A Excel Spread sheet create iSreies fil

Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
4 posts Page 1 of 1

amsoffen

Posts: 1
Joined: Wed Dec 04, 2013 10:56 am

Post by amsoffen » Fri Dec 06, 2013 2:28 pm
I have a Spread sheet where 1st row is the field names. I want to create a temporary file where I can read remaining data into and then copy the data mapping it into an as400 file or read the spreadsheet and insert data into a iSeries file. I am very new to go anywhere and this is the first porject I need to complete.

Support_Rick

Support Specialist
Posts: 592
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Sun Dec 08, 2013 12:15 pm
GoAnywhere has example project templates that will help you create work flows.

When you create a project, click on the browse button (the button with 2 dots at the end of the prompt). Then, pick a project that closely resembles what the job is you need.

In this case, pick the "FTP Get Encrypted Excel to Database". You can remove the Decryption Task and/or the FTP|Get. This leaves you with the ReadExcel and the Connect to DB tasks which will help you do what you need. Just modify to point to your resources and/or file names and you should be good to go.

Please let us know if we can help any further...
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696

Nana111

Posts: 1
Joined: Mon Dec 02, 2013 2:09 am

Post by Nana111 » Wed Jan 22, 2014 1:20 am
Hi there
I have encountered the same questions.I am new here and i want to read the excel spreadsheet and insert data into a iSeries file.I have tried to do that using this Excel program:
http://www.rasteredge.com/how-to/csharp ... l-reading/
But it can not work effecive.I want to know that if there is a tool which supports to do that directly.
Thanks a lot

Support_Chris

Support Specialist
Posts: 7
Joined: Thu Oct 24, 2013 10:23 am

Post by Support_Chris » Fri Jan 24, 2014 9:16 am
Hi Nana111,
I have good news for you then, GoAnywhere Director can translate your data from an excel spreadsheet to an iSeries file. In fact, if you'd like to read more about the different types of formats that GoAnywhere Director can read and write, here is a direct link: http://www.goanywhere.com/products/director/translation

The steps that Support_Rick laid out in his prior post would work nicely for your request.

If you'd like to give GoAnywhere Director a try, you can download the product from here, http://www.goanywhere.com/download and enjoy a 30 day free trial period.

Please let us know if we can help in any way.
Chris Spargen
Technical Support Manager

e. Chris.Spargen@helpsystems.com
p. 1-800-949-4696
w. GoAnywhere.com | HelpSystems.com
4 posts Page 1 of 1