Sitemap

Amicuk Programming Answers

Infopackage-Load Many Files from Application Server and later Archive/Move

2015-10-11   Views:14

Advertisement

Hi All..   I have a doubt,   I have a requirement of take many files to load into BI 7.0..  I used the infopackage before with option: Load Binary File From Application server   I load information successfully... only with one file ...but If I can lo

Hi All..
  I have a doubt,   I have a requirement of take many files to load into BI 7.0..  I used the infopackage before with option:
Load Binary File From Application server
  I load information successfully... only with one file ...but If I can load many files (with different names) like the next list.. I think it's not a good idea modify the file name (path) on infopackage each time).. :
*All of this files will be on one server that itu2019s map into AL11.. Like
Infopfw
BW_LOAD_20090120.txt
BW_LOAD_20090125.txt
BW_LOAD_OTHER_1.txt
u2026.
Etc..
This directory it's not in BW server.. It's other server..but I can load form this location (one file by one)
Could you help me with this questions:
-     How can I Use an infopackage with routine that take all the files..one by oneu2026 in order of creation dateu2026and load into Target? Is it possible?.. I have some knowledge of ABAP.. but I don´t know exactly how I can say to system this logicu2026
-     In addition is it possible move this files to other locationu2026 like into Infopfwarchive u2026 just to have an history of files loaded.
I saw that in infopackage you have an option to create a routine.. in ABAP codeu2026 Iu2019m a little bit confused because I donu2019t  know how I can specify all the path..
I try with:
Infopfw
InfopfwFile.csv
Infopfw
This is the abap code that automatically you see and you need to modifyu2026
Create a routine for file name
This routine will be called by the adapter,
when the infopackage is executed.
          p_filename =
          p_subrc = 0.
Thank you for your ideas or recommendations.
Al

The replay answer
Advertisement
Hi Reddy, thank you for your answer
I have some doubuts.. when you explain me the option:
All the above files are appending dates at the end of the file....
You can load the files through infopackage by using Routines and pick the files based on date at the end of the file..***
I need to ask you if you think that when you know the date of the file and the infopackage pick each file... thi can work for many files??... or how it's possible control this process?
About this option, I want to ask you If when you menction Unix code... where it's programed this code?.. in the routine of BW Infopackage??
****Or
Create two folders in your BW in Application server level, in AL11 (ask Basis team)
I call it is F1 and F2 folders.
First dump the files into F1 I assume that the file name in F1 is "BW_LOAD_20090120.txt", using Unix code you rename the file and then keep in the same foleder F1 or move to F2.
Then create InfoPackage and fix the file name (i.e. you renamed), so you don't need to change everyday your file name at infopackage level.Because in AL11 everyday the file are overwrite.
To I get BW_LOAD_20090120.txt file in F1, then I renamed to BW_LOAD.txt and loaded into BW, then tomorrow I get BW_LOAD_20090125.txt in F1, then I renamed to BW_LOAD.txt....
so in this way it will work.You need to schedule the Ubix script in AL11.
This is the way how to handle the application server...I'm using the same logic.
Thank you soo much.
Al

Go to See the other 8 answers

Infopackage-Load Many Files from Application Server and later Archive/Move

Category:DefaultRelease time:2015-10-11Views:130

Hi All..   I have a doubt,   I have a requirement of take many files to load into BI 7.0..  I used the infopackage before with option: Load Binary File From Application server   I load information successfully... only with one file ...but If I can lo[More]

Error Loading the file from application server

Category:DefaultRelease time:2015-10-11Views:130

Hi Team, I'm trying to load the .CSV file from application server and I'm getting the error message. In the data package   Update to PSA --Green   Transfer Rule -- Green   Update Rule -  error ABORT was set in the customer routine 9998               [More]

Error loading csv file from application server

Category:DefaultRelease time:2015-10-11Views:130

Hi all, While uploading a csv file from the application server to psa we are getting the following error, Error 2 while splitting CSV data record Message no. RSDS_ACCESS011 Diagnosis Error 2 occurred while splitting the CSV data record 1 1 = Could no[More]

Error when loading a flat file from Application server.

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am trying to load a flatfile from the application server, and I am getting the message Error while accessing the application server file Message no. RSDS_ACCESS002 I checked for notes and found only one: Note 1033978 - Correction: Loading Unico[More]

Logical path for getting a Flat file from application server

Category:DefaultRelease time:2015-10-11Views:130

Hi All, We have loaded some .csv files to application server, what is the logical path we have to mention in the infopackage scheduler screen? please guide me how to give the path for getting a flat file from application server. Thanks, Sairam.Hi Sai[More]

Process Chain - Delete File from Application Server

Category:DefaultRelease time:2015-10-11Views:130

Hi Gurus, Im working with Process chain, and i have a load from a flat file, so my question is : How can i delete that file from the application server after was loaded ? THANKS IN ADVANCED !!! I REALLY APRECCIATE YOUR HELP. Marcoshi, I have gone thr[More]

File from Application server into BW

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I have a urgent requirement and I do not know much of ABAP The requirement is selecting existing file from application server Dynamically in BW server. This will be done by writing an ABAP code at the InfoPackage level in the External Data Ta[More]

XML data into Oracle Tables. XML file on Application Server.Oracle Apps R12

Category:DefaultRelease time:2015-10-11Views:130

Hi All, My Database version : 11.2.0.2.0 I have an XML file which needs to be loaded into the Database Tables. How ever i do not want to use the XMLTYPE as given below insert into test1 ( SELECT PrcDate, PmtType, PmtStatus, PmtTypeCount, PmtTypeAmt F[More]

Upload XML file from Application Server to Internal Table

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts,    i have xml file in application server and i want to convert to internal table .    i have tried this link http://wiki.sdn.sap.com/wiki/display/ABAP/UploadXMLfiletointernal+table.    Here the file is loaded from local(presentation Serve[More]

How to save CSV file in application server while making infospoke

Category:DefaultRelease time:2015-10-11Views:130

How to save CSV file in application server to be used as destination while making infospoke. Please give the steps.........Hi If you want to load your flatfile from Application server,then you need to trasfer your file from your desktop(Computer) to[More]

Downloading file from application server to presentation server

Category:DefaultRelease time:2015-10-11Views:130

Hi,       We have a requirment to download file from application server to presentation server.  The problem is while down loading, some of the filds showing some junk values. Instead of that junk values we have some Russian texts there.  These Russi[More]

Hot
I would like to play my Mac book pro retina through my Yamaha amp via HDMI, I get video to TV but no sound, only from mac speakers..any help please?Hello Linesy1961, The following article contains a few things worth looking at when trying to use your [More]
Dear Friends Excise invoice number for export should be in continuation with domestic i.e if my last domestic excise number is 0000000050 & if i do the export excise transaction the system should pick up 0000000051 vipinDo not maintain Numbers for th [More]
My wife and I each have an iPhone 4S, and we each have an iPod Touch. We use a single Apple ID on all devices (mine). I'm the only one that's really even using Passbook, but Passbook alerts are popping up on all four devices. When I use my Starbucks [More]
JDev 11.1.1.6 Hi, In my current table, I am able to show total row count at a table footer by using #{bindings.<myVO>Iterator.estimatedRowCount}. I have a request from my user to show unique total row count. For example rows below: 1 A 2 B 3 A 4 C T [More]
Hi, I am new user of MSAccess.I am getting exception: Invalid user type when i was trying the following code: String name1=nameTextfield.getText().trim(); String query="SELECT ID from Suppliers WHERE name=name1;" Statement stmt=con.createStateme [More]
is there a way to hide the used clips?? iMovie 10.0.4You can capture the complete clip and then apply Mark > DV Start/Stop Detect over the captured clip. You could get the best of two worlds so: smooth capture and clips creation.Read other 4 answers [More]
How do you show only one caller's video output with four people sharing a video call? i.e. the call originator wants to show a DVD video on a TV screen and the other callers want to view the video on full screen not just one fourth of their screen.Th [More]
Hello again, Still url-pattern of security-constraint issue in web.xml of sunone 6.1 (SP5). I am pretty sure this pattern works fine in SunOne 6.0 and SunOne 6.1 SP2, <security-constraint> <url-pattern>/app/jws1/*.jsp</url-pattern> <u [More]
I type an area that i would like mopre info on and recently it automatically crosses over to Bing search engine rather than to my area of interest. Please help dont like bing and cant shut it off and dont know how to.See [[Removing the Search Helper [More]
How do you remove a stick safely from the back of the computerSettings > Passbook & Apple Pay > [the Visa card] > (scroll all the way to the bottom) Remove CardRead other 2 answers [More]