Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Install a lib xlrd module in my Pyhton datebase on my Synology NAS

By
MetAandacht
on 8/3/14, 5:27 PM 3,849 views

Hello People,  I need to install the "lib xlrd" for my OpenErp 7.0 system so I can install de the "bank_statement_module".

I don't now what I am doing rong!

1. I installed the Putty for my windows 7 machine 

2. I configured my Synology NAS for a terminal connection including the firewall setting

3. I start-up a connection with Putty between my windows 7 machine and my Synology NAS

4. I downloaded the xlrd module on the Python website

5. I tried to install the module but it doesn't work! :-(

I used different kind of actions like

"sudo apt-get update"

"sudo apt-get upgrade"

"sudo apt-get install xlrd"

But I get all the time a massage like "Not found"

Please good some one help my?

1

Dhinesh - Technical Consultant, Sodexis Inc

--Dhinesh - Technical Consultant, Sodexis Inc--
3577
| 5 4 9
Pondicherry, India
--Dhinesh - Technical Consultant, Sodexis Inc--

Passionate coder in Python/OpenERP. Knows Django/Flask MVC frameworks. Did code in Java, PHP.

Contact me at: dvdhinesh.mail@gmail.com

Dhinesh - Technical Consultant, Sodexis Inc
On 8/4/14, 12:50 AM

Extract the downloaded package and use this comment to install: sudo python setup.py install

More info here...

Dear Dhinesh, I am in the root folder of the synology NAS I use. But do not now where I have to download the package so I can comment it in Putty to install. Do you maby no where i can find this, I am searching for 4 hours on the internet but I see no answer. I hope to here you soon. Kind regards, Remco Willekus

MetAandacht
on 8/25/14, 3:06 PM
0
Jan-Paul Theunissen
On 3/28/15, 3:20 PM

Dear Synology users,

This answer is directly targeting those of you who'd like to use OpenERP on a Synology NAS server.

I've gone through substantial efforts to get to the bottom of certain issues with the combination of OpenERP7.x with a Synology server. In this posting I'd like to give you a heads-up on some of the most "crucial" elements one has to think about when (or before deciding if) starting to customise the standard OpenERP installation:

1. By default only a "limited" set of modules are available on a standard OpenERP installation on a syno Box. If a user want to add more modules this is quite well possible but one needs to have some knowledge of SSH and command line syntax to do this succesfully. More about this later (see Ad 1. section).

2. If Python needs additional modules (like xlrd), this will require adding the python code to OpenERP7.x's "modules" directory (this is located in the following path on a Synlogy box: /volume1/@appstore/OpenERP7.x/openerp/modules. This is completely different from adding a "module" through OpenERP7.x directly and also completely different from adding a library like xlrd to Python.

Ad 1.

  1. To add "non-standard" modules first download whatever module you'd like to add to your Mac/PC and,

  2. unzip/untar the downloaded file (for those of you adventurous enough, obviously you can also do the unzipping/untar-ing on the box)

  3. now copy the unzipped folder (whole directory) to your Synology NAS (I'll assume you copy it using your web-interface to /volume1/homes/admin (the main admin directory)

  4. access your Syno box via SSH and enter the following command (adapt the paths to the locations you have used)

  5. cp -R /volume1/homes/admin/name_of_directory_with_OpenERP7_module /volume1/@appstore/OpenERP7.x/openerp/addons 
  6. Check if the new module "landed" in the correct spot

  7. ls -la /volume1/@appstore/OpenERP7.x/openerp/addons/name_of_directory_with_OpenERP7_module 
  8.  The response should be a listing of the contents of the directory you just added. If you get an error (directory does not exist or something, please make sure the paths you entered were correct)

  9. The last thing you need to do is to change the owner of the new files in the module
    (by default any file for OpenERP7.x is owned by http and the group http

  10. chown -R http:http /volume1/@appstore/OpenERP7.x/openerp/addons/name_of_directory_with_OpenERP7_module 
  11. Now you can reload the modules in OpenERP "Update Modules list" from within OpenERP (in "settings" menu)

Ad 2. To add a library/module like xlrd (which is required for a module like for instance "Swiss bank statements import" for OpenERP7.x, the following steps need to be executed:

  1. Download the library/module https://pypi.python.org/pypi/xlrd and unpack the package on local HD

  2. Copy the contents of the package to the Synology. Copy it to any location of the user's desire (I'll assume /volume1/homes/admin/xlrd-0.9.3, using rsync via SSH or just drag and drop via web interface)

  3. cd /volume1/homes/admin/xlrd-0.9.3
    python setup.py install
  4. The above commands will add the module to Python but still not available to OpenERP7.x. It took me a while to realise this so I'm hoping this line will help you go the next steps. So if you're not quite feeling satisfied, read on...

  5. In order for OpenERP7.x to be able to use 'xlrd' copy a file called 'runxlrd.py' into the modules directory (located at: /volume1/@appstore/OpenERP7.x/openerp/modules

  6. cp /volume1/homes/admin/xlrd-0.9.3/scripts/runxlrd.py /volume1/@appstore/OpenERP7.x/openerp/modules
  7. Now xlrd will be accessible to OpenERP7.x but OpenERP may require a reboot (this you can do via the package manager (stop/start) or using a command like this:

  8. su -s /bin/sh -m -c "/volume1/@appstore/OpenERP7.x/bin/openerp-server --config=/volume1/@appstore/OpenERP7.x/openerp-server.conf --addons-path=/volume1/@appstore/OpenERP7.x/openerp/addons/ --logfile=/volume1/@appstore/OpenERP8.x/logs/server.log" http 

 All done, hope this helps.

Happy OpenERP-ing! 

Cheers Jappie




0

Bole

--Bole--
2385
| 5 4 6
Zagreb | Karlovac, Croatia
--Bole--

there is only 10 kind of people the ones that understand binary ... and others

Bole
On 8/26/14, 7:31 AM

you can also try like this:

sudo apt-get install python-pip
sudo pip install xlutils  

-> xlutils contains xlrd and xlwt (libraries for reading xls files : xlrd , and for writing xls file: xlwt)

0

ton123

--ton123--
1418
| 5 6 9
Lisse, Netherlands
--ton123--
End-User. Installed 6.1.1 on a DS412+, DS211+ and DS113J Synology NAS. Reference installation on Ubuntu 12.04/Samsung Notebook. 12-03-2013 In production for Suppliers and Customers, adresbook. 7 small companies. Testing accounting, document management, import and export. Too much showstoppers I haven't fixed at this moment. 06-05-2013 little progress. Migration to v7 impossible because of missing Dutch localisation modules. What I see working is nice, so further testing and asking. Start testing products and warehouse. Happy with this forum and the community.
ton123
On 10/16/14, 3:20 AM

Synology linux is a very customized version of linux. The usual linux command language doesn't work. The directory structure is also very special. Adding libraries is possible but difficult and can give conflicts. Starting with synology installed openerp version is easy but it is only nice to play with. I have tried it for more than a year and couldn' t make it functional and stable for my business environment. The community is not familiar enough with this combination. You are on your own. Anyway i didn't succeed in it. And i have put everything on hold waiting for more interest in the community for this.

0
MetAandacht
On 8/25/14, 1:38 PM

Dear Dhinesh, Thank you very much for your time so far.

I do not now how and where I have to extract the Package.

I use a Synology server connected with Putty.

I hope this is enough information.

kind regards, Remco Willekus

 

 

 

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 8/3/14, 5:27 PM
Seen: 3849 times
Last updated: 3/28/15, 3:59 PM