cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Create a CSV with 2 Header lines

ConnorSkillsoft
Deputy Chef II
Deputy Chef II

I'm attempting to create a CSV file with 2 header lines for an integration between D365 and Coupa:

 

RequisitionSubmit For Approval?JustificationRequested By (Email)Requested By (Login)Ship to Location CodeHide Pricepo_email_addressevent__work_orderevent_start_dateevent_end_date                        
Requisition LineLine NumberCatalog Item NumberNon Catalog Item DescriptionSupplier Part NumberQuantityPriceUOM CodeNeed By DateSupplier NumberCommodity NameCurrency CodeChart of Account NameAccount CodeAccount Segment 1Account Segment 2Account Segment 3Account Segment 4Account Segment 5Payment Term Codeasset_locationasset_tagasset_idservice_start_dateservice_end_dateproductexpense_glprofile_idusers_deptchannelmodalityproduct_lineactivitycategoryinstructor


Output should look like below

 
RequisitionSubmit For Approval?JustificationRequested By (Email)Requested By (Login)Ship to Location CodeHide Pricepo_email_addressevent__work_orderevent_start_dateevent_end_date                        
Requisition LineLine NumberCatalog Item NumberNon Catalog Item DescriptionSupplier Part NumberQuantityPriceUOM CodeNeed By DateSupplier NumberCommodity NameCurrency CodeChart of Account NameAccount CodeAccount Segment 1Account Segment 2Account Segment 3Account Segment 4Account Segment 5Payment Term Codeasset_locationasset_tagasset_idservice_start_dateservice_end_dateproductexpense_glprofile_idusers_deptchannelmodalityproduct_lineactivitycategoryinstructor
Requisition                                  
Requisition Line                                  

Has anyone faced a similar issue before, and if so, knows the most efficient way to solve this?

 

Any suggestions welcome, many thanks!

 

Connor Smith

9 REPLIES 9

brian-haskins
Deputy Chef III
Deputy Chef III

What are you trying to accomplish with the integration? 

In theory, it should only be one file, one header row with many fields or two files with transformation between the two. The only example I can think of is what Concur does with their Extracts where its 235 columns across but it contains the lowest level of detail you need. The screenshot below shows the column order and different types of data including line level data. 

brianhaskins_0-1705950397240.png

 

This is for creating requisitions within Coupa, from Purchase Order information in Dynamics 365.

Agreed, the formatting is odd. I had explored the option of generating 2 seperate CSV files (1 for each header line) and appending, but that hasn't appeared to work!

Coupa should have example import files either with the schema or how they want it imported. Either in a portal or through Support. 
https://compass.coupa.com/en-us/products/product-documentation/integration-technical-documentation/c...

Thankyou!

meghan-legaspi
Community Manager
Community Manager

Hey @ConnorSkillsoft, did any of the provided responses help you resolve? Please let us know if you need more assistance, or if you found a solution, it may help others in the future!