Hi,
could anyone advise me how to load or import excel data into Infor Data Lake.
An Excel Add-In has been officially published in Microsoft AppStore. This can export or import the excel data to and from Datalake. It has been published with the name "Infor OS Add-In for Excel". It can be accessed from - Find the right app | Microsoft AppSource . Attaching a few screenshots of the same for your reference.
Hi Vadivel,
Our Data Catalog currently supports a format family called "DSV" (Delimiter-separated value) which allows you to describe & support CSV, PSV, TSV, and custom flat file formats. You can walk through the Data Catalog's registration wizard and upload a sample file. Then, it's simply a matter of using the File Connector within ION to connect to your file server, define the object name (from the Data Catalog), and then move it into the Data Lake via a flow.
Are you thinking of putting in .csv files or .xls/.xlsx files into Data Lake?
If it's a proper excel file, you can put these files into the Data Lake but I should mention that we don't natively support .xls/.xlsx formats in Data Catalog and Data Lake at this time. This means you can move the file into the Data Lake by registering your spreadsheet as an "ANY" document type within Data Catalog (see GIF below) and then use the file connector steps above. However, you won't be able to query the file with Compass.
We do have this in our future roadmap to support so we'll keep you updated on when it comes out.
Here is some sample please change it:
import pandas as pd
import requests
import inforion
import json
df = pd.read_excel("samplee1.xlsx")
#print (df.head())
config = inforion.load_config()
token = inforion.login(config)
print (token['access_token'])
headers = inforion.header(config, token)
url = '[View:https://mingle-ionapi.eu1.inforcloudsuite.com/FELLOWCONSULTING_DEV/IONSERVICES/api/ion/messaging/service/v2/message:1040:50]';
pandasstring = df.to_csv(sep='|', index=False)
print (pandasstring)
payload = {
"document": {
"characterSet": "UTF-8",
"encoding": "NONE",
"value": pandasstring
},
"documentName": "People_CSV",
"fromLogicalId": "lid://infor.ims.mongooseims",
"messageId": "message72876bbc4e6f49dd8a32a8f7b2017a68",
"toLogicalId": "lid://default"
}
print (payload)
response = requests.request("POST", url, headers=headers, data = json.dumps(payload))
print(response.text.encode('utf8'))
to get the token:
def load_config():
with open('Postman.ionapi') as json_file:
data = json.load(json_file)
return data
def login(config):
base_url = '[View:https://mingle-sso.eu1.inforcloudsuite.com:0:0]';
url = base_url + "/as/token.oauth2"
data = {
'grant_type' : 'password',
'username' : config['saak'],
'password' : config['sask'],
'client_id' : config['ci'],
'client_secret' : config['cs'],
'scope' : '',
'redirect_uri' : '[View:https://localhost/:1040:50]';
r = requests.post(url, data=data)
return r.json()
Let me make a proper howto document in the next days
Here is the script Python Script
Hi Raghu,
It never worked for me. Always stucked on this window after entering login//pwd:
I checked parameters many times but never got the green "Authenticate" button.
Hi Maxime,
Request you to send an email to infor.labs@infor.com , so that we can investigate the issue and try to resolve it.Thank you
Same with me. Not able to login or authenticate
Hi Mohan,
Request you to send an email to infor.labs@infor.com , so that we can try to resolve it.
Thank you
Thanks to the team. It is working with excel online.
Still have to figure out what is blocking the right-clic in my personnal excel version.
Hello Everyone,
After receiving feedback from various customers regarding storage of frequently used queries, we're excited to announce a powerful new feature in the Infor OS EXCEL Add-In: "Add to Favourites." This feature is designed to streamline your workflow and enhance your user experience by allowing you to easily save and access your frequently used queries in the Microsoft EXCEL Add-In for Infor OS.
Key Benefits:
Please feel free to use the new feature.
Additional details regarding this is available on the Instructions Page in the Add-In. Please feel free to reach out to us here, in case you have any questions/suggestions.
As we try to make our product "Infor OS Excel Add-In" even better and user friendly. we are happy to announce that we have added few additional features in the Add-In.
Additional details regarding this is available on the Instructions Page in the Add-In. Please feel free to reach out to us here, in case you have any questions/suggestions. Alternatively, you can mail us on infor.labs@infor.com for any kind of assistance.
Hello everyone,
First, we want to thank all our users for their continued support and valuable feedback. Based on your suggestions, we’ve implemented several enhancements to improve your experience with the Infor OS Excel Add-In. Here are the key updates:
Initial Load Feature: Users can now mark up to five queries as "Initial Load," which will be automatically executed upon login. This new feature, accessible under 'View Favorites,' saves time by eliminating the need to manually execute the same queries every time you log in.
Enhanced Security Role: A new security role has been introduced, giving Admins greater control. Admins can now restrict users from pushing data to the Data Lake and limit them to only viewing data. This helps ensure data integrity and provides more control over sensitive information.
Bulk Retrieval Capability: The Add-In now supports bulk retrieval, allowing users to download up to 10,000,000 records at once. This enhancement dramatically improves the efficiency of data retrieval for large datasets and reducing wait times.
These updates are aimed at improving efficiency, security, and providing a smoother, more intuitive user experience. We hope you enjoy these new features and look forward to your continued feedback!
Please feel free to use the new feature.Please feel free to reach out to us here, in case you have any questions/suggestions. Alternatively, you can mail us on infor.labs@infor.com for any kind of assistance.
