Why import/export a file to/from a database?
Because
- You have a big amount of data to be imported
- You need to update your database and you prefer to do it on an external spreadsheet
- You want to use a remote SQLite database
The file format to import to Mobincube has to be a CSV file (comma, or semicolon; separated). You can export to CSV(semicolon; separated) or SQLite.
Be careful that the multimedia type fields (audio, images and video) cannot be imported and exported in CSV formats. Therefore if you want to modify any database with them it's preferable to work with online (URLs) content.
Importing:
Once your CSV is ready, and once the database has been created and the number/type of the fields are the same as your CSV, you can import the file.
The selector is the character used to separate values in the CSV text file.
IMPORTANT: This can lead to not importing your data correctly:
- The CSV file must be exported into UTF-8 character encoding and without incorrect characters (google docs always export it into UTF8).
- The first row of your CSV will be considered as the head and therefore not imported.
- If you have multimedia (not online) columns, the content in the CSV must be empty (row 6 below).
- When you import, you add the rows to the existing ones.
- If you have numeric fields, they must at least begin with a number.
- Be aware about location and date types (rows 4-5 below).
Export
You can export your database to a CSV or SQLite file, in order to edit it or upload to a remote server respectively.
