kmorse

I'm trying to use Caspio Web Services (with SOAP) to import CSV data into a Caspio Data Table. Below are two SOAP messages. The only difference between the two SOAP messages sent is one character. The segment that reads "...teaspoon salt, and 1/2 .12345678901" in the GOOD SOAP request. Reads "...teaspoon salt, and 1/2 .123456789012" in the bad SOAP request. That number '2' pushes the SQL insert segment to 257 characters (Character 256, counting the zero) The field into which I am trying to import this troublesome data is a "Text 64000" data type. Will the 64000 data type not be recognized? ********************************************************************************************************************* GOOD SOAP message sent : xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" > - - -edited -edited -edited -recipes -false -Headline, Intro, Directions, Ingredient1, Ingredient2, Ingredient3, Ingredient4, Ingredient5, Ingredient6, Ingredient7, Ingredient8, Ingredient9, Ingredient10, Ingredient11, Ingredient12, Ingredient13, Ingredient14, Ingredient15, Ingredient16, Ingredient17, Ingredient18, Ingredient19, Ingredient20, Ingredient21, Ingredient22, Ingredient23, Ingredient24, Ingredient25, Ingredient26, Ingredient27, Ingredient28, Ingredient29, Ingredient30, Ingredients, Category, Date, PhotoURL, Photo -'Stracciatella', 'mrtest5', 'From "Salt to Taste," by Marco Canora with Catherine Young. Serves 6. ', '', '3 large eggs', '2 tablespoons freshly grated Parmigiano- Reggiano plus additional for serving', '1 tablespoon finely chopped fresh flat-leaf parsley Pinch of freshly ground nutmeg Kosher salt and freshly ground black pepper', '4 cups rich homemade broth (vegetable- or meat-based)', '3 large eggs', '2 tablespoons freshly grated Parmigiano- Reggiano plus additional for serving', '1 tablespoon finely chopped fresh flat-leaf parsley', 'Pinch of freshly ground nutmeg Kosher salt and freshly ground black pepper', '4 cups rich homemade broth (vegetable- or meat-based)', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Beat the eggs and then mix in the cheese and the parsley. Season the egg mixture with nutmeg, 1/2 teaspoon salt, and 1/2 .Beat the eggs and then mix in the cheese and the parsley. Season the egg mixture with nutmeg, 1/2 teaspoon salt, and 1/2 .12345678901 ', '12/02/2009', 'fe02fdcoorec1.JPG', '' server return message GOOD: xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" > - - -1 ========================================================================== The following SOAP message gets a error return message: BAD SOAP message sent: xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" > - - -edited -edited -edited -recipes -false -Headline, Intro, Directions, Ingredient1, Ingredient2, Ingredient3, Ingredient4, Ingredient5, Ingredient6, Ingredient7, Ingredient8, Ingredient9, Ingredient10, Ingredient11, Ingredient12, Ingredient13, Ingredient14, Ingredient15, Ingredient16, Ingredient17, Ingredient18, Ingredient19, Ingredient20, Ingredient21, Ingredient22, Ingredient23, Ingredient24, Ingredient25, Ingredient26, Ingredient27, Ingredient28, Ingredient29, Ingredient30, Ingredients, Category, Date, PhotoURL, Photo -'Stracciatella', 'mrtest5', 'From "Salt to Taste," by Marco Canora with Catherine Young. Serves 6. ', '', '3 large eggs', '2 tablespoons freshly grated Parmigiano- Reggiano plus additional for serving', '1 tablespoon finely chopped fresh flat-leaf parsley Pinch of freshly ground nutmeg Kosher salt and freshly ground black pepper', '4 cups rich homemade broth (vegetable- or meat-based)', '3 large eggs', '2 tablespoons freshly grated Parmigiano- Reggiano plus additional for serving', '1 tablespoon finely chopped fresh flat-leaf parsley', 'Pinch of freshly ground nutmeg Kosher salt and freshly ground black pepper', '4 cups rich homemade broth (vegetable- or meat-based)', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Beat the eggs and then mix in the cheese and the parsley. Season the egg mixture with nutmeg, 1/2 teaspoon salt, and 1/2 .Beat the eggs and then mix in the cheese and the parsley. Season the egg mixture with nutmeg, 1/2 teaspoon salt, and 1/2 .123456789012 ', '12/02/2009', 'fe02fdcoorec1.JPG', '' server return message BAD: xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" > - - -soap:Client -{SQL Server error: String or binary data would be truncated. The statement has been terminated.} -http://bridge.caspio.net/ws/api.asmx - -1015 -SQL Server error: String or binary data would be truncated. The statement has been terminated. ============================================== Any help or advice will be appreciated.

Anyone out there ever used Perl with Caspio Web Services? Here is the task I'm trying to accomplish: 1. Extract data from my newspapers print-publishing system (accomplished) 2. Format data in XML for export to a Caspio data table (accomplished) 3. Insert data automatically via script into existing Caspio data table using Web Services (not yet accomplished). I and the the developer I am working with have never used SOAP, which I believe is necessary to use CWS. If there is anyone out there who can help us get over this last obstacle, please reply here and I'll try to get in touch with you. Keith Morse denverpost.com

Thanks. I look forward to giving it a whirl.

I have in mind one search form using virtual fields and passing the search parameters to three separate results pages that would all be on the same web page. I haven't tried it yet and thought that before I went ahead and put in all the work, I'd see if anyone knows this is possible or impossible. I thought about using one search form and one results page and joining the three datatables, but the problem is that if the data isn't found in one of the data tables, it may return no results for that search criteria even if there is data in the other tables.

I run into this issue with just about every datapage I have that uses a map. The only way around it I've found is to force the user to enter *something* that will produce a result. And about the only way to do that is to give them nothing but dropdown lists or list boxes that always produces a search criterion. However, I would like to see either a better workaround or an enhancement to Caspio that would produce a default map based on my criteria along with the \"No results found\" message. If anyone has any ideas, I am eager to hear them.

I have a lookup table with 1,557 rows in it. I was hoping to be able to use a dropdown list in a \"submit new information\" web form in order to get consistent data entry.

It looks like 1,000 is the limit to items in a listbox or drop down list, right?

Steve, Thanks. I was afraid of that. I've made multiple-select listboxes in standalone HTML-javascript pages but wondered if there was something about Caspio Bridge that would make it more difficult. I'll leave it as a wish-list item.

Thanks. That did the trick. Now, for my other wish: is there a way within Caspio to make that dropdown list capable of selecting more than one item for a search? Thanks in advance. Keith

http://www.denverpost.com/2007candidates where it says \"enter selection\"

Steve, Followed your instructions. There is a link on the page now, just below my dropdown list, which says \"Enter Selection.\" Clicking on it doesn't result in any action. I doubled checked and I am certain that I followed your steps, but perhaps I missed something. Keith

Dave, And just to be certain: this will work even though the two pages are linked to different data tables which happen to have a column or columns with identical names. Keith

Dave, Thank you. I will give it a try and see what happens. Keith

I have in mind a Caspio Datapage that would query data from one Caspio data table and, when a link is clicked on, open a new browser window containing a different Caspio datapage is connected to a different Caspio data table. These two tables would have several column (parameter) names in common and these would be the search criteria for each datapage. Another way of putting it is this: If I query Table A using parameter [field@School] and then click on the link to open up the other datapage, can I pass that parameter (field@School] to the new datapage and bring up the results I desire? Also, do Caspio data tables have size limits, either in the number of rows, columns or kilobytes/megabytes? The tables I have in mind for this application are rather large. Thanks in advance. Keith Morse

Steve, I ended up making a lookup table from which to draw my prefab list. All I need for this particular one is to know how to enter a value not included on the prefab list. here's the url: http://www.denverpost.com/candidateinfo This is a page that we will point our candidates to so that they can enter their information. It will not be publicizecd to our general readership. Mulitple selections from the same list would be handy in other datapages, however. Thanks in advance, Keith