Uploading Data

Any IBM i topic that does not fit in another forum
Post Reply
tbrantley
Posts: 11
Joined: Fri Jul 14, 2023 9:25 pm

Uploading Data

Post by tbrantley »

Good morning!

I have a web program that allows a user to upload a file to the ifs. Then it does a CPYFRMIMPF to put the data into a temporary file for validation and processing.

What is the best way to attach the user to the records they uploaded?

Hopefully this makes sense!

Below is what I'm trying to accomplish!

1. Give users a csv template that they can upload into IFS.
2. Once file is loaded into ifs, CPYFRMIMPF into a temporary file so that i can validate data.
-How can identify what user uploaded the records?
-Need a way to attach the user to the records they upload.
3. Move from temporary file into audit file of records that updated successfully.

Thanks,
Trent
Scott Klement
Site Admin
Posts: 872
Joined: Sun Jul 04, 2021 5:12 am

Re: Uploading Data

Post by Scott Klement »

The terms "upload" and "web program" are general, broad, concepts not specific things.

If you are asking how your program can retrieve the userid so that it can place it into fields in the file, then we need to know the specifics. How are you getting the data to the IBM i? Not just "upload" or "web program" but the specific details of the software you are using, how it works, how it handles authentication, etc.
Post Reply