Loading data using CSV or any flat file from end user desktop to PAPM Table

[former_member733222]

Hi there,

I have a requirement, wherein an end user should have the ability to load the data using CSV or TXT file from desktop or document folder. Can we configure this by using FILE ADAPTER Function? If so, could you please help me with the steps?

Thanks,

Prashanth

[former_member733222]

Thanks Jan.

[former_member357892]

Hi, in one project as a customer request, we created a procedure in BW in order to load those files. PAPM will read those as a BW object

[former_member713148]

Hi,

Even we have that requirement to load file from desktop/user local folder instead of server upload. Please suggest.

[former_member672444]

Hi Prashant,

I have tried to do what you mention but I have not succeeded.

I have solved it using analysis for office and a planning sequence. The user in the AFO selects the file on his desktop, the planning sequence loads it into an ADSO and then PAPM consumes that data.

[former_member733222]

Thanks for your response. Would you be able to help me in explaining in detail what exactly should I do in PaPM. Do I need to set up any configuration in PAPM to load data from AFO?

Thanks,

Prashanth

[Samantha_Yasay1]

Hi Prashant,

Regarding the question you have raised, the SAP Profitability and Performance Management have a functionality where in it provides automated access to files so that file content can be imported as input for calculations which is called File Adapter (File IO Type is Import).

For more information, you may refer to this link https://help.sap.com/viewer/56471df1959f4cfd9e3bf7a6d2d5be42/LATEST/en-US/d8c2ddf22a3146689675a33ea1...

You may also check this link https://help.sap.com/viewer/56471df1959f4cfd9e3bf7a6d2d5be42/3.12/en-US/036766143bc34086bea02fb3f4e7... for the procedure on how to Import CSV files.

Hope this helps you!

Thanks and Best Regards,

Samantha

[former_member733222]

Thanks Samantha for your response.

I have seen this document earlier as well as blog on this before posting my question. Let me re-phrase my question/requirement.

The end user should have the ability to directly upload the data file from his desktop rather than first saving the file on the server and then loading it from there. Is there an option or function that helps the end user to directly select the data file directly from his personal folder (desktop) to PaPM

Regards,

Prashanth

kt

[former_member733222]

Hello Samantha,

Using FILE ADAPTER function (Import option) I have loaded the flat file from server and have mapped the columns as well. When I have executed (RUN) the function, the execution did not complete successfully, instead it created a error log file with a size of 104 GB. The number of records in flat file (Test1.csv) are only 6 and the mapping is also done correctly. But not sure why is it creating a error log file (TEST1.log) which is consuming the entire database (104 gb). Basis team forcibly deleted the error log file from whitelist path, but the job is still showing up in Application Monitor screen. Would you be able to help me, what could be the rason for this?

REgards,

Prashanth

[NathSomera]

Hi Prashanth,

As of the moment there are no way to directly upload data file directly from desktop. File Adapter was created for this kind of situation which you already knew.

Now, with regards to the error you are encountering, I am not seeing a problem if the data was true enough to have 6 entries only. Are there any other tabs in the flat file? There might be some other hidden data in your flat file. Please share your input file and configuration so the community can take a look at it and provide you with a better suggestion.