I am trying to take all the messages that are in a public message folder and export them to a database and then from there I can output to a webpage. I have it set up so I can do it all manually.I have to copy them all to a persoanl folder and from there I can export to a database.
I am looking for a way to automatically. Is it going to be possible to do, or will I need to take a look at making a Macro to do it? I havent done any real VB in quite some time, just VBScript in ASP's. I am trying to avoid doing the macro thing.
Is there a way to display a calendar created in a public folder? We are using Exchange 2003 and have an intranet and I would like to pull the daily view form the calendar and display it at the bottom of my daily announcements page.
Can I create a Function or Sub in my GLOBAL.ASA file for all pages of my application to use? If not, how does one do this? For example, I have an "IIF" function since it isn't natively implemented in ASP. Currently I have an Include directive on every page that includes the scripting for this function. I'd rather just declare it once, globally.
'--- Provide IIF functionality to ASP ------------------------------- Function IIF(eval, trueVal, falseVal) if (eval) then IIF=trueVal else IIF=falseVal end if End Function
Would anyone have a way to access certain Exchange public folders that contain news group emails, perform a query on the folders for keywords and return a list of those emails?
Basically, I've been asked to put a simple single field on a web page that will query a list of exchange public folders and return a list of those emails that have a key word match.
sort of like the MS Index server does on folders with files where one has an asp interface to query the index data base.
I have a VB script Sub() that is used by several ASP pages. How do I make it globally available rather than having to replicate the source code in each ASP page that uses it?
we would like to be able to put a simple query field on a webpage whereby users could enter keywords and then have some of the msx 5.5 public folders searched and return a list of those emails that match the criteria. would anyone know how that might be done useing asp and mapi?
I'm creating a web application for my company now. This application has 2 parts. 1 part for the customers to access. The 2nd part is for our staff to access only. My director hopes to make the 2nd part to be something like an intranet, such that only our company's computers (maybe only 1 or 2 in the company) can login to this part of the application.
1. My company's intending to put the application on shared server with a web host. Windows Authentication is NOT allowed.
2. My company doesn't have a static IP address.
3. My manager suggested using Network Card number (which I don't really quite understand. Is there a way to get the Network Card number that's on a client PC?).
How??
Some ISP told us that they can provide a firewall management feature such that it will restrict access to the website from anyone that is not coming from my company's network. This requires Static IP.
Another told me that IIS Manager has the security feature that restrict access based on IP address. This requires Static IP again.
Is it possible to implement the 2nd part (the part that is to be accessed by my company's PC) as a windows application instead? Then we only put the windows application on one computer. So, 1st part (for the public) will be a web application, 2nd part (for my company) is a windows application, both accessing the same database server from an ISP. Will the ISP allow the windows application to access its database server? I've no experience in making a windows application at all, is it the same as making a web application?
I am going to construct a housing search website ... similar to www.mls.ca ... is there anyway I can populate the data(s) stores in their database? So when my user search for one kind of house, my website will return the data from the MLS database? Or there is similar way to get data from public websites?
Also, if a user search "sport" in my search text box, it will returns all the related links ... just like those search engine ... how can I acheive that? Or I need to pay or register to get the function?
Is there a way of exporting some asp generated text to various formats (doc,pdf,csv,xls etc.)? Idealy it should be preformated in order to print it directly (ex. labels).
I've got a code that takes SQL query and creates a downloadable csv file, and it works fine. But, there is data that is getting seperated by commas that I don't want to be seperated. Like "Last Name" that is "Drake, Dr.".
I tried creating a tab delimited file (which I did) but it opens all wacky if I leave it as a csv file, and if I change it to txt then the download box doesn't open. The end users could select all the text and create their own file, but these end users are in desperate need of as much assistance as possible. Here is the code I am using:Code:
I am using a SQL 2000 server and am trying to export results from a query to a text file. The code is working, expect my CONTACTNAME field has a comma, and my export is splitting that into 2 columns when I only want it to be one. Code:
I have been able to successfully export data to Excel via ASP, however there is a small problem.When the file download window is displayed (to export to excel), you have have several options: open, save and cancel. Pressing the save button allows you to save a *.xls file to your HDD (THIS WORKS FINE). However, most users will push the open button. By doing so, the same screen will appear again with the same options: open, save and cancel. Pressing the open button again causes MS Excel to open (as expected) and then a dialog with the following message appears: "C:Documents and Settings<user name>Local SettingsTemporary Internet FilesContent.IE5BIOJDDG5<filename[1].xls> could not be found".
As most users will probably press the Open button, I want to find a solution to this problem.
I am trying to export a dynamically generated table to excel. I have used following code for the same
Response.ContentType ="application/vnd.ms-excel"
On some machines with excel 2000 version it is not working. The problem is that i have coded a session check for the user in that page and page is not getting the session value & it is redirecting the user to homepage for login in that excelsheet itself. That means instead of showing expected report ,excel sheet is showing contents of home page. I am not getting what is the connection of excel version with session.
I have a table that contains information that I need to export to a .csv file without manually saving the file, e.g click a button, information is passed and saved. I have no problem geting the information from the table, just exporting it into a .csv and then saving.
I am trying to export a result set as an excel spread sheet. Most of the time this works as expected, when a user chooses to save as excel the browser pop-up a save as dialog to allow the user to save the spreadshet with a .xls name. Some times the browser will open up the file as text file within the bvrowser itself? These are my two lines of code to prompt the save as dialog for a Browser:
I have a site where orders are placed, i was just thinking of a good way for customers to keep track of there orders, at the moment they can page through there orders and and find it manually, I was thinking of putting a seach in also. Another one was to export all there orders in to an excel file, and one think thats any good?
the below code successfully queries the database for the record with the correct username and password, and then displays the users age and email from the database.
what i need
at the moment the asp returns the details in the form of a sentence on the browser. however, i shall be exporting the retreived details into flash, so rather then the current way, i would like to declare the fields i have just loaded as something i can export out to flash..such as Response.write (age=myage which will be the flash text box name) or something like that. Code:
I am planning to export data from SQL that generates HTML table. Instead of selecting the table and then copy then paste to word, I need a script(JS or VB) that will automatically export or open the Query to word.
I am trying to export a recordset to an excel file using the Content Type below in the header.
Response.ContentType = "application/vnd.ms-excel"
Which works fine however the problem is that when I have a number in a column with a leading zero the zero gets dropped. E.G. 01760942 will be displayed as 1760942 . How can I rectify this?
Is this possible? I am planning to export data from SQL that generates HTML table. Instead of selecting the table and then copy then paste to excel, is ther a script(JS or VB) that will automatically export or open the Query to it.
