While waiting for an Apex to arrive, I'm Using a Classic bt32 running
ks 7.5 build 31, and I'm having trouble importing a .csv file into
the database.
1. The database definition file contains a field for each field in
the file to be imported, about 32 in number. The definition file has
60 fields, well under the number mentioned in the manual. Although
in some cases the field name is a bit different (such as "street1"
having no space in the .csv file but having a space in the definition
file), this has not prevented the mapping screen from coming up, with
mapping working successfully, on a couple of occasions.
Because line 1 of the .csv file contains the field names, I answer
yes to Keybase's query on that point.
2. But the mapping screen does not come up consistently: most of
the time the process hangs after the "please wait" prompt. While the
.csv file is perhaps large, at 250k or so, partial importation has
occurred on some occasions -- on one occasion
quite quickly. Because of the .csv's file size, I have several
times left the process going for long periods -- one try for about
three hours, another for about six hours -- with no success: the
display showed all pins raised, like when the unit is idle for long
enough, and pressing the advance or space bar simply lowered the pins
without getting to any message; no other keys would work; and after
reset, examination of the .cdb file showed only 48k in one instance
and 56k in another.
On another occasion after a much shorter period of "please wait",
examination of the .cdb file after reset showed that file to be
128k. That is, in some instances the importing process seems to get
farther in less time than it gets on other occasions.
3. Tech support says the problem is probably low virtual memory and
suggested a reset. So far I have tried only the regular reset button
with no keys held down; this produces no noticeable improvement.
The flash disk has 18.05 mb free. Most of the fields in the
definition file are set to "string", and in some (such as phone
numbers) I have shorted the field length from the default of 255 to
20 or 25; there are a couple of yes-no fields, one number field, and
a couple of document fields.
4. On one of the occasions where successful mapping occurred, I
noticed that the .csv file exported from Excel 2007 separated the
fields not with hard returns but, instead, with line breaks only:
dollar-sign l instead of the dollar-sign p I had expected). As an
experiment, I routed the cursor to the first character of the first
seven or eight records and then hit the enter key to insert a hard
line break. The records edited in this manner imported successfully,
but the program then hung. This led me to believe that the program
needs hard returns as record separators; but I didn't want to edit
the nine hundred thirty records by hand. So I started from a fresh
.csv file and, when I was asked whether I wanted to review the
options, I said yes and chose line mode. This put a dollar-sign-p at
the beginning of each record, but none of the records were
imported. I have trouble imagining that a hard return inserted by
hand is different in any important way from hard returns inserted by
KS when you choose line rather than paragraph mode when opening the file.
Any thoughts about things to check or alter so that mapping
consistently comes up in a reasonable amount of time, and so that all
records import successfully, will be welcome.
I note the ks 7.5 build 31 does not offer progress beeps while
importing, so when the unit says "please wait" there's no way to tell
whether progress is being made or whether the program has hung.
I hope the problem, whatever it is, will disappear once I try the
import on an Apex. But the partial success on some occasions leads
me to believe that even the lowly Classic could handle this task if
the problem could be identified.
Thanks in advance.
Steve
___
Replies to this message will go directly to the sender.
If your reply would be useful to the list, please send a
copy to the list as well.
To leave the BrailleNote list, send a blank message to
[email protected]
To view the list archives or change your preferences, visit
http://list.humanware.com/mailman/listinfo/braillenote
