Import CSV File: AIF method – Part 3Continue reading
So far we have created and deployed Service and created the transformation, we are almost there, now we need to put this together and create inbound port.
First go to the System administration -> Setup -> Services and Application Integration Framework -> Inbound ports:
Click on New and create new inbound port, lets name it for example AttributeTableServices.
First we need to set Adapter to File system adapter and specify the URL which in our case is the folder to where you will drop your CSV files. Then click the Configure button and select Admin:
Then in Service contract customizations select Service operations and find AttributeTableConfigService.create in Remaining service operations and select it by clicking ‘<‘:
Next step is to check the Transform all request checkbox and load the dll for our transform (follow the red arrows J).
Remember that every time we modify that dll we need to change its version in Visual Studio:
Click button Activate:
First drop the CSV file into the URI directory. After execution it will disappear because it will be consumed by the service, so every time we want to test the execution we need to add a new file into the folder. Approach: Execute this following job:
static void AifProcessor(Args _args)
AifGatewayReceiveService agrs = new AifGatewayReceiveService( );
AifInboundProcessingService aip = new AifInboundProcessingService( );
AifGatewaySendService agss = new AifFatewaySendService( );
AifOutboundProcessingService aop = new AifOutboundProcessingService( );
Check AttributeTable, you should see changes!
Approach: Create batch job:
System administration -> Inquiries -> Batch jobs -> Batch jobs
- Add new batch job (Ctrl + N).
- Click on View tasks and add new tasks (Ctrl + N) in the given above order.
- Change status to waiting and wait for the execution.
When status changes to Ended check AttributeTable, you should see changes!
Implementing a new ERP system in an organisation is always a challenge. Users question whether they will be able to cope with analysing the data flow in an integrated system without external support. The accountant wonders whether all the set-up accounts are correct. The chief technologist cannot get rid of troublesome thoughts about whether the routings and boms are set up optimally. This is why it is so important to have a reliable service team to help the company control the system in the post-implementation stage. In this article, we take a look at the issues surrounding the implementation of an ERP system and the benefits of maintaining proactive service support.
328.77 million terabytes of data are generated every day - this is the estimate for the first quarter of 2023 (1). These are massive amounts of data on a global scale. On a smaller scale, such as an enterprise, it's difficult to estimate because it depends on the organisation in question, but one thing is certain - collecting, processing and analysing this data is the key to business success today. Why is the Data Lake service so important for data analysis and reporting in Microsoft Dynamics 365 Finance and Operations? How can you tame the data by integrating Microsoft Power BI analytics with Data Lake? We have drawn up some tips.
The retail industry is still dealing with the effects of the pandemic that lasted almost three years. In addition to this, further global events are causing disruption to the supply chain or financial stability of many retailers globally. As the industry confronts new challenges shaped by economic and geopolitical factors, it also faces trends influenced by changing customer expectations and needs. Here are 5 developments and trends to watch.
An interactive, AI-powered support for sales, customer service, marketing, and supply chain - Microsoft Dynamics 365 Copilot leverages generative AI and natural language processing technology to perform simple, yet time-consuming daily tasks that workload employees but can be automated.