thanks i owe you one.
OT: somebody should create two sibling websites:
www.buythemanabeer.com
and
www.buythegirladrink.com
Restaurants and Bars register their businesses.
People owing drinks around the country can go online and buythemanadrink =
pay for it and an email gets sent to the individual who then grabs an online
coupon and heads down to his local establishment for replenishment and
refreshment.
I'm sure there are some details to work out, but I would buy Jeff a beer.
Micheal should probably get one too! for all the headaches of late.
hmmmm. I want to put together a network of community sites. this could be a
plugin application. hmmmm.
Eric
From: "Jeff Beer" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: <[EMAIL PROTECTED]>
Subject: RE: (thinking aloud) Data conversions
Date: Thu, 22 Jun 2000 14:32:35 -0400
This is completely off the top of my head, so double check syntax, counts,
etc!
<cfset recordLength="14">
<!--- read in the records --->
<cffile action="read" .... variable="fileContent">
<!--- get the total number of records --->
<cfset ubound = (Len(fileContent) / recordLength)>
<cfset start = 1>
<!--- loop over the records --->
<cfloop from=1 to=#ubound# index="ii">
<cfset recordString = MID(filevar, start, recordLength>
<!--- parse the individual fields --->
<cfset field1 = MID(recordString, 1, 4>
<cfset field2 = MID(recordString, 5, 2>
<cfset field3 = MID(recordString, 7, 4>
<cfset field1 = MID(recordString, 11, 4>
<!--- set start to the beginning of the next record --->
<cfset start = start+14>
<cfquery ...>
<!--- insert the record --->
</cfquery>
</cfloop>
Again, double check the logic, but it seems sound to me.
-----Original Message-----
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 1:07 PM
To: [EMAIL PROTECTED]
Subject: (thinking aloud) Data conversions
I need a sample piece of VB code (I don't really know VB - ie a hunt and
peck type) that will parse a text file into a database using Access97 (I
have Access 2000 available, just haven't looked at it yet), as well as SQL
Server 7.0 (more complicated to get my hands on it).
Hmmmm. skip VB. SQL should do the trick. hmmmmm.
I have currently created a import mapping in access, but there are no CRLFs
in the fixed width text file, so I need to process the file first to prepare
it for import (ie insert CRLF - in ultraedit convert Wrap to CRLF).
Does anyone have any sample code they can throw my way? either SQL or VB.
Sample file layout.
1111223333444411112233334444111122333344441111223333444411112233334444
Database Layout
Field1 1111
Field2 22
Field3 3333
Field4 4444
===== i cut it short, but here is my initial ramblings ====
I have a text file containing batch credit card transactions. A new one is
created everyday and submitted at the end of the day. Two files are returned
from the batch process, accepted and rejected.
The rejected file gets resubmitted the next day. As well as the next days
transactions. To track the generation of the submission they are keeping
each returned rejection file and submitting on its own accord, ao ya gotta
keep your head in the game to figure out what files have been submitted or
not. so after a few days there are submitting 5 or 6 files a day.
What they should be doing is creating a single submission file containing
todays transactions and yesterdays rejections. A field is available in the
text file to track submission iteration information.
Enter in me. Fix it they say.
Option 1.)
- Read all new transactions into a database.
- After submission, Record status as submitted.
- Receive Accepted and Rejected files
- read in and reconcile to submitted transactions flagging as accepted or
rejected.
==== next day
- read in new ta
- create submission file including new ta and yesterdays rejected ta
- After submission, Record status as submitted.
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
