Forum Replies Created
- AuthorPosts
- Peter BarusMember
Neil,
Libre Office does that, with the csv files, maybe they use wxwidgets or
something. Just a thought.What are your plans vis-a-vis "apps?" Is it, or will it be, possible to
construct Android/iPad/etc-oid apps in SIMPOL?I am switching PDAs, and amazed at the way Apple and Google are dividing
up the market for every sort of intrusive "cloud" connection. Almost
impossible to just have a smart phone or tablet that isn't plugged into
some mega-corporation's data-suckers. Before I knew how to turn it off,
all my contacts were slurped up by Google. I get the most spam from them,
from my hack-victim email friends.Love to the family,
Peter
On Fri, 04 Jul 2014 07:28:50 -0400, Neil Robinson <neil@simpol.com> wrote:
> On 06/05/2014 12:29, kromkowski wrote:
>> It seems to be there probably is a better way to do this (but I don't
>> know exactly what is happening – consider my email offer).
>>
>> pseudo code
>>
>> get first line with field names
>>
>> open the modify table and let user set the field types and indexes. (it
>> happens at the end but it should happen up front.)
>>
>> save the empty table
>>
>> import the data into the proper table.
>>
>> JDK
>>
>
> Hi John,
>
> Sorry about the late answer to this, my attention was elsewhere. I have
> done a considerable amount of work on the CSV converter
> over the last few weeks. It is in about as good a state as I can get it
> without adding features like the ability to preview the
> first 50 lines or so of content and then manipulate the column
> information. I do have that planned as a future enhancement, but it
> will be part of a larger release.
>
> Ciao, Neil—
Peter BarusPeter BarusMemberIs there a new release? I've been out of it…
On Mon, 05 May 2014 15:42:21 -0400, Neil Robinson <neil@simpol.com> wrote:
> On 24/04/2014 18:27, kromkowski wrote:
>> When you import, everything is default to string type.
>
> That is true. There is currently no code to detect data type during an
> import from a text file. In that case if you are doing it a
> lot, you can use import merge to an existing definition.
>
>> You get a chance to modify the table (add indexes, change types).
>
> True.
>
>> But it is pretty clear that those changes aren't really "totally
>> effective" unless you do a reorg.
>
> If you change data type and don't do a reorg, then SIMPOL is forced to
> use the data in the format that it currently finds it. That
> could mess up indexes. If you change data type you really have to
> consider the ramifications. Worse is importing something like a
> date or time, since internally they are stored as values. The same is
> true in Superbase. If you convert a string field containing
> dates to a date field, you first have to update the database converting
> the date to a DAYS() value and store that in the field.
> Then change the data type to date, then reorganize.
>
>> For example, if you change a field to "integer" and index it, they are
>> not indexed as if they are integers
>>
>> 1,2,10,98,1000
>>
>> but as if they are strings:
>>
>> 1, 10, 1000, 2, 98
>>
>> I am see many more issues, but I'll just stop here. And see what kind
>> of response with this stuff.
>
> If you add an index in the same step that you change the data type,
> without reorganizing, then this will happen. The only thing we
> could do is to force a reorganize as part of the process.
>
> Ciao, Neil
>—
Peter BarusPeter BarusMemberCan appframework run as a project without modification?
On Wed, 25 Dec 2013 14:48:23 -0500, Peter Barus <peter@barus.com> wrote:
> Are there examples with more functionality, such as individual forms
> instead of pages, data entry, etc.?
>—
Peter BarusPeter BarusMemberI started dataforms example in the IDE, and after messing about, restarted
and chose my database file, and wow! it opened the form I had made! Stil
no record displays in record view, but that is probably pilot error…On Tue, 24 Dec 2013 11:59:52 -0500, Peter Barus <peter@barus.com> wrote:
> Ok. I seemto have got a two page form, header and detail on the first
> page, single record on page two; I can see where two different forms
> might be more better. The record view doesn't show the selected record.
> There isn't any code so far, but I still don't know how to derive that
> from Personal.
>
>
>
> On Thu, 19 Dec 2013 18:24:07 -0500, Peter Barus <peter@barus.com> wrote:
>
>> 6:01 PM 12/19/2013
>> re-made form, 2 page, dblock p1, rec p2;
>>
>> Features?
>> would be handy if I could find a snap grid setting;
>> Personal doesn't remember window size/position when reopened;
>>
>> So far I have not gotten a two page form to show a detailblock related
>> to
>> a header;
>>
>> My old Superbase stuff would create a header on any indexed field I
>> clicked, on the fly, but that's a lot of code away from where I am with
>> SIMPOL.
>>
>> Attached: form and tables
>>
>>
>
>—
Peter BarusPeter BarusMemberOk. I seemto have got a two page form, header and detail on the first
page, single record on page two; I can see where two different forms might
be more better. The record view doesn't show the selected record. There
isn't any code so far, but I still don't know how to derive that from
Personal.On Thu, 19 Dec 2013 18:24:07 -0500, Peter Barus <peter@barus.com> wrote:
> 6:01 PM 12/19/2013
> re-made form, 2 page, dblock p1, rec p2;
>
> Features?
> would be handy if I could find a snap grid setting;
> Personal doesn't remember window size/position when reopened;
>
> So far I have not gotten a two page form to show a detailblock related to
> a header;
>
> My old Superbase stuff would create a header on any indexed field I
> clicked, on the fly, but that's a lot of code away from where I am with
> SIMPOL.
>
> Attached: form and tables
>
>—
Peter BarusPeter BarusMemberNeil,
Just testing to see if I got on here…
Peter
On Thu, 18 Jul 2013 07:18:20 -0400, Neil Robinson <neil@simpol.com> wrote:
> On 17/07/2013 17:52, kromkowski wrote:
>> For future release in Personal
>>
>> 1. If you reorganize you lose your display settings.
>>
>> basically you get I guess default settings.
>
> Not sure what you mean by your display settings, what is changing? If
> you mean things like the table grid column layout, those are
> not preserved across closing and opening of a table, so yes, currently
> they would be lost.
>
>> 2. The modify table thing does really work correctly with respect to
>> display settings. You actually have to manually change the cell to what
>> you want.
>
> ?
>
>> 3. Importing from csv, etc in Personal also still a problem accepting
>> time values.
>
> Are you import merging, or importing to new table? If to new table, then
> you would have to convert the data in date, time, and
> datetime fields to appropriate integer values first. That is an area
> where we could improve, I agree. Potentially we could do this
> change ourselves.
>
> Ciao, Neil
>—
Peter Barus - AuthorPosts