Bulk Updates
I have an Employee Database in MSAccess with more than 10 tables. The updates of employee is done frequently and is done in bulk. The fresh data arrives in Excel worksheets (more than 50 records).
I have created a user interface in ASP to update these records in Access. But the user ends up doing more work updating. Importing Excel worksheets to Access is one way ...but then the column names and types have to be adjusted evrytime.
Can i build a datagrid in browser using ASP, so that the whole table gets displayed and the user can update the data in bulk. And is there any way I could copy paste the Excel records in such datagrid?
View Replies
ADVERTISEMENT
I am currently working on script which needs to be able to send personalized emails.
The number of emails needing to be sent at one time could be anywhere from 100 to 100,000.
I would like to provide this as a background process. IE The administrator clicks on the "Dispatch Emails" button, is able to continue with his work, and then sometime later a popup windows shows up telling him the emailing was successful.
The script is currently using a sendmail function using CDONTS. Will this be able to handle a large number of emails? What about being able to somehow have the sendmail functioning in the background?
I have never worked with ASP send mailing features before and I guess I am looking for suggestions as to how i should go about this.
View Replies
View Related
Novice here, I am doing bulk emails using CDO, connection to a smtp
server at another location. I am trying to streamline my script, or
through it out and start over to make it faster.
I know that I am doing something wrong and that messages should be
sending much faster.
Set objConfig = Server.CreateObject("CDO.Configuration")
Set Fields = objConfig.Fields
With Fields
.Item(cdoSendUsingMethod)= cdoSendUsingPort
.Item(cdoSMTPServer) = "blah.com"
.Item(cdoSMTPServerPort) = 25
.Item(cdoSMTPConnectionTimeout) = 10
.Item(cdoSMTPAuthenticate) = cdoBasic
.Item(cdoSendUserName) = "blah@blah.com"
.Item(cdoSendPassword) = "blah"
.Update
End With
Set objMessage = Server.CreateObject("CDO.Message")
Set objMessage.Configuration = objConfig
' Open database here
objRS.Open SQLString, objConn,2,2
I = 0
With objMessage
.From = "Blah Mailer <blah@blah.com>"
.Subject = Request.Form("Subject")
.TextBody = Request.Form("Body")
Do while not objRS.EOF
.To = objRS("Name") & "<" & objRS("Email") & ">"
.send
objRS.MoveNext
I = I + 1
Loop
End With
objRS.Close
objConn.Close
Set Fields = Nothing
Set objMessage = Nothing
Set objConfig = Nothing
View Replies
View Related
I have an error as follows:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not bulk insert. File 'c:mydata.csv' does not exist.
My mydata.csv file is inside the directory i stated. But why does the server complains that the file is not fould?
My codings:
strSQL = "BULK INSERT NAME FROM 'c:mydata.csv' WITH (FIELDTERMINATOR = ',',ROWTERMINATOR =
'
')"
Response.Write ("test")
Set oRS = conn.Execute(strSQL)
View Replies
View Related
I need to send an email out to about 800 members of our organization once every month. I've been using a 3rd party listserver, but that's been cumbersome at best, trying to keep the two email databases in sync and all.
I know how to write an asp loop to query our database and send an email to each of the 800 recipients, but I'm not sure if this is the right approach. We have an sql-driven website that's tied in as well, so ideally what I want to do is use asp to grab some website data from the sql database, generate the email text, then cycle through our membership database sending it to each member. Is this a good method, or what would be a better approach?
View Replies
View Related
I want to know whether a certain function on the database such as add or delete record is successful or not to be indicated after the transaction.
E.g. if a record was not found, or not deleted, the next page should indicate the event. If deleted it should indicate as well.
View Replies
View Related
my problem is The updates on my asp files are not reflected in the browser. Till recently everything was working fine.
Today I installed new updates on my windows 2000. After all the cached asp contents are appearing and the updates are not getting refreshed. I dont know if this is becoz of the updates on my OS.
I had a file addfield.asp. It was working fine, I made some changes and they worked. But after that my updates are not reflected. If I rename the file to addfield1.asp. I am getting the desired results. Again if I change the contents of this file, they are not appearing.
View Replies
View Related
lets say we have a ms db with two cols
id value
1 4
2 7
3 9
4 1
is there a simple way of updating all the value fields with one form? so i can have the page lay the four value's out in a list, the user could then edit them and hit update and this would update all the value fields. i can update single records no problem but have no idea where to start with this one.
View Replies
View Related
I need to know if I should use asp.net or Java for this. I would like to use asp in general. I need to have a function check to see if a variable is true or false and update an icon. But I want it to either check when updated or every 3 seconds. I suppose it has to be somewhat client side scripting but is there a way around this.
As of now I use IFrames whith a refresh of 10 seconds, any less will cause it to timeout. I kind of want it real-time or very near. It's kind of like a status page for information in a database.
View Replies
View Related
I have a Client Mailer page which basically sends emails off containing information specific to each client = email address found in the relevant database. I basically get this to simply loop through the client recordset (recordset.moveNext), and on each loop it sends an email to the relevant email address via CDOSYS.
Can I just check that this is ok, and this could :
a. Not have a maximum amount of clients this could send to, and basically be too much for the page to cope with if there were too many clients to loop through?
b. This could not cause some sort of Email block due to the server thinking it is spamming, etc.?
This was something someone mentioned, which I just wanted to check out!, as they suggested changing it to a Javascript refresh page, whereby it will send an email every 6 seconds for example by refreshing the page with Js, but I don't really want to change it to this unless I have to... as I was hoping the way in which I have it with the recordset loop, that it would be ok.
View Replies
View Related
I was wondering if there was a CDOSYS attribute to mark the importance of mail messages. I'd like to set their importance to "80" so the CDO Generated messages are treated as low priority by my mail server.
I was wondering if their was an configuration attribute like the following which I could use.
ObjMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusing")=2
ObjMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserver") ="mail.domain.com"
ObjMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserverport")=25
ObjMessage.Configuration.Fields.Update
View Replies
View Related
Can we use BULK INSERT for .dbf files
View Replies
View Related
We are having large database of 3000 emailids and we want to send the newsletter to all these ids at a time. The program works for 20 to 30 email ids but when we are trying to send for 3000, the page cannot be displayed error is coming. When it is run in local system server.scripttimeout error is coming and the mail is going to 2000 mailids.
View Replies
View Related
I am building a web script that will enable a user to compose an email and send it to potentially thousands of subscribers on their mailing list from a DB. The ASP script will use CDONTS or Jmail.
Problem is that I told my host about the app and they say they only allows 1000 emails to be sent daily from my server. The script will possibly send thousands of emails daily. Any body have experience with using ASP for bulk emailing, and how to get around server limitations?
View Replies
View Related
my web host offers ASPMail - which works fine for sending individual emails, but I'm not too keen on using it to send out bulk emails because generally it times out, and then I am left with having to work out who has received their email, and who hasn't.
Anyway, just checking to see if anyone here has any advice about what options I could use to send out bulk emails. My idea of "bulk" is anywhere between 300 and 1400 at a time.
I know there are lots of free services on the web out there which offer free email newsletter services - do people have any recommendations for any of these, or any ASP based components or scripts which I could use on my site to get around this problem?
View Replies
View Related
I would like to have it to use the variable "Id" in the bit which says where Subject = having set the variable earlier. This is for updating replies in a forum script. Code:
View Replies
View Related
I have a new feature called What's New i'm implementing. Whenever i add a new feature to my site, i am goign to write a little blurb about it.
On my main page, i have a javascript that will appear if there are any WhatsNew to show. However, i only want it to appear at least until the person has visited my WhatsNew page. Then, it does not need to appear again until i add another feature.
So, i have a Publish date field in my DB for weach feature and i was going to do this.
On the main page, check to see if Cookie exists, if not, display JS. When user goes to WhatsNew page, i update the cookie with the date.
My problem is that if my last feature was published say 12/02/2005 and todays date is 12/05/2005, the JS will appear. So my theory is flawed. I need to JS to only appear when the user has visited that page, since the last feature was added.
View Replies
View Related
In the site I have to create the user area to bring update the site he himself, as a form
to enter with the texts and images, and to be inserted automatically following the layout and design of the site, and the images with the accurate measures.
View Replies
View Related
I am having problems sending emails via the CDO.Message object from an
ASP script which was working fine. On the server I can still send
emails via the CDO.Message from a .vbs script executed on the desktop.
If I pause the SMTP service I can see mails queuing up from the .vbs
script but the ASP script no longer generates emails, nor does it error
when it creates the object.
Could this be a permissions problem? No IIS settings have changed, but
the server downloads automatic Windows updates.
View Replies
View Related
I'm used to passing information between asp pages but now need to try something different. I've set up a page which loops through a database table and shows the results in text boxes.
I want the user to be able to change the text and then update the database. I guess this would be passing the whole page to another page which will use oRS.update. I can't imagine how I can pass the looped text to a receiving page.
View Replies
View Related
I'm trying to install the Devices Update 4.0 but it failes every time with the error
"Application has generated an exception that could not be handled." Does anybody has any idea where I could find what's going wrong, or who I have to contact for support on Devices Update at Microsoft? As Devices Update is a free download.
View Replies
View Related
how can i upload all the files of a folder which is selected by the user using persits.upload
View Replies
View Related
is it possible to rn a client side vbscript to send messages using cdo.message and cdo.configuration? what are the requirements to do this? my wks are xp and 2000 and all have cdosys.dll registered. do i have to have outlook express loaded.
i have workstations that don't have outlook but rather lotus notes and want to send email to an smtp server. these emails have local attachment thus the need to run client script versus server scripts. is this possible or am i on the wrong track.
View Replies
View Related
Im trying to get a drop-down box that when a value inside it is selected, it updates a data grid below.
I am making a world cup fantasy football league between a few buddies and i want for each person to view points stats etc on a web page which connects to a database.
On one of these pages which i want help with has a list of Managers, and when a manager is selected it will show in a data grid their chosen squad of players.
I can get a page to select each teams squad, but at the moment i only know how to do that as a set of unique pages for each team which would be time consuming to do. Therefore a drop-down list of the team names would be a lot easier if it could update the page when a value is selected. Code:
View Replies
View Related
I would like to know that ,is there any way that the asp page would get refreshed automatically when there is an update in a tbale in SQL Server. The page should get refresh automatically on updates in SQL Server. The user will not hit refresh button neither I want the page to have meta-refresh tag.
View Replies
View Related
What I want to do I select one database and the set the Rs1, rs2 etc.. like in Vb6 I would set DB then:
Set rs1 = db1.OpenRecordSet("Table1")
Set rs2 = db1.OpenRecordSet("Table2")
etc...
However how do I do this in asp3? Code:
View Replies
View Related
I'm trying to create a single form to update multiple records in a database (Access). Similar to an update qty's in a shopping basket, whereby, on submit/update it passes and updates each record, without using the ONCHANGE feature (otherwise this would become an extremely laborious task in this application)
I've tried passing and updating an array but to no avail (maybe I'm doing something wrong)
Also, I can't seem to grab the contents of the form text field, even though I'm dynamically assigning names to each text field.
Should I be using Javascript to handle the change in values, if so, anyone got any sample code/helpful links?
View Replies
View Related
How to prevent duplicate values when using BULK INSERT to insert CSV to SQL Server? Code:
View Replies
View Related
