Forum OpenACS Development: Ref Currency pkg

1: Ref Currency pkg

Posted by Iuri Sampaio on 09/27/15 08:37 PM

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

2: Re: Ref Currency pkg (response to 1)

Posted by Iuri Sampaio on 09/27/15 08:55 PM

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

3: Re: Ref Currency pkg (response to 2)

Posted by Iuri Sampaio on 09/27/15 08:57 PM

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 ''

4: Re: Ref Currency pkg (response to 3)

Posted by Gustaf Neumann on 09/28/15 08:07 AM

Thanks, Iuri, fixed in CVS HEAD.