DwZone Forum DwZone Forum
Welcome to the DwZone-it Forum
 
  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  
    RegisterRegister -->   LoginLogin  
Import/Export Tools  
DwZone Forum Index -> Import/Export Tools

Moderators: Administrators, Moderators 		 Mark all topics read
Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.
New Topic Search for
 View     Per page     Messages Since 
Messages 91 to 100 of 382 (Total: 233) First |  Prev |  Next |  Last  
 Subject Author Date  
   Re: Error 424 - Object Required...  
View this persons public profile  Gianluigi   10:49 5 Oct 2011  
   Import txt into Access - Disallowed Path Characters  
View this persons public profile  Andrea S   0:30 6 Sep 2011  
   Re: Import txt into Access - Disallowed Path Characters  
View this persons public profile  Gianluigi   9:39 6 Sep 2011  
   How to add line breks for RSS feed?  
View this persons public profile  PekkaImmonen   1:12 9 Aug 2011  
   Re: How to add line breks for RSS feed?  
View this persons public profile  Gianluigi   8:45 9 Aug 2011  
   language support strange characters  
View this persons public profile  Jos�AntonioViadas   7:13 13 Jul 2011  
   Re: language support strange characters  
View this persons public profile  Gianluigi   9:23 13 Jul 2011  
    Import not recognzing TAB delimiter  
View this persons public profile  GeraldArtman   9:37 24 Jun 2011  
 
When trying to import a 7 row CSV file, I am getting all NULLS as fields and errors displayed.

The CSV file was created in XL2010 and is pretty clean in notepad++

admitNo DOB patient type drg physician admitDX primaryDX admitted discharged reviewStart reviewReason
568590 07/23/1956 "BROWN, JEAN M" 01:INPATIENT 194:SIMPLE PNEUMONIA & PLEURISY W CC "08444:MAGYAR, FRANCIS M" "78605:PNEUMONIA, ORGANISM UNSPECIFIED" "486:PNEUMONIA, ORGANISM UNSPECIFIED" 06/21/2010 06/22/2010 06/24/2011 Recent Actual Items

the setups seem to match
$dwzCsvImport_1->SetFieldSeparator("TAB");
$dwzCsvImport_1->SetSkipFirstLine("true");
$dwzCsvImport_1->SetEncloseField("SA");
$dwzCsvImport_1->AddItem("admitNo", "Csv", "Ni", "", "1");
$dwzCsvImport_1->AddItem("DOB", "Csv", "D-DD/MM/YYYY", "", "2");
$dwzCsvImport_1->AddItem("patient", "Csv", "S", "", "3");
$dwzCsvImport_1->AddItem("type", "Csv", "S", "", "4");
$dwzCsvImport_1->AddItem("drg", "Csv", "S", "", "5");
$dwzCsvImport_1->AddItem("physician", "Csv", "S", "", "6");
$dwzCsvImport_1->AddItem("admitDX", "Csv", "S", "", "7");
$dwzCsvImport_1->AddItem("primaryDx", "Csv", "S", "", "8");
$dwzCsvImport_1->AddItem("admitted", "Csv", "D-DD/MM/YYYY", "", "9");
$dwzCsvImport_1->AddItem("discharged", "Csv", "D-DD/MM/YYYY", "", "10");
$dwzCsvImport_1->AddItem("reviewStart", "Csv", "D-DD/MM/YYYY", "", "11");
$dwzCsvImport_1->AddItem("reviewReason", "Csv", "S", "", "12");

Should be pretty simple?

Also, it did not seem to recognize XL2010 workbook at all.
New format not yet supported?
 
Reply to this current thread  View this persons public profile  Send Private Message
   Re: Import not recognzing TAB delimiter  
View this persons public profile  Gianluigi   9:44 24 Jun 2011  
   Re: Import not recognzing TAB delimiter  
View this persons public profile  GeraldArtman   19:28 28 Jun 2011  
Last Visit: Tuesday 4 Nov, 2025 7:13 am First |  Prev |  Next |  Last  
 Login
Username:  Password:    
Read Message Read Message   Unread message Unread message
Read message [popular] Read message [popular]   Unread message [popular] Unread message [popular]
Read message [locked] Read message [locked]   Unread message [locked] Unread message [locked]
All times are GMT-1

Jump to: