Load multiple Excel files from a directory with one connection and extract (like CSV Files).
Load multiple Excel files from a directory with one connection and extract (like CSV Files). Basically the same structure like creating a file extract using a folder-connection. But also working with Excel files :)
Integration patterns between Microsoft Dynamics 365 and external systems (Jedox) typically rely on the use of CSV files to pass data between the 2 applications with Azure BLOB storage the place to put or get the file from
Bring back addFileNameColumn in directory/ file extract
As of Version 23.4 the distinct directory extract has been deprecated in favour of the option to select to extract either a single file or a directory within the file extracts. While doing this the addFileNameColumn option of the directory extract...
Our Partner had the following request: We need some of the jobs to be able to run when a long job is already running but they shouldn't run when other jobs are running.This means we cannot set them as standard and cannot set them as parallel.The i...
Filesize in Metadata Extract for Directory Connection
After access on the cloud to Java.IO and other classes in the integrator has been blocked, it is no longer possible to query the size of files. This is very important for various use cases. My suggestion would be to output the size in Metadata Ext...
Currently it's only possible to store new views and open existing views in O365 Excel Add-In. It's not possible to delete a stored view. This functionality would be beneficial in the future.
Enable copying connections details from cloud console to 365 add-in
If you copy your connection details from the cloud console, you could paste them into the Excel Add-in. This isn't possible anymore - and I think never worked - in the new Add-in for Excel 365. Please implement this for the new add-in, because oth...
When creating ETL project, a lot of debugging is needed. At this moment to check if data is correct, I'm exporting data to CSV right from DataPreview vindow. The problem - it exports only data visible on screen.
Sure - with BIG data, it is ok.
My...
Create a function that shows the last update of the sheet, by making it a function I can decide where in the report to place it so it's well located for others to see it and I could also change its format.