[Phpcompta-support] Re: Phpcompta-support Digest, Vol 35, Issue 9

[Alain Delmotte]

Je vais continuer en français comme il semble que la majorité le fait !
Mon post sous la réponse de Dany

PS. J'ai modifié mon inscription pour recevoir des messages et non des 
digest (question sujet !)

address@hidden a écrit :
> Today's Topics:
>
>    5. two question (Alain Delmotte)
>    6. Re: two question (Dany De Bontridder)
>   
> Message: 6
> Date: Thu, 07 Feb 2008 16:59:02 +0100
> From: "Dany De Bontridder" <address@hidden>
> Subject: Re: [Phpcompta-support] two question
> To: address@hidden
> Message-ID: <address@hidden>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Alain Delmotte writes: 
>
>   
> > Hi! 
> >
> > I am just discovering phpcompta (one and an half day).
> > As far as I see, it is promising. 
> >
> > I am working with Windows XP (I had to for my work, as there was no 
> > comptability software on Linux :-)), so eventually I'll migrate to Linux, 
> > if...) 
> >
> > I have questions:
> > 1) I have EasyPHP with MySQL installed, is it possible to have Postgrsql 
> > next to MySQL without problems and conflicts?
> > And is it easy to go to one or the other?
> >     
>
> Dany : well, someone who takes in charge the port to mysql will be welcome, 
> but up to now, there is no plan to support mySql, the problem is the time : 
> I don't have enough time to develop for mysql, test twice the application 
> (once with mySQL, once with postgresql...), explaining how to change the 
> database, test of the patch... 
>   
Ma question ne portait pas sur le portage de phpcompta vers MySQL, mais 
la possibilité d'avoir sur la même machine, côte à côte, MySQL *et* 
PostgrSQL ; sans qu'il y aie de conflit.

Pour EasyPHP et MySQL, tout se trouve dans le dossier c:\program 
files\easyphp ; et phpmyadmin ainsi que local host y trouvent les 
informations requises.

> > 2) Why should I create a specific user (not admin) to use phpCompta?
> > Is it only for security (one more password before to reach the books) or 
> > is it required by Postgrsql or phpcompta?
> > I am going to use the system on a stand alone machine (local server) and I 
> > do not really need loads of passwords (I do not use with my present 
> > bookkeeping software)
> >     
>
> Ok, to be short: one application, one owner : so we need an owner for 
> phpcompta's databases, so it means we need a postgresql user. With mysql, 
> often root is the owner, it is not the case here, root can't access 
> postgresql if it is not granted (except if he becomes the super user 
> postgres). It's also a question of security, the password of the superuser 
> is not written in files, the password is the one of the phpcompta user. 
>   
OK donc il faut un utilisateur non administrateur !
> > [3) Extra question, but I already know the answer = no]
> > Is it possible to export the parameters (like clients' parameters,...) 
> > from another system?
> > I use Ciel! Evolution and I already have many clients and suppliers!
> >     
>
> Everything is possible in IT, it is just a matter of competence, motivation 
> and time. 
>
> Are you developper ? If yes you can use the class_supplier and 
> class_customer to insert data, I can make a short explanation of this. WIth 
> these objects, it is easy to create and object customer (or supplier), to 
> fill them with required data and to save them into the database. 
>
> You need +/- 25 lines of code to do that (including the parsing of your 
> files), it is not as difficult. 
>   
En faisant référence à MySQL : par phpmyadmin je peux importer des 
fichiers (par exemple .txt avec tabulations) dans les tables d'une base 
de données.
Ma question était : est-il possible de le faire avec PostgreSQL? (Je 
vais explorer le web pour une initiation à PostgrSQL).

Merci pour la réponse et la réactivité,

Amitiés

Alain