How to use csv files in OWB

Advertisement

Hi Experts
I have one UNIX server and i my user is putting the csv files on windows machine. I want
1. If User put some new csv file in windows machine it should automatically reflect in UNIX machine.
2. If user enter some data in windows csv files then it should be reflect in UNIX csv files automatically
3. Now I want to connect my OWB with these UNIX csv fils. my csv files are in /home/oracle.source directory.
Regards
Frnd

Advertisement

Let me give an insight of how it works for me:
1. A CSV file is created in unix at a specified location.
2. Using ULTRAEDIT software(installed on windows client) FTP is configured to access the unix server.
3. Open the file stored in unix through ULTRAEDIT from windows.
4. MAKE changes to the file from ultraedit in windows.
5. SAVE it and close ULTRAEDIT.
The changes will be automatically reflected in unix without having the need to FTP it.
OWB accesses the CSV file from unix and does further processing.
Not sure if OPs can do this but this is probably the easiest way of achieving what he wants and this approach works very well for me.

October 11, 2015

How to use csv files in OWB

Hi Experts I have one UNIX server and i my user is putting the csv files on windows machine. I want 1. If User put some new csv file in windows machine it should automatically reflect in UNIX machine. 2. If user enter some data in windows csv files t

How to use csv file to populate all the items in a form

Our environment - Forms 6i/IAS 9i on Solaris/8.1.6 database on Solaris. In the web form I want the user to type in the name of an existing csv file(which contains 1 record). Then press a button and all the items on the form should be populated with t

How to save CSV file in application server while making infospoke

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

How to use properties file

Hi, I want to use properties file in my application. I have kept properties file inside a directory called properties which is inside myProject(which is the parent directory of my project) i.e "myProject/properties". My java file where i want to

How to use property file - sql query define in property file

Hi All, Anybody please tell me how to use property file. I have placed sql query in propery file and I have to access this in my file. well so far this is my code but don't know how to implement in the following ... pstmt = con.prepareStatement("sele

How i use bainary file

hi master sir i forget my sun application server password sombody give me idea i use my master-password file please give me idea how i use bainary file thanks aamirhi master sir i forget my sun application server password sombody give me idea i use m

How can i update an existing item in sap using CSV file?

Hi, i am trying to update an existing Item in SAP using a CSV file. in the message log i get an error message that the item already exists. what should i do in order to update the existing record? Thanks, UdiHi.......... I would sugest you to use Tab

Create Response groups multiple reponse groups using CSV file

Hi Champs, We have good amount of response groups has to be created, I try to write the script but failed. Can any one help me to create Response groups through script. In below script agents should be taken from CSV file. Import-Module Lync $service

How to use PDF files with links to other PDF Files

How to use a PDF file with links to other PDF files that have been transferred to the same folderAre you using a mouse, or a trackpad on a laptop? Either way, your cursor is usually an arrow, right? And presumably it's working/moving MOST of the time

Any example on how to put csv files under context-root

Hi All, Where to put csv files under context-root, so that if i give the file link like http://server-name:port/context-root/folder-name/filename.csv to the end user, he/she needs to download the file automatically to his/her machine. Any examples or

SAP BW 7.0 - How to use control file?

Hello experts, In my current project, I need to use a control file to load some flat files into BW. In version 3.5 we had a option in the infopackage where we could select if it was a csv or a control file. But in 7.0 version this option is not avail

Apple Script to rename images using CSV file

Hello, I have build a website using a Woocommerce for Wordpress. The site is going to have over 1200 images and they need to be renamed appropriately for each product. I've never used Apple Script before but after hours and hours of searching I have

How to use jpg files as a background in a Frame

Could anyone help me to figure out how to get jpg files set as my background of my Frame. I have used Awt to create my frame. Should i use the swing classes to do this? If so could you help me with what is needed to be done to accomplish this task. T

How to use jar files without setting classpath

Hi, I have a situvation, I can not set classpath, but i have to use jar files, how can I do that.URL[] urls = new URL[]{pathToJar, pathToAnotherJar, ...}; URLClassLoader urlc = new URLClassLoader(urls); Now load classes within the jars loaded by the

How to use .mod files from a JVC camcorder?

Hi All, I'm trying to find the proper workflow for using .mod files from a JVC Everio model camcorder. I was able to transfer the files onto my system by simply using the included usb cable from the unit. It simply mounted the camera's flash card on

How to create .csv file from ABAP report

Hi We have a requirement to generate .csv file from abap report. Currently user saves data from abap report to spreadsheet(.xls format) in desktop.  Then opens excel file and save as .csv format.  Need option to save directly in .csv format instead o

How to upload .csv file with tab as delimiter.

HI, I want to upload a .csv file with tab as delimiter to unix path in background.                                                                                                              I know there is function module 'GUI_UPLOAD', but in my ca

How to use XLIFF file as resource bundle in Java code

We use xliff as resource bundle for our ADF application. it is has been no problem to have localized message displayed on UI. how ever, I'm wonderring how to use Java code to access xliff as resource bundle which similar to access properties resource

How to use WMV files in Imovie?

I have a bunch of WMV files from Windows that I would like to use in iMovie. But, it keeps telling me they have to be .avi files in order to be used in iMovie. If someone could please advise how to convert these windows files to usable iMovie files t

How to Use Flat File As source in operation mapping?

Hi dont want to use an FCC. I have written an JAVA Mapping to convert a flat file to XML. But in Interface Mapping How i can test this?/*This java mapping will give same output as input payload */ package com.mapping; import java.io.InputStream; impo