Import

[JD Kromkowski]

Importing causes Shutdown.

[Michael]

JDK wrote:
> Importing causes Shutdown.
>

I had a similar problem with the ASCII-Delimited converter, which I have
fixed in the final release. Which converter were you using?

Ciao, Neil

[JD Kromkowski]

Neil Robinson wrote:
> JDK wrote:
>> Importing causes Shutdown.
>>
>
> I had a similar problem with the ASCII-Delimited converter, which I have
> fixed in the final release. Which converter were you using?
>
> Ciao, Neil

The import function in personal in lastest release.

I'm still not clear why it is that you don't have an import for

Dbase .dbf
Excel .xls
superbase (Your concern about password protection to me is misplaced
given the demise of SB PLC vs. the vision of having old SB users migrate
to SIMPOL)
Paradox .db
Data Interchange Format .dif
..adr and related address book formats
Sql databases .frm, .myd, etc.
Access mdb, etc

[Michael]

JDK wrote:
> Neil Robinson wrote:
>> JDK wrote:
>>> Importing causes Shutdown.
>>>
>>
>> I had a similar problem with the ASCII-Delimited converter, which I
>> have fixed in the final release. Which converter were you using?
>>
>> Ciao, Neil
>
> The import function in personal in lastest release.

Yes, I gathered that. Which format were you importing?

> I'm still not clear why it is that you don't have an import for
>
> Dbase .dbf
dBase format would require us to license a third-party library, unless
we were willing to do it ourselves. In either case, it is not currently
worth it. When you are deciding what to support you have to vote with
what the customers most need.

> Excel .xls
Which format? There are more than 10. The documentation that is
available from OpenOffice.org about the reverse-engineered MS Excel
formats runs to over 200 pages. Supporting native Excel import is
non-trivial.

> superbase (Your concern about password protection to me is misplaced
> given the demise of SB PLC vs. the vision of having old SB users
> migrate to SIMPOL)

I may include an importer for Superbase format directly into SIMPOL
Personal for the next release. It will still respect passwords (but may
not be able to open tables that are password protected). If not, I will
include a Superbase utility to remove all the passwords from a directory
of tables (assuming you know the passwords). It won't be able to open
encrypted Superbase tables.

> Paradox .db

Same reason as dBase. When somebody needs it, we will do it.

> Data Interchange Format .dif

Same reason as dBase. When somebody needs it, we will do it.

> .adr and related address book formats

Address book formats are more of an application-level import capability,
but if these become necessary for something, we will code them then.

> Sql databases .frm, .myd, etc.
> Access mdb, etc

Any SQL-based import will probably have to go through ODBC. We are not
ready to ship the ODBC client support that we have, it isn't yet ready
for that level (some additional functionality that is not directly SQL,
but more ODBC Admin is required).

Ciao, Neil

[JD Kromkowski]

Neil Robinson wrote:
> JDK wrote:
>> Neil Robinson wrote:
>>> JDK wrote:
>>>> Importing causes Shutdown.
>>>>
>>> I had a similar problem with the ASCII-Delimited converter, which I
>>> have fixed in the final release. Which converter were you using?
>>>
>>> Ciao, Neil
>> The import function in personal in lastest release.
>
> Yes, I gathered that. Which format were you importing?

Ascii

As to the other issues. It just seems to me that if you want new users
to use your database (SBME), then you need to make it very easy to import.

FYI, for what's its worth

http://it.toolbox.com/blogs/oracle-guide/state-of-the-database-2008-desktop-databases-22900

It might be interesting to explore some of the functionality in Kirix
Strata.

[Michael]

Lawrence Ward wrote:
> I tried importing an XML file and SIMPOL Personal shut down.
>

Can you give me more information about what you were doing? Were you
merging or creating a new file? What format was the xml file in (can you
send me a sample record or so from the top)?

Ciao, Neil

[Lawrence Ward]

Sorry,

I mentioned my import shut down in the date field area. Using the recent
file sent, Neil, all three import features shut down, although the import
worked. This includes the ASCII converter.

[Michael]

Bert Lundberg wrote:
> I work with Superbase Ver 2.01. I export sbf-file to csv-file with my
> own routine. I import the csv-file in Simpol Personal. When I try to
> create index Simpol give me "Error number 63 updating the table in
> the *.sbm file" with SB Compatible and number 914 with Unicode Index
> Algorithm. This i the 2nd table in container file. In the first table
> was no problem to create index.
>

Hi Bert,

An error 63 usually implies an index problem in the table. Error 914 is
a duplicate index entry on an index set up as unique. I strongly urge
you to use the SB Compatible index as a rule, since it does a very good
job of not only being Superbase compatible, but i understands upper and
lower case across most of the first 900 Unicode characters, whereas
Unicode order just understands that, which means it will not sort upper
and lowercase together.

I also suggest that you stick with one table per container file for now,
since it will aid in doing system updates and provides a performance
boost when doing reorganization.

Ciao, Neil

[Philip Goodfellow]

Neil Robinson wrote:
> JDK wrote:
>> Importing causes Shutdown.
>>
>
> I had a similar problem with the ASCII-Delimited converter, which I have
> fixed in the final release. Which converter were you using?
>
> Ciao, Neil

I have this problem on the evaluation version. I was importing an XML
file produced by XML from Superbase.

Philip

[Bert Lundberg]

I have installed the last version of Simpol Professional and try again to
import CSV files in Simpol Personal.
First I test with the same file as in the earlier version.
The textfile has 17468 records.
When the progress dialog leave after 145 sec. Simpol Personal hang up and
only Alt+Ctrl+Delete will close the program.
After restart the imported file is ok.
145 sec. is very slow, in Superbase Ver 2.1, import av the same file take
less than 3 sec. inclusive modifying fieldnames A, B, C…. to real names.

The other testfile has only 19 records.
Simpol Personal hang up after import and after restart, the table is empty.

[Michael]

Bert Lundberg wrote:
> I have installed the last version of Simpol Professional and try
> again to import CSV files in Simpol Personal. First I test with the
> same file as in the earlier version. The textfile has 17468 records.
> When the progress dialog leave after 145 sec. Simpol Personal hang up
> and only Alt+Ctrl+Delete will close the program. After restart the
> imported file is ok. 145 sec. is very slow, in Superbase Ver 2.1,
> import av the same file take less than 3 sec. inclusive modifying
> fieldnames A, B, C…. to real names.
>
> The other testfile has only 19 records. Simpol Personal hang up after
> import and after restart, the table is empty.
>

Hi Bernd,

The initial import/export library has been written in SIMPOL, rather
than in C. String parsing is a processing-intensive process. We fully
intend at a later stage to implement the import/export filters in C, but
for now we have to use the ones written in SIMPOL. If you are importing
from Superbase, there is now a faster tool that directly reads in SBF
files. Please check the new Quick Start Guide handbook. We are not happy
about the import speed, but took the view that importing data is a much
rarer occasion than other things that we needed to place a priority on.

Can you send me the 19 record table so that I can test the problem here?

Ciao, Neil

[Author]

Posts