20110929-setup-new-bbmb

<< Masa.20110930-setup-new-bbmb-rename-order-filename-bbmb-update-fi-google-twitter-button-migel | 2011 | Masa.20110928-search-faster-facebook-migel >>

1. Set up new Bbmb
2. All 'bezugsgruppe' must be 'Apo'
3. Create a new bin/admin command to set all 'bezugsgruppe' as 'Apo'

Goal/Estimate/Evaluation:

• Set up new bbmb / 100% /

Milestones

• Commit, push and pull
• Update customer and stock data
• Encoding lookandfeelbase.rb
• bezugsgruppe 'Apo'

Commit

• Updated for new data format (bbmb.ch)
• Updated for new data format (globopharm.xmlconv.bbmb.ch)
• Updated for new data format (xmlconv)
• Fixed encoding of lookandfeelbase.rb from utf-8 to iso-8859-1 (bbmb.ch)

ToDo

1. Create new bin/admin command to change 'bezugsgruppe' to 'Apo' (bbmb.ch)
2. 'Lieferant' (company name) is not shown in the search result view (bbmb.ch)
3. Update 'FI' information (get a new atc.yaml file from ch.oddb.org and put it manually, refer to http://dev.ywesee.com/wiki.php/Masa/20110728-setup-fi-ddd-bbmbCh)

Set up new Bbmb

Commit

• Updated for new data format (bbmb.ch)
• Updated for new data format (globopharm.xmlconv.bbmb.ch)
• Updated for new data format (xmlconv)
• Fixed encoding of lookandfeelbase.rb from utf-8 to iso-8859-1 (bbmb.ch)
  • Use convert.rb before committing lookandfeelbase.rb
  • See Encoding problem

Note

Summary for updating 'globopharm.xmlconv.bbmb.ch'

IMPORTANT

• 'globopharm.xmlconv.bbmb.ch' uses 'bin/xmlconvd' of 'xmlconv' repository (the 'bin/xmlconvd' of 'globopharm.xmlconv.bbmb.ch' is a symbolic link)
• 'lib' directory is overwritten by the 'lib' directory of 'xmlconv' repository in my local environment (Let's think more reasonable way)
  • I have to commit separately 'lib' directory update (to 'xmlconv' repository)
  • Some files are modified for the local environment (See setup.bbmb.ch shell script)
  • -> Let's think about more efficient way (when I update 'globopharm.xmlconv.bbmb.ch')

Command log

$ bin/admin
ch.bbmb.globopharm> overwrite_customer_ids_by_email '/var/www/bbmb.ch/new_customer_id_ean_email.dat'
-> 28
ch.bbmb.globopharm> replace_customer_ids_gag_to_alloga '/var/www/bbmb.ch/actual_gag_ean_allo_user_ids.csv'
-> 124
ch.bbmb.globopharm> replace_article_ids_gag_to_alloga '/var/www/bbmb.ch/actual_gag_ean_allo_stock_ids.csv'
-> 271
ch.bbmb.globopharm> update
-> 

Note

• There are 3 mapping files needed to execute the update methods above
  1. new_customer_id_ean_email.dat
  2. actual_gag_ean_allo_user_ids.csv
  3. actual_gag_ean_allo_stock_ids.csv
• These file are generated from Customer.csv and Item.csv on the ftp server
• The scripts to make the 3 mapping files are located in http://dev.ywesee.com/wiki.php/Masa/20110722-replace-user-stock-ids-bbmb
• Once we have done the replacing completely, we do not have to execute the replace methods again

All 'bezugsgruppe' must be 'Apo'

Problem

• 'bezugsgruppe' is not 'Apo'

Note

• I should log-in bbmb.ch by usgin root user account to see 'bezugsgruppe'

Refer

• http://dev.ywesee.com/wiki.php/Masa/20110726-update-new-user-stock-format-bbmbCh-inject-local-xml-order-xmlconvBbmbCh#GrpMethod

Consider

• src/custom/behavior.rb#update_users updates the 'bezugsgruppe' (values[:group_short]) to 'Apo'
• update bin/admin command calls the 'update_users' method

Create a new bin/admin command to set all 'bezugsgruppe' as 'Apo'

Experiment

ch.bbmb.globopharm> users.values[0]
-> #<BBMB::HospitalUser:0x7fa2f527c7d0>
ch.bbmb.globopharm> users.values[0].value('group_short')
-> Aerzte

ch.bbmb.globopharm> users.values[0].value('customer_id')
-> 404439
ch.bbmb.globopharm> resellers.values[0].users.values[0].value('customer_id')
-> 404439

Note

• 'value('group_short')=' method is not available

Experiment

ch.bbmb.globopharm> users.values[0].instance_variable_get('@attributes')[:group_short]
-> Aerzte