VBScript Fixed Limit Delimiter
Project ID: 1247143005
Project Details
  • Status:
    Closed (Chosen Programmer: softwarehandyman; Rated 10 out of 10)
  • Posted:
    7/9/2009 at 8:36 EST
  • Closed:
    7/13/2009 at 8:19 EST
  • Project Creator:
    (No Feedback Yet)
  • Budget:
    $25-150
  • Description:
    Hi There. We need to have two possibly three VBScript functions modified to read fixed limit delimited text files which are output from a testing system, then build SQL statements to insert them into an Oracle database. We are using a proprietary system that uses VBScript and the system takes care of all the database connections, so that isn't something you need to worry about on our end. As long as you have a similar type database, and can create the three simple tables with 5 exact same columns each, to get the script functioning properly, we will insert the proper db connections using existing functionality in our script. Currently the VBScript function (and would appreciate it staying VBScript) reads comma delimited text files for a similarly related legacy system's output files, so the script is mostly written. With my less complex scripting ability, I made some attempts, but need a more proficient expert to finish and get the script functioning properly. For the right person, this shouldn't take more than an hour or two. We do need this done quickly to avoid minimal downtime.

    I have attached the Script to be modified and the two types of files it needs to read and insert into the database tables.

    I will pay promptly through paypal or your reasonable method of choice. Thank you for your consideration on this!
    Additional Info (Added 7/11/2009 at 11:26 EST)...
    Removed file: vbScript FV Delimited Modified Function.txt
    Additional Info (Added 7/11/2009 at 11:28 EST)...
    Attached file: ImportFunctions.vbs
    Additional Info (Added 7/11/2009 at 11:31 EST)...
    Attached file: tblTEST_SCORES.sql
    Additional Info (Added 7/11/2009 at 11:32 EST)...
    Attached file: tblTEST_DATA_24.sql
    Additional Info (Added 7/11/2009 at 11:32 EST)...
    Attached file: tblTEST_DATA_25.sql
    Additional Info (Added 7/11/2009 at 11:34 EST)...
    Removed file: 24_100507ShortTest.txt
    Additional Info (Added 7/11/2009 at 11:35 EST)...
    Removed file: 25_100507ShortTest.txt
    Additional Info (Added 7/11/2009 at 11:36 EST)...
    Attached file: 24_ShortTest.txt
    Additional Info (Added 7/11/2009 at 11:36 EST)...
    Attached file: 25_ShortTest.txt
    Additional Info (Added 7/11/2009 at 11:36 EST)...
    Attached file: 24_25_ShortTest.txt
  • Tags:
Project Bids
Programmer Bid Delivery Time Time of Bid Rating  
nlance $25 2 days 7/13/2009 at 4:47 EST 7.69/10
(8 reviews)
I can do this project in VBScript with 99% accuracy.
softwarehandyman $40 1 day 7/11/2009 at 14:59 EST 6.50/10
(57 reviews)
I've looked at the script - my test enviro is MSSSQL, but I can make it all work. Next day delivery. PayPal at the end.
rajkumark2003 $56 2 days 7/9/2009 at 22:10 EST 9.52/10
(21 reviews)
I will do this as you need. I have experience working with data porting with VBScripts. Thanks.
7even $150 2 days 7/11/2009 at 15:03 EST 8.99/10
(191 reviews)
place holding bid