Documents

Instructions for correctly use before buy source code

Update: 09/09/2020

General

CSV XLS Visual Mapping Field PHP is an MVC PHP Project developed to support import and export information from or to a database in a matter of seconds, using allowed ext files:

  • .csv
  • .xls
  • .xlsx
  • .xlt
  • .xlsm
You can drag and drop file to input type file, detects your fields automatically, so it will save you time to sort that out as well. And final, we use a bulk system to import/export data that will improve speed of technical process. You can save and store Mapping of file upload and recall whenever you need for the next files.

Autodetect:

  • Enclosure
  • Delimiter
  • Encoding

Requirements

  • PHP >= v5.2.
  • MySQL database - for the database that you want to import or export.
  • More info on SysInfo Section

Documentation

In this documentation you will find everything you need to start with our CSV XLS Visual Mapping Field PHP.

Path File

Path File to start with CSV XLS Visual Mapping Field PHP .

  • config
    • database.php
  • controller
    • index.php
    • import.php
  • libs
    • Csv.php
    • Bootstrap.php
    • Controller.php
    • View.php
    • Functions.php
    • Mapp.php
    • Model.php
  • models
    • import_model.php
  • public
    • assets
      • css
      • js
      • fonts
      • sass
  • uploads
  • views
    • import.php
    • import_view.php
    • importlist.php
    • js
      • importLists.js
  • vendor
    • autoload.php
    • phpoffice
      • phpspreadsheet

Installation

Installation is very simple and quickly you have done! Follow this few steps:

  • Create Your Database
  • Dump table.sql (* not necessary)
  • Upload CSV XLS Visual Mapping Field PHP source code files using FTP Transfer Protocol
  • Edit Database Params Connection in config/database.php
  • Edit "BASE_URL" Params in config/database.php to point on your virtual host
  • Edit folder "upload/" to write with permissions set to writeable
  • Enjoy with CSV XLS Visual Mapping Field PHP

Database

Here an example of database create for live preview of CSV XLS Visual Mapping Field PHP

  • categories
  • orders
  • products
  • orders

Native CSV XLS Visual Mapping Field PHP tables are two:

  • import
    • id_import (primary key)
    • importUniquid (associate to your import table)
    • filename (name of file upload)
    • select_table (name of table selected during import)
    • rows (number of row)
    • ext (extension of file upload)
    • data (timestamp of file upload)
  • mapping
    • id_mapping (primary key)
    • name_table (name of the associated table)
    • map_name (name of the map saved)
    • map_query (string of mapping saved)
    • use_header (boolean if import first row)

Download Dump

Framework (External Dependency)

List of framework in use on: CSV XLS Visual Mapping Field PHP

C.G.U. (terms & conditions)

Here a list of terms and conditions valid for: https://www.csvxlsvisualmapping.com/ website. Read carefully before purchase CSV XLS Visual Mapping Field PHP

Premise

  • We are not responsible for any malfunctions caused to server or existing applications on your OS
  • CSV XLS Visual Mapping Field PHP source code need a specific OS to work properly.
  • No refunds are guaranteed for an incorrect OS purchase
  • More info for OS Requirement here: SysInfo Section

Licenses

There are N.3 Kind of license available at this time.
  • Regular License (N.1 Domain/Application Install)
  • Extended (Max N.5 Domains/Applications Install)
  • Enterprice (Unlimited Installation)

License can't be update or edit after purchased and it is forbidden to use application outside by terms of purchased license.

Purchase

Paypal is only method available for buy on https://www.csvxlsvisualmapping.com/. Safety and security especially for buyers. No others methods at moment are allowed. During purchase, an email address and name will be requested to send specific email with download link to purchased source code. No other data will be retained.

Responsibility

Our company is not responsible for any error or malfunctions caused to server or existing applications on your OS during installing: CSV XLS Visual Mapping Field PHP

Prohibition of transfer

Source Code cannot be transferred to third part.

F.A.Q.

1. Connect Database

Simple Way. Edit file path: config/database.php and use your connection DB.

2. Allowed Files

Many extensions are automatically available. Here complete lists:
  • .csv
  • .xls
  • .xlsx
  • .xlt
  • .xlsm

3. Hide Table to show

If you have multiples table and need to hide them, you can do this editing file path: model/import_model.php line 26.

4. Hide Columns to show on mapping field?

If you need to hide some columns to associated you can edit: libs/Mapp.php (search $options_except variable)

5. Save Mapping

During upload process you need before to associated columns to field and after you can click on right-top button "SAVE MAPPING" to store in Database and recall to next upload. This will save your time.

6. Don't upload file

Make sure your are able to write on path upload. Set right permission.

7. Licenses

There are N.3 Kind of licenses available at this time.
  • Regular License (N.1 Domain/Application Install)
  • Extended (Max N.5 Domains/Applications Install)
  • Enterprice (Unlimited Installation)

License can't be update or edit after purchased

8. Purchase and Refound

You can complete purchase using Paypal methods. Safe and secure for all, buyer and seller. If purchase work right we'll send you and automatic email confirm with download url. Just name and email field are required during purchase process. Refound are not available for error on OS System.

9. Source Code

If purchase work right we'll send you and automatic email confirm with download url. Source Code cannot be transferred to third part.

10. Need More Help

Write to info@webmio.it