Loading Text Files Into Oracle Using Creation Date?

Apr 12, 2011

I've written a loading program that writes text files to our database. The text files are dumped by another system every 2 hours onto on a shared network drive at my work. Here's the problem though - the files don't have a date/time stamp within them. I've been getting the date for each file from the creation date. That works okay, but when I've written loading programs in the past, I like to move the loaded files into a folder called "Loaded Files". That way, I can quickly see visually how many files I've loaded vs how many have not be loaded.

The problem this time, is that if I were to move the file into another folder, the creation date changes...a lesson I learned when I copied all of the files into a directory on my C: for testing. They all had the same date/time stamp!My question is, what's the best way to handle this? I don't want to move the files after loading them if it alters their creation date. I mean, what if I have to go back and load one for some reason, the date will be lost forever. I also don't want to write something into the software that has to check a file each time before loading it to the database.

View 2 Replies


ADVERTISEMENT

Get Creation Date Of Multiple Files In Vb?

Jul 20, 2011

I'm trying to pull the creation date of all the files (1000+) in a folder on a local server to list in an excel file. I've been trying to use FileSystemInfo for this, but it doesn't seem to work to get the creation date of MULTIPLE files because it doesn't allow me to use wildcard characters to read all (not even sure if that's what I'll need to do).

View 1 Replies

Text Editor - Loading Multiple Large Text Files

Jul 10, 2010

I'm fairly new to VB.NET, and I'm working on a text editor with a tabbed interface. I deal with large text files. Should I have each tab / text document open up in a new thread or a process? I basically want the entire application to always run fast as the text editor is just one part of it. If I have several large text files open I don't want the rest of the application slowing down a bit.

View 2 Replies

Loading JavaScript Files Into Rich Text Box?

Apr 16, 2010

I am trying to make an application that will load any Javascript file into a rich text box.

[Code]....

View 5 Replies

Asp.net - Know The File Creation Date

Sep 27, 2011

I have a files list which contain the directory of file. I want to know file creation date of that files. I used fileInof.CreationTime. But It is not displayed creation date. How I can know about this.

[Code]...

View 1 Replies

Change File Creation Date?

Apr 29, 2009

I'm trying to save a files save date, modify that file and then restore the file back to it's original date. I can't get it to work, I've tried it several ways and cannot get it to work.

My code so far is

origdate = My.Computer.FileSystem.GetFileInfo("inspection").L astWriteTime.ToShortDateString()
' changing file content here
System.IO.File.SetLastAccessTime("inspection", origdate)

View 2 Replies

Compare Date Of File Creation

Aug 4, 2010

be able to check if an application i am writing has been run on a week by week basis. i have created a button that when pressed creates a text file with nothing in it, i can read back the date it was created which also gives me the time which i dont need, i then need to compare the date the file was created to see if it is older than 6 days if so delete the file. how can i check to see if a creation date is older than six days???

View 9 Replies

Creation Date Column In SQL Table?

Apr 29, 2010

What is the easiest way to automatically fill a datetime column in an SQL data table with the date the row was created? Using SQL Server 2005 if that matters.

EDIT: I've tried using GETDATE() for default and that works for an INSERT Query but not when the TableAdapter adds the row.

View 6 Replies

Check Creation Date Of Executable That Is Currently Running

Jun 9, 2009

I would like to implement into my program a version query of the executable and I figured the easiest way would be having a check on the date of the executable. So how can I check the creation date of the executable that is currently running (from the program itself that is)?In short - double click on .exe and it will tell the date of its creation

View 10 Replies

File Creation/modified Date/times?

Mar 16, 2010

I created a background thread that constantly scans a specified folder for any .xls files that are created or modified. These files come from a vba macro in outlook that will automatically save the attachments of the mails in the this folder. This will update the modified date/time, or at least it seems to.

For Each fi In aryFi
fidate = System.IO.File.GetLastWriteTime(path & fi.ToString)
fidate1 = System.IO.File.GetCreationTime(path & fi.ToString)

[code]....

Everytime I check to the code, the fidate and fidate1 variables are indeed the correct dates/times of the file it's currently checking. It almost never gets inside the elseif block at runtime though.

View 1 Replies

Automated Creation Of PDF Files

Oct 12, 2009

So I am attempting to do the following: Use VB to select multiple Files(Excel, Word, RTF, PDFs) and create one PDF from all these files. I need to perform this for approximately 2000 files with a different number of files going into each PDF. I have Acrobat 8 and Visual Studio 2008.

View 2 Replies

Creation Of Program To Create Security Code Based On Current Date?

Apr 3, 2012

I need some help in the creation of a program to generate a security code based on the current date. I need to create something that first multiplies the MMDDYY (ie X=MM * DD * YY) then also adds the MMDDYY then finds the remainder and then multiplies but a specified number. I would like to create a small program that sits in the system tray with this code displayed. The code will always need to be 6 characters, so I might need to pad it with zeros. It has been years since I took basic VB, and I am really rusty.

View 1 Replies

Inserting Date Into Oracle?

Dec 10, 2011

I am getting error String was not recognized as a valid DateTime. I want to know exact parameters to insert into Oracle. To Do this My code is Bellow to Insert

[Code]...

View 1 Replies

Save Datetimepicker Value Of Date And Time In Two Separate Text Files?

Jun 12, 2011

I want to save datetimepicker value of date and time in two separate text files. Currently, when I select a date from datetimepicker and save it in a text file it saves both date and time as below:

5/11/2011 8:25:06 PM What I would like to happen is as below: Datefile.txt saves 5/11/2011 Timefile.txt saves 8:25:06 PM Alternative solution that can work for me would be, if the time (only the TIME) can be modified after saving as below: saved datetime into text file is 5/11/2011 8:25:06 PM

How can I modify the time only to say 12:00:00 PM. By doing so I would like to keep time as 12:00:00 but date can be changed by the user using the datetime picker.

View 1 Replies

Concerning Creation Of JAR Files - Java | Dream.In.Code?

Sep 19, 2011

I'm new here at Dream.In.Code, and this is my first question! To begin I would like to say I am new to Java but not new to coding, I am using Eclipse IDE 3.7 for Java and only have a basic knowledge of Java. I understand how it works; I don't know very much code... On to my question! I am wishing to create a simple JAR file for my own education/demonstration. Yet despite my searching and reading through my book I cannot find any relevant information about how JAR files are constructed. So, what defines a JAR file? How does one compile/make one?

P.S. I wish to work with JAR files because of their seeming simplistic nature and cross-compatibility. This is true, yes?My dearest apologies, I realise I posted this in the wrong forum. May a moderator move it for me?

View 5 Replies

Inserting Date In Oracle 9i From .net 2008?

Mar 7, 2010

how can i insert date from vb.net 2008 to oracle databse.i unable to insert correct date in DB, i tried with different formats but correct date didnt get inserted..

View 2 Replies

Inserting Date In Oracle 9i From 2008?

Sep 21, 2011

Inserting Date In Oracle 9i From Vb.net 2008

View 14 Replies

VS 2008 Search For Date In Oracle DB?

Jun 21, 2010

I have a date in an Oracle DB wich is saved like this in the DB "18-JUN-10 02.01.48,000000 PM"

I want to do a search for a specific date and I tried this:

Dim strZoekDatumVan As String strZoekDatumVan = String.Format("tblRUN.Datum < TO_DATE({0}, 'DD-MM-YYYY')", txtZoekDatumVan.Text.ToUpper)
Dim sql As String = String.Format("SELECT " & _
"tblRUN.Run_ID, " & _
"tblKLANT.Naam, " & _

[Code]...

View 3 Replies

.net - What Date Format Should Send When Using Oracle.DataAcess

Apr 27, 2010

Converting from usind Micorsofts Syste.Data.OracleClient to what I believe is called Oracles ODT (Oracle.DataAccess 10.2.0.100). When I try and send a date I get this error "ORA-1858: a non-numeric character was found where a numeric was expected". This code worked great using System.Data.OracleClient.

cmd.Parameters.Add(New OracleParameter("I_FIRST_LOSS_EVENT_DATE", OracleDbType.Date)).Value = .LossEventsMessages(0).LossEventTime

View 1 Replies

Insert Date And Time In Oracle Database?

May 26, 2011

I am trying to insert date and time in dtime column in oracle database by using this code but it gives me following error ORA-01830 date formate pictures ends before converting entire output.

[Code]...

View 5 Replies

FileSytemWatcher Event Handler - Monitor The Creation Of Files From Macros?

Jul 27, 2010

I'm trying to monitor the creation of files from macros I have launched from VB.Net. The code below works and the event fires but nay code I insert in the OnChanged events gets this error:Error 7 Cannot refer to an instance member of a class from within a shared method or shared member initializer without an explicit instance of the class.

The error message makes no sense to me. I just want to call a SUB() on the same form or make a call to me WP class as shown. How do I do that?

Imports System.IO ' WP
Imports System.Diagnostics ' WP
' WP Monitoring

[code]....

View 6 Replies

Multiple UI Thread - Show An Animated Loading Gif Image Till Data Loading Is Completed In All Text Boxes

Jul 13, 2009

I have a window application develpoed in vs 2008, framework 3.5, in which i have put a button.. Now where i click that button the other text boxes are filled up with the data from database thru web service.. what i want is while all text boxes are being filled i want to show an animated loading gif image till data loading is completed in all the text boxes.. i have tried to use image picture box but while data is loading gif image is displyes but in static mode.. cant see animation... i think this is because data loading and animation both are done thru one UI thread..

View 8 Replies

VS 2010 Application Supports The Creation Of System Files From A Windows Mobile PC - Subject?

Jan 28, 2010

I would like to fine-tune their work tool.The basic idea is to load different libraries etc CppThere in my working environment, such as files - *. dsm.Read the information from them is no mean feat.

View 2 Replies

Store TIFF Files In Oracle?

Nov 11, 2009

I have an ASP.NET application (vb.net codebehind) that has serious performance problems because of its storage of TIFF files in one server share. There are over a million .TIF files there now! The application tracks the scanned images of property with a corresponding row in an Oracle database table. We have this idea that it might be better to store the images themselves in a new Oracle table.

The alternative solution we are thinking of is to split up the server share into multiple folders by State (an OH folder, a WV folder, a VA folder, etc.) Seems like the database option might make more sense long-term, but how do we do it? Can a TIFF be stored in a BLOB column and then extracted back into TIFF format using .NET?

View 2 Replies

VS2010-blob - Insert Several PDF Files Into Oracle

Nov 9, 2010

I would like to insert several PDF files into oracle. I have been looking for some examples but i didn't find it.

View 1 Replies

File I/O And Registry :: FileStream File Creation With Date?

Apr 16, 2009

I have found many pages referring to having the date be part of a txt file being created, but not like the way I need. Having said that, this is what I've got.. [code] I read a page on working with txt files and learned what I could from it. It said to use the method in the beginning of my code for creating the file. It works great, but I would like to have a new file name everday, hence the date being integrated. So even if program was running, when midnight hits, a new txt file is created and new entries are written to that file. But I can't even get the date to be put in there. Everytime I try to make this work by using methods I read about in other pages, I get a syntax error, or a warning saying an end of statement is expected. I'm not sure those methods are compatible with what I've already got going.I was actually trying to store these values in a database, and I got real close I think, but I couldn't get any help to fix my problem so I'm trying to write to daily txt files instead. url....

View 6 Replies

Recommended Text For The Creation Of Custom Controls?

May 1, 2009

I was wondering if there is a recommended text for the creation of custom controls? I know a few years ago this book was out: Developing Microsoft .NET Controls with Microsoft Visual Basic .NET (Pro Developer)

It was published in 2003 I think. I have a great deal of experience in VB but not in actual control development, so I don't need a primer on classes and properties and the like. Wondering if this would still be worth it? I never dove into this part of VB and .NET before.

View 2 Replies

Check For Valid Date Before Loading Data

Aug 1, 2009

How to deal with a "date bug" that I have encountered in my program. Here is a scenario.
1. My system has a locale of en_US and therefore displays the date as MM/DD/YYYY
2. My program tries to import from a csv file in which it carries out tests on a field to check for a valid date before loading the rest of the data.
3. If the date in the file is in the format DD/MM/YYYY the test fails and therefore the data is not loaded. This is the bug.
I would like code to test for the date string in the csv file that will recognize any date format (locale).

View 12 Replies

Sorting Files - Get Files Name - Modified Date In A Folder

May 30, 2012

i am trying to get files name, modified date in a folder Before i get those files, can i pump a command by using vb to the folder and make them sort by modified date?

View 6 Replies

Bulk Insert From Datatable In To Oracle Using Oracle.DataAccess

Mar 4, 2010

I am reading a csv file in to a datatable in vb.net and making a few checks and appending an extra column. I then want to perform a bulk insert using microsofts Oracle.DataAccess (no choice in this) to an Oracle database. what would be the best way to perform this as there is no bulkImport like in SQLserver.

View 2 Replies







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