Re: [libreoffice-users] Re: [libreoffice-documentation] Re: Base Document - Forms

Hi :)
Superb!  Thanks :)

Errr, if you are "up for it" then it would be great if you could join the
Documentation Team to help review or proof-read the Base Handbook.

For many people i suggest starting with something more familiar before
diving into Base because there is quite a lot else to get used to when
joining the Documentation Team.  We do still have a couple of chapters of
the Writer Guide left but in your case i think you could jump straight into
working on the Base Handbook.

I'm trying to keep the first few chapters available for a new person to the
team so that he can learn about Base as he goes.  The more people joining
in the better!  Especially people who have experience with databases such
as you and Peter G.

Thanks for the advice though!  On another mailing list people suggested
that it might be something wonky about the import filters for the date
format (the devs did some work on them in the 4.1 branch) or that Excel
might not be properly setting the date-field.  Your pointers give
additional options.

So, thanks and regards from
Tom :)


On 28 September 2014 12:25, Paul <paulsteyn1@afrihost.co.za> wrote:

> I've got some experience with various databases, but little with
> Access, sorry.
>
> Given the OP exported the data from Access once, I'd assume that it's
> possible to export to csv format instead of Excel spreadsheets, and I'd
> recommend that. Then importing into Base should be straightforward, and
> formatting shouldn't be lost. Access might even give some options for
> the export formats, but worst case the data can be massaged in Calc
> before importing into Base, say to change the date format.
>
> If the OP is still having trouble with this, he can try posting a
> couple of lines of the exported csv file, and we can see if there is a
> reason Base is not importing it correctly.
>
> This does sound like it should be possible with the method he is using,
> but it's much harder for me to debug. If he's using plain csv files,
> just posting a couple of lines would give me an idea of how the data
> looks, and I could test on my machine, which does have Base, but not
> Access.
>
> And if he wants to go to MySQL/MariaDB/PostgreSQL, again using csv
> files should be pretty straightforward, even if it does mean command
> line and queries, and not a GUI interface. Although those exist, I'm
> just not as familiar with them.
>
> Paul
>
> On Sun, 28 Sep 2014 09:29:57 +0100
> Tom Davies <tomcecf@gmail.com> wrote:
>
> > Hi :)
> > Ok, so the Documentation Team have got an example database for Peter
> > to work with in the short-term but the question of how to migrate an
> > Access Database would still be good to get some hints and advice on.
> >
> > Is there anyone who can help with this?
> > Regards from
> > Tom :)
> >
> >
> > On 28 September 2014 09:13, Tom Davies <tomcecf@gmail.com> wrote:
> >
> > > Hi :)
> > > Errr, obviously if he's using Access then it must be Windows.  The
> > > only other platform that MS Office has been able to port to was Mac
> > > and they weren't able to port Access were they?
> > >
> > > Anyway, i think that mean Peter could use some help porting an
> > > Access database to either Postgresql, MySql/MariaDb or into Base
> > > itself and on Windows.
> > > Regards from
> > > Tom :)
> > >
> > > On 28 September 2014 09:09, Tom Davies <tomcecf@gmail.com> wrote:
> > >
> > > > Hi :)
> > > > Has anyone here got experience with migrating Access databases to
> > > > Base?
> > > >
> > > > I have a strong feeling that migrating the Tables to Postgresql or
> > > > MySql/MariDb would be a better first step.
> > > >
> > > > I'm not sure what platform Peter is on, sorry.
> > > > Regards from
> > > > Tom :)
> > > >
> > > >
> > > > On 28 September 2014 05:22, Peter Goggin <petergoggin@bigpond.com>
> > > > wrote:
> > > >
> > > > > I am working through the documentation for the forms. To do this
> > > > > properly I needed a data base. As I have an access data base
> > > > > which I want to convert to Librebase I used this. I exported the
> > > > > tables from Access as Excel files, opened them in Librecalc,
> > > > > saved them in native librecalc format. I made sure the column
> > > > > definitions were correct for dates.
> > > > >
> > > > > I copied the data cells and imported them into a Base table. I
> > > > > found a problem with all fields which were created as text.  If I
> > > > > change the date columns to date format I cannot save the new
> > > > > version of the base table without losing the date data. Is there
> > > > > any way of importing data and preserving the data format?
> > > > >
> > > > > Many years ago using Oracle SQL I believe you could import text
> > > > > data into an already created table if your text data had been
> > > > > properly formatted. Is this possible with LibreBase?
> > > > >
> > > > > Thanks for an advice.
> > > > >
> > > > > This won't stop me from continuing to reviews the documentation
> > > > > but it would be good to know how to import data , retaining the
> > > > > formatting and data types.
> > > > >
> > > > > Regards
> > > > >
> > > > > Peter Goggin
>
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted