OraFAQ Forum: Forms » Import excel to forms

Home » Developer & Programmer » Forms » Import excel to forms (Unix OS)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Import excel to forms [message #453205]

Tue, 27 April 2010 20:25

coolbharat4u
Messages: 30
Registered: April 2010

Member

Hi, could anyone let me know if there is a way to import excel to form in Oracle Apps Server running on UNIX using forms program unit?

I wanted to know where do we need to place the file on the server and how do we need to invoke the excel.

I would really appreciate your response.

--
Thanks
CB

Report message to a moderator

Re: Import excel to forms [message #453240 is a reply to message #453205]

Wed, 28 April 2010 00:42

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you try to search the board? Similar questions are relatively frequently asked these days.

Report message to a moderator

Re: Import excel to forms [message #453362 is a reply to message #453240]

Wed, 28 April 2010 06:38

coolbharat4u
Messages: 30
Registered: April 2010

Member

I have seen it, I was able to create the same using windows server, but I was not sure about the unix server, I mean where do we need to place the file(which directory), also I wanted to know where or how do we need to call the excel?

Report message to a moderator

Re: Import excel to forms [message #453439 is a reply to message #453362]

Thu, 29 April 2010 00:28

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Which version of Forms are you using?

David

Report message to a moderator

Re: Forms [message #453535 is a reply to message #453439]

Thu, 29 April 2010 08:21

coolbharat4u
Messages: 30
Registered: April 2010

Member

Forms 6i

[Updated on: Thu, 29 April 2010 12:31]

Report message to a moderator

Re: Forms [message #453602 is a reply to message #453535]

Thu, 29 April 2010 23:09

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Okay, the AS is on Unix. Is the PC on which the form is displaying running Unix or Windows?

David

Report message to a moderator

Re: Forms [message #453723 is a reply to message #453602]

Fri, 30 April 2010 07:09

coolbharat4u
Messages: 30
Registered: April 2010

Member

The PC is running on Windows

[Updated on: Fri, 30 April 2010 09:22]

Report message to a moderator

Re: Forms [message #453939 is a reply to message #453723]

Mon, 03 May 2010 02:21

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Excel runs on the PC. The AS is on Unix. Can the PC see the directory on the Unix machine in which you have stored the spreadsheets?

Does the PC have the necessary access privileges?

David

Report message to a moderator

Re: Forms [message #454003 is a reply to message #453939]

Mon, 03 May 2010 07:09

coolbharat4u
Messages: 30
Registered: April 2010

Member

Yes, the PC has all the necessary access privileges, so how do we need to invoke the excel here? could you please let me know if you have any sample code for this?

--
Thank you.

[Updated on: Mon, 03 May 2010 07:10]

Report message to a moderator

Re: Forms [message #454084 is a reply to message #454003]

Tue, 04 May 2010 01:12

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I don't understand your problem. In Oracle Forms Builder you create a form that can read an excel file on your PC. You move the form to the unix server and recompile it. Then you invoke the form through the AS URL and open the file on the unix box through the virtual directory defined on the PC.

David

Report message to a moderator

Re: Forms [message #454252 is a reply to message #454084]

Tue, 04 May 2010 11:21

coolbharat4u
Messages: 30
Registered: April 2010

Member

David,

I was using DDE in windows, I was not sure how to map the path(Directory) using UNIX,please see the below sample code, I want to know how we can map this and where we can place our excel file, also how to establish a conversation with Excel

Sample code:
APPID := DDE.APP_BEGIN('D:Program FilesMicrosoft OfficeOffice10EXCEL.EXE',
DDE.APP_MODE_MINIMIZED);

I would really appreciate your help.

Thanks

[Updated on: Tue, 04 May 2010 11:25]

Report message to a moderator

Re: Forms [message #454321 is a reply to message #454252]

Wed, 05 May 2010 01:22

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Are you asking about opening an Excel file or how to invoke the Excel application which may or may not be installed on a PC?

David

Report message to a moderator

Re: Forms [message #454394 is a reply to message #454321]

Wed, 05 May 2010 06:46

coolbharat4u
Messages: 30
Registered: April 2010

Member

I would really appreciate if you can tell me both, opening and invoking, it would really be a great help.

[Updated on: Wed, 05 May 2010 20:46]

Report message to a moderator

Re: Forms [message #454493 is a reply to message #454394]

Thu, 06 May 2010 01:47

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

One bloody thing at a time! Which do you want to do first? What have you done already?

David

Report message to a moderator

Re: Forms [message #454678 is a reply to message #454493]

Thu, 06 May 2010 18:36

coolbharat4u
Messages: 30
Registered: April 2010

Member

David,

My Oracle Apps server is on Unix, and I wanted to know how to use DDE.APP_BEGIN here

Initially I taught to write

AppID := DDE.App_Begin('C:\excel\excel.exe C:\emp.xls',DDE.APP_MODE_MINIMIZED);

But my doubt is that the server is on Unix and the I am not sure if this will work (C drive), also I wanted to know where do I need to place the excel file on the server, in order to get the file name and use the data.

Its really urgent rek for me, I would really appreciate if you can help me in this regard.

Thanks in advance.

[Updated on: Thu, 06 May 2010 18:40]

Report message to a moderator

Re: Forms [message #454682 is a reply to message #454678]

Thu, 06 May 2010 20:53

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

There are many threads on this subject!

Look at http://www.orafaq.com/forum/m/260061/67467/#msg_260061

Get the form working on the developer server and then copy it toyour AS and recompile. The 'excel' HAS to exist on the client machine.

Alternatively, invoke the file with the 'xls' extension and let the client machine use whichever application has been assigned to that file type. If you just want to open and display the spreadsheet then consider 'web.show_document'.

David

Report message to a moderator

Re: Forms [message #454688 is a reply to message #454682]

Thu, 06 May 2010 22:25

coolbharat4u
Messages: 30
Registered: April 2010

Member

Thanks a lot the info David, I'll try this and let you know.

Report message to a moderator

Re: Forms [message #456411 is a reply to message #454688]

Mon, 17 May 2010 15:50

coolbharat4u
Messages: 30
Registered: April 2010

Member

David,

My form doesn't load the data when I am trying to upload, it gets stuck when

MESSAGE ('Check1');
AppID := DDE.App_Begin('C:\excel\excel.exe C:\emp.xls',DDE.APP_MODE_MINIMIZED);
MESSAGE ('Check2');

this happens, I tried to keep the check messages, before and after this, I can see check1 when i run the form. I also tried using

AppID := dde.app_begin('rundll32.exe url.dll, FileProtocolHandler "file_name.ext"', dde.App_Mode_Normal);

could you please help me.

[Updated on: Mon, 17 May 2010 22:02]

Report message to a moderator

Re: Forms [message #457076 is a reply to message #456411]

Fri, 21 May 2010 00:28

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

There should be a 'pause;' after each 'message;' command. Add them and then see which line is failing.

David

Report message to a moderator

Re: Forms [message #457756 is a reply to message #457076]

Tue, 25 May 2010 20:19

coolbharat4u
Messages: 30
Registered: April 2010

Member

AppID := DDE.App_Begin('C:\excel\excel.exe C:\emp.xls',DDE.APP_MODE_MINIMIZED);

This line is failing David, I think that my forms developer is calling the LINUX server and searching for the excel.exe there, rather then on the windows, so will that work if I can install open office on my Linux server?? or do you think I should further tweak my code??

I tried all the possible combinations on this, I would really appreciate if you could help me.

Thanks in advance.

Report message to a moderator

Re: Forms [message #459723 is a reply to message #457756]

Tue, 08 June 2010 01:57

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you solved your problem?

Are you just trying to open a spreadsheet so that someone can read it or are you trying to push or pull data between forms and excel?

Please search this forum for 'excel', there are very many threads on the subject.

David

[EDITED by DJM: typos]

[Updated on: Wed, 07 July 2010 02:46]

Report message to a moderator

Re: Forms [message #459818 is a reply to message #459723]

Tue, 08 June 2010 07:21

coolbharat4u
Messages: 30
Registered: April 2010

Member

David,

I was able to do the import on windows server for normal Oracle forms, where as it was not working for Oracle Apps which is on Linux server, I am still in research of how can the excel be invoked on the Linux server, I am trying to pull the data between forms and excel.

Thanks,
CB

Report message to a moderator

Re: Forms [message #460350 is a reply to message #459818]

Thu, 10 June 2010 12:56

coolbharat4u
Messages: 30
Registered: April 2010

Member

Is it possible that if we install Open office on Linux server then this would invoke the excel?

Report message to a moderator

Re: Forms [message #460371 is a reply to message #460350]

Thu, 10 June 2010 15:20

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As far as I can tell, Open Office will open MS Excel file. According to Open Office site, it is available for Linux as well.

Report message to a moderator

Re: Forms [message #460479 is a reply to message #460371]

Fri, 11 June 2010 07:21

coolbharat4u
Messages: 30
Registered: April 2010

Member

I mean I wanted to know will AppID := DDE.App_Begin('C:\excel\excel.exe C:\emp.xls',DDE.APP_MODE_MINIMIZED); work on Linux? if we install Open Office.

Report message to a moderator

Re: Forms [message #460483 is a reply to message #460479]

Fri, 11 June 2010 07:32

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What do you think?

Report message to a moderator

Re: Forms [message #460778 is a reply to message #460483]

Mon, 14 June 2010 14:30

coolbharat4u
Messages: 30
Registered: April 2010

Member

As per my research I guess DDE doesn't work on Linux, I am not quite sure. can anyone help me with this?

Report message to a moderator

Re: Forms [message #460781 is a reply to message #460778]

Mon, 14 June 2010 14:57

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't know about DDE, but I'm pretty sure that

C:\excel\excel.exe C:\emp.xls

will hardly work on Linux.

Report message to a moderator

Re: Forms [message #460786 is a reply to message #460781]

Mon, 14 June 2010 15:56

coolbharat4u
Messages: 30
Registered: April 2010

Member

Yes, I know that, I tried all the different combinations like just excel.exe, also some dll, giving ip etc, but I am not sure how to I need to do it on Linux. any help?

Report message to a moderator

Re: Forms [message #460788 is a reply to message #460786]

Mon, 14 June 2010 16:05

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Well how would you start it from the command line in linux - forgot about forms for a minute, you are calling like you would in windows.

Report message to a moderator

Previous Topic:	if am close OC4J ?
Next Topic:	Export files from an OLE container

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 00:44:53 CDT 2024