Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
- Posts: 1
- Joined: Wed Dec 04, 2013 10:56 am
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.
- Posts: 592
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
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...
Lead Solutions Consultant
- Posts: 1
- Joined: Mon Dec 02, 2013 2:09 am
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
- Posts: 7
- Joined: Thu Oct 24, 2013 10:23 am
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.
Return to “Community Forum”