Extension - CSV Raw Import/Export

Extension Filter

Search

Categories

License

Version

Currency

CSV Raw Import/Export

CSV Raw Import/Export
csv-admin
Extension Name CSV Raw Import/Export Rating 1 2 3 4 5
License Free Votes 9
Developer qphoria Views 69162
Date Added 1 December 2010 Downloads 5740
Date Modified 13 July 2012 Request Support
Report extension
READ THIS FIRST!
==========================
The purpose of this tool is to allow "raw" data to be edited similar to the way you can edit in phpmyadmin, except much easier since its using the openfield CSV format. You can use Excel to edit the fields the same. Just be sure you save the files in csv format (as excel always offers to convert to xls for you).

This is not meant to be a replacement for the "Excel Import/Export" tool. That is a structured product import tool that correlates products, options, and more into one formatted structure. This means that changes to the database will need to coded into that mod.

This mod is "raw" by design to remove dependency on version or customizations to the database, and read it on-the-fly when generating the output. However, it can be used for product import (or any other field) but all individual tables need to be edited separately.
Download Name Compatibility Action
CSV Raw Import/Export v1.4.7, v1.4.8, v1.4.8b, v1.4.9, v1.4.9.1, v1.4.9.2, v1.4.9.3, v1.4.9.4, v1.4.9.5 [ Download ]

Supported OpenCart Versions:
================
v1.4.x

What does it do:
================
This contrib adds a new tool page for CSV Import/Export.
The mod will list ALL tables in a dropdown.
Choose individual tables to export in CSV format.
Edit the CSV file in an editor or Spreadsheet program (recommended)
Save and reimport the CSV file. It will replace the existing data with the new imported csv data


Main features:
==============
* Tables are Completely dynamic. Automatically gets the list of ALL tables, even custom ones
* Columns are also completely dynamic. All columns are found and listed, even custom ones
* Edit tables individually. This is a raw format editing tool which allows it to edit new fields at anytime without dependencies.
* Ignores columns that don't exist or that were left out purposely when reimporting.


How to install it:
==================
1) Unzip and upload the "admin" folder to the root of your OpenCart install. No files are overwritten
2) a. EDIT: admin/view/template/common/header.tpl
b. FIND:
----------------------------------------------------

<li><a href="<?php echo $backup; ?>"><?php echo $text_backup; ?></a></li>

----------------------------------------------------


c. AFTER, ADD:
----------------------------------------------------

<?php @$this->load->language('tool/csv'); ?>
<?php if (@$this->language->get('text_csvmenu') != NULL) { ?>
<li><a href="<?php echo (((HTTPS_SERVER) ? HTTPS_SERVER : HTTP_SERVER) . 'index.php?route=tool/csv&token=' . $this->session->data['token']); ?>"><?php echo $this->language->get('text_csvmenu'); ?></a></li>
<?php } ?>

-----------------------------------------------------

3) From the admin menu, go to 'Admin->Users->User Groups'. Edit the Top Administrator.
4) Find and check the new entries for both modify and access.
5) From the admin menu, go to 'System->CSV Import/Export'.


Usage Notes:
===============
- This is an atomic import. Meaning it deletes the data in the table before importing the new data. An Append mode is planned for a later date.
- The top row of the exported CSV files is in "table.column" format. Do not change these headings. You may, however, remove complete columns that you don't want to import. These will just be left blank.
- Microsoft Excel is a good CSV editor, but erroneously converts the date column to "xls" format. I do attempt to correct this behavior programmatically but the feature is in beta and may or may not work. In the case it does not work, you will likely see a date of 01/01/1970 which is the default date mysql uses. Please report cases of this when noticed.
- This tool is for raw editing of table data. Do not delete or change any "ID" columns as they are used to link to other tables for extra data
- This tool is designed to be dynamic performance may or may not be affected. Performance is not the goal since it is on the admin side. Dynamic functionality is the goal.

Tags csv import, csv export, csv, csv dynamic, raw csv, csv raw, CSV Raw Import Export

Hosted by Arvixe Web Hosting