DLR
- 4 Minutes to read
- Print
- DarkLight
- PDF
DLR
- 4 Minutes to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Article Summary
This article provides an overview of creating and managing Data Load Rules (DLRs) in Planful. It explains the supported input methods—such as file upload, copy-paste, and web services—and outlines the types of data that can be loaded across various areas of the application. It also highlights key access prerequisites and administrator actions required to enable DLR functionality, helping users efficiently set up and manage data imports for a secure, flexible, and streamlined data integration experience in Planful.
AKA: Cannot see DLR, cannot see Data Load Rule
eddy_questions: I cannot see DLR menu.
google drive file upload - To create a Data Load Rule to load a file from Google Drive, follow the steps below:Click Maintenance > Data Integration > Data Load Rules. Click New Data Load Rule. Enter a Name and Description. For Load Type, select Google Drive File Upload. For Load Item, select Data. For Sub Load Item, select from GL Data or Translation Data. Complete the fields on the remaining Data Load pages as needed. Refer to Understanding New Data Load Rules for detailed instructions. Note: When a Google Drive Data Load Rule (DLR) file is created by a user, it automatically creates a folder with the same name in the Administrator's Google Drive account. The file is accessible to the user and the Administrator only.
The Planful suite includes built-in data integration functionality, which allows you to import your data.
A Data Load Rule (DLR) tells the Planful system how to handle data values in the data source during a data load. You can create data load rules to load files, copy and paste data, and use web services to load segment hierarchies, attributes, attribute hierarchies, entity hierarchies, users, Workforce data, currency exchanges rate and other data. There are several steps to create a data load rule. These steps vary based on source and target data options.
Notes:
To view/access the Data Load Rules option, the user's Navigation Role must include Navigation Access for Data Load Rules.
An Administrator can enable this by selecting the Data Load Rules checkbox under Data Integration in the user's Navigation Access settings.
Once the user has navigation access, their ability to view, create, or edit DLRs is controlled by their assigned Data Integration Security settings. Ensure the appropriate permissions are granted based on the access level required.
The first page you will see when you access the Data Load Rules page is the Data Load Rule List. Click the New Data Load Rule page and the Data Integration wizard will step you through the remainder of the process.
Types of Data Loads
The following methods for data import are available:
Spreadsheet Based Data Load
Using this approach, your source data is first exported to Microsoft Excel and then copied on to the Planful browser-based spreadsheet interface through the copy/paste operation.
This approach is user-friendly and most commonly used, however, when the data volume is huge (i.e. above 60,000 records per data load), alternative methods are recommended.
Note:
When using Excel Files ensure all numerical data is formatted as Number. Data formatted as Accounting and other formats is not supported.
File Based Data Load
Using this approach, your source data is first exported into a text /excel/csv file format. Then, through load mapping settings, load file setup is configured in the application. Lastly, the source file is setup to upload to the Planful application database.
If you set up a File based data load rule and later on want to load data via Web Services, instead of re-creating the entire DLR (Data Load Rule), you can simply edit it and change the Load Type to Web Services. This flexibility saves time and ensures consistency in loading data when the same DLR is used. However, it is very important and a best practice to complete all the steps in the DLR to effectively change the DLR type. Otherwise, the DLR will be rendered unusable.
You can switch between the types of DLRs:
File Load
Web Services
Copy – Paste
NetSuite Connect
For example, to change the load type from File to Web Services, click the DLR. Change the Load Type to Web Services and complete the remaining steps of Select Sample Input File, Define Overall Rule Settings, Manipulate Input File, Define Data mappings and Load Data for the changes to take effect.
Data Load Rules (DLRs) are automatically sorted alphanumerically. Sorting alphanumerically allows you to more quickly identify a Data Load Rule without scrolling through the lists.
If you sort on any column on the Data Load Rule List page, navigate away, and then return to the same page, the sorting is retained.
Note:
The orange carrot displayed in any of the columns denotes that the user has sorted the DLR list on that column.
Template Based Data Load
Using this approach, data is loaded into the Planful suite via data input templates in which data is manually entered. Administrative users can design and publish the data input templates, which are then accessed by end users who input data into the templates.
This approach is recommended when the data needs to be loaded into the Planful suite from several disparate General Ledgers with significant dissimilarities in the chart of accounts and the data translation mappings from the subsidiary general ledger data to the common reporting chart of accounts do not exist or would be hard to create.
Web/Cloud Services
See the Admin Guide to Loading Data to Planful
How to load data to a scenario?
How do I upload a scenario
You can upload data into scenarios using the Data Load Rules (DLR) feature. This allows you to import data from various sources into specific scenarios for analysis and planning.
Was this article helpful?