Re: Data Upload to AS/400

On Jul 25, 12:21 pm, Stupid Shoe <s...@xxxxxxxxxxxxxx> wrote:
On Fri, 25 Jul 2008 09:00:41 -0700, buddd wrote:
Hello,

I have no experience with AS/400 systems, and I am trying to help the
local sports organization with data upload to their AS/400 system.

Currently scheuding data for various sport activities such as hockey,
soccer, baseball, football, etc. are manually inputted into the AS/400
system (which is some flavor of IBM CMS). The data is sent in by the
various sporting groups.

This manual input takes hours. My guess is there must be a way to
automate this procedure. Users currently connect to the AS/400 from a
IBM based PC using Boganova as the client.

Does anyone have any suggestions / recommendations? Can data upload be
done, and what addition information is required in order to properly
configure this?

Any suggestions would be greatly appreciated.

Thanks in advance.

Mark

Mark

Yes it is possible but some upfront work needs to be done. First how is
the data being sent? If it is being sent on paper then it is not going to
help you much. You would still have to make it electronic to upload. If
the data is coming in electronically then how is it formatted? I mean is
it a .CSV .XLS, .TXT or what?

After you get that settled then you need to look at the format of the
files that they are imputing the data into. The programs in questions may
update several files and you would have to do the same thing with an
automatic upload.

Basically it is possible, but you need to do some work to get there.

Jason

 Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
               http://www.usenet.com- Hide quoted text -

- Show quoted text -

The data is submitted in electronic format by the various
organizations to the city. The city clerk then manually inputs the
data.

The original data can be prepared in any format. Typically it is an
Excel spreadsheet, but can be saved as a .csv file.

Thanks,

Mark
.

Relevant Pages

  • Re: Data Upload to AS/400
    ... AS/400 system (which is some flavor of IBM CMS). ... You would still have to make it electronic to upload. ... The data is submitted in electronic format by the various organizations ... but can be saved as a .csv file. ...
    (comp.sys.ibm.as400.misc)
  • Re: Data Upload to AS/400
    ... local sports organization with data upload to their AS/400 system. ... IBM based PC using Boganova as the client. ... You would still have to make it electronic to upload. ... Excel spreadsheet, but can be saved as a .csv file. ...
    (comp.sys.ibm.as400.misc)
  • Re: For the last time
    ... He changes the format by converting it to a mp3. ... He uploads the mp3 to a peer-to-peer site. ... copyright laws no longer apply to the artistic work. ... for upload for other people to get free, or shared the files with other ...
    (rec.music.progressive)
  • Re: Design question
    ... Big fish eat little fish ... This is probably not the case and all vendors will have their own format. ... I would go ahead and account for specifying an upload format per vendor type and creating a provider model type parser. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Design question
    ... Big fish eat little fish ... You create a common format ... Vendor states to salesman he can "go to hell" if he can't use his Excel ... upload format per vendor type and creating a provider model type parser. ...
    (microsoft.public.dotnet.framework.aspnet)