Need Help - Building Function to Dump Tables before Environment Reset

Kinetic ERP
41

Figured that out pretty quickly. :laughing:

No where clause on GetRows would return all? I seriously donā€™t know the answer to this.

Again, donā€™t care about the upload at this time. Running a bunch of DMTs is my plan for now.

Thatā€™s why a csv. You can open it in Excel.

42

I stand corrected. I was thinking of GetList. GetRows gets everything:

image
image646Ɨ753 9.55 KB

2 Likes
43

One thing to keep in mind is that the result of GetRows may not map 1:1 with your DMT template. You may have to rename some columns

2 Likes
44

DMT can consume Excel sheets also, sadly the last time I looked it canā€™t consume anything other than Sheet 1. Leading 0ā€™s is a problem (apparently there is a new option in Excel to enable not truncating leading zeros)

Hmmmm. Now that would be useful to be able to DMT in parallel by loading multiple sheets at the same timeā€¦ I know you can manually run the same DMT template with different data at the same time.

45

Even before the fix, if you want a string, you can enter as a formula with quotes:

...,="0801",...
1 Like
46

Or format the whole sheet to have the cells be Text and then paste in.

1 Like
47

I have always used that approach, leading zeros option in Excel also handy for copy to Excelā€¦

48

And itā€™s AWESOME!!! :delicious:

Of course they introduce it right after Iā€™ve reduced my CSV consumption to near zero.

3 Likes
49

How does the Epicor ERP Analyzer / Cirrus program do it? Maybe thereā€™s something that can be leveraged, or turned into a feature for us lowly customers. Ideas?

50

Here is your tool. We could expand this a lot.

https://www.epiusers.help/t/dump-database-table-to-csv-file-in-epicordata-folder/117317?u=klincecum

4 Likes