Importing BPCS files to another format?
Our company has some backup tapes from a previous organization and need to get invoice data from the older tapes. We have a data restoration company that can pull the files from the tapes and place them on a hard drive for us. We do not have an AS 400 system available or the BPCS software. Is there a way that we can at least view the data on a PC, so we can search for the info we need?
Thanks!
Software/Hardware used:
Software/Hardware used:
ASKED:
June 19, 2009 1:32 AM
UPDATED:
July 1, 2009 2:55 PM
Answer Wiki:
If the data restoration company can pull the data, that means they have an AS/400, iSeries, i5, Power System or whatever it's called now a days. I would imagine that it would take very little effort for them to output the data in a format you can use. If not, then perhaps you should find another company.
To see all answers submitted to the Answer Wiki: View Answer History.
He is right, in order to view data off a tape that came from an Iseries you need another iSeries, System i, Power 6 or whatever they are called these days……
As the other colleagues mentioned, the data would be restored to an AS/400 (iSeries, etc.). You would need access (directly or thru somebody) to this system and extract it directly to a PC.
You can do it with Client Access, if available, and also with Excel and many other ways, including ftp. One method may be more convenient than the other.
An important consideration for you would be weather the Data is in structured format (DB/2) or “Flat” files.
With the former, you should have much less problem, since the fields are defined; with the latter, you need the fields’ definitions or somebody to identify the data. From here (most likely after some cleansing), you can create or update local databases in your current system.