Forum OpenACS Development: Ref Currency pkg
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!)
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 ''
\COPY currencies FROM '[acs_root_dir]/packages/ref-currency/sql/common/currencies.dat' WITH DELIMITER AS ',' NULL AS ''