OpenConcerto-sql.zip for Windows o.s. multiposte installation

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Install Postgres on Windows OS
2. Follow instructions to create openconcerto connection user.
3. Exécute OpenConcerto-sql using administration tool

The openconcerto database should be created an initialized, but
errors are raised, due essentialy to the linux's specific syntaxes.
[COPY "ACCES_SOCIETE" ("ID", "ID_USER_COMMON", "ID_SOCIETE_COMMON", "ARCHIVE", 
"ORDRE") FROM stdin;
1   1   1   0   0.00000000
\.]

One error is raised trying to assign an object to a non-existing user (who's 
maillard?)  
[ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO maillard;]

I've begun to clean all comments in the script first.
Then I issued to execute the script until the "COPY" instructions.
No way to go further. 
Now, i should have to extract each data rows to put them in some external 
files...tough too much!!

Original issue reported on code.google.com by florent....@gmail.com on 11 Mar 2012 at 10:29

[GoogleCodeExporter]

Maybe i should specify the context :
I'm triying to improve the software for a close acquaintance who asked me for 
help...

Original comment by florent....@gmail.com on 11 Mar 2012 at 10:40

[GoogleCodeExporter]

the user maillard can be safely replaced by openconcerto or postgres.
COPY is not linux specific,
use the 'psql' command to inject the sql script, see the forum for more 
information

Original comment by guillaum...@gmail.com on 27 Mar 2012 at 8:57

• Changed state: Done
• Added labels: Priority-Low, Type-Enhancement
• Removed labels: Priority-Medium, Type-Defect

[GoogleCodeExporter]

I am facing the same problem by the installation with Postgres. I am using 
Postgres 9.2 and database server working properly.
When I try to execute the openconcerto.sql-1.2 using the pgAdmin III I get a 
number of error begining with 
ERROR:  Syntax error by »1«
LINE 22483: 1 1 1 0 0.00000000
            ^

and so on at anytime

Original comment by lnadi...@googlemail.com on 12 May 2013 at 11:58

[GoogleCodeExporter]

Bonjour

Même problème que ci-dessus, le script fourni pour créer la base dans 
postgresql ne fonctionne pas.
Personne n'a répondu depuis mai dernier ?
Ce n'est pas très sérieux. Openconcerto existe encore ou c'est tombé à 
l'eau ?

Original comment by c.gallin...@abaque-s.fr on 2 Feb 2014 at 3:13

[GoogleCodeExporter]

Bonne question!! Openconcerto existe-il encore en libre!!
J'ai exactement le même problème aussi quand j'essaye d'injection le dump. Il 
n'y a personne qui veuille éclairer les autres!!?? C'est plutôt toujours flou 
et on nous demande d'acheter le manuel!! C'est justement pour manque de budget 
on s'est dirigé vers le OpenSource justement!!

Original comment by bahsekou...@gmail.com on 19 Feb 2014 at 3:00

[GoogleCodeExporter]

I got the same exact problem. have anyone figured out any solutions and solve 
it? How did you do?

Original comment by bahsekou...@gmail.com on 19 Feb 2014 at 3:05

[GoogleCodeExporter]

first create a new database in postgre DBMS then create a new role under the 
name openconcerto after finishing :

Click on Plugins/PSQL Console
Write \i /path/to/yourfile.sql

for example : 

\i E:\openconcerto_dump_file.sql

Original comment by boufouss...@gmail.com on 6 Jun 2014 at 8:25