QINVOICING Manual

Index

  • Home
  • What's new in version 10
  • Network Installation
  • How to start
  • FAQs
  • Send a document via e-mail
  • Using barcodes
  • Files
  • Processes
  • Reports
  • Statistics
  • Company
  • Settings
  • Utilities
  • Planner
  • OsCommerce
  • Appendix
  •  
    Home  l  Buy Now  l  Qinvoicing forum  

    Data import

    This process allows import data from other applications to the archives of QINVOICING.

    Data import CSV files should be delimited by semicolons (;). You can create a CSV from a excel table saving as CSV (comma-delimited) (*.csv) or exported in this format since the implementation where it has data.

    The CSV files contain records on each line and the fields are separated for ;. If the field contains the character; is enclosed in double quotes. The double quotes are indicated by repeating the character (“”).

    The first line of the file containing the field name (something like the header column). For example:

    The following excel table

    CODE DESCRIPTION
    10001 TECHNICAL SERVICE
    10007 “SPECIAL” SOFTWARE

    to save as CSV remains internally as:

    CODE;DESCRIPTION
    10001;TECHNICAL SERVICE
    10007;""SPECIAL"" SOFTWARE

    For QINVOICING can import data from the CSV files to your tables be indicated in the first line of each file name field referred to each column. Field names of each file, the type of data that must contain (numeric, character, etc.) and fields that are required are shown in the following tables.

    The import process reading the CSV file and looking at the file to insert code (the manufacturer code, the article, the client, etc.). If this code already exists in QINVOICING updates the registry with information from CSV. If the code does not exist in QINVOICING be added to registration. This type of import permits repeat the process several times, or even make regular imports of certain data items (a supplier adding new products and updating prices, etc.).

    A portion of the required fields, import file can contain only those fields (columns) that actually contain data import and omitting others. By adding a record, QINVOICING left blank fields that have no column in the import file, and if the record already exists in QINVOICING maintain the values that have these fields. This makes it possible to update the prices of products, importing a CSV file containing only two columns: the code of the product and the new price.

    In the folder \import of the program there is a file import CSV data with each test. You can open them to view its contents and layout or serve as a base for the data to be imported.

     

    Fields to import the manufacturers

    Column name Data type
    Len.
    Dec. plac.
    Required
    Contents
    NCODIFAB numeric
    11
    0
    always
    Code
    CNOMFAB alphanumeric
    50
    0
    yes
    Manufacturer
    CURLFAB alphanumeric
    200
    0
    no
    Website
    CURLFAB2 alphanumeric
    200
    0
    no
    Website (language 2)

     

    Fields to import the suppliers

    Column name Data type
    Len.
    Dec. plac.
    Required
    Contents
    NCODIPR numeric 7 0 always Code
    CGENERE numeric 1 0 yes Type (0=organization, 1=man , 2=woman)
    CNOM alphanumeric 50 0 yes Name
    CNOMPROPI alphanumeric 20 0 no First Name
    CCONTACTE alphanumeric 30 0 no Contact
    CNIF alphanumeric 25 0 no Tax ID
    CADRECA alphanumeric 100 0 no Address
    CCPOSTAL alphanumeric 10 0 no Zip code
    CPOBLA alphanumeric 40 0 no City/town
    CCOMARCA alphanumeric 30 0 no State/Province
    CPAIS alphanumeric 40 0 no Country
    CODPAIS alphanumeric 5 0 no Country Code. If not is empty, must exist in the countries file.
    CTELF1 alphanumeric 20 0 no Phone 1
    CTELF2 alphanumeric 20 0 no Phone 2
    CFAX alphanumeric 20 0 no Fax
    CEMAIL alphanumeric 50 0 no E-Mail
    CWEB alphanumeric 50 0 no Customer website
    LREQ logical (true/false) 1 0 no Tax 2
    LIRPF logical (true/false) 1 0 no Apply withholding
    XIRPF numeric 7 2 no % Withholding
    NCTEEOS numeric 5 0 no Group code. If not is empty, must exist in the customer groups file.
    MNOTES text 10 0 no Notes
    COMPTE alphanumeric 12 0 no Account
    LEXIVA logical (true/false) 1 0 no Tax-free

     

    Fields to import the categories

    Column name Data type
    Len.
    Dec. plac.
    Required
    Contents
    CODIG numeric 5
    0
    always
    Code
    NOMGRUP alphanumeric 50
    0
    yes
    Category

     

    Fields to import the products

    Column name Data type
    Len.
    Dec. plac.
    Required
    Contents
    CCODIART alphanumeric
    20
    0
    always
    Code
    CNOMART alphanumeric
    100
    0
    yes
    Product or service
    CODIG numeric
    5
    0
    no
    Category code. If not is empty, must exist in the categories file.
    NPV0 numeric
    16
    5
    no
    Sales price, rate 0
    NPV1 numeric
    16
    5
    no
    Sales price, rate 1
    NPV2 numeric
    16
    5
    no
    Sales price, rate 2
    NPV3 numeric
    16
    5
    no
    Sales price, rate 3
    NPV4 numeric
    16
    5
    no
    Sales price, rate 4
    NPV5 numeric
    16
    5
    no
    Sales price, rate 5
    NPV6 numeric
    16
    5
    no
    Sales price, rate 6
    NPV7 numeric
    16
    5
    no
    Sales price, rate 7
    NPV8 numeric
    16
    5
    no
    Sales price, rate 8
    NPV9 numeric
    16
    5
    no
    Sales price, rate 9
    NCODIPR numeric
    7
    0
    no
    Supplier code 1. If not is empty, must exist in suppliers file.
    NCODIPR2 numeric
    7
    0
    no
    Supplier code 2. If not is empty, must exist in suppliers file.
    NCODIPR3 numeric
    7
    0
    no
    Supplier code 3. If not is empty, must exist in suppliers file.
    CREFPROV alphanumeric
    40
    0
    no
    Supplier Ref.
    NTIPIVA numeric
    2
    0
    yes
    Sales Tax Class. If not is empty, must exist in tax class file.
    NTIPIVASOP numeric
    2
    0
    yes
    Purchase Tax Class. If not is empty, must exist in tax class file.
    NSTOCMIN numeric
    13
    3
    no
    Minimum inventory
    NPES numeric
    10
    3
    no
    Weight
    NCDAHAB numeric
    13
    3
    no
    Usual order
    NPVOFERIN numeric
    16
    5
    no
    Internet quote price
    CNOMART2 alphanumeric
    100
    0
    no
    Product name, language 2
    MDESCRI1 text
    10
    0
    no
    Product description
    MDESCRI2 text
    10
    0
    no
    Product description, language 2
    MNOTES text
    10
    0
    no
    Notes
    XDTEA numeric
    6
    2
    no
    % Product discount
    XDTECOM numeric
    6
    2
    no
    % Purchase discount
    DALTA date
    10
    0
    no
    Product add date
    CMODEL alphanumeric
    45
    0
    no
    Model
    NCODIFAB numeric
    11
    0
    no
    Manufacturer code. If not is empty, must exist in manufactures file.

     

    Fields to import the payment terms

    Column name Data type
    Len.
    Dec. plac.
    Required
    Contents
    NNUMFP numeric
    7
    0
    always
    Payment term code
    CDESCRI alphanumeric
    40
    0
    yes
    Description

     

    Fields to import the customers

    Column name Data type
    Len.
    Dec. plac.
    Required
    Contents
    NCODICL numeric
    7
    0
    always
    Code
    CGENERE numeric
    1
    0
    yes
    Type (0=organization, 1=man , 2=woman)
    CNOM alphanumeric
    50
    0
    yes
    Last name
    CNOMPROPI alphanumeric
    20
    0
    no
    First name
    CNOMFI alphanumeric
    50
    0
    no
    Legal Name
    CCONTACTE alphanumeric
    30
    0
    no
    Contact
    CADRECA alphanumeric
    100
    0
    no
    Address
    CPOSTAL alphanumeric
    10
    0
    no
    Zip code
    CPOBLA alphanumeric
    40
    0
    no
    City/town
    CCOMARCA alphanumeric
    30
    0
    no
    State/Province
    CODPAIS alphanumeric
    5
    0
    no
    Country Code. If not is empty, must exist in the countries file.
    CPAIS alphanumeric
    40
    0
    no
    Country
    CTELF1 alphanumeric
    20
    0
    no
    Phone 1
    CTELF2 alphanumeric
    20
    0
    no
    Phone 2
    CFAX alphanumeric
    20
    0
    no
    Fax
    CMOBIL1 alphanumeric
    20
    0
    no
    Cell Phone 1
    CMOBIL2 alphanumeric
    20
    0
    no
    Cell Phone 2
    CEMAIL alphanumeric
    50
    0
    no
    E-Mail
    CNIF alphanumeric
    25
    0
    no
    Tax ID
    DNEIX date
    10
    0
    no
    Date of birth
    CODIG numeric
    5
    0
    no
    Customer group. If not is empty, must exist in the customer groups file.
    MNOTES text
    10
    0
    no
    Notes
    CIDIOMA alphanumeric
    10
    0
    no
    Language
    NCODIVEN numeric
    5
    0
    no
    Sales rep code. If not is empty, must exist in the sales rep file.
    XDTECL numeric
    7
    2
    no
    % Customer discount
    XDTEPP numeric
    7
    2
    no
    % PP discount
    NTARIFA numeric
    1
    0
    no
    Rate
    LEXIVA logical (true/false)
    1
    0
    no
    Tax-free
    LREQ logical (true/false)
    1
    0
    no
    Tax 2
    XIRPF numeric
    7
    2
    no
    % Withholding
    CREFCLI alphanumeric
    60
    0
    no
    Customer Ref.
    CWEB alphanumeric
    50
    0
    no
    Customer website
    NNUMFP numeric
    7
    0
    no
    Payment terms. If not is empty, must exist in the payment terms file.
    NDIAP1 numeric
    2
    0
    no
    Payment day 1
    NDIAP2 numeric
    2
    0
    no
    Payment day 2
    NDIAP3 numeric
    2
    0
    no
    Payment day 3
    NDIAP4 numeric
    2
    0
    no
    Payment day 4
    NMESNOPAG numeric
    2
    0
    no
    Month without payment
    CIBAN alphanumeric
    34
    0
    no
    IBAN
    CNUMTAR alphanumeric
    25
    0
    no
    Card number
    CTIPTAR alphanumeric
    20
    0
    no
    Credit card type
    CCADU alphanumeric
    5
    0
    no
    Card expiration date
    CSECTOR alphanumeric
    50
    0
    no
    Industry/activity
    CPORTS alphanumeric
    60
    0
    no
    Shipping costs
    DALTA date
    10
    0
    no
    Customer add date
    LNOMOLES logical (true/false)
    1
    0
    no
    Do not disturb

     


    Related topics:

    Importing data from osCommerce to QINVOICING

































































      web hecha con qfacweb ©2001 - qsoft