Open microsoft application from Alpha(hope it also wont add in my few un answered qns

[DOntquIT]

Re: Open microsoft application from Alpha(hope it also wont add in my few un answered

Hi steve,

You can be patience but our customers dont have patience to get thier product.
Hope you know this statement as well,"time and tide wait for noone" same thing we cant wait and watch your patience when our deadlines are closer.

All this while, we faced and facing lots of problems and we managed to solve it by ourself.still we have some strange problems which ourself dont understand y does it happen? because the problem also not reliable which will come sometimes and disappear sometimes.
a simple one or two i can say now,
when we have two three web pages open at same time, some times we dont understand y n how it happens.one page will duplicate the other page and code in that page will be replaced with other page.

we don know y it happens then we always close , dont save and open again the page.
sometimes when we click wysiwyg and source again then all the code disappears....then have to undo again to get back our work.

even in the dialog properties undo function is not really helpfull.....

like this so many....all this while im more patience then u without bringing this to forum notice.

its not that one or two of my qns not answered , until now i posted onel few qns i think only 2 is answererd excluding this.

we are not commanding you to provide us code, jus demandin for some ideas and help.
Even if you all are too tired to do that,Afterall forum is for what then.

[sendamail]

Re: Open microsoft application from Alpha(hope it also wont add in my few un answered

dear steve..

good you are so patient..
but it doesn't matter here..
what matters here is, if ALPHA5 works reliable.. let the developers answer the question.. we are not begging here for somebody's code or what..
we are demanding about the non-maturity of the product and examples given which don't work..

by god's grace .. we have done well all this while without the help of steve workings or etc., or etc.,

but, we bought alpha5, so we as a customer we have all the rights of demanding or yelling out about the loop-holes in the product..

hope you and all the patient guys got me.. if not, answer to the question that is related to the problem.. don't come here and boast up about your patience or something.. nobody is bothered if u r a patient guy or an arrogant..

btw.. write something here about alpha5 problems.. u can find many german literature forums if you want to prove your knowlwdge in german language.. we are least bothered about your treatments and your german literature..

god bless you

[Steve Workings]

Re: Open microsoft application from Alpha(hope it also wont add in my few un answered

Usually I stay very quiet. So do others. Tonight I'm gonna tell you, and probably even damage my reputation for patience:

Ya'll get a lot of free help and free advice here. If someone doesn't answer your question for free once or twice, then don't smear everyone here with the kinds of comments you just posted.

In German, we have a treatment for this. It's called KwitcherBitcheien.

[DOntquIT]

Re: Open microsoft application from Alpha(hope it also wont add in my few un answered

sendamail,

Thanks for your supportive words and honest opinion.i agree with what u said.
Hope you also one of the sick and tired customer of alpha five.
The most simple and basic things i cant find solution.their example not so clear.for each n everyth i have to depend on java script which is not reliable in all browsers.

jus a simple thing ,on leave of textbox i have to fill in the rest of the forms. this option is Not available in V8. then i used JS.once they released V9 i was bit relaxed seein the eg of onleave of textbox can fill in the forms ...but when i see the code i hold my breathe . oh GOd y should i have to write such a long code for simple thing.(ajax callback) even all the examples provided for that, i guess the pages doesnt use component at all(if i'm not mistaken)..

and basically becuase of the time difference we cant get help wen we need.have to wait one day after u post for answers. but even after that day the response wont be there(most of the times).

i can make my code work using JS but i dont want to completely rely on it for small small things...then what for we have alpha if we jus have to use html for designing and JS for scripts.so im jus trying my best to use Alpha functions (if at all, there is any built in) thats the reason im posting here to know whether they have any built in fnc or not.

But answers not much helpfull. will google about LAUNCHINIE

Thanks

[sendamail]

Re: Open microsoft application from Alpha(hope it also wont add in my few un answered

Dont Quit,

most of the times this forum won't provide you what you need..
cause here the developers of "ALPHA" itself are not sure how their things work..

simple example in alpha5 help file itself not working even though you copy as it is.. and when you asked about it in the forum, nobody will dare to talk about it..
whether it is richard robins (co founder) or so and so VARs or so and so "CERTIFIED ALCOHOLICS" oh! sorry.. "CERTIFIED ALPHAHOLICS"..

but you don't quit.. dont get upset.. everything can be done .. there is nothing that is not impossible..

i think those who replied earlier for this post should read about "LAUNCHINIE" dll etc., to know how to open "ms-word" or "excel" in a client PC from a web application..

don't listen to the SCRAP here.. even mine is of that sort.. Just "SCRAP".. depend on yourself.. and get the things done.. then post the results to this fellows, then they all will use it nicely.. like you did earlier for "select all" option to check in a "GRID".. i think still some of the alpha developers are struggling to use ur code.. :) pity them..

[DOntquIT]

Re: Open microsoft application from Alpha(hope it also wont add in my few un answered

The answer to the first one is don't create components and A5W pages in subfolders.

I have a question here.we are developing a system with several modules with a team of four.
Lets say my module name is A which is inside folder folderA, now i want to
copy my team members modules lets assume(b,c,d) in to my Pc.so i want to create folderB , folderC,folderD and put corrsponding comp and pages in that folders.

Is that possible or not?

Regarding my second query, we are still workin on it to find some other better solution.

[Steve Wood]

Re: Open microsoft application from Alpha(hope it also wont add in my few un answered

The answer to the first one is don't create components and A5W pages in subfolders.

The answer to the second one is you CANNOT open a copy of MS Word on the Client computer by providing a link to the EXE file - even if you knew exactly what the path was on the client computer, you cannot do it at all, no one can, its not possible at all. What ever path you provide will always execute on the server, not on the client computer.

But you can follow the advice provided by Andrea and create a link to a Word file on your server and causing that file to open in Word on the client computer, IF the client computer user agrees to open the file and has set their computer to use Word for all DOC files (the default), for instance.

A perfect example of this is the DOC attachment on your last post. That is a DOC file. When I click on the attachment it opens in Word, after I agree to open it. That is a lnk to a file on the server, not a link to my MS Word executable.

[DOntquIT]

Re: Open microsoft application from Alpha(hope it also wont add in my few un answered

if you are publishing at all, how you are publishing. You seem to have the files all over the place.
If you are moving things around at the file level, no one can guess what is where and why something does not work.

Yes i have my files all over in my project, its jus like scattered here n there without a simple way to maintain folders. i doesnt know that creating folders and placing components and pages will become a issue for me.what makes someone to post such a question "How to create folder" doesnt it sounds SIMPLE? we tried and we failed .and we never thought it will make our job difficult.
Here is what i did,

1)i created a new database ,
2)i created component firstcomp and insert that component in to firstpage.a5w
3)Then i added a folder MISmodules
4)i created component MIScomp and a5wpage MISpage inside that folder.
once i saved a5w page and when i clik insert component its showing my component -MIScomp under the folder mymodules.

when i clik that and insert,it showing component not found.
What could be the reason?


Hope My explanation is clear ...

What do you expect the USER to SEE as a result of making that selection? Or, if you don't expect the user to see anything, what do you expect to happen on the server? Are there any Macros involved - do you want Word or Excel to run some macro? Or, do you just want Word or Excel to just open?

Regarding the applications, i clearly mentioned it as shortcut so ofcourse from the user point of view it should be shortcut for microsoft applications.
when i click MS-WORD it should open MS-word application as how we open MS-WORD by clcking start -> Microsoft office--> ms-word.
In same manner but its a shortcut to open the application in client pc even my page runs from server.

if Myval = "E" then
sys_shell("c:\Program files\microsoft office\office11\excel.exe ")
else if Myval = "P" then
sys_shell("c:\Program files\microsoft office\office11\powerpnt.exe ")

end if

it will work for me but it doesnt goin to help me when i publish my files and run from server.since the path wont be same and we dont want all application to open from server , we want the client pc applcations to be opened.


Thanks for all the supports given.

[Steve Wood]

Re: Open microsoft application from Alpha(hope it also wont add in my few un answered

You have me (us) lost because I cannot tell what is where, if you are publishing at all, how you are publishing. You seem to have the files all over the place.

Component and A5W pages normally are NOT moved around at all at the file level. They should stay exactly where they were created, in a project folder together. I can't tell if you copy files to the server or not, but you always have to publish, you can't just copy them to the server. IF you insert a component in an A5W page in your project, and then publish that project, the files will be together, and the components will all be "found". If you are moving things around at the file level, no one can guess what is where and why something does not work.

On the second item, what exactly do you expect to happen when your user, who is using their browser to access your application, clicks some link to open Word or Excel? What do you expect the USER to SEE as a result of making that selection? Or, if you don't expect the user to see anything, what do you expect to happen on the server? Are there any Macros involved - do you want Word or Excel to run some macro? Or, do you just want Word or Excel to just open?

[DOntquIT]

Re: Open microsoft application from Alpha(hope it also wont add in my few un answered

Thanks for the response

The short answer to your linked post is that if the components and A5W pages are in the same folder, the forward slash is never needed

as a first step to the solution suggested,i created new folder and added components and a5w of my project to same folder ,next when i insert component in my a5w page i got mesg as component not found.

but i can able to insert the component which is not inside that folder.i even checked my files in my c: default web projects whether the a5w page and component in same folder,yes it is in same place.what could be the reason that i cant add my component in to my a5w page even when they are in same folder?

Regarding my second query,im not opening word, excel file ..im giving shortcut to the application itself.i have to open the microsoft application and not the file.

I attached my screen shot as well

[NoeticCC]

Re: Open microsoft application from Alpha(hope it also wont add in my few un answered

As you note, you cannot use shell_sys at all since that opens an executable on your server, doing nothing of value for your client.

You can use it but as you said, it is useless in THIS case... I've a few very handy scripts set up that use it on WAS to call ImageMagick etc. but of anything that requires to be opened on the client PC it is not the way to go, for reasons you already outlined...

As for this case...

To avoid the files being available to anyone and everyone, I would, within the a5w page, copy the document to the client's session folder using file.copy2() and then either redirect to it or use something like the below to prompt an open/save message box:

Dim FilePath as c
FilePath = session.session_folder + FileName
file.copy2(FileLocation,FilePath)
	
RESPONSE.ADD_HEADER("Content-Length: " + FILE_GET_SIZE(FilePath))
RESPONSE.ADD_HEADER("Pragma: no-cache")
RESPONSE.ADD_HEADER("Expires: 0")
response.mime_type = resolve_mime_type(file.filename_parse(FileName,"E"))
		
RESPONSE.ADD_HEADER("Content-Disposition: attachment; filename="+FileName)
	
Dim FileBlob as B
FileBlob = file.to_blob(FilePath)
?FileBlob
End

(With no other output on the page)

[Steve Wood]

Re: Open microsoft application from Alpha(hope it also wont add in my few un answered

The short answer to your linked post is that if the components and A5W pages are in the same folder, the forward slash is never needed, and Alpha is never going to automatically put one there.

On the link to Word, Excel, etc. You have no control over how your client applicaitons respond. Almost always however, documents will open in their respective programs. If you provide a link to a Word "doc" or "docx" file it will most likely open in Word; same with an "xls" or "xlsx" file. Your doc or xls would need to be accessible to the user, normally in your Document Root so the file is publically available, but there are other ways to make it available to only logged in users.

As you note, you cannot use shell_sys at all since that opens an executable on your server, doing nothing of value for your client. You don't need to, can't anyway, launch an executable on your user's machine, other than through the method I describe above. Unless you are actually going to provide a download of that EXE to the client machine, and then tell the user to launch it. YOU still cannot make it happen, the User has to run it.

[DOntquIT]

Hi all ,

im developing web application using v9. i posted few questions earlier which still remains unanswered.
unfortunately , this is the only forum we have to post our queries regarding alpha.i asked earlier about how to maintain folders inside our projects.

this is the link:
http://msgboard.alphasoftware.com/al...ad.php?t=74627

still i could nt able to find solution for it.
My new query:
in my application i have link to word, excel and powerpoint.
i already provided proper link to open the corresponding exe file using sys_shell command.its also opening link in my pc.but once i publish to server and wen program runs from server ...

wenever the links open from client pc its searchin for application in server since the path provided is
sys_shell("C:\programfiles\microsoftoffice\...")

is it possible to make application of client pc to be open when user click the links?