Another How To for how to use the File Picker Client control and file-erp-transfer widget. This tutorial will go over how to wire up the controls, pass the file to a function, parse the data, return the dataset to App Studio, and display the rows in a grid. Create a DataView holder [image] Cr…

Great work! Thanks to both of you.

[image] hmwillett: I’m adding an additional directory to mine called “Uploads”, but this is something only On Prem folks can do I can do it :slight_smile: But anyway, nice job writing it up. I’m sure I’ll reference it in the future. As far as your function, I believe Epicor has a prebuilt c…

[image] klincecum: I can do it I just assume SaaS-a-frass can’t do anything except cry in frustration. :slight_smile: [image] klincecum: As far as your function, I believe Epicor has a prebuilt class or helper method that parses CSV files for us if we can find it. Interesting! I’ll t…

[image] hmwillett: Interesting! I’ll take a gander. Now which library I came across it in is anyone’s guess. I didn’t use it, just saw it :slight_smile:

See the top part of this post. @hkeric.wci :metal: [image] Button to Export To CSV ERP 10 I am going to assume you know your .NET, given that you are attempting to do something a bit more advanced. You might want to .NET Reflect or dotPeek on: Ice.Lib.SharedUtilities.d…

This guide has been really helpful to me. Thank you! I have an issue regarding the refresh of the grid. If you : Upload a CSV; Add, edit, or delete columns in the CSV file; Reupload the CSV; ===> the Kinetic grid columns are not updated. I clear the dataview using the dataview-clear widget when…

[image] vingeance: Is there something else I could try? I’m wondering if we could make a blank “template” dataset, and use dataview-copy to overwrite it. Poke it and let us know :slight_smile:

I played with the dataview-copy widget. Same issue. I appreciate the suggestion! What’s strange is that the Debug Tool work as intended. For example, I uploaded a CSV. I removed a column from the CSV file, then reuploaded it. The grid still displays the removed column, but the Debug Tool did remov…

[image] vingeance: Debug Tool I’ll have to look into that.

The Debug Tool is a nice addition. It still forget about it sometimes and use the CTRL+ATL+V command to display the DataViews in the browser Developer Tools console. Just found out that expanding / collapsing a panel does refresh the columns. It would be great if I could just find the event to trig…

How To: Kinetic - Upload a Client File, Parse, and Display in a Grid

Experts' Corner

klincecum (Kevin Lincecum) March 17, 2023, 3:34pm 6

See the top part of this post.

@hkeric.wci

Kinetic - Looping through rows - SelectSerialNumbersEntry

Topic		Replies	Views
Kinetic, Application Studio, Server Files (Saas) Kinetic ERP	21	7217	March 26, 2025
Best way forward Kinetic ERP e10	45	3173	March 16, 2023
Kinetic Calling function return dataset not working Kinetic ERP	1	924	February 20, 2024
Kinetic web dashboard, upload file possible? Kinetic ERP	7	2567	August 5, 2022
File Save from epicor functions Kinetic ERP	2	2093	December 21, 2023

How To: Kinetic - Upload a Client File, Parse, and Display in a Grid

Related topics