[Koha-bugs] [Bug 7736] Edifact QUOTE and ORDER functionality

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Fri Mar 22 14:45:00 CET 2013


http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7736

--- Comment #57 from Brendan Gallagher <brendan at bywatersolutions.com> ---
Comment on attachment 16779
  --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=16779
Instruction to test the patch and how-to use the feature



Perl dependencies
-----
Edifact::Interchange
Business::ISBN
Net::FTP
Net::FTP::File


(This should be at the top - Removed somewhere along the line)

>Test Plan - Koha EDIfact module - PTFS Europe 
>
>(Updated by Brendan Gallagher - ByWater)
>(with little extra frm Zeno tajoli
>
>Setup, testing and how-to
>-----
>
>1. Allocate permissions to a staff user
>Find a staff user and click the Details tab.
>Select More > Set permissions
>Expand the Tools options, then check '(edi_manage) Manage EDIFACT transmissions', 
>then click the Set flags button.
>This user should now be able to see an EDIfact messages option in Tools > Additional Tools
>
>2. Set default values for testing the included quote message
>Add two test branches with the branchcodes 'BRANCH1' and 'BRANCH2'
>Add two funds with the fundcodes 'FUND1' and 'FUND2'
>Add three itemtypes with the codes 'BKREF', 'BK1WK', and 'BK4WK'
>Add three authorised values in the LOC category - 'REFERENCE', 'STORE', and 'SHELVES'
>
>3. Add the test bookseller and EDIfact account details
>Create a new bookseller with the name 'PTFS-Europe'
>Go to Administration > Additional Parameters > EDI Accounts
>Add a new account:
>        Vendor: PTFS-Europe
>        Description: Test EDI FTP account
>        Server hostname: <hostname of your FTP account> 
>			**ByWater for testing - 166.78.149.34
>        Server username: <user with read and write permissions> 
>			**ByWater for testing - edifact2443
>        Server password: <password of the above user> **ByWater for testing - order2443
>        Server remote directory: <path to the remote directory holding edi quotes and orders> 
>			**Bywater is offering one for testing - /home/edifact2443
>        Vendor SAN/EAN: 5099876543210
>Click save (these details can be edited or removed using the options in Administration > 
>Additional Parameters > EDI Accounts)
>Upload the supplied quotes file to the Server remote directory on your FTP server
>(supplied quotes file is in misc/edi_files/ptfs-europe-koha-community.CEQ)  
>***(Brendan has uploaded that file to ByWater temp FTP and renamed it edifact_test_brendan.CEQ)
>
>
>4. Check the mode of FTP
>The test FTP site works in a 'passive' mode. Now (2013) passive mode is standard for FTP sites.
>Ask to your vendor if his site support FTP in passive mode.
> 
>
>5. Setup the  misc/edi_files dir
>Before running the import, ensure that the user running the web server has read/write 
>access to  misc/edi_files and the files in it (drwxrwx--- koha www-data)
>The defaults users are 'koha' [standar command line users] and www-data [standard debian 
>apache user].
>With those users you the instructions are:
>
>cd <your install patch>/misc
>sudo chown koha:www-data edi_files
>sudo chmod 770 edit_files
>sudo touch edi_files/edi_ftp_error.log
>sudo chown koha:www-data edi_files/edi_ftp_error.log
>sudo chmod 770 edi_files/edi_ftp_error.log
>
>It is important that you create an empty file misc/edi_files/edi_ftp_error.log and that
>koha and apache could togheter use it. The file misc/edi_files/edi_ftp_error.log will be
>used as log file for errors about EDI.
> 
>
>6. Import the quote file from the Vendor FTP account
>On the command line cd to misc/cronjobs and run 'perl edifact_order_ftp_transfer.pl' 
>ordinarily this would be automated at intervals using the cron)
>The remote file will be renamed following EDI convention with a .EEQ extension. You 
>can also move the file to another directory (see later details)
>The last activity date will be updated in the vendor EDI account
>FTP transactions are logged in misc/edi_files/edi_ftp.logged
>Any errors in processing the quote will be logged in edi_quote_error.log
>Downloaded EDI messages are stored in misc/edi_files and also in the 
>edi_messages MySQL table
>
>
>
>7. View the EDI message
>Go to Tools > EDIfact messages
>Messages are listed in date order descending. You should have a QUOTES
>type message with a status of processed, and a link to the basket
>holding the order
>
>Click View basket
>Three items should be in the basket, linked to the correct funds, branches,
>etc. that you specified earlier.
>When the quote message is imported, existing bib records are checked for a match
>on ISBN. If a match is found, items are attached to that bib record. If no
>matches are found, a bib record is created using the detail from the quote 
>message and items are attached to them. The name of the created basket is the
>same as the originating quote message filename
>
>
>
>8. Sending an order message back to the vendor
>Click the EDIfact order button (this is only shown for vendors with an associated
>EDI account). Now the EAN used for identify the library is the code in 
>the system prefernce 'EDIfactEAN'. So, for now, all libraries share the same EAN
>identifier
>
>The EDI order message is generated and delivered to the 
>vendor FTP site. Filenames take the format 'ediorder_xxx.CEP' 
>(where xxx is the basket number).
>The edi_messages table is updated with an entry for your edi order message with
>a status of sent, transactions are logged to misc/edi_files/edi_ftp.log, and the
>last activity date is updated for the vendor edi account.
>
>
>9. Sending an order message without a quote
>Any vendor that has an edi account can accept order messages without a quote. 
>When you have created a basket from scratch, follow the instructions in step 7 
>to send the order message.

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list