20120316-improve-interaction-basket-view-update-patinfo-yaml

<< | Index | >>

summary

• updated oddb2tdat gem.
  • added support migel_all_products_(de|fr).csv support.
  • removed unexpected string in CISK from oddb.csv
  • (NOTE:) to check bin/oddb2dat_import_prmo (no in gem)

commit

oddb.org

• Fixed subscription price for downloads

oddb2tdat

• Updated for migel.csv support
• Removed '+' and blank space in CIKS from oddb.csv

index

• Updated oddb2tdat
  • ackage making
  • Added support migel_add_products.csv
  • 14 digits EAN code
  • Updated oddb2tdat command
• Fixed subscription price in download service

Updated oddb2tdat

ackage making

rake package command failed.

$ rake package
which: no dot in (/usr/local/sbin:/usr/local/bin:/usr/local/bin:/usr/bin:/bin:/opt/bin:/usr/i686-pc-linux-gnu/gcc-bin/4.5.3:/usr/games/bin)
$ rake gem
which: no dot in (/usr/local/sbin:/usr/local/bin:/usr/local/bin:/usr/bin:/bin:/opt/bin:/usr/i686-pc-linux-gnu/gcc-bin/4.5.3:/usr/games/bin)

I noticed this gem use hoe gem.

 $ ruby -r hoe -e 'p Hoe::VERSION'
"2.13.0"

updated hoe to 2.16.1. It works.

$ sudo rake install_gem 
or
$ sudo rake clean
$ sudo rake package
$ sudo gem install --local pkg/oddb2tdat-1.0.8.gem

Added support migel_add_products.csv

This file are exported via Migel::Util::Server#export_products in migel/lib/migel/util/server.rb

NOTE: (header)

 0. product.migel_code,
 1. product.pharmacode,
 2. product.ean_code,
 3. product.article_name.send(lang),
 4. product.companyname.send(lang),
 5. product.companyean,
 6. product.ppha,
 7. product.ppub,
 8. product.factor,
 9. product.pzr,
10. product.size.send(lang),
11. product.status,
12. product.datetime,
13. product.stdate,
14. product.language,

used following values from MiGEL csv

• pharmacode
• article_name
• ppha
• ppub
• eancode

14 digits EAN code

Some MiGel record has 14 digit EAN code.

...
1112013024SOFNET Stomakompresse 10x10cm 8f 100 Stk          00050000000030000000000  0000000000000  (<- EAN code debug)
1112180880MODERMA FLEX Colo 1t 25mm hf                      01440002030030000000000  10610075105776
1112877983MODERMA FLEX Colo 1t 25mm konvex hautf            02120003000030000000000  10610075112415
1112878468MODERMA FLEX Colo 1t 20mm konvex transp           02120003000030000000000  10610075112460
1114605510EAKIN Release adhesive remover Spray 50 ml        00200000280030000000000  0000000000000
1112164355ASSURA COMF Kolo 1t 20-50/65 mini hautf           00000003040030000000000  5701780732116
...

• http://oddb.yasuhiro.org/de/gcc/search/zone/migel/search_query/MODERMA%20FLEX#best_result

skipped these products.

EAN digits - count in MiGel

• 14 EAN - 548
• 13 EAN - 30192 (contain empty EANs)

created simple ean14 counter (skip empty EANs)

Attach:ean_14_counter.rb-20120316.txt:

output:

$ ./ean_14_counter.rb ./migel_all_products_de.csv
14 EAN - 548
13 EAN - 25004
--------------
30382903012290
30382903006299
30382903009122
30382903001379
30382903008651
30382903096580
30382903096498
30382903009115
35413206005209
...

Updated oddb2tdat command.

New usage:

/usr/local/bin/oddb2tdat ver.1.1.0
Usage: 
  /usr/local/bin/oddb2tdat <input file (oddb.csv)> <output file (oddb.dat)>
  /usr/local/bin/oddb2tdat <input file (oddb.csv)> <output file (oddb.dat)> <transfer file (transfer.dat)>
  /usr/local/bin/oddb2tdat <input file (oddb.csv)> <output file (oddb.dat)> <optional input file (migel.csv)>
  /usr/local/bin/oddb2tdat <input file (oddb.csv)> <output file (oddb.dat)> <optional input file (migel.csv)> <transfer file (transfer.dat)>

Fixed subscription price in download service

• http://oddb.yasuhiro.org/de/gcc/download_export/

commit

• Fixed subscription price for downloads

simlpe download files creator script.
This are needed show available files in downloads state.

Attach:list.sh-20120316.txt