jassimp

Thank you Tobias for your great support
as you advised, i achieved the auto migration of multiple files with a php code.( i am just posting it here if it help for others)
So the migrated file will auto import to table press by the provided import option

is there any option form the auto import time interval change as the minimum is 15 minuts on it

secondly the table press showing all tables before its return to the real setting which is hiding all tables except the first row and header- how i can solve this issue?

also is there any option to search that the result to view only as full search word met in a table cell?

thank you`

<?php

/**
 * 7design.studio
 * Merge multiple CSV files into one master CSV file 
 * Remove header line from individual file
 */

$directory = "directory-name-where-multiple-files-to merge*"; // CSV Files Diectory Path

// Open and Write Master CSV File
$masterCSVFile = fopen('merge.csv',"w+");

// Process each CSV file inside root directory
foreach(glob($directory) as $file) {

    $data = []; // Empty Data

    // Allow only CSV files
    if (strpos($file, '.csv') !== false) {

        // Open and Read individual CSV file
        if (($handle = fopen($file, 'r')) !== false) {
            // Collect CSV each row records
            while (($dataValue = fgetcsv($handle, 1000)) !== false) {
                $data[] = $dataValue;
            }
        }

        fclose($handle); // Close individual CSV file 
        
        unset($data[-1]); // Remove first row of CSV, commonly tends to CSV header

        // Check whether record present or not
        if(count($data) > 0) {

            foreach ($data as $value) {
                try {
                // Insert record into master CSV file
                $val =  fputcsv($masterCSVFile, $value, ", " );
                } catch (Exception $e) {
                    echo $e->getMessage();
                }
            
            }

        } else {
            echo "[$file] file contains no record to process.";
        }

    } else {
        echo "[$file] is not a CSV file.";
    }

}

// Close master CSV file 
fclose($masterCSVFile);

?>

• This reply was modified 6 years, 4 months ago by jassimp.

Thank you Mr. Tobias for your reply

Also is it possible to do pre filled search form through a URL?

thank you so much for all your support.

• This reply was modified 6 years, 4 months ago by jassimp.
• This reply was modified 6 years, 4 months ago by jassimp.