I have created a new External File Template for ExtSuppInv file type , how do I now generate the template in an excel so I can fill in the necessary details, convert it to CSV and then import via the External File assistant ?
Question
How to generate the external file template in excel ?
+5
I am usually exporting details of the template to Excel (through Output channel) to get column headers for my Excel template.
+23Hi
in the past we had the same issue. I developed a VBA script to create a csv file with the proper structure from excel.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.