Importer module provides an easy way for creating database tables from various files. All variants of delimited text files are supports, and with an external class .xls files are also supported.
With this module the user can also insert new data into the 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. If the ordering of the columns is not matched, the user can alter the ordering in which the data is inserted. Types of the appropriate columns in the table and the file are
displayed as means of ensuring that no sql error is generated (unintentionally).
If the user has a field in the data that should serve as a link to files in the file system, the procedure is as follows:
- upload the data to the database ensuring that the appropriate field contains
the file name of the file to which it should point
- zip all files that are relevant to the table
- upload files to the server using "Batch file upload" feature of the module,
making sure that appropriate table and field is selected
Uploaded files are saved in the directory of user choice under the files/ directory (it has to be created by this module). After this, the data in the chosen field are updated with the relative path to files uploaded on the server.
The original file names are stored in the utility table, so if the user wants to make a change, all that is necessary is that the new file that is packed and uploaded has the same file names as the old one.
Finally, there is an option to drop the table previously created by this module or delete previously uploaded files.
Notes for Drupal 7:
Due to changes in the way schema works, all date/datetime fields are stored as text for the time being. The appropriate date template is still auto detected, but it will be stored as text in the database.
Batch upload part has been altered slightly to utilize the new file system. Now when the user uploads zip archive with files, the selected field in the database is updated with the file ids from the file_managed table. If there is the need to change the files, the new archive MUST contain all the files with SAME names, so it can find the appropriate record in the file_managed table. Old files on the server will then be replaced with the new ones.
This module is part of a package of modules being developed by Jefferson Institute. These modules are meant to serve as tools for data visualization:
- VIDI - Vidi module serves as a guide to choose adequate visualizations from Timeline, Tagmap and GVS modules for specific data, i.e. wizard with visualizations preview.
- Timelinemap - It allows you to load one or more data sets onto both a map and a timeline simultaneously. Only items in the visible range of the timeline are displayed on the map. Timeline Map displays data represented in the timeline as markers on Google map.
- KML content type - Users can attach .kml files to a node (with upload module), which in turn is displayed through the Google Earth API. If a user attaches several .kml files it is possible to choose between them via a drop-down box.
- Google Visualization API - It uses Google Visualization API to display different types of charts. Pie, Bar, Column, Gauge, GeoMap, IntensityMap, Area, MotionChart and Scatter plot are supported at the moment.
- Tagmap - Display a geo-coded tag cloud over Google Map. Taxonomy terms or imported external data can be displayed.