Hyper-efficient Text Importing

I am working on a project that involves importing IIS Log files into a SQL
Server database (and these logfiles are big --> Some up to 2GB in size).

Up until now I thought that DTS or the BULK INSERT command was the fastest
method out there, but still proves to be long (taking an average of 45mns to
an hour to process each log file).

Because I have to import the log files from three web heads in my cluster
(therefore 2GB log files per server times three servers), this really throws
off the concept of "real time" or near "real time" reporting.

So that begs the question. WHAT IS THE MOST EFFICIENT, AND QUICKEST
TEXT-FILE TO SQL SERVER IMPORTING TOOL, METHODOLOGY, SAMPLE CODE, WHATEVER,
OUT THERE??? Code:

View Replies


ADVERTISEMENT

Text Box Hyper Link To Frame

I have a text box in frame one that the user will enter a 4 to 8 digit number and tab over to text box two to enter a qty they want to order.

BUT after they tab out of the first text box I want to display in the second frame the results of that number from the first text box - weather its valid with discription or invalid number.

1. I have created a database with the inventory #'s with discription.
Current link will display number and product code /framequickpadinfo.asp?pass=0401
/framequickpadinfo.asp?pass=4160017
and so on. That part works fine.

I just need to know how to link that text box in frame 1 over to page (framequickpadinfo.asp) in frame two..

View Replies View Related

Problem Importing Text In Access Memo Field

I'm using asp to retrieve data from a server and import that data in a client that uses MSAccess, into a memo field. The text hes line breaks 0D 0A (the usual DOS line breaks). However the client sees these line breaks as two squares!

The strange thing is that when I look at the exported text (yes, I also export text from the client to the server), it also contains the same line breaks. So the exported text from the memo field can look exactly the same as the imported text, and before the export the line breaks are correctly shown als line breaks, but after the import that same line breaks are shown as squares! I would like to see line breaks after the import and NO squares.

View Replies View Related

Hyper Link Data Field Problem

I have a hyper link field in access 2003. when I present the information in my form(after retrieving it from a recordset) the link appears like this:

c#http://c#

even though the actual field in the database contains only the letter "c". this is the same for every value I insert in the field..

View Replies View Related

Sending A File Using ASP - Is This Efficient?

I have a guy asking me about the speed of downloads from his web site. I use
ASP code to send the download to the user, and the code I use is basically
like this:

FileName = Request.Form("FileName")
Path = Server.MapPath(FileName)
Set Upload = Server.CreateObject("Persits.Upload")
Upload.SendBinary Path
Set Upload = Nothing

Is there anything that can be done to make this more efficient and to send
the file faster?

View Replies View Related

How Do I Build Efficient Category Trees?

I am currently putting together an eCommerce site. I have almost everything
in place, but I am not happy with the category system for our products.

There are around 2500 products in a SQL Sever db, each assigned 1 of 300 odd
categories. Currently, I have statically built the category tree but wish to
automate this task as it is becoming increasingly difficult to manage.

I have googled plenty of info, specifically for ADO data shaping. Is this
the right route to take, especially considering each branch of the category
tree may differ in depth of categories? How exactly do other eCommerce sites
automate this task?

I would also want to be able to copy the category system that provides links
to previously selected categories i.e.

Category 1 > Sub Category 2 > Sub Category 3 > etc etc

Is this possible with the SHAPE command? Are there other methods of
performing this task?

I am particularly concerned about the database taking a major performance
hit from all of these SHAPE queries, which would be required on every
category page. Could I use a stored procedure, and how much would it improve
performance? Considering I will be hosting on a shared server, I want to
make this as efficient as possible.

View Replies View Related

Is Recordset.Find Or A Select Statement More Efficient?

i have to do a lot of searching for records in a script that i have, and i was curious whether its better to:

a) open a recordset once, then use recordset.find for each record i want to find, then close the database

or

b) open a recordset, find one record, close the recordset, open a recordset, finda second record, close the recordset, and so on

View Replies View Related

Importing From Csv

I'm importing from a csv file but got the following error :

If theres a newline field in one of the columns (i.e with a text field) and I want to read that line from code it see everything after the new line as a new line.

If I open the file in notepadeverything's on one line as it should be, but somehow the importing mess it up.

View Replies View Related

Importing From SQL To ASP

I am having a problem displaying data into an ASP Listbox , when I import data in random named field names say 1, 3, 5 from SQL
empty records of hypthytical 2,4 are shown inti ASP listbox

View Replies View Related

Importing Csv Into Access Db Via Asp

I've got a csv file which I will need to import into an access db via asp.
The csv file will be imported every day of each month so there will be
duplicates which will not need to be imported.

View Replies View Related

Importing .xls To MSSqlserver

Can anyone tell me how to exactly import excel sheets into sqlserver from the dts?

View Replies View Related

Importing .CSV File

I'm trying to import my outlook contacts into my access database using a .csv file. i want to be able to browse for the .csv file and hit an upload button on my site and be able to see them all.

View Replies View Related

Importing Data

Is there a way of importing information from an Excel document or a comma delimited file to a database using ASP.

Has anyone tried doing this before? I'd love to know how you did it. At the moment, I'm thinking of uploading a file, opening it with FSO then creating an array (or something similar) from the content of the file. If there's an easier way of doing this (with components etc) please let me know.

View Replies View Related

Error When Importing Csv File

I have the following code which imports a csv file into the database. but when i run the code i get this error message:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

BUT it's imported all the data Code:

View Replies View Related

Importing Excel Cells In ASP

I've seen lots of posts on this and other boards, but nothing seems to work for me. I need to import data from an Excel spreadsheet using ASP. None of the ranges in the spreadsheet are named. I'm using this code:Code:

<%
Set ExcelConn = Server.CreateObject("ADODB.Connection")
Set ExcelRS = Server.CreateObject("ADODB.Recordset")
ExcelConn.Provider = "Microsoft.Jet.OLEDB.4.0"
ExcelConn.Properties("Extended Properties").Value = "Excel 8.0"
ExcelConn.Open "c:inetpubwwwrootaspcalendar est.xls"

set ExcelRS = ExcelConn.Execute ("SELECT * FROM [Sheet1$]")

Response.Write(ExcelRS($A$1))

%>
I've tried every variation on "ExcelRS($A$1)" that I can think of - I've seen "ExcelRS(1,1)" used, but that doesn't work... What is the syntax for accessing Excel data by cell coordinates?

View Replies View Related

Importing XML Into Access 2000

I have an XML file that gets updated every 4 hours on a web server. I can check the XML modification time in ASP and compare to the databse. If it is newer, I need some ASP code to then import the XML into Access. Been trawling the net for an answer for a while .

View Replies View Related

Importing ACT! And Outlook Addresses

We need to import the contact details from Act! and Outlook/Outlook Express
(Both) to a website (hosted database MSSQL or Access). Is that possible in
any ASP Scripting?

View Replies View Related

Problem With Excel Importing

I am trying to get the all data from my excel document. I almost can.

But there are some colums that I can't get!P1aP2b

because there is no column at the start of them!

the all I can get with asp is just data not data name (field name) Code:

View Replies View Related

Importing Files To Database

I have intermediate experience with asp, and sql. I am stumped on how to properly do a project, and hoping that one of you can point me in the right direction instead of playing the trial/error game for 2 weeks!!

Basically, I have a program that exports information into a html file for viewing of results. The file contains event information, user information, and results of each individual user along with statistics of the event. I want to take this generated file, and import it directly into a sql database (point and click upload of sorts to be user friendly) for further data mining. Code:

View Replies View Related

Importing ASP Page Into Excel

I was having a go at importing a page written using HTML embedded with some ASP and SQL commands into an Excel sheet.

Now I have tried using the command below and no luck. After doing some Google searching I found some people suggesting removing HTML and BODY tags which I did but no luck. Tried using HTML and BODY tags and still no luck and all of a sudden I hit a brick wall. Code:

View Replies View Related

Is There A More Efficient Way To Do Multiple "replace"s?

Instead of repeating "replace" for every character you'd like to eliminate, is their a better, more efficient method?

SE_product = replace(replace(replace(trim(product_name), ".", ""), "�", ""), "and", "")

View Replies View Related

Importing Data From Excel Into Access Using ASP

Am tying to build a system where you can browse and upload files into a MS Access database.

View Replies View Related

Importing Comma Delimited File

I've been asked to develop a semi-automated type situation where we have a
database table (sql server) and periodically, there will be a comma
delimited file from which we need to import the data, replacing the old.

I naurally know that we can use [truncate tablename] to kill the other data,
but does anyone have any examples of importing a comma delimited file into
SQL Server with ASP?

View Replies View Related

Importing EXCEL Worksheet Into Existing ACCESS

Importing EXCEL worksheet into existing ACCESS tables is possible.

Is there any way i could import EXCEL worksheet into an existing ACCESS table using ASP code.Something like, i could upload a EXCEL file from a browser and then it can be imported into an existing table And if possible also check for duplicate keys and update those records. If no records exist then insert them.

View Replies View Related

Controlling Text In A Text Area Or Text

I have this problem in controlling a the text in a Text Area. How can I do
that for example the field size is 200, when it reaches 50 it automatically
goes to the next line. Bcoz im having problem when viewing it in my report,
it continuesly views in a strieght line and im having problem in printing.

View Replies View Related

Importing A File And Validating The File

How would I import a file thru an asp page and then validate the fields in
that file - the file would be comma separated file (CSV or Txt extension).

View Replies View Related

International Text And FSO Created Text Files

When using ASP's FileSystemObject to create text files, I am unable to get user submitted text (in Hebrew) to save as anything other than "?????". The text file is being saved in Unicode and setting the CodePage in ASP proved unsuccessful. Strangely, hard coded Hebrew text in an ASP variable does add to the text file correctly.

Any ideas of why this happens and how to get it to work correctly?

View Replies View Related

Text Area Limited Text

I have a text area which I want to limit the number of words or number of text entered into it. Is this possible?

<textarea name="textarea" cols="35" rows="5"></textarea>

In the text area above, can I say limit the person filling in the text area to say 100 characters?

View Replies View Related

Text Box In Form Cutting Text

I have a form on asp page that pulls info from a DB when the page loads.
It them puts the info into text boxes on the page that are editable by the
user.

The only problem I have is say in the description text box it should
read "HP Laserjet 5Si" , it always cuts the text off where it just says "HP"
.. It does this on all the text boxes? I can't seem to figure out why it
is doing it. Here is the sample code:

With quotes around <%= vdesc%>

<td><input name="desc" type="text" id="desc" size="45" value="<%=
vdesc%>"></td>

And I tried it without.

View Replies View Related

Regular Expression Of Text OR Text OR Etc...

I have text in a field coming from a database. The text has various
forms such as:

text1
text1 or text2
text1 or text2 or text3
text1; or text2
text1; or text2; or text3
etc...

how can I parse this with a reg ex? I tried this:

(.+);? or

but it only captures 1 submatch (text1) and only if theres an "or"
after it

I'd like to get 1 submatch for each piece of text separated by the
"or", just the text itself if there is no or.

Anyone know how to do it?

View Replies View Related

Controlling Text In A Text Area

I have this problem in controlling a text in a Text Area. How can I do that, for example the field size is 200, when it reaches 50 it automatically goes to the next line. Because im having problem when viewing text in my report, it continuesly views in a straight line. Can you give me ASP code for that.

View Replies View Related

Hover Over Text To Bring Up Text

I have text - ARI Promise, when I hover over the text I would like a box to appear with the Promise information. It would be several paragraphs that need to be formatted with paragraph and bullets. Is this possible to do? If so how would I go about it?

View Replies View Related

Display Text In Text Box

I have a search page, after search returns value I want to display fields in text box instead of table.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved