Hi Team,

This is my first question in this forum! Kindly correct me if I am in wrong page.

Recently, my customers came up with a new enhancement in my reports. Currently, all the reports are setup like getting SINGLE input (usually numbers) from the users from HTML Launch Page. Now, I need to provision my reports to get bulk numbers from users by allowing them to uploading a list of numbers. Is there a way to achieve this? Any guidance for proceeding further will be greatly appreciated.

Thanks,
Vinoth Prakash

WebFOCUS 7.6.11 | DB2 | Windows 7

This message has been edited. Last edited by: <Kathryn Henning>,

Welcome.

How does the current SINGLE input is done ?
Is it from text box, selection made from drop down list, ...?

Provide sample and more detail it may help us helping you.

Vinoth,

I don't know if this is a part of the HTML composer in 7.6.11, but what you want to use is whats essentially called a double list box. In your case you would want to use an input box and a multi select list box. Where the user would input their value into the input box, then you would have a button for them to transfer the value to the list box. They would repeat this for each value, and then you would pass the list box to the report. In the later version there is some out of the box functionality to do these things, but you might need to write your own javascript for this in 7.6.11. I'm not sure.

quote:

I need to provision my reports to get bulk numbers from users by allowing them to uploading a list of numbers.

You want a file upload functionality or something? A text file with lot of delimited numbers? Or how it is?

Yes, thats right.. I need to know the uploading functionality.

Vinoth,

If you expect any assistance from this forum you need to respond fully to the questions that folks put to you in order to understand your request.

quote:

Yes, thats right..

doesn't cut it.

Eric - one of the people on here who truly understands all aspects of the product - provided you with a suggestion and you didn't even have the courtesy to respond. Ramkumar asked a question and you replied in a manner that doesn't go very far in helping anyone to get a handle on your problem.

What you need to do is to tell us exactly how your input data is structured and what the business problem is that you are trying to solve - because it's possible you may in fact be looking at it from entirely the wrong angle. There are folks on this forum with hundreds of years experience with the product. If you let them in on what you are trying to do you are going to get far better answers to your questions.

OK - here is MY suggestion, but it's based on an incomplete understanding of your problem, because you haven't laid it out comprehensively: If you need to upload a file of numbers from a PC to the server you can use the open-source program PSCP.EXE (Pretty Secure CoPy). It is by the creator of PuTTY. Just google "putty.exe" and you will find it. All you have to do is put pscp.exe in an accessible place on the PC and you can transfer files to any machine where you would normally use an SCP connection.

@Martin - Currently, we are getting that single input from a Text box in the HTML page. For multiple IDs, we are explicitly loading the list of IDs (usually in .TXT file) in our data server thereby creating a temporary table and joining that table with our SQL joins.

We don't want this explicit loading and we would like to allow users to upload a text file with millions of rows from the front end.


@Eric - Thanks so much for the suggestion! Actually, we do have the double list box for field selection. The real thing is user input may be dynamic and it vary every time.


@George - I would like to apologize for not replying back promptly for the questions posted by the techies. Actually, I have seen Ramkumar's reply in my email and replied back from there; I didn't notice Eric's and Martin's reply.

Thanks for your suggestion! I exactly looking for the functionality to upload a file from PC to server. We will try PSCP.EXE program.


Again, thanks for all!