Forum OpenACS Development: Ref Currency pkg

Collapse
Posted by Iuri Sampaio on
Hi there,

I installed the package ref-currency but the table currencies remains empty. Was it supposed be filled in, after package installation?

The files /sql/postgresql/00-currencies.ctl and /sql/common/currencies.dat are properly in place. .CTL script ran just fine back then in the installation process which had no errors logged, for instance.

Lastly, the file /sql/postgresql/ref-currency-create.sql seems fine to me.

Why the data isn't there then?

SELECT * FROM currencies; returns 0 (nada!)

Best wishes

Collapse
2: Re: Ref Currency pkg (response to 1)
Posted by Iuri Sampaio on
There we go.

It required a small change in the SQL syntax because of PG version I'd say.

\COPY currencies FROM '/var/www/iurix/packages/ref-currency/sql/common/currencies.dat' WITH DELIMITER AS ',' NULL AS ''

Best wishes

Collapse
3: Re: Ref Currency pkg (response to 2)
Posted by Iuri Sampaio on
To make it as a core contribution.

\COPY currencies FROM '[acs_root_dir]/packages/ref-currency/sql/common/currencies.dat' WITH DELIMITER AS ',' NULL AS ''

Collapse
4: Re: Ref Currency pkg (response to 3)
Posted by Gustaf Neumann on
Thanks, Iuri, fixed in CVS HEAD.