SitePoint Sponsor

User Tag List

Results 1 to 1 of 1

Thread: txt file reader

  1. #1
    SitePoint Evangelist
    Join Date
    Jun 2004
    Location
    ny
    Posts
    560
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    txt file reader

    I am trying to update someonelse code, the attached code reads from a unicode txt files and compares a string of "Department_Name|Division_Name|Position_Name|Job_Name" with a db field called "ident_org" in org tbl. Since it is a bad design, I need the code to check a combination of ""Department_Code|Division_Name|Job_Code" against db and get the value of uid_org (unique key). Then if key exists then update that specific row(s) else insert the combination of "Department_Name|Division_Name|Position_Name|Job_Name" into db.

    I need help with this....


    Sample: txt file rows are at below.
    TYPE ID Company_Name Company_Code Dept_Name Dept_Code Division_Name Division_Code Position_Name Position_Code Job_Name Job_Code Service_Name Service_Code System_Name System_Type Application_Name ROLE_ID Role_Name Role_Values Status IDM_Managed Approval_Status Create_Date Created_By Update_Date Update_By Approved_By Approval_Date Version

    I Genel Müdürlük Teftiş 1 G011A100 GENEL MÜDÜRLÜK 1 Yetkili Müfettiş Yardımcısı 162 Yetkili Müfettiş Yardımcısı 162-YEMUF01 ADS Microsoft ADS ADS CifsTeftisAviWR CifsTeftisAviWR 1 1
    I Genel Müdürlük Teftiş 1 G011A100 GENEL MÜDÜRLÜK 1 Yetkili Müfettiş Yardımcısı 162 Yetkili Müfettiş Yardımcısı 162-YEMUF01 ADS Microsoft ADS ADS CifsTeftiskrl2005WR CifsTeftiskrl2005WR 1 1


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •