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:100px;overflow:hidden;scrolling:no;"></iframe> |
Back
Directory - Data Discovery Plugin
The
CSV plugin can consume data from correctly formatted CSV files.directory plugin can be pointed to a folder from where CSV, Excel and JSON files automatically will be loaded. When loaded, default settings according to the file type will be used to create a corresponding Data Discovery data source.
When a new file of the correct type is added to the specified folder, Data Discovery will automatically create it as a new data source.
If changes are made to an existing file in the specified folder, the data will automatically reload.
Adding the Data Source
The CSV Directory plugin is a 'Files' data source.
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
Select a type according to the accessibility of the data source:
Local fileDirectory path
Enter, or browse, the path of the
filefolder, e.g. “C:\
Temp\CountryLatLong.csv”DataDiscoveryDirectoryFiles”. Bear in mind that the
filefolder must be accessible from the TARGIT server’s point of view.
- 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 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 is 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 nothing
- Will assume data is available from the first row.
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.”Create Cubes for each file
If checked, Data Discovery will automatically create a default cube for each of the loaded files.
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> |