{"id":17,"date":"2009-06-01T09:35:50","date_gmt":"2009-06-01T13:35:50","guid":{"rendered":"http:\/\/192.168.17.17\/wordpress\/?p=17"},"modified":"2010-08-14T12:48:53","modified_gmt":"2010-08-14T16:48:53","slug":"dumping-checking-dbtext-data","status":"publish","type":"post","link":"https:\/\/www.bobsown.net\/?p=17","title":{"rendered":"Dumping & Checking DBText Data"},"content":{"rendered":"

DBTextCheck will check exported borrower, catalog or loans files for blank records or missing required fields.\u00a0 The name of the file to be checked is the only required parameter.\u00a0\u00a0 Blank record output defaults to DBTblanks.csv<\/em>.\u00a0 Records missing required fields will be written to DBTinvalid.csv<\/em>.<\/p>\n

DBTextCheck will produce a summary of each field showing the field name, blank count, maximum length and number of CR\/LFs in the field.\u00a0 DBTextCheck can be downloaded here<\/a><\/strong><\/p>\n

Checking Steps<\/strong><\/p>\n

    \n
  1. Modify DBTextCheck to select the fields to be checked.\u00a0 For example : I have set “First Name”, “Last Name” and “Company” as the fields to be checked for blank records.\u00a0 These field names have been modified or added to the original DBText for Libraries database.\u00a0 The required fields for borrowers are “City”, “State” and “Zip”.\u00a0 Capitalization is important.<\/li>\n
  2. Export the Borrower.tba, catalog.tba, and Loans.tba files.\u00a0 Set the Exports Options to:\n