nsype

Thank for you getting that update so quickly! It seems to be working as intended, which is great.

The only problem is that for our catalog, we need the extra character space rather than having the author and title being cut off/truncated. The longest title that we have is 461 characters and the longest author that we have is 210. Am I able to adjust the code in the set_*functions, upload_csv()function, and the database code section to these numbers? I’m curious if the front end view will allow these longer characters or if it will mess everything up. Unfortunately, we don’t have an experienced PHP programmer and are trying to figure this out as we go.

Thank you for your quick responses and assistance!

I think we’re having the issue because of the character length. Would changing the character limit be as a simple as below? I would need to do it for all of them but would this work?
Example:

original-
title varchar(128) not null check (title<> ”)

edited-
title varchar(300) not null check (title<> ”)

Is changing the field widths as simple as increasing the number in the ‘includes’>’database_code.php’ code section?

I deleted the barcode column as I don’t need it. I went and changed the order of the columns to reflect the order in the system. I do have the header line with the needed column headers. I converted the file to ASCII through a plug in converter on Notepad++.

I tried uploading 6 records and only one was successfully uploaded. After looking at the differences between the records I noticed there is a significant character difference in the title and author sections-the one that was uploaded had a shorter title and author section. Is there a title and author character limit? If so, would I be able to expand this, a lot of the collection has very long titles and authors listed.

Here is a sample from the csv file:
title author subject description publocation pubdate edition isbn type callnumber
Fishes of the Salish Sea : a compilation and distributional analysis,”Pietsch, Theodore W., Orr, James Wilder, United States and National Marine Fisheries Service.”,Auxiliary Sciences of History,”(iii, 106 pages): illustrations (some color).”,”Seattle, Washington : United States Department of Commerce, National Oceanic and Atmospheric Administration, National Marine Fisheries Service, Scientific Publications Office, 2015.”,Jan/2015,N/A,979930870,Book,C 55.25 NMFS 18
“An Assessment of the Bottom Fauna and Sediments of the Western Basin of Lake Erie, 1979″,Ontario Ministry of the Environment,Physical geography,N/A,Ontario Ministry of the Environment. Harry C. Parrott. Graham W.S. Scott,Jan/1979,N/A,977070946,Book,GB1627.G83 M5 1979
Developing Rare and Exotic Plant Geographic Information System Databases for Indiana Dunes and Sleeping Bear Dunes National Lakeshores,”Pavlovic, Noel B., Quinlan, Karen M. and Ford, Thomas”,Physical geography,N/A,”USGS, Biological Resources Discipline”,Jan/2005,N/A,,Book,GB634 .15 .P3 2005
The creative communicator : 399 tools to communicate commitment without boring people to death! / Barbara A. Glanz.,”Glanz, Barbara A.”,Industries. Land use. Labor,”xviii, 228 p. : ill. ; 24 cm.”,”Homewood, IL : Business One Irwin, c1993.”,Jan/1993,N/A,27382264,Book,HD30.3 .G56 1993
“When fish fly : lessons for creating a vital and energized workplace from the world famous Pike Place Fish Market / John Yokoyama, Joseph A. Michelli.”,”Yokoyama, John”,Commerce,”viii, 158 p. ; 22 cm.”,”New York : Hyperion, c2004.”,Jan/2004,N/A,52806137,Book,HF5549.5.M63 Y65 2004
Study and Interpretation of the Chemical Characteristics of Natural Water. (3rd Ed.),”Hem, J D.”,Government Publication,263 pages + 3 maps + 1 overhead transparency,Government Publication,Jan/1985,N/A,631706463,Book,I 19.13.2254
Office, 2015. Jan-15 N/A 979930870 Book C 55.25 NMFS 18

Thank you for your help!

Hello,

I have went through and cleaned up all of the data in OpenRefine and double checked the format in Notepad++. Everything appears to be formatted correctly but when I try to bulk upload it says that it is adding them but nothing shows up in the collection. I changed all of the barcode numbers to 0 and had one entry populate in the collection. Then I changed all of the numbers to a series (1-7,890) and nothing is populating. Do you have any other recommendations on how to proceed?

Thank you!

I am currently working with the file in Google Refine to clean up the data. Do you still recommend checking it with a plain text editor? Thank you.