Help   gFr21

Ayuda_iOS_iPhone.html
 

Button : It is used to link gFr21 to Dropbox.

Operation is explained below.

Off if you do not want to print the pictures of the references of orders.

Field to put the symbol of the country's currency.

Reset all zones assigned to clients.

Reset all catalogs delivery lists.

Delete export files.

If we have sent from another app (Dropbox, e-mail, etc..) And send another without importing and / or removed the first, second rename the file with which gFr21 not recognize it. eg if the first file is lama Clientes.csv if we send another with the same name will be called the second 2.csv Customers, As gFr21 only recognizes the name Clientes.csv mind always the same.

Export clients, creates a file with all customers of our database and the name Clientes.csv which we can send to another app (Dropbox, e-mail, etc..). Also we can use as a template to import clients.

Exports

When preparing a file to import from gFr21 is essential :

1. Must have 20 fields, if anyone does not know (except the name), we leave it blank. The first row (1) we can leave, gFr21 not matter if it detects that the cell 1A says "Name".

2. The file must have the name and extension  Cliente.csv.

3. Once prepared Cliente.csv file from a spreadsheet. (We understand that the user knows how to use spreadsheets), you can send the same to open it on iPad or iPhone, saving the file to Dropbox or sending an e-mail attaching the file.

4. On the iPad or iPhone open the file in Dropbox or e-mail, in the action "Open with ...", select gFr21, the application will automatically open and warns us gFr21 :                                                         Once imported clientes Clientes.csv import file is deleted.

Export orders, creates a file with the list of all orders from our database and the name Pedidos.csv which we can send to another app (Dropbox, e-mail, etc..) and open it in a sheet of calculus.

Export suppliers, creates a file with all the providers in our database and the name Proveedores.csv which we can send to another app (Dropbox, e-mail, etc..). Also we can use as a template to import suppliers.

When preparing a file to import from gFr21 is essential :

1. You must be 16 fields, if one does not know (except the name), we leave it blank. The first row (1) we can leave, gFr21 not matter if it detects that the cell 1A says "Name".

2. The file must have the name and extension  Suppliers.csv.

3. Once prepared Suppliers.csv file from a spreadsheet. (We understand that the user knows how to use spreadsheets), you can send the same to open it on iPad or iPhone, saving the file to Dropbox or sending an e-mail attaching the file.

4. On the iPad or iPhone open the file in Dropbox or e-mail, in the action "Open with ...", select gFr21, the application will automatically open and warns us gFr21 :                                                    Once imported suppliers Suppliers.csv import file is deleted.

                                    

Exporting catalogs, create a file with a list of all catalogs ordered by providers in our database and the name Catalogs.csv which we can ship to another app (Dropbox, e-mail, etc..) And open it in a cáculo sheet.

Export of products, creates a file with all the products in our database and the name Products.csv which we can send to another app (Dropbox, e-mail, etc..). Also we can use as a template to import products.

We can export only products from a catalog (explained in Help catalogs).

When preparing a file to import from gFr21 is essential :

1. Must have 9 fields, if any do not know (except the reference), we leave it blank. The first row (1) we can leave, gFr21 not matter if it detects that the cell (1A) says "Reference".

2. The file must have the name and extension   Products.csv.

  1. 3.Once prepared Products.csv file from a spreadsheet. (We understand that the user knows how to use spreadsheets), you can send the same to open it on iPad or iPhone, saving the file to Dropbox or sending an e-mail attaching the file.

4. On the iPad or iPhone open the file in Dropbox or e-mail, in the action "Open with ...", select gFr21, the application will automatically open and warns us gFr21 :                                                    In the list of products select the supplier and catalog that we want to import

                                                                                    the file, go to the window product management and follow the steps 2 and 3 of the alert.

                                                                                    Once imported the products the import file is deleted Productos.csv .

Preferences

Preferences, Utilities and Exports

When you import a file reference gFr21 checks whether there is or not. When If there is change fields Description, Points, Price and Long Description. When there is NO added. (Very useful for updating price lists.)

For memory problems advise importing files with a maximum of 2000 records, if the product catalog are more, we can create 2000 files in 2000 and import one by one.

When we link gFr21 with Dropbox creates a folder (if it exists) is called Applications within it create another folder called gFr21 app, this folder is where we have to put the images that we see from gFr21, creating folders providers name within folders within catalogs and catalog images. Images must be in jpg or png.


To link an image to an article, enter the vendor folder, open the catalog folder, select the image and then click the button the image will automatically be linked to the article.

Dropbox

Attention!

Import files must tiener the Unicode (UTF-8).

  1. 1.The comma separated .csv format       (See non;)

  2. 2.The name and extension for clients "Clients.csv" to suppliers "Suppliers.csv" for products "Products.csv".

  3. 3.It is advisable to put all cells format numbers as text.

  4. 4.Replace the comma "," to point "." So that if there are fields with commas (as decimal numbers) to import, not detected as another field.

  5. 5.We must remove the following columns to the last, to make sure they are empty.

  6. 6.It can be used as templates, a file created from the app Preferences> Export.

To download a template click here

To download a template click here

To download a template click here