Re: Step By Step - How to import Excel data and how to show them on front end page?

something like that snippet should do it:

Thank you So Much Bruno17.

Thanks Everyone for your Help and Time..

Quote from: Bruno17 at Sep 03, 2013, 07:38 PM

with some little tricks it should be possible to have a import csv - button above the MIGX-grid, which could open a modal-window with a textarea, where you can paste the csv-code and import it as json for MIGX or have an upload-button for uploading a csv-file and importing it at the same time into the MIGX-grid.

Hi, i know this is an old thread, but hope this trick can be explained Dont know exactly where to begin.
The client want to add extra data from a csv/excel-sheet without having to enter each row by hand, one at a time.

Just create a snippet called getCsvFileItems and paste the long code section from Bruno17's post above into it.

Then copy this tag into the resource content of the page where you want the data to appear:



Change assets/files/csvtest.csv to the actual path of the file (from the MODX root). If the data doesn't change often, you can remove the exclamation point from the tag and just clear the site cache when it changes. That will cut the page load time considerably.

This assumes that the first line of the CSV vile contains the headings for the columns (it should). If not, I'd suggest changing the options when you export to CSV so that the headings are included.

Hi BobRay, thanx for the pointer but i am actually interested in an csv-import button above my MIGX-grid as quoted by Bruno17 in my previous post. The csv-data should be imported into MIGX.

Hi!

Did you ever get an answer to this? How were you able to create a button to import csv into MIGXdb?

Cheers,
Ben

Hi Ben,

No, not yet...
Solved in another way i believe...

Still interested though in how to create such an import button for CSV 2 MIGX.

Quote from: Bruno17 at Sep 04, 2013, 07:51 AM

something like that snippet should do it:

[[!getCsvFileItems? 
&file=`assets/files/csvtest.csv`
&columnheadings=`1`
]]

<!--?php
/*
[[!getCsvFileItems? 
&file=`assets/files/csvtest.csv`
&columnheadings=`1`
]]
*/

$file = $modx--->getOption('file', $scriptProperties, '');
$delimiter = $modx->getOption('delimiter', $scriptProperties, ',');
$columnheadings = $modx->getOption('columnheadings', $scriptProperties, false);
$outerTpl = $modx->getOption('outerTpl', $scriptProperties, '@CODE:[[+heading]][[+rows]]<table><tbody></tbody></table>');
$headingTpl = $modx->getOption('headingTpl', $scriptProperties, '@CODE:[[+_fields]]');
$headingFieldTpl = $modx->getOption('headingFieldTpl', $scriptProperties, '@CODE:[[+_field]]');
$rowTpl = $modx->getOption('rowTpl', $scriptProperties, '@CODE:[[+_fields]]');
$rowFieldTpl = $modx->getOption('rowFieldTpl', $scriptProperties, '@CODE:[[+_field]]');

if (!function_exists('parse_csv_file')) {
    function parse_csv_file($file, $columnheadings = false, $delimiter = ',', $enclosure = "\"") {
        $row = 1;
        $rows = array();
        $handle = fopen($file, 'r');

        while (($data = fgetcsv($handle, 1000, $delimiter, $enclosure)) !== false) {

            if (!($columnheadings == false) && ($row == 1)) {
                $fieldnames = $data;
            } elseif (!($columnheadings == false)) {
                foreach ($data as $key => $value) {
                    unset($data[$key]);
                    $data[$fieldnames[$key]] = $value;
                }
                $rows[] = $data;
            } else {
                $rows[] = $data;
            }
            $row++;
        }

        fclose($handle);

        $result['fieldnames'] = $fieldnames;
        $result['rows'] = $rows;


        return $result;
    }
}

if (!function_exists('parseCsvGetChunk')) {
    function parseCsvGetChunk($tpl, $properties) {
        global $modx;
        if (substr($tpl, 0, 6) == "@CODE:") {
            $template = substr($tpl, 6);
            $chunk = $modx->newObject('modChunk');
            $chunk->setCacheable(false);
            $chunk->setContent($template);
            $output = $chunk->process($properties);
        } else {
            $output = $modx->getChunk($tpl, $properties);
        }
        return $output;
    }
}

$file = $modx->getOption('base_path') . $file;
$result = parse_csv_file($file, $columnheadings, $delimiter);

$output = array();
$output['heading'] = '';

if ($columnheadings) {
    $heading['_fields'] = '';
    foreach ($result['fieldnames'] as $fieldname) {
        $properties = array();
        $properties['_field'] = $fieldname;
        $heading['_fields'] .= parseCsvGetChunk($headingFieldTpl, $properties);
    }
    $output['heading'] = parseCsvGetChunk($headingTpl, $heading);
}

$rows = array();
foreach ($result['rows'] as $row) {
    $row['_fields'] = '';
    foreach ($row as $field) {
        $properties = array();
        $properties['_field'] = $field;
        $row['_fields'] .= parseCsvGetChunk($rowFieldTpl, $properties);
    }
    $rows[] = parseCsvGetChunk($rowTpl, $row);
}

$output['rows'] = implode('', $rows);

return parseCsvGetChunk($outerTpl, $output);

?>

This snipppet is very close to a solution for a project I'm working on. I've modified the tpl in this to output the content in a series of divs vs a table format. I would like to add a class or classes to each row based on the content of selected cells in that row. Ultimately I will filter or sort these rows/divs based on these classes.

Is there someone out there that knows how to do this?

Thank you!

if you have



you can use output-filters or snippets to prepare the wanted classes in your Chunk

Right. I know how I might put in a static class on a row, but I would like to put variable class based on the contents of a specific column in each row.

I don't know how to write a snippet that would do that__not in my skill set.

I use output filters pretty regularly but I'm not sure an output filter could do this.

Any suggestions would be appreciated.