Export the products in a database:

In EasyForYou, go to menu Tools->Export products.
EasyForYou will generates a file with MsAccess format (C:\Temp\ArtEFY.mdb) which contains the whole of the products present in EasyForYou.

Importation of a new database:

After having exported C:\Temp\ArtEFY.mdb, take this database as structure sample.
You can modify the price of the products present in ArtEFY.mdb, it will be updated in EasyForYou during the re-importing.
To add new products in EasyForYou, respect the structure of ArtEFY.mdb. Carry out a copy of ArtEFY.mdb in then folder c:\program files \easy for you while taking care to rename the file to import as ART.MDB.
During the restarting of "Easy For You" the new products will be imported and the price of the existing products will be updated.

Caution: following this operation, file ART.MDB will be automatically deleted.

Please respect these recommendations for the import of new products:

• In the field CLEF (product Code) , only numbers, capital letters allowed.
• No spaces allowed in this field!
• Only the sign "-" (less) is accepted in the field CLEF and CLE2.
• In the fields texts, do not use apostrophes or star (*) .
• For the quantities, not to update field QUAN (quantities) directly but to pass by the encoding of the purchases - > Inventory.

The Back-Order tab lists the OPEN orders of all customers (or suppliers for purchases)
BO=Back-Orders (orders that have not been delivered yet)

TO CREATE A PARTIAL DELIVERY :

1. Under the back-order tab, select the specified customer by double-clicking the corresponding line of the document.
2. For each product, enter the quantity to be delivered under the column "delivered" (the only column you can edit) and press the F10 key to validate the whole operation
3. To generate the invoice corresponding to these products and to remove them from the inventory: click Code customer and then click the right button of your mouse and choose "copy to" invoice or picking ticket

Note :

• Only the lines corresponding to a fill in delivery disappear from the table after invoicing.
• The corresponding order is automatically closed when the total of the products have been delivered.
• Printing or the pre-visualisation shows the quantity left to deliver

1) Keep a copy of your file layout.htm and make a copy to a new file: layoutmod.htm

2) Modify your file layoutmod.htm with a HTML editor

3) You may NOT at any time:

• Delete the field us-Name1, us-post and us-City that must be represented in the heading of your new document.
• Delete the tag of commentary that serve as a point of Code for the software

4) Test your new page layout by printing several different documents.

NOTE, as long as you do not have the official EFYLAYOUT licence at your disposal, the amounts will be replaced by the word "TEST" or 0 and the software will post a message such as "Licence EFYLAYOUT for c:\...\layoutmod.htm is invalid"

5) If you are satisfied with your new page layout, please send us your file layoutmod.htm by attachment for approval.

6) Once you have received an approval, you may order and pay for the module EFYLAYOUT.

7) As soon as your payment has been received, you will receive the official licence in an attachment via email.

1) Parameterisation of EasyForYou.

In the menu Parameters->General->ID Barcode->Value = 120

2) Parameterisation of barcode scanner (keyboard interface).

1. Language for keyboard interface (group 3)
   Adjust the country parameters for your keyboard
2. Terminator: (group 4)
   No character (ENTER) after scanning but SPACE.
3. General Parameters (group 16)
   Choose: Upper Case
   
4. Code ID Setting (group 17)
   Choose the barcode types (the most used: CODE39, EAN13/UPC-A)
5. Function Key Emulation (group 20)
   Program the beginning of the scanning (see group 6 - Preamble) of the barcode by the function key F9 or HEX 09

3) Scan the barcodes from EasyForYou.

In document management, choose your customer or supplier, then the type of document followed by the + button or F2 to add a new document. From this moment, the focus automatically passes into the bottom grid to the encoding of products and you may begin the data entry of your barcodes with your scanner.

If the barcode Code of the scanned product does not already exist in your product file, EasyForYou prompts you to create a new product form.

Procedure (single user)

1. Check licenses, click File-> Licenses-> To download...GO ...
2. In the Menu Tools->Update software, check if the date of license is OK-> 20??, Otherwise click the menu Tools-> Calculation of the price of your update, order the license and return to point 1.
3. Make a backup in the menu Tools-> Backup ...
4. Perform the update from the menu Tools->Software Update
5. Wait until the update if finish and re-start EasyForYou.

In network you must insure at 100% that:

1. Verify on each workstation that no easywin.exe session is open (see Windows->CTRL-ALT-DEL->Task manager->Applications).
2. Execute a test (on the server if you are on the network) by renaming easywin.exe and easywin.mdb to easywin2.exe and easywin2.mdb.
3. If Windows authorizes the name change of both files, you can be sure that no one is working in the EasyForYou program.
4. In the properties of the shared folder for the network, please DO NOT SHARE THIS FOLDER until the update takes place normally.
5. (On the server, if you are working on the network) rename easywin2.exe and easywin2.mdb with their original names easywin.exe and easywin.mdb.
6. DO NOT restart EasyForYou and update from the site on the downloading page ("update" button at the bottom of the page)

Wait for EasyForYou to restart.

7. In the properties of the shared folder for the network, re-authorize the sharing of the folder.

1. Uninstalling EasyForYou in the classical manner :
   Windows->Start button->Parameters->Settings->Add/Delete program->Easy For You->Delete.
   
   
2. fill inly delete the folder EasyForYou in c:\Users\USERNAME\AppData\Roaming\EasyNet\Easy For You (To locate the folder, see the menu Help->Folder).
   
   

Import lines in a document (inventory movements) with a text file.

Necessary packages : EFYBARCODE ou EFYESHOP

Important : The customers (or supliers) codes present in the text files must exist in the customer file from Easyforyou. (same for the products) . In case of non exist, when importing the file, Easyforyou take the code REG and put the 'not found' code in square brackets before the product description.

Structure of the FileName : For example : YOURREFERENCE-BC1.txt (or .csv)

All the caracters (maximum 30 numbers or letters) before the - (minus caracter) are allowed and wil be taken as reference for the payment in the generated document (YOURREFERENCE like in the example from the next line) .
The 3 last caracters, define the type of document generated (BC1 for the example in the next line) in which the document will be generated.
So, for the example, Easyforyou will generate a customer with number -> BC12010000000X...

Structure from the file.

(semicolon delimited)

Click here to download the example YOURREFERENCE-BC1.txt
With the Notepad from Windows, create and save this text in your folder " import " if not exist, to create in folder c:\Users\USERNAME\AppData\Roaming\EasyNet\Easy For You (To locate the folder, see the menu Help->Folder)\import

Exemple from text file :

DATE;TIME;CLIENT;USER;PRODUCT;QUANTITY;PRICE;DESCRIPTION;DISCOUNT
13/04/2011;15:34:43;AAABCTEST;USERNAME;FLOP;50.00;23.97;Floppy disk;0.00
13/04/2011;15:34:43;AAABCTEST;USERNAME;BIC;30.00;1.28;Blue Stylo - BIC;0.00
13/04/2011;15:34:43;AAABCTEST;USERNAME;CD;20.00;1.11;Compact disc 80 minutes TDK;0.00
13/04/2011;15:34:43;AAABCTEST;USERNAME;TRA;1.00;14.50;Shipment;0.00
13/04/2011;15:34:44;AAABCTEST;USERNAME;;;;Your comments;
13/04/2011;15:34:43;NEWCUSTOMER;USERNAME;CD;50.00;23.97;Floppy disk;0.00
13/04/2011;15:34:43;NEWCUSTOMER;USERNAME;BIC;30.00;1.28;Blue Stylo - BIC;0.00
13/04/2011;15:34:46;NEWCUSTOMER;USERNAME;PAYMENT;500.00;K;3333-99999;
13/04/2011;15:34:45;GOOD-CAR-HAMBU;USERNAME;FLOP;60.00;23.97;Floppy disk;0.00
13/04/2011;15:34:45;GOOD-CAR-HAMBU;USERNAME;CD;15.00;1.11;Compact disc 80 minutes TDK;0.00
13/04/2011;15:34:45;GOOD-CAR-HAMBU;USERNAME;SH002;1.00;10.50;Shipment;0.00
13/04/2011;15:34:46;GOOD-CAR-HAMBU;USERNAME;;;;Your remark;
13/04/2011;15:34:46;GOOD-CAR-HAMBU;USERNAME;PAYMENT;0;A;444-88888;

1) DATE from the document
2) TIME from the document
3) CLIENT = Customer Code in Easyforyou
4) USER = User name (login Easyforyou)
5) PRODUCT = Product Code in Easyforyou
6) QUANTITY = Quantity (Decimal = DOT, numbers to format with 2 decimals, no zero)
7) PRICE = Unit proce (Decimal = DOT, numbers to format with 2 decimals, no zero)
8) DESCRIPTION = Description (50 caracters, no apostrophe and no quotation mark )
9) DISCOUNT = Discount (Decimal = DOT, numbers to format with 2 decimals)

The file can contain more than one customer, so you cn use one file to generate more than one document.
In the example, there is two different customers, the first AAABCTEST and for the 4 last lines the customer GOOD-CAR-HAMBU.
This will generate tree orders BC12010….1,BC12010….2 and BC12010….3
You can also put remark's in the lines (see the example " Your remark ")
You can also put payments in the lines (see the example "PAYMENT")
A = Paypal
K = Credit card
B = Bank

Insert the customer data with a SQL request:

Create a customer code and use this code as filename (Example: TESTCUSTOMER)
Only the letters, numbers and the minus sign are accepted.
Max length = 15

Import in two stages :

1) Insert the record (INSERT request)
Example with a text file : Download the example (TESTCUSTOMER.sql)

2) Update data (UPDATE request)
Example with a text file : Download the example (TESTCUSTOMER.squ)

To copy in your folder " import "

Importation : Start Easyforyou and press Shift-F2

After import, the file Extention is renamed in " .OK "
(For the example YOURREFERENCE-BC1.ok)