Closed GoogleCodeExporter closed 9 years ago
Did it only import the first 31 entries? If so, could you provide a sanitized
version of line 32? Sanitized in the sense that we really don't want you to
reveal
your information. Perhaps you ran into a formatting issue. Like you have a
special character that the import is choking on.
Currently the import only limits the total number of Categories. That limit
is 256.
Original comment by rmce...@gmail.com
on 29 Oct 2008 at 4:13
It did import only the 1st 1 entries. So I deleted the 1st 2 entries and tried
again
and I got the 1st 31 including the next two that were missed the first time.
So it
was not a special character. I'll put together a list (try it) and if it has
the same
issue I'll send it to you. Thanks,
Original comment by rgarli...@gmail.com
on 29 Oct 2008 at 11:30
I created a file with dummy data in all the fields and tried again. This time
all
entries were imported. So something is wrong with my specific data. I will try
later. Work is getting in the way.
Original comment by rgarli...@gmail.com
on 29 Oct 2008 at 12:06
I've taken the list and resorted it. Then imported it again. This time I got
31
different entries. It is giving me only the first 31 regardless of which ones
in the
list they are.
Original comment by rgarli...@gmail.com
on 29 Oct 2008 at 4:52
I finished polishing my personal import that I exported from my old Sony Clie.
The
.csv I'm working with has 184 entries and worked like a charm. So, in general
you
should be able to import your file. Is it possible for you to attach a sample
file
that you're only able to get the first 31 entries to import?
Original comment by rmce...@gmail.com
on 29 Oct 2008 at 11:33
Well I added some test lines and can now get 47 of 77 entries to import. Here
is the
current scrubbed file. I am using excel to edit in case that is an issue but I
am
saving as a .csv.
Original comment by rgarli...@gmail.com
on 30 Oct 2008 at 1:07
Attachments:
I get the same failed behavior with the test file. Thank you. Let's see
what I find.
Original comment by rmce...@gmail.com
on 31 Oct 2008 at 3:51
Turns out the the CSV was missing information. There were lines that only had
5
fields instead of the required 6.
For example record 19 (line 20 in the file) was the following:
passcodes,Mindspring kjmpokil 2,,qwbertdrqwerter@mindspring.ertom,fljldflsjjf
If we translate to the headers we get:
Category,Description,Website,Username,Password
Notice it's missing the final field "Notes". Because of that the record was
not
imported. The record should have looked like this:
passcodes,Mindspring kjmpokil 2,,qwbertdrqwerter@mindspring.ertom,fljldflsjjf,
If you update your CSV to ensure that all records contain 6 fields then it'll
import
just fine.
I've incorporated an update to the importing to automatically create blank
entries
for missing fields. So in the next release this will work cleaner.
Original comment by rmce...@gmail.com
on 31 Oct 2008 at 5:08
r27 auto fills missing fields at the end of a record. Should help for when
there
aren't enough commas to indicate blank fields.
Original comment by rmce...@gmail.com
on 1 Nov 2008 at 8:13
Original issue reported on code.google.com by
rgarli...@gmail.com
on 29 Oct 2008 at 3:49