OESF Portal | OESF Forum | OESF Wiki | LinuxPDA | #planetgemini chat on matrix.org | #gemini-pda chat on Freenode | #zaurus and #alarmz chat on Freenode | ELSI (coming soon) | Ibiblio

IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> The New Data App, help required in the use of this app
rodgos
post Dec 20 2018, 12:42 PM
Post #1





Group: Members
Posts: 54
Joined: 2-May 18
From: United Kingdom
Member No.: 822,018



Hi, Has anyone used the new Data app, in any serious way? I've installed the thing, with no problems, but the biggest problem is "How do you use the blessed thing". I'm a great fan of databases, and my Psion netBook, currently houses fourteen of the things. I've, in the past built, setup, managed and used many such. The Psion Data, I have to admit is one of the best flat databases I've ever come across. Endlessly configurable, neat, and user friendly. This Gemini database has me beat. As an app, it's one of the most opaque objects that i've ever come across. A database is just a set of listings of associated things. An address book is one of such, with fields for names, addresses, etc. In this app, I can generate a database, but from there it's as clear as mud as far as creating fields and populating those fields with data, and later organising the presentation in a logical and/or pleasing way, goes. any help, anyone?
In the Psion netBook, I can import or export data, and have in the past, done so. In the new app, the import data seems to be absent, although i can export the data that, so far, I've been unable to enter. Just to add to the frustration, having created a test database, I can find no way of deleting it. is this real?
Go to the top of the page
 
+Quote Post
Beiriannydd
post Dec 27 2018, 10:12 AM
Post #2





Group: Members
Posts: 28
Joined: 5-January 18
Member No.: 815,894



QUOTE(rodgos @ Dec 20 2018, 12:42 PM) *
An address book is one of such, with fields for names, addresses, etc. In this app, I can generate a database, but from there it's as clear as mud as far as creating fields and populating those fields with data, and later organising the presentation in a logical and/or pleasing way, goes. any help, anyone?
In the Psion netBook, I can import or export data, and have in the past, done so. In the new app, the import data seems to be absent, although i can export the data that, so far, I've been unable to enter. Just to add to the frustration, having created a test database, I can find no way of deleting it. is this real?


Import from CSV is available. The little button on the bottom left of the display (To the left of the magnifying glass) when you open Data.

Here's a database you can import to test: Address.csv

Once you have a database, you will see it shown highlighted with yellow and a 3 dot widget. The Delete option is accessible from that widget but the hit box should probably be made bigger IMHO as 9/10 it will open the DB because you missed the widget.

Is that enough to get you started?


Faye
Go to the top of the page
 
+Quote Post
rodgos
post Dec 28 2018, 07:24 PM
Post #3





Group: Members
Posts: 54
Joined: 2-May 18
From: United Kingdom
Member No.: 822,018



QUOTE(Beiriannydd @ Dec 27 2018, 06:12 PM) *
QUOTE(rodgos @ Dec 20 2018, 12:42 PM) *
An address book is one of such, with fields for names, addresses, etc. In this app, I can generate a database, but from there it's as clear as mud as far as creating fields and populating those fields with data, and later organising the presentation in a logical and/or pleasing way, goes. any help, anyone?
In the Psion netBook, I can import or export data, and have in the past, done so. In the new app, the import data seems to be absent, although i can export the data that, so far, I've been unable to enter. Just to add to the frustration, having created a test database, I can find no way of deleting it. is this real?


Import from CSV is available. The little button on the bottom left of the display (To the left of the magnifying glass) when you open Data.

Here's a database you can import to test: Address.csv

Once you have a database, you will see it shown highlighted with yellow and a 3 dot widget. The Delete option is accessible from that widget but the hit box should probably be made bigger IMHO as 9/10 it will open the DB because you missed the widget.

Is that enough to get you started?


Faye



Not really, I'm afraid. Thanks for the info on deleting the test file. It was, as you said hidden behind the yellow and the three black dot widget. Looking at my data files on the netBook, an exported database does, in fact, appear to be a comma separated values table, so there shouldn't be any problem in importing the things. A minor problem is that the netBook is not normally connected to my local network, but that is only time. Which seems to leave me with two further problems. The first, is that the two dots and a bar symbol to the bottom left of the screen only brings up three options, Rescan Data, About Data and Exit Data. Nothing about import. The second is that I've about twenty odd years experience in Unix and Linux, but the unappealing jumble of the Android file system, and where Andoid apps put things tries my patience.
Go to the top of the page
 
+Quote Post
Beiriannydd
post Dec 30 2018, 10:42 AM
Post #4





Group: Members
Posts: 28
Joined: 5-January 18
Member No.: 815,894



QUOTE(rodgos @ Dec 28 2018, 07:24 PM) *
Not really, I'm afraid. Thanks for the info on deleting the test file. It was, as you said hidden behind the yellow and the three black dot widget. Looking at my data files on the netBook, an exported database does, in fact, appear to be a comma separated values table, so there shouldn't be any problem in importing the things. A minor problem is that the netBook is not normally connected to my local network, but that is only time. Which seems to leave me with two further problems. The first, is that the two dots and a bar symbol to the bottom left of the screen only brings up three options, Rescan Data, About Data and Exit Data. Nothing about import. The second is that I've about twenty odd years experience in Unix and Linux, but the unappealing jumble of the Android file system, and where Andoid apps put things tries my patience.


You have a different icon to me, I'd describe it as two dots in bars. if I click about then it tells me I am running v 0.770. I downloaded it from the play store. i feel your pain with the filesystem. Selecting Gemini 4G and Download got me the downloads folder. Perhaps you can use a CF-> SD adapter and a small SD card in FAT format to get the file transfer done?


Faye
Go to the top of the page
 
+Quote Post
rodgos
post Jan 1 2019, 01:17 PM
Post #5





Group: Members
Posts: 54
Joined: 2-May 18
From: United Kingdom
Member No.: 822,018



Faye,
Thanks for the info. I checked my install of Data, and it was v0.763. An update raised this to v0.770, and this does have the required function. I thought that I'd better get the original Data file on the netBook, up to date before considering adding it to the Gemini. This turned out to be a bigger task than I'd anticipated. The database is of my book collection, and runs for near 1200 items. Over time, I've moved, misfiled, added, lost, discarded books. So the database itself was well out of date. Nearly done now, save for the odds and ends. The newly updated Data app, had the option for imports, so should not be much of a problem. I've a Dacom Gold Card for ethernet connection, and I really ought to take the opportunity to backup the netBook onto secure storage, while I'm connected. Having an ordered, and working database, that I'm used to, on the Gemini may give me an insight into how it works on the new machine. If all seems proper, I might consider some of my other databases, to add to the Gemini

Cheers, Rod Goslin
Go to the top of the page
 
+Quote Post
jakfish
post Jan 1 2019, 02:16 PM
Post #6





Group: Members
Posts: 261
Joined: 12-September 10
Member No.: 91,772



I imagine a Gemini Data converter module for PsionDataFile>GeminiDataFile would be too Byzantine, though I do remember the Sharp Mobilon series arriving with a ROM conversion app that converted Zaurus (SynergyOS) files to Windows CE 2.0.

The truer days of handhelds,
Jake
Go to the top of the page
 
+Quote Post
Beiriannydd
post Jan 1 2019, 03:12 PM
Post #7





Group: Members
Posts: 28
Joined: 5-January 18
Member No.: 815,894



QUOTE(jakfish @ Jan 1 2019, 02:16 PM) *
I imagine a Gemini Data converter module for PsionDataFile>GeminiDataFile would be too Byzantine, though I do remember the Sharp Mobilon series arriving with a ROM conversion app that converted Zaurus (SynergyOS) files to Windows CE 2.0.

The truer days of handhelds,
Jake


I'd be willing to look into what's involved if I can get an upload of a file in the appropriate format.

Faye
Go to the top of the page
 
+Quote Post
rodgos
post Jan 12 2019, 06:51 PM
Post #8





Group: Members
Posts: 54
Joined: 2-May 18
From: United Kingdom
Member No.: 822,018



My apologies for my tardy continuance of this thread. I had decided to make my first foray into the game with my books database, as the most interesting. I soon realised that it was miles out of date, and that there was little point in creating yet another out of date database. So, over the Xmas peiod I spent ages checking, editing and moving books . Out of the 1100, odd entries, I was down to the last half a dozen, when on a 'save' the Data application failed and left me with A Data file which gave only a 'Corrupt' message when it came to load it. Fortunately, I'd created a CSV file before embarking on the adventure. Here, I discovered that importing a .csv file does not create the database structure. To get this I had to go back to a very out of date backup, create a new database on it, free of content and import the data into it. So I had a working database, but back to square one. All this on the netBook, still my favourite piece of kit. In the meantime, I tried the csv and transfer, with another database. This one was 'Elements', one of the databses available for download when the genre was popular. As the name implies, it was data on the elements, both physical and atomic. So long as we do not have another supernova, the data will remain the same. Which is more than can be said of 'Books' So, along with mass, melting and boiling points, etc were details of isotopes, half lives and abundances. This went well, transferred from the netBook to the Gemini. here, a further problem. The csv file has no information as to structure, so importing would create the database but without the field headings to indicate what the content was. However, the Gemini database does the process in two stages. The first establishes the structure, and the second imports the data proper, into the database. Nicely, it seems the application does in fact, as far as I can ascertain, assign the content type correctly (text, number, date etc.). I had to go back to the netBook, copy all the field names into the Gemini, by hand and then move to the second stage, and import the data. It all worked well.
I've now completed the books database update, with hopefully no errors. I did find quite a lot of entries for which there were no books! No doubt, lost, stolen, strayed, given away, junked. Returning to transferring 'books'. It all went well until I opened the new file, when I found that one of the important fields, that of the books location in my collection was missing. Being missing all the following fields were misplaced up one level. Most unhelpful. Whereas my original data was of 'Book Title','Author','Location','Subject','Owner', the data was now set out with the data for 'Subject in the field for 'Location'. and all down the line. A lot of the books were collection of short stories from such classic SciFi magazines as Analog and Galaxy, where the contents too, figured in the database. I finally found the reason, by opening the .csv file in a text editor. For some odd reason the export function on the netBook has assigned the'Location', and 'Owner' to the last but one, and the last field in the series. At the moment, I'm at a bit of a loss how to put this right. I suppose I could open the file in a spreadsheet, on the PC, and move the whole columns back to where they should be
Go to the top of the page
 
+Quote Post
rodgos
post Jan 17 2019, 08:24 PM
Post #9





Group: Members
Posts: 54
Joined: 2-May 18
From: United Kingdom
Member No.: 822,018



That seems to be resolved. I've re-installed the gemini database from the revised text based .csv. Unfortunately it didn't work the other way about.. having two copies of the same database on two machines is not feasible for keeping them both in sync, and my modified .csv, while installable on the gemini is now not compatible on the Psion netBook. More headscratching required. I've been playing around with the newly installed data file, and have found a few snags. I'll open another thread for these, unless someone can point me back to the programming team at Planet.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
2 User(s) are reading this topic (2 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 22nd September 2019 - 06:28 AM