Bugzilla – Attachment 2742 Details for
Bug 5379
import_borrowers.pl fails with db insert/update errors
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
Example of a CSV which causes db errors
patron_import.csv (text/csv), 1.03 KB, created by
Chris Nighswonger
on 2010-11-12 13:21:13 UTC
(
hide
)
Description:
Example of a CSV which causes db errors
Filename:
MIME Type:
Creator:
Chris Nighswonger
Created:
2010-11-12 13:21:13 UTC
Size:
1.03 KB
patch
obsolete
>"borrowernumber","cardnumber","surname","firstname","title","othernames","initials","streetnumber","streettype","address","address2","city","zipcode","country","email","phone","mobile","fax","emailpro","phonepro","B_streetnumber","B_streettype","B_address","B_address2","B_city","B_zipcode","B_country","B_email","B_phone","dateofbirth","branchcode","categorycode","dateenrolled","dateexpiry","gonenoaddress","lost","debarred","contactname","contactfirstname","contacttitle","guarantorid","borrowernotes","relationship","ethnicity","ethnotes","sex","password","flags","userid","opacnote","contactnote","sort1","sort2","altcontactfirstname","altcontactsurname","altcontactaddress1","altcontactaddress2","altcontactaddress3","altcontactzipcode","altcontactcountry","altcontactphone","smsalertnumber","patron_attributes" >2,2,"Doe","Jane","Mrs.",,"JD",555,"street ","anystreet",,"anytown",55555,"usa","nobody@nospam.com",,,,,,,,,,,,,,,01/02/2008,"JL","CO-GRADUAT",,,,,,,,,,,,,,"F",,,"jadoe",,,,,,,,,,,,,,"âSTARTDATE:January 1, 2010â,âTRACK:Dayâ"
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 5379
: 2742 |
2755
|
2760
|
4486