Search found 3 matches

by ken
Wed Oct 17, 2007 9:38 am
Forum: Support
Topic: CSV import format
Replies: 4
Views: 5396

You should see me when I really get going. ;-)

I forgot to mention, one of the crucial steps in there is converting ", " to "," , because the original export had spaces after its commas, despite the fact that most CSV readers don't recognize that.

-Ken
by ken
Tue Oct 16, 2007 5:41 pm
Forum: Support
Topic: CSV import format
Replies: 4
Views: 5396

Excellent, thanks. Amazing turnaround time on the patched release. :D The conversion code I used was as follows: perl -nle 'chomp; @f=split /", "/; for(@f) {s/&newline;/\\n/g; s/&doublequote;/"/g} if($.==1) {splice @f,43,5}else{@authors=grep/\S/,$f[1],splice@f,43,5; for(@autho...
by ken
Tue Oct 16, 2007 9:42 am
Forum: Support
Topic: CSV import format
Replies: 4
Views: 5396

CSV import format

I'm evaluating Bookpedia and attempting to import our library records. I have a CSV file (generated from our old software), but I can't seem to find a specification for what format Bookpedia expects. Specifically: How should authors be specified? "First Last" or "Last, First"? Ho...