TeraScript-Talk: TeraScript SMTP server on Windows 10 Pro

As Windows 10 Pro does not provide a SMTP server in IIS, I was wondering what you use for a SMTP server on a TeraScript server setup on a Windows 10 Pro laptop? Thanks Steve Fogelson Internet Commerce Solutions To unsubscribe from this list, please sen

TeraScript-Talk: Braintree payment system - Java

I want to integrate the Braintree (PayPal) Drop-In payment solution into my TeraScript eCommerce application. I started to research implementation of this using their Java SDK. https://developers.braintreepayments.com/start/hello-client/javascript/v3 The first thing to do involves Downloading an

RE: TeraScript-Talk: Finding a file

older contents in a database – this second one has the added cost of essentially maintaining a cache. Robert From: Fogelson, Steve [mailto:foge...@askics.net] Sent: Saturday, April 11, 2020 11:48 AM To: TeraScript-Talk@terascript.com<mailto:TeraScript-Talk@terascript.com> Subject: Tera

TeraScript-Talk: Finding a file

Hope you are all staying safe. I have a folder that has a 100,000 plus images in it. Before I use the "Write" action, I would like to check to see it the file already exists. I could use the "List Directory" action and then parse, but as I mentioned there are a lot of files and it would be cum

RE: TeraScript-Talk: FedEx return label

binary so just place the tag in the data body of a Write File Action. From: Fogelson, Steve [mailto:foge...@askics.net] Sent: Wednesday, February 19, 2020 12:02 PM To: TeraScript-Talk@terascript.com<mailto:TeraScript-Talk@terascript.com> Subject: TeraScript-Talk: FedEx return label I am writing

TeraScript-Talk: FedEx return label

I am writing a taf to allow customers to request a return label from FedEx utilizing the Web Call action. I have it working but part of the returned xml is in Base64. This is actually the label for the customer to print. FedEx told me to decode it and save it to a file and then print it. I am n

TeraScript-Talk: Java Update

Using JDBC Just checking to see what everyone is doing with the Java update. Looks like Oracle wants us to upgrade to business use Steve Internet Commerce Solutions To unsubscribe from this list, please send an email to lists...@terascript.com with "

TeraScript-Talk: Writing array back into MySQL DB

I use MySQL for my DB. If you read a set of data into an array, can you write the revised array back to the DB with one write or do you need to write back a row at a time? If you can, how? Thanks Steve Fogelson Internet Commerce Solutions To unsubsc

TeraScript-Talk: Surface Pro X

Does anyone know if the New Surface Pro X will run TeraScribe? It uses 64-bit (ARM64) https://docs.microsoft.com/en-us/surface/surface-pro-arm-app-performance Thanks Steve Fogelson To unsubscribe from this list, please send an email to lists...@teras

RE: TeraScript-Talk: Web Service

ith the commas and semicolons) Once you have that postArgs array, you can pass it to the Webcall Argument Array and TS will take care of the rest. Each row of that array will be an argument available on the server, eg <@ARG OrderDetail> Robert PS. The format you suggest below would be

RE: TeraScript-Talk: 7.1.5 pre-release

Hi Robert, Are there any release notes (Features & bug fixes) available? Thanks Steve Fogelson From: Robert Shubert Sent: Sunday, July 21, 2019 6:49 PM To: TeraScript-Talk@terascript.com Subject: TeraScript-Talk: 7.1.5 pre-release Windows Users, Please consider downloading the latest build o

RE: TeraScript-Talk: Web Service

e serialized format. Sort of a SQL RPC. Of course you want to be mindful of security. SSL, password, IP restriction, or best, VPN, should be used. Robert From: Fogelson, Steve [mailto:foge...@askics.net] Sent: Thursday, July 11, 2019 8:05 AM To: TeraScript-Talk@terascript.com<mailto:TeraScript

RE: TeraScript-Talk: Web Service

Usually you'll want to return a fail/success flag so you can debug problems. I've seen implementations where the actual SQL Insert query is the serialized format. Sort of a SQL RPC. Of course you want to be mindful of security. SSL, password, IP restriction, or best, VPN, should be us

TeraScript-Talk: Web Service

Good morning. I have an eCommerce app that is also used as a POS at retail shows. Sometimes the shows are outdoors with limited bandwidth, so I adapted the app to run on it's own LAN. After the show is over and the laptops are back at the main location, I update the live database with the show d

RE: TeraScript-Talk: Validating HTML tags

unauthorized. If you have received this information in error, please delete it and any attachments and notify me immediately. On Apr 22, 2019, at 10:53 AM, Fogelson, Steve mailto:foge...@askics.net>> wrote: I am looking for suggestions for simple HTML tag validation. When a user

TeraScript-Talk: Validating HTML tags

I am looking for suggestions for simple HTML tag validation. When a user enters content, they quit often forget a bracket, closing tag, nested incorrectly, etc. They usually only use the following tags. I am not real strong in DOM, but I was wondering if this might be useful. Other id

TeraScript-Talk: MySQL & TeraScript

Just thought I would give some information about an upgrade I did this past six months with MySQL. I use MySQL with TeraScript 7 on Windows 2012 R2 servers setup with VMs I upgraded MySQL from version 5.0 to 5.7. I would recommend against using 5.7 unless you are able to tweak it to match your

RE: TeraScript-Talk: ODBC vrs JDBC

@terascript.com Subject: Re: TeraScript-Talk: ODBC vrs JDBC just wondering something. have you tried adding o1. to the as value. ie. o1.OV_ID as o1.OV_ID2 On Jan 1, 2019, at 4:41 PM, Fogelson, Steve mailto:foge...@askics.net>> wrote: I am converting an app from using a MySQL ODBC connec

TeraScript-Talk: ODBC vrs JDBC

I am converting an app from using a MySQL ODBC connector to MySQL JDBC connector and am finding a few differences Below is part of a SQL build for a Custom SQL Query <@assign request$SearchQuery "SELECT"> <@assign request$SearchQuery "<@var request$SearchQuery> o1.OV_ID, "> <@assign request$Searc

RE: TeraScript-Talk: Web Call action question

rows, which will solve your problem. It can also ease debugging since you can output the array if you need to see its contents. Merry Christmas to you as well. Robert From: Fogelson, Steve [mailto:foge...@askics.net] Sent: Thursday, December 20, 2018 12:11 PM To: TeraScript-Talk@terascrip

TeraScript-Talk: Web Call action question

First of all. Merry Christmas to all and have a Happy and Prosperous New Year I have a Web Call action that I have always use to transmit Purchase Orders to a manufacturer. Now we have to update the Web Call to their version 4 requiring a POST Form. Easy enough except that they have three lines

RE: TeraScript-Talk: An SSL Connection could not be established

: Fogelson, Steve [mailto:foge...@askics.net] Sent: Sunday, June 24, 2018 12:39 PM To: TeraScript-Talk@terascript.com<mailto:TeraScript-Talk@terascript.com> Subject: TeraScript-Talk: An SSL Connection could not be established I am converting sites to SSL and am getting this error from a Web C

TeraScript-Talk: An SSL Connection could not be established

I am converting sites to SSL and am getting this error from a Web Call. I am using TeraScript 7.1.3 Anyone know why this Web Call would have trouble with SSL? Thanks Steve Internet Commerce Solutions Server: TeraScript Server 7-7 Class: Internal Application File: /Cron/SS.taf Position: Web

RE: TeraScript-Talk: Numeric display default

you have a specific question or test case you want me to look at. Robert From: Fogelson, Steve [mailto:foge...@askics.net] Sent: Tuesday, June 19, 2018 11:40 AM To: TeraScript-Talk@terascript.com<mailto:TeraScript-Talk@terascript.com> Subject: TeraScript-Talk: Numeric display default I re

TeraScript-Talk: Ports

When setting up TeraScript on Hyper V servers, does each Hyper V Server have its own ports? Or are the ports defined at the host server (for the Hyper V servers)? Ie: Do I need to assign different ports for TeraScript from Hyper V server to Hyper V server? Thanks Steve Fogelson Internet Comme

TeraScript-Talk: Numeric display default

I recently moved our TeraScript 7.1.3 apps to a new server. We are using MySQL 5.7 for the DB. Some of the tafs are now displaying numeric differently. IE: 9.00 instead or 9 The tag is not formatted as indicated in the following example <@var request$InventoryValues[<@var request$InventoryR

RE: TeraScript-Talk: Problems after TS 7 Server update ...

Hi Dale, Not sure if you are using Windows and what version, but my best guess would be that the "Handler Mappings" are not assigned. Examples *.taf C:\Program Files\Tronics Software\TeraScript Server\iis_terascript.dll TeraScript 7 TAF *.tcf C:\Program Files\Tronics Software\TeraScript Server\

RE: TeraScript-Talk: Request timeout

> <@CALC “@@querytimeout *900”>> <@URL <@DOMAIN><@APPFILE>?start={where to pickup} waitforresult=false> If you’re thinking about using v8, there are other methods there can do this as well. Robert From: Fogelson, Steve [mailto:foge...@ask

RE: TeraScript-Talk: Request timeout

nfigPasswd> Steve From: Wayne Irvine Sent: Monday, April 16, 2018 12:17 AM To: TeraScript-Talk@terascript.com Subject: Re: TeraScript-Talk: Request timeout Yes it is. And there is a procedure to override it per TAF. It is this procedure that I am not sure of. W On 16 Apr 2018, at 11:5

RE: TeraScript-Talk: Request timeout

Hi Wayne, Don’t know if this is what you are looking for. Hope it helps. QueryTimeout System scope only This configuration file variable causes queries that exceed the specified number of seconds to time out and return the HTML page specified in timeoutHTML. This variable is specified in secon

RE: TeraScript-Talk: Windows error 2 occured while loading the Java VM

loading the Java VM Also try running the installer as administrator. From: Fogelson, Steve [mailto:foge...@askics.net] Sent: Monday, July 17, 2017 3:02 PM To: TeraScript-Talk@terascript.com<mailto:TeraScript-Talk@terascript.com> Subject: TeraScript-Talk: Windows error 2 occured while loadi

TeraScript-Talk: Windows error 2 occured while loading the Java VM

I am trying to load TeraScribe 7.03 on a new Windows Pro 10 laptop and am getting the error listed in the subject line. I have loaded Java on the machine but still getting the error. Thanks in advance for any suggestions. Steve Fogelson To unsubscribe

RE: TeraScript-Talk: Off Topic - MySQL

es the live table and returns the results. Views get complicated though. You can chain and nest them. You can force them to maintain realized copies of data. And the list goes on. Robert From: Fogelson, Steve [mailto:foge...@askics.net] Sent: Wednesday, March 15, 2017 8:27 AM To: TeraScrip

RE: TeraScript-Talk: Off Topic - MySQL

to change any code. Robert From: Fogelson, Steve [mailto:foge...@askics.net] Sent: Tuesday, March 14, 2017 2:52 PM To: TeraScript-Talk@terascript.com<mailto:TeraScript-Talk@terascript.com> Subject: RE: TeraScript-Talk: Off Topic - MySQL Hi Ian, Well that’s a DUH moment for me. I forg

RE: TeraScript-Talk: Off Topic - MySQL

.somename; -- Ian Evans Web Developer - eCommerce Team University Book Store, Inc. 4326 University Way NE Seattle, Washington 98105 206.634.3400 ext.621 ia...@ubookstore.com<mailto:ia...@ubookstore.com> On 3/14/2017 11:17 AM, Fogelson, Steve wrote: > Over the years, I have written

TeraScript-Talk: Off Topic - MySQL

Over the years, I have written a pretty extensive shopping cart/back end processing application using TeraScript. The application handles multiple web sites with a separate MySQL database for each web site. All databases are running under one MySQL service with the One File per Table option enab

RE: TeraScript-Talk: Processing a csv file with intermittent quotes contained in it

row 1 is column names. From: Fogelson, Steve [mailto:foge...@askics.net] Sent: Monday, October 24, 2016 1:44 PM To: TeraScript-Talk@terascript.com<mailto:TeraScript-Talk@terascript.com> Subject: TeraScript-Talk: Processing a csv file with intermittent quotes contained in it I receive an inv

RE: TeraScript-Talk: Processing a csv file with intermittent quotes contained in it

16 1:44 PM, Fogelson, Steve wrote: I receive an inventory file in a comma delimited csv file. In the taf I use to process it, first I @TOKENIZE using a <@CRLF> to separate rows, then @TRANSPOSE and then @TOKENIZE based on a comma to segment the fields. I didn’t realize but some of the fields are en

TeraScript-Talk: Processing a csv file with intermittent quotes contained in it

I receive an inventory file in a comma delimited csv file. In the taf I use to process it, first I @TOKENIZE using a <@CRLF> to separate rows, then @TRANSPOSE and then @TOKENIZE based on a comma to segment the fields. I didn't realize but some of the fields are enclosed in quotes because they c

TeraScript-Talk: Avalara Sales Tax Calculator

Has anyone created a taf to use the Avalara Tax Calculation REST API? If so, any chance you could share some code. In particular I am having trouble with the Autorization segment Thanks Steve Fogelson Internet Commerce Solutions To unsubscribe from

TeraScript-Talk: RE: Another retrieving data from XML

7;request$myDom' xpath='//*:ShippingInfo[position()=<@currow>]/*:Region' type='text'>"> ShippingRegion: <@var request$ShippingRegion> <@assign request$ShippingRegionDescription "<@elementvalue object='request$myDom' xpath='//*:Sh

TeraScript-Talk: Another retrieving data from XML

In the past I have parsed xml with <@locate>, <@substring>, etc I would like to use <@dom>, <@domsearch> and the <@element tags> I started with <@assign request$myDom value="<@dom value='<@var request$httpData>'>"> Could someone give me a few suggestions and point me in the right direction how

TeraScript-Talk: TeraScribe What's new and Release Notes

Can someone point me to the What's New and Release Notes for TeraScribe 7.1 Thanks Steve Fogelson To unsubscribe from this list, please send an email to lists...@terascript.com with "unsubscribe terascript-talk" in the body.

TeraScript-Talk: Blog

Has anyone created a blog app with TeraScript? Steve Fogelson Up North Sports 1900 Division St W #7 Bemidji, MN 56601 218-444-SNOW (7669) 866-335-8500 To unsubscribe from this list, please send an email to lists...@terascript.com with "unsubscribe ter

RE: TeraScript-Talk: Adding to an array

Not sure if you are building the array with SQL. If so, could you use a UNION to add the two additional procedures? -Original Message- From: Dan Stein [mailto:d...@dss-db.com] Sent: Monday, October 06, 2014 4:01 PM To: TeraScript-Talk@terascript.com Subject: TeraScript-Talk: Adding to an

RE: TeraScript-Talk: PayPal Express Checkout

about this process if you are considering hiring a consultant. Robert From: Fogelson, Steve [mailto:foge...@askics.net] Sent: Thursday, September 18, 2014 11:25 PM To: TeraScript-Talk@terascript.com<mailto:TeraScript-Talk@terascript.com> Subject: TeraScript-Talk: PayPal Express Checkout Has

RE: TeraScript-Talk: PayPal Express Checkout

ayPal offers a good sandbox environment to test the complete cycle, which is helpful. I know Ben Johansen is knowledgeable about this process if you are considering hiring a consultant. Robert From: Fogelson, Steve [mailto:foge...@askics.net] Sent: Thursday, September 18, 2014 11:25 PM To:

TeraScript-Talk: PayPal Express Checkout

Has anyone put together a TeraScript app for PayPal Express Checkout? It appears that PayPal requires a direct url to their site with customer info including total purchase amount. The customer logs in to PayPal and approves purchase and payment. Then PayPal redirects back to the originating si

RE: TeraScript-Talk: Possible Syntax Problem on my part

name does not undergo variable replacement in 7.0.1 through 7.0.5. This will be corrected in 7.0.7. Robert From: Fogelson, Steve [mailto:foge...@askics.net] Sent: Monday, August 04, 2014 11:41 AM To: TeraScript-Talk@terascript.com<mailto:TeraScript-Talk@terascript.com> Subject: TeraScrip

TeraScript-Talk: Possible Syntax Problem on my part

I have a <@callmethod> tag that worked fine in TS6.2, but fails in TS7.0.5 with this error. I looked through the Notes and didn't find anything related to this. Might have missed it. [Error] [832] -810 Error getting object's introspection information. Couldn't find info for method <@var instanc

RE: TeraScript-Talk: Programming Guide

: Fogelson, Steve [mailto:stevefogel...@askics.net] Sent: Monday, December 09, 2013 10:31 AM To: TeraScript-Talk@terascript.com<mailto:TeraScript-Talk@terascript.com> Subject: TeraScript-Talk: Programming Guide I have looked on the website for the Programming Guide the past couple weeks. Eithe

TeraScript-Talk: Programming Guide

I have looked on the website for the Programming Guide the past couple weeks. Either I am missing something or it was moved. Does anyone know where I can access it now? Thanks, Steve Fogelson To unsubscribe from this list, please send an email to lis

RE: TeraScript-Talk: Send XML to specific URL

MC, Robert is correct that he made many enhancements and fixes to the Web Call action. The Web Call is easy to use. Put the URL in the "URL" field under the "Request" tab. I assume you want a "POST" If so, the easiest way to include you XML is to set a var to the XML and then place a referen

TeraScript-Talk: Successful Update

I would like to verify that an update action was successful. Is there a tag or a technique to indicate how many rows were updated using an update action? Thanks Steve Fogelson Internet Commerce Solutions To unsubscribe from this list, please send an

RE: TeraScript-Talk: Ajax

Hi Dale, I would be interested in looking at your tcfs / custom tags and your how-to. Steve Fogelson Internet Commerce Solutions -Original Message- From: Dale Graham [mailto:dale.gra...@gmail.com] Sent: Wednesday, June 26, 2013 10:47 AM To: TeraScript-Talk@terascript.com Subject: Re: Ter

RE: TeraScript-Talk: Latest Mac Java Update Breaks Terascribe

Hi Erik, I know that is a problem with Windows. I haven't upgraded Java for a while now as it breaks TeraScript. I had to re-install the prior version of Java to get it to work again.. I think Robert will make TeraScript compatible with the current version of Java in the future unless he alrea

TeraScript-Talk: New encoding method

Hi Robert, Would you consider a new encoding method of "excel" that could be used to format a text field to place in a csv file that would be read correctly by Excel? Thanks Steve Fogelson Internet Commerce Solutions To unsubscribe from this list, p

RE: TeraScript-Talk: RE: Write - FTP action

t the firewall is your problem. Robert From: Fogelson, Steve [mailto:stevefogel...@askics.net] Sent: Friday, May 03, 2013 2:25 PM To: TeraScript-Talk@terascript.com<mailto:TeraScript-Talk@terascript.com> Subject: RE: TeraScript-Talk: RE: Write - FTP action Hi Robert, I have been working throug

RE: TeraScript-Talk: RE: Write - FTP action

the list to improve the actions per your comments. Thanks, Robert From: Fogelson, Steve [mailto:stevefogel...@askics.net] Sent: Wednesday, May 01, 2013 9:44 PM To: TeraScript-Talk@terascript.com<mailto:TeraScript-Talk@terascript.com> Subject: TeraScript-Talk: RE: Write - FTP action I di

TeraScript-Talk: RE: Write - FTP action

that our firewall is preventing ftp traffic. Case solved. This Write action works great. Steve From: Fogelson, Steve [mailto:stevefogel...@askics.net] Sent: Wednesday, May 01, 2013 5:01 PM To: TeraScript-Talk@terascript.com Subject: TeraScript-Talk: Write - FTP action I am looking for some

TeraScript-Talk: Write - FTP action

I am looking for some documentation for this action. Can the "host" just be the domain? Does it need to include ftp:// What is the "File" field used for? I thought maybe it was a path and file name to write to the ftp site. When I click on "Browse" TeraScribe locks up on me. Maybe I am doing so

RE: TeraScript-Talk: Terascript 6 STARTUPURL error

Hi Matt, The user I setup is a member of the Administrators group on the local machine. You have done everything that I would suggest. I assume that web sites are working fine on the server. You have probably had Robert look at your server.ini. I really reaching now, but have you tried reducing th

RE: TeraScript-Talk: Terascript 6 STARTUPURL error

Hi Matt, We have been running STARTUPURL for over a year on our server. Same setup as you. 64 bit Windows 2008 R2 server. Three things potentially different. We are running the pro version with 4 instances running on the same server. We have not updated our server to the most current version. I be

RE: TeraScript-Talk: <@callmethod>

@@request$ReturnSeoUrl[<@currow>,Cat_Name]> <@assign request$ReturnSeoUrl[<@currow>,Cat_Name] "<@callmethod request$Common 'PurgeSeoUrl(<@VARPARAM param>)'>" encoding=none> Robert From: Fogelson, Steve [mailto:stevefogel...@askics.net] Sent: Fri

TeraScript-Talk: <@callmethod>

I am having a little trouble with the <@callmethod> tag when my argument (in red) contains an apostrophe. The callmethod work fine when there are no apostrophes in the argument, but returns a blank or null when there is an apostrophe. <@assign request$ReturnSeoUrl[<@currow>,Cat_Name] "<@cal

TeraScript-Talk: RE: Separate Event Logs Per Witango Instance

BOR | inContact From: Fogelson, Steve [mailto:stevefogel...@askics.net] Sent: Monday, March 04, 2013 16:35 To: TeraScript-Talk@terascript.com<mailto:TeraScript-Talk@terascript.com> Subject: TeraScript-Talk: RE: Separate Event Logs Per Witango Instance Hi Richard, I have a server run

TeraScript-Talk: RE: Separate Event Logs Per Witango Instance

Hi Richard, I have a server running 4 instances of TersScript on it. You designate the location of the log file in your server.ini. Set up a separate folder for each instance and designate it as follows in server.ini Possibly similar to this. LOGDIR=C:\\Program Files (x86)\\Tronics Software\\T

TeraScript-Talk: Encoding ??

I am working on the email client and am having trouble with some of the email addresses and subjects of some of the email I read from the email server. I am getting the following =?utf-8?Q?SearchSpring?= =?utf-8?Q?SearchSpring=20Newsletter?=

TeraScript-Talk: Scanning PDF documents

I need to come up with a way of searching pdf documents. I need to find the phrase "Purchase Order Number" and then possible using <@substring > to read the number following this phrase. Then to find the tracking number from a subsequent phrase. So I need some method to read the pdf doc within

TeraScript-Talk: MySQL - SQL (OT)

I have a question for the SQL experts on the list if possible. Is it possible in MySQL to have two (multiple) LEFT OUTER JOINS in a command? Or is there another way to do this? IE: SELECT t1.id, t1.var1, t2.var1, t3.var1, t4.var1 FROM Table4 t4 LEFT OUTER JOIN Table2 t2 ON t2.id

RE: TeraScript-Talk: Witango_cmd

Hi Wayne, What version of Imagemagick are you running? I upgraded to the newest version when I started using TeraScript. Are you having trouble with "Identify"? I use Robert's tcf as well. There is a @TOKENIZE tag for the results of the "Identify" call. The new version now returns one more field

TeraScript-Talk: WebCall Action

I am trying to use a WebCall Action for a SOAP message The SOAP message was supplied to me by IT for the server I am trying to access and is as follows: http://schemas.xmlsoap.org/soap/envelope/"; xmlns:ws="http://ws.api.xx.com";> access.key

TeraScript-Talk: FW: Witango-Talk: Re-Directs

(otherwise you’ll be calling recursively) @URL does not by default pass the user reference cookie. If you need to sustain user scoped variables, you must explicitly add the argument to the URL. Robert From: Fogelson, Steve [mailto:stevefogel...@askics.net] Sent: Monday, August 15, 2011 3:19 PM

RE: TeraScript-Talk: subscribe terascript-talk

Still developing with TeraScript Steve Fogelson -Original Message- From: Wayne Irvine [mailto:wa...@byteserve.com.au] Sent: Tuesday, January 24, 2012 4:01 PM To: TeraScript-Talk@terascript.com Subject: Re: TeraScript-Talk: subscribe terascript-talk These subscription notifications are th