The importer module makes creating database tables from various files easy. All variants of delimited text and .xls files are supported. Users can insert new data into an existing table, provided that the number of columns in the table (not counting the primary key column) matches the number of columns in the file. You can modify the columns or alter the ordering of your data entry. Types of the appropriate columns in the table and the file are displayed as a means of ensuring that there is no sql error.
If you have a field of data that serves as a link to files in the file system, simply follow these steps:
1. upload the data to the database ensuring that the appropriate field contains the file name of the file to which it should point
2. zip all files that are relevant to the table
3. upload files to the server using "Batch file upload" feature of the module, making sure that the appropriate table and field is selected.
Uploaded files are saved in a directory of your choice under the files/ directory. The data in the chosen field are updated with the relative path to files and uploaded on the server. The original file names are stored in the utility table.
Finally, there is an option to drop the table previously created by this module or delete previously uploaded files.
maps & charts themes
Click below to explore color scheme suggestions to fit your web site style.
Help us improve VIDI! Leave a comment if something seems amiss or confusing
Recent comments
just installed and made a first test-setup on timelinemap. now wondering about how to get the drop-down field "image" in the...
This is indeed a very useful chart. Just one question - is there any way I can download this in jpg or similar format?
...
Tried installing vidi module on drupal 6 lates version.
I get
Internal Server Error
The server...
Great tools, but I receive error messages when trying to upload an Excel file, although the same file can be used when turned...
I have experience with many other drupal charting and data viz modules and this one is by far the easiest to use, and the most...