Lantica User Forum - [Fixed Cannot import XML forms

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › [Fixed Cannot import XML forms

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Page Index Toggle

Pages: [1] 2

Send Topic

Print

Hot Topic (More than 10 Replies)

[Fixed Cannot import XML forms (Read 2505 times)

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	[Fixed Cannot import XML forms Sep 16^th, 2007 at 5:18am	Print Post
	Fixed in 2.0.3 Version 2.0.2 Unable to import XML form files. Expected to import and relink. Exported two forms from Application A as XML files. Files are in destination, look good in text editor. Both XML files are relatively small, 35Kb and 287Kb each. Opened Application B. Opened existing database, named different from A. Selected to import XML form. Get error: "Error: Cannot translate XML form file Data\SS\Masters\frmTest1.xml. Check the Server Administration Log for details." Try importing form 2 instead, same results. SvrAdmin log shows one line for each error: server_error S_CLIENT 510071 Error: Cannot translate XML form file Data\SS\Masters\frmTest1.xml. Tried creating a new database in App B with same name as original in App A. No Elements. Still could not import. Added element to new form in database, tried to import again, same result. See nothing special about instructions in User Guide. What am I missing here?
	« Last Edit: Oct 4^th, 2007 at 9:18pm by Hammer »
	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Carl Underwood Senior Member Members Offline Posts: 1351 Location: New Hampshire Joined: Mar 11^th, 2003	Re: Cannot import XML forms Reply #1 - Sep 16^th, 2007 at 1:40pm	Print Post
	I have confirmed that I too get an error when trying to import an XML form. The problem must be in the creation of the XML file, because I happened to have an XML file that I created back on July 12th, 2007, and that imports without error.

	Carl Underwood CDU Computer Consulting LLC Epsom, New Hampshire
	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Cannot import XML forms Reply #2 - Sep 16^th, 2007 at 6:36pm	Print Post
	Hmmm, happy and sad to hear that Carl. Happy because of confirmation, sad because of confirmation. I also had success in the past with imorting XML, but thought perhaps certain elements might have an impact. It now sounds like this might be a version problem. I don't think I can load old versions because the beta versions needed connection to Lantica Server and that is no longer available. Can you send me a copy of the XML that you can import? I would like to see if that works for me. Thanks.

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Cannot import XML forms Reply #3 - Sep 16^th, 2007 at 7:49pm	Print Post
	While researching why XML files would not process properly, I found instructions that said Quote: To check if the XML is well-formed, you can open the document in Microsoft Internet Explorer 5 or later. If the document opens without an error, it is well-formed. Opening my files in MSIE and Firefox, I got the following messages: Quote: XML Parsing Error: not well-formed Location: file:///C:/Sesame2/Data/SS/Masters/frmTest1.xml Line Number 697, Column 14: While(vLoop <= vListCount) { -----------------^ And I got this error with my other XML file: Quote: XML Parsing Error: not well-formed Location: file:///C:/Sesame2/Data/SS/Masters/frmTest2.xml Line Number 8654, Column 26: ........................<name>Client Address & Telephone List</name> ----------------------------------------------^ I also used this site: http://www.validome.org/xml/validate/ to validate the XML file and got the same error indications. So it appears that there may be a problem with the XML code that is created? Is there a Sesame XML parser that we can use to validate our files?

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Carl Underwood Senior Member Members Offline Posts: 1351 Location: New Hampshire Joined: Mar 11^th, 2003	Re: Cannot import XML forms Reply #4 - Sep 17^th, 2007 at 5:22am	Print Post
	I've discovered that in my case, after deleting a Mass Update spec, the form exports/imports properly. The Mass Update contained code with the following line in it, which is similar to one of your errors, and it's also where Internet Explorer indicated that there was an error in the XML file. Code while vLoop <= vCnt

	Carl Underwood CDU Computer Consulting LLC Epsom, New Hampshire
	WWW IP Logged

Carl Underwood Senior Member Members Offline Posts: 1351 Location: New Hampshire Joined: Mar 11^th, 2003	Re: Cannot import XML forms Reply #5 - Sep 17^th, 2007 at 5:49am	Print Post
	Bob, It does appear to be an issue with the way Sesame is exporting certain characters from Mass Update specs. I noticed that "<=" is being changed to "<=" in the XML file when it comes from regular programming events, but not being changed at all when it comes from a Mass Update spec event. Try removing all of your Mass Update specs (on a backup, of course), and see if you can export/import an XML form.

	Carl Underwood CDU Computer Consulting LLC Epsom, New Hampshire
	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Cannot import XML forms Reply #6 - Sep 17^th, 2007 at 5:59am	Print Post
	I edited the XML file. Changed from "<=" to "=<". Result = No Good (NG) Changed from "<=" tp "<". Result = NG Changed from "<=" tp "=". Result = NG Then did a search to find I have many "<=" instances. My tests above only changed the first one I saw in the error messages. So, I went back to the first instance and found this: Changed from "<=" to ">=". Result = OK Changed from "<=" tp "=". Result = NG, but it was NG at the next instance of "<=", not at the same line. So it appears that the "<" character may be the issue. For this diagnosis only, I changed all "<=" to ">=" and had no more failures for that reason. But, have a new failure now: Quote: </head> --^ No more testing for me, will have to leave this to Lantica, I guess. I think the Sesame XML parser needs to be updated to accept "<=" combinations. Hmmm, gotta remember to change back my ">=" to "<=".

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Cannot import XML forms Reply #7 - Sep 17^th, 2007 at 11:13am	Print Post
	Thanks guys. We'll take a look at the Mass Update Specs and let you know what we see.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Cannot import XML forms Reply #8 - Sep 17^th, 2007 at 2:13pm	Print Post
	I think it is in the general programming sections, dealing with "<=". My XMLs do not have a Mass Update spec, but both of mine, plus Carl's include "<="

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Cannot import XML forms Reply #9 - Sep 17^th, 2007 at 2:53pm	Print Post
	Bob_Hansen wrote on Sep 17^th, 2007 at 2:13pm: I think it is in the general programming sections, dealing with "<=". My XMLs do not have a Mass Update spec, but both of mine, plus Carl's include "<=" < and > are both used by XML, so you are likely correct.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Cannot import XML forms Reply #10 - Sep 20^th, 2007 at 4:11am	Print Post
	Any idea on a date for a sensible solution? Lost of work waiting to be copied vs. a lot of duplicate layout/tabs work, copy/paste programming, etc. Work estimate was based on XML transfers, not all the manual efforts. Difficult to hold off much longer.

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Carl Underwood Senior Member Members Offline Posts: 1351 Location: New Hampshire Joined: Mar 11^th, 2003	Re: Cannot import XML forms Reply #11 - Sep 20^th, 2007 at 5:09am	Print Post
	Bob, maybe you could either temporarily changed the "<" and ">" to something else like "LessThan" and "GreaterThan" until the XML export/import is completed; or just export the entire programming for the form, delete all programming, export form to XML, import XML form to new location, and import programming back into the form after it's in its new location.

	Carl Underwood CDU Computer Consulting LLC Epsom, New Hampshire
	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Cannot import XML forms Reply #12 - Sep 20^th, 2007 at 5:30pm	Print Post
	Been there, done that. Could not replace "<" since it is a critical part of XML, so ... I replaced "<=" with "~" I was not getting error with ">" but decided to change that also, just in case. So... I replaced ">=" with "^". Yes, before I made those changes I made sure there was no "`/^" symbols. Tried to import, get same error message from Sesame. If I open the file in browser, I get a message about </head> being an issue. I just don't have the time to diagnose this any more, and I can't spend the time to make the changes manually as you suggested. I had already done a similar process for one form, but I have too many to do. So, problem with XML import is not limited to "<", but it does need a solution soon. (More personal details sent to Carl in PM).

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Cannot import XML forms Reply #13 - Sep 20^th, 2007 at 5:42pm	Print Post
	Quote: or just export the entire programming for the form, delete all programming, export form to XML, import XML form to new location, and import programming back into the form after it's in its new location. Since the problem characters seem to be contained in your code, have you tried Carl's other suggestion?

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Cannot import XML forms Reply #14 - Sep 20^th, 2007 at 5:52pm	Print Post
	Need to use available time to get my other work done first. It sounded like problem was confirmed by Lantica, and I was waiting for the solution. I did not think I needed to do more diagnosis, but Lantica would be doing that. I heard nothing yet, so that is why I bumped the issue. I can continue to try work arounds in spare time, but none available right now. Can probably get to it this weekend if no resolution by then.

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Page Index Toggle

Pages: [1] 2

Send Topic

Print

‹ Previous Topic | Next Topic ›

« Board Index ‹ Board Top

Top

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid XHTML

Valid CSS

Powered by Perl

Source Forge