HTML

<script>
  AJS.toInit(function(){
    if (AJS.params.remoteUser == ''){
      AJS.$('#header').hide();
      AJS.$('#main-header').hide();
    }
  });
</script>
<iframe id="topheader" src="https://www.targit.com/layouts/targit13/doc_confluence.aspx" scrolling="no" style="width:100%;height:467px100px;overflow:hidden;scrolling:no;"></iframe>

Image Modified Back

CSV - InMemory

Plugin

Assembly

The CSV plugin assmebly can consume data from correctly formatted CSV files.

Adding the Data Source

The CSV plugin assembly is a 'FilesTARGIT' data source.

Image RemovedImage Added

Name

Enter a unique name for this data source. This is the name of the data source as it will appear in the Data Sources list in TARGIT Data Discovery.

Type

.

Assembly location

Select an assembly location:

Local. Use this option if you have a special assembly or an updated assembly that hasn't been installed on the server.
Server. Use this option in most cases. The assemblies are normally installed on the server and used from there.

File type

Select a type according to the accessibility of the data source:

Local file. Use this option if your data source is accessible on a hard drive or a network drive through a file explorer.File path: Enter, or browse, the path of the file, e.g. “C:\Temp\CountryLatLong.csv”. Bear in mind that the file must be accessible from the TARGIT server’s point of view.
Url. Use this option if your data source is accessible through http:// or https:// protocols.
Use Credentials: An option for supplying username and password, if necessary.

Server

: Enter the link for

Enter the Urlfor accessing this data source, e.g.

https://github.com/wp-content/uploads/2019/04/fsi-2019.csv

.

Schedule

Note: The Schedule options are only available for Url types. For Local files, data are reloaded automatically when the source file is updated and saved.

Click the ‘Set’ button to configure how often to check this data source for updated data.

The scheduling options can be set to: Minutes, Hourly, Daily, Weekly, Monthly or Yearly.

Find the most filled row

Select an option for detecting a row that best represents the data you want to load:

Autodetect

Automatically finds the row with the most filled columns.

Skip X Lines

Skips the first X rows and starts loading data from the next row.

Do nothingWill assume data is available from the first row

Delimiter

Select the field delimiter that has been used in the CSV file. If you select 'Other', you can enter a custom delimiter.

Load as string

Use this option if you want to skip the automatic data type detection and load all columns as String data type columns.

Has headers

Check this option if your sheet has headers. If unchecked, columns will loaded as “Column1, Column2, etc.”

Detection rows count

This is the number of rows, counted from first row, that will be examined to detect proper data types of the columns.

Encoding

If necessary, select the encoding with which the CSV file has been saved. Select from UTF-8, Windows-1252 and Windows-1251 encoding.

File without headers

Check this option if your CSV file does not have headers. When loaded, columns will be named “Column1, Column2, etc.”.

Culture

Enter the proper culture code to ensure correct loading of dates, numbers with decimals and thousand separators etc.

Culture code examples:

en-US (English, United States)
en-GB (English, United Kingdom)
de-DE (German, Germany)
da-DK (Danish, Denmark)

Connection string

The connection string is auto-generated from the other settings and is usually used as such. However, you have an option to change the connection string and thereby further customize your settings.

HTML

<style type="text/css">
      #title-text { display: none;} 
      #breadcrumbs, #footer, #likes-and-labels-container, #comments-section { display:none; }	 

div.theme-default .ia-splitter #main {
    margin-left: 0px;
}
.ia-fixed-sidebar, .ia-splitter-left {
    display: none;
}
div#main {
    margin-left: 0px !important;
}
div#footer {
  margin-left: 0px !important;
}

.columnLayout.two-equal
{
padding-left: 20px;
padding-right: 20px
}

#main #content
{
padding-right:0px;
}

div#main
{
padding:0px;
}
#page
{
overflow-x: hidden;
}
iframe#topheader
{
border:0px;
}
.contentLayout2 .columnLayout
{
margin-bottom:0px;
}

#workflow-page-message
{
margin-bottom: 0px;
}

   </style>
<script src="//cep.targit.com/bundle/beacon"></script>

<div class="Footer" style="background-color: #1d252d;width:100%;">
    <div class="loop" style="padding-top:69px;padding-bottom:72px;text-align:center;">
        <img src="https://targitmedia.azureedge.net/Resources/MainSite/Images/TARGIT_OODA-jigsaw-start-screen.svg" style="margin-bottom:32px;width:100px;">
        <div style="font-size:24px;line-height:32px;letter-spacing:0.6px;color:#fff;">
            Courage to Act
        </div>
    </div>
    <div style="width:100%;background-color:#121a23;">
        <div style="width:1080px;margin:auto;padding-bottom:20px;padding-top:20px;">
            <div style="float:left;font-size:13px;color:#8a9298;">
                <div style="margin-top:5px;display:inline-block;padding-right:30px;color:#8a9298;">
                    © 2019 TARGIT. All Rights Reserved.
                </div>
                <a style="margin-top:5px;display:inline-block;text-decoration:none!important;color:inherit;font-size:13px;" href="https://www.targit.com/en/personal-data-policy">Personal Data Policy</a>
            </div>
            <div style="float:right;">
                <a style="vertical-align:super;font-size:13px;letter-spacing:0.6px;margin-right:36px;color:#fff;text-decoration:none!important;text-transform:uppercase" href=".columnLayout.two-equal
{
width: 85%;
margin: auto;
}
</style>

<script src="//cep.targit.com/bundle/beacon"></script>
<iframe id="bottomfooter" src="https://www.targit.com/en/meet-targit/meet-the-targit-team/contact-targit">CONTACT</a>
                <a style="vertical-align:super;font-size:13px;letter-spacing:0.6px;margin-right:36px;color:#fff;text-decoration:none!important;text-transform:uppercase"  href="https://www.targit.com/en/meet-targit/targit-news/news-list">PRESS</a>
                <a style="vertical-align:super;font-size:13px;letter-spacing:0.6px;margin-right:36px;color:#fff;text-decoration:none!important;text-transform:uppercase"  href="https://www.targit.com/en/meet-targit/targit-career/jobs">CAREERS</a>
                <a style="margin-right: 36px !important;text-decoration: none !important;color: inherit;" href="https://twitter.com/targit" target="_blank"><img src="https://targitmedia.azureedge.net/Resources/MainSite/Images/twitterfooter.png"></a>
                <a style="margin-right: 36px !important;text-decoration: none !important;color: inherit;" href="https://www.linkedin.com/company/targit" target="_blank"><img src="https://targitmedia.azureedge.net/Resources/MainSite/Images/linkedinfooter.png"></a>
                <a style="margin-right: 36px !important;text-decoration: none !important;color: inherit;" href="https://www.facebook.com/TARGIT.BI.Suite" target="_blank"><img src="https://targitmedia.azureedge.net/Resources/MainSite/Images/fbookfooter.png"></a>
            </div>
            <div style="float:none;clear:both;"></div>
        </div>
    </div>
</div>





emptyfooter" scrolling="no" frameborder="0" style="width:100%;height:190px;overflow:hidden;scrolling:no;border:0px"></iframe>

Page tree

Versions Compared

Old Version 2

New Version Current

Key

Image Modified Back

CSV - InMemory

Assembly

Adding the Data Source

Name

Assembly location

File type

Schedule

Find the most filled row

Delimiter

Load as string

Has headers

Detection rows count

Encoding

File without headers

Culture

Connection string

Page tree

Page History

Versions Compared

Old Version 2

New Version Current

Key

Image Modified Back

CSV - InMemory

Assembly

Adding the Data Source

Name

Assembly location

File type

Schedule

Find the most filled row

Delimiter

Load as string

Has headers

Detection rows count

Encoding

File without headers

Culture

Connection string