Premiado

Magento extension Tech Spec

Could you please estimate the work described in this email below?

Magento extension Tech Spec:

1. Create a new module for "Magento Community Edition 1.8.0.0" under "local" namespace and call it "W3i_ImportRates".

2. Create a configuration var "w3i/w3i_rates/w3i_exchange_rate" under "System -> Configuration -> W3i -> Rates -> Exchange Rate" with default value set to [url removed, login to view]

3. The new module should create an "Advanced Dataflow Profile" using the data install interface. Name for the profile is "Import Custom Rates".

Created profile will be used by an admin to import a CSV file located on the server into a new table, that has to be created using sql install interface.

The table should be called "w3i_rates" and should have 3 fields:

- "country" - varchar(32) NULL

- "group" - varchar(32) NULL

- "rate" - decimal(12,4) NOT NULL

- PRIMARY KEY ("country", "group")

CSV format:

"country,group,rate"

where:

- "country" is a country code in ISO 3166

- "group" is a free text

- "rate" price in some currency

CSV Example:

country,group,rate

FR,ven123,[url removed, login to view]

4. Dataflow profile should parse the CSV from "/var/import/[url removed, login to view]" (will be uploaded manually over the FTP) and populate "w3i_rates" table.

Table should be truncated before the import.

5. It is also required to create a Custom Indexer Model that will populate an index table called "w3i_rates_idx", once dataflow profile execution is over or the "w3i_exchange_rate" value is changed. Also the index can be rebuilt manually from "System -> Index Management".

Index Name in the backend: Custom Rates Index

"w3i_rates_idx" table should have 3 fields:

- "country" - varchar(32) NULL

- "group" - varchar(32) NULL

- "final_rate" - decimal(12,4) NOT NULL

- PRIMARY KEY ("country", "group")

where "final_rate" value is a "rate" value taken from "w3i_rates" table and multiplied by "w3i_exchange_rate".

So, "w3i_rates_idx.final_rate" = "[url removed, login to view]" * "w3i_exchange_rate"

6. The final module should be packaged using "System -> Magento Connect -> Package Extensions" and sent back as a single file.

Habilidades: Magento

Ver mais: magento tech spec, tech data, sql create table price, execution table, exchange currency rates table, currency table rate, currency rate table, currency rates table, call tech, spec, magento server configuration, magento extension, key value model, it spec, magento create admin, sql server import text, magento indexer, magento extension configuration, magento create table, csv import sql server, email indexer, import sql ftp, magento install sql, magento system interface, currency rates csv

Acerca do Empregador:
( 0 comentários ) Russian Federation

ID do Projeto: #5080503

1 freelancer está ofertando em média $150 para este trabalho

dannv

Hired by the Employer

$150 USD in 4 dias
(228 Comentários)
7.1