[CLOSED] Upload Parameters VIA Excel/CSV into HTML
My user needs to UPLOAD an Excel/CSV file with 1 Column to be used as a Parameter in an HTML File. Example file will contain Acct.Numbers as such: 123, 456, 789
The WHERE clause will be as such:
WHERE ACCT_NUMBER IN ('123','456','789)This message has been edited. Last edited by: <Kathryn Henning>,
Developer Studio 7.6.11 Reporting Server = Unix 7.6.8 Client = Unix
October 07, 2013, 09:54 AM
Doug
What is your question about this?
October 07, 2013, 10:49 AM
Leo Sanchez
My apologies; can this be done and if so, how can we accomplish this?
Developer Studio 7.6.11 Reporting Server = Unix 7.6.8 Client = Unix
October 07, 2013, 01:43 PM
Doug
Yes it can be done. Upload their data file to an app server, in their app path, and use that in your IN FILE selection criteria...
October 07, 2013, 01:50 PM
Leo Sanchez
Can it be uploaded from user's desktop?
Developer Studio 7.6.11 Reporting Server = Unix 7.6.8 Client = Unix
October 07, 2013, 01:51 PM
Leo Sanchez
Can it be done programatically on the fly
Developer Studio 7.6.11 Reporting Server = Unix 7.6.8 Client = Unix
October 07, 2013, 02:30 PM
Leo Sanchez
So, what we are trying to do is have the user UPLOAD one column of values from Excel into an EDIT BOX on the HTML form so it can pass to FEX to be used in the WHERE Clause..Therefore, we need this to be as easy as possible for the user.
Developer Studio 7.6.11 Reporting Server = Unix 7.6.8 Client = Unix
October 09, 2013, 08:46 AM
Dave
Leo,
please keep in mind that the number of values you can put in a WHERE is limited.
Danger of SQL-buffer overload. ( maximum number of characters allowed in SQL statement ). Either by the RDMS or Adapter or ODBC or whatever.
WHERE TESTVAL IN ( here a lot of comma separated values );
Perhaps you'll need to join ( or match ) the uploaded file with a complete set of all data...
Just a heads up, DaveThis message has been edited. Last edited by: Dave,