Richard Brown
Beginner Celigo
Activity overview
Latest activity by Richard Brown-
Richard Brown commented, Thanks Tyler...your explanation makes sense and I appreciate the very detailed examples...including NetSuite examples. It's nice that your example output format YYYY-MM-DD HH24:MI:SS is easily conv...
-
Richard Brown created a post, NetSuite date format in Celigo export -- where set?
Hello All -- I am exporting project records from NetSuite via Saved Search flow. The date fields are exported in European D/M/YYYY format. My personal date format setting is DD-MMM-YYYY. The NetSui...
-
Richard Brown commented, Hello Scott -- thanks for your alternative suggestion. It is more elegant and highlights how the SQL steps can be repurposed as command steps, opening up all sorts of SQL manipulation. Unfortunatel...
-
Richard Brown commented, Here's a quick-and-dirty solution to adding pre- and post-Insert/Update SQL commands, at least for Microsoft SQL Server. Place the commands at the top and bottom of the Insert and Update commands, ...
-
Richard Brown commented, Hi again -- I used your techniques to get 2 flows working with my data -- thanks again for such complete descriptions. My only change was using simply "SELECT 1" for the second flow's export -- the...
-
Richard Brown commented, Wow Tyler I'm impressed with your quick *and* complete response. I will explore your suggestions and let you know how it goes. It does seem a lot of work to submit a couple of SQL commands...the im...
-
Richard Brown created a post, SQL Commands in SQL Server Import flow
Hello All -- I would like to execute some SQL Commands -- like initializing a table and running a post-import merge -- and do this before and after the Insert and Update commands in my SQL Server I...