From wiki.ginstr.com
Jump to: navigation, search


Export data

In some cases, it is desirable to further process data generated using ginstr apps in other programs or Excel. The ‘download data’ feature allows downloading data stored in ginstr tables to your local PC.

To download data from a table or ginstr app, right-click anywhere in the table then select the ‘download data’ option to display the following pop-up window:

download data’ pop-up window


The following options are available to configure the data download:

export format

  • CSV
Files with .csv file extension (Comma-separated values) are commonly used to exchange data between different applications; so in case you would like for example to further process your data in a dispatching or book-keeping software then you can export the data to a .csv file and then import this .csv file into your other software.
  • Excel
This option creates Microsoft Excel compatible files with .xlsx file extension.
Excel 2007 version or newer is required to open such files.
.xlsx files can hold up to 1 million records.

include attachments

  • yes
In case you select this option the data will be downloaded as a .zip file which contains several other files:
  • the .csv or .xlsx file depending on the chosen export format
  • all media files (e.g. .png image files, .wav sound files etc.)
Depending on your operating system and version there are different steps how to extract the individual files contained within the .zip file. If you don´t know how to do this please contact your system administrator.
  • no
  • download of the data of just one table
In this case just the .csv or .xlsx file will be downloaded depending on the chosen export format
  • download of all tables of a ginstr app
In this case the data of all tables of the selected ginstr app will be downloaded packed into one .zip file.

rows filter

  • all rows
This option allows to download all records of a table independent of currently applied filter options.
  • visible rows
ginstr tables provide a multitude of options to filter and sort the content of tables.
In case you have filtered some records to be shown on your screen and you choose this option then only the records currently shown on the screen will be downloaded.
  • table with dependencies
This option allows you to download the selected table together with any related tables connected through pointer and/or assignment datatype.
  • all tables of this ginstr app
In case the table you right-clicked belongs to a ginstr app, then this additional option will be available which allows downloading all tables of the ginstr app in one step.
all tables of this ginstr app’ option displayed in ‘download data’ pop-up window if the selected table belongs to a ginstr app
This feature is sometimes used for local data backup on a customer’s PCs in addition to the automatic backup the ginstr cloud provides by default.
In case of CSV export format, each table will be represented as a separate .csv file. In case of .xlsx export format, each table will be represented as a separate sheet inside one single .xlsx file.

columns filter

  • all columns
This option allows to download all records of a table independent of currently applied column visibility settings.
  • visible columns
ginstr tables provide a multitude of options to filter and sort the content of tables.
In case you have hidden some columns to be shown on your screen and you choose this option then only the columns currently shown on the screen will be downloaded.

language

Most ginstr apps are available in multiple languages. The language selection does not only affect the UI of the apps on the phone but also the table headings. With this option you can select the language in which the headings of the downloaded tables must be stored in the .csv or .xlsx file.
Default value depends on the settings of the user in his ginstr web preferences.

time format

ginstr supports multiple time formats. This option allows defining in which time format the data should be downloaded. This might be relevant for you because the software that will be used to further process the data might have some restrictions in this regards.
Default value depends on the settings of the user in his ginstr web preferences.

date format

ginstr supports multiple date formats. This option allows defining in which date format the data should be downloaded. This might be relevant for you because the software that will be used to further process the data might have some restrictions in this regards.
Default value depends on the settings of the user in his ginstr web preferences.

number format

ginstr supports multiple number formats. This option allows defining in which number format the data should be downloaded. This might be relevant for you because the software that will be used to further processing the data might have some restrictions in this regards.
Default value depends on the settings of the user in his ginstr web preferences.

time zone

ginstr internally stores all data in UTC time zone; this is the universal time which is the same worldwide. Before presenting dates and times on the screen, each timestamp is adopted to the time zone selected by the user in his ginstr web preferences.
This option can be used to override the time zone settings in the ginstr web preferences.
Default value depends on the settings of the user in his ginstr web preferences.
Export into Excel of numbers, dates, times and pointers to these datatypes is done supporting Excel cell formats according to the operating system's 'Region and Language' settings. This means that if a date is exported as "1 January 2016" but Excel is opened on a system with 'Region and Language' format set to German, it will be shown as "1. Januar 2016".


Each table is exported with one additional column: "record created on". The value in this column stores the record creation date which is used for filtering in the case of a large data table.


Access to media files (pictures, videos, audio files, documents) after download

Export without attachments
In this case the URL of the media files will be stored in the .csv or .xlsx file. In case a table cell contains multiple files, then the URLs will be separated with “|” (i.e. http://ginstr.com/image1.jpg|http://ginstr.com/image2.jpg)
These links will be available until the attachments (or the entire row which contained such attachments) are deleted from the ginstr cloud.
Note: ginstr credentials are not required to open these links (i.e. anybody with the link can view the attachments).
Export with attachments
  • Tables that do not belong to a ginstr app:
In this case the .csv / .xlsx file will contain relative links to the appropriate files in the archive folder.
For example pictures/image1.jpg in single table export will mean that this file is placed inside the archive at the following path: /pictures/image1.jpg.
  • Tables belonging to a ginstr app:
In this case pictures/image1.jpg of “customers” table will be stored in the archive at the following path: /customers/pictures/image1.jpg.
As per Export without attachments (above), if a table cell contains multiple files, then the URLs will be separated with “|” (i.e. pictures/image1.jpg|image2.jpg)


Import data

In some cases it is desirable to import data generated using third party programs or to upload data that has previously been exported from the ginstr cloud back to the cloud again. The ‘upload data’ feature allows uploading data stored on your local PC to ginstr tables in the ginstr cloud.

To upload data to a ginstr table or ginstr app, right click anywhere in the table then select the ‘upload data’ option to display the following pop-up window:

upload data’ pop-up window

In order to ensure that the headings of the tables to be uploaded to the ginstr cloud are correct and complete, it is recommended to download the existing table(s), even if they are empty, and to use these downloaded files for editing and subsequent data upload.


The following options are available to configure the data upload:

upload data

  • in this table only
Use this option if you want to upload data for the selected table only.
  • all dependent tables
If you had previously downloaded the selected table together with any related tables connected through pointer and/or assignment datatype and made some changes to these downloaded tables, this option allows you to re-upload all dependent tables in one step.
  • in all tables of this ginstr app
In case the table you right-clicked belongs to a ginstr app which is using multiple tables, then this option will be available; it allows uploading data to all tables of this ginstr app in one step.

include attachments

  • yes
In case you select this option, the data must be uploaded as a .zip file which contains several other files:
  • the .csv or .xlsx file
  • all media files (e.g. png image files, .wav sound files etc.)
Depending on your operating system and version there are different steps how to pack individual files into a .zip file. If you don´t know how to do this please contact your system administrator.
  • no
In this case just the .csv or .xlsx file(s) will be uploaded without attachments. These files must be packed as a .zip file in any case if you are going to upload data, which will go into tables belonging to ginstr apps.

language

Most ginstr apps are available in multiple languages. The language selection not only affects the UI of the apps on the phone but also the headings of the tables in ginstr web.
With this option, you can select the language in which the headings of the table columns to be uploaded have been stored in the .csv or .xlsx file.
This is essential to ensure that the upload routine can assign the content of the various columns in the files to the related columns of the ginstr tables.
Default value depends on the settings of the user in his ginstr web preferences.

time format

ginstr supports multiple time formats. This option defines in which time format the data should be uploaded. This is essential to ensure that the upload routine treats the timestamps in the various columns correctly.
Example: 10:00:00 PM or 22:00:00 - one of these two time formats can be used with the values stored as text.
Default value depends on the settings of the user in his ginstr web preferences.

date format

ginstr supports multiple date formats. This option allows defining in which date format the data is stored. This is essential to ensure that the upload routine treats the dates in the various columns correctly.
Note that two date formats can look similar: dd/mm/yyyy and mm/dd/yyyy, hence 01/02/2016 can be either the 2nd of January 2016 or the 1st of February 2016. This cannot be detected automatically and therefore setting this option carefully is required.
Default value depends on the settings of the user in his ginstr web preferences.

number format

ginstr supports multiple number formats. This option allows defining in which number format the data should be uploaded. This is essential to ensure that the upload routine treats the numbers in the various columns correctly.
Default value depends on the settings of the user in his ginstr web preferences.

time zone

ginstr internally stores all data in UTC time zone; this is the universal time which is the same worldwide. Before presenting dates and times on the screen, each timestamp is adopted to the time zone selected by the user in his ginstr web preferences.
This option can be used to indicate the time zone in which the data contained in the file to be uploaded has been saved.
Default value depends on the settings of the user in his ginstr web preferences.

choose file

This option is used to select the file on the local disk drive which contains the data that should be uploaded to the ginstr cloud.


If the “record created on” column is empty in the file to be uploaded, then the newly uploaded records will have a record creation date from the moment when the data was uploaded. Otherwise the record creation date provided in the imported file will be used.


File names and table names

Excel files
For the upload of Excel files the Excel file names and sheet names are not relevant.
Each Excel sheet must provide in cell A1 the precise name of the table to which the data will be uploaded. This table name must correspond with the language which was selected in the ‘language’ option of the file upload pop-up window.
.csv files
.csv file names must have the following format:
table_name_in_language_of_import.csv (i.e. customers.csv)
Data with references to other tables in the ginstr cloud (not presenting in Excel file) can only be uploaded if the relevant columns with the references have the ‘unique’ attribute set for them. In case of Excel import and both rows present (row to which reference is created and row which has reference) import can be done to non-unique row in case reference is a correct Excel reference.


Please note that the data upload feature does not update records; it just creates new records.

In case of uploading Excel .xlsx files with dates and numbers columns stored in 'text' cell format, these values should have the format which was previously selected in the data upload pop-up window.

If dates and numbers are stored in an Excel file like a number datatype, then the Excel cell format will be used during the data upload and therefore the format specified in the upload dialog will be ignored.

Data upload is limited to max. 100 MB per file to be uploaded.