Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Data Migrator - XML Schema
Go
New
Search
Notify
Tools
Reply
  
Data Migrator - XML Schema
 Login/Join
 
Member
posted
To begin with - I am a complete newbie with the Migrator tool - please bear with me.

From what I have read - if you have an xml schema (.xsd) - it can be used to create the corresponding xml file.

The first step was to try to create the system. Upon doing so I get the following error - (FOC42233) UNEXPECTED TOKEN: 'version'.

A Google search - on the above - doesn't produce many hits.

I was wondering if anyone has ran into the above issue or can point me to some documentation.

Thanks.


WebFocus 7.6.10
 
Posts: 10 | Registered: July 27, 2011Reply With QuoteReport This Post
Guru
posted Hide Post
Indeed you can create a synonym from an xsd (or with the xml itself, albeit with less information).

The first line of an xsd should look something like this:

<?xml version="1.0" encoding="utf-8"?>

The xsd must be valid; you may want to validate it in a tool like xmlspy if you have one, or download a free tool like xmlpad.

There is an example of creating a synonym in the DataMigrator User's Guide for 7.6.

The procedure has changed somewhat for 7.7. Configure an adapter for XML, then select Create Synonym. For Base Location enter the location of the xml document. Then click Next. Then for Base Location enter the location of the xsd. Then click Create Synonym.

This message has been edited. Last edited by: Clif,
 
Posts: 380 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Member
posted Hide Post
Clif;

I appreicate the response.

I went ahead and validated the schema with XMLPAD. I've retreieved the documentation you mention and for the most part - it appears to be what I am doing.

I believe you were commenting on what the first line of the xsd should look like - but it seems it got cut off.

I am not sure if would make a different - but I can upload the schema if needed.

Thanks.


WebFocus 7.6.10
 
Posts: 10 | Registered: July 27, 2011Reply With QuoteReport This Post
Guru
posted Hide Post
It looks like eve treated the xml snippet as xml. I edited the post to put code markers around it. However since you've validated the xsd it should be good to go.

Please upload the schema and I will try to create the synonym myself.
 
Posts: 380 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Member
posted Hide Post
Here is the schema - I am trying to create the synonym for - ClaimIntakeEDI.xsd

This message has been edited. Last edited by: InformSRB,


WebFocus 7.6.10
 
Posts: 10 | Registered: July 27, 2011Reply With QuoteReport This Post
Guru
posted Hide Post
The problem is the line
  <version>1.8.0</version>  

I removed it and (using 7.7.03M) was able to create the synonym, which takes a while because it's humongous.

Which unfortunately means it's too large to use as is. What do you want to do with it?

This message has been edited. Last edited by: Clif,
 
Posts: 380 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Member
posted Hide Post
Thanks Clif - that did the trick. I'll reach out if I have any further questions.


WebFocus 7.6.10
 
Posts: 10 | Registered: July 27, 2011Reply With QuoteReport This Post
Member
posted Hide Post
quote:
Originally posted by Clif:
The problem is the line
  <version>1.8.0</version>  

I removed it and (using 7.7.03M) was able to create the synonym, which takes a while because it's humongous.

Which unfortunately means it's too large to use as is. What do you want to do with it?


Sorry - I got pulled away to another project. As you said, the schema is huge. I have a list of the elements I have to map - my plan at the moment is to create to a Focus database will all the data field values - use that as the source and map each data field to the element in the XML synonym - is that a viable option - I've looked at the IWAY documentation - not much there on a process like this.

Any alternatives? Open to suggestions.

Update - I tried creaing a flow - by mapping a few of the field - as you mention the synonym is too large to use as is -

(FOC336) THE SUM OF ALL FIELD LENGTHS EXCEEDS MAXIMUM.

Is there an alternative way to reduce it?

This message has been edited. Last edited by: InformSRB,


WebFocus 7.6.10
 
Posts: 10 | Registered: July 27, 2011Reply With QuoteReport This Post
Guru
posted Hide Post
The error is because the master parser runs out of memory.

What you need to do is create a synonym for the subset of the schema that has the data you want.

On the "Create Synonym for XML Step 3 of 3" panel for the option "Position" enter the XPATH to the element subtree you want to use.
 
Posts: 380 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Member
posted Hide Post
Is there an option to enable the position variable?

During the synonym creation, I only have 2 steps.

Step 1 - asks for the location of the synonym
Step 2 - select the xsd,

Validate,
Make Unique,
Select application,
Prefix,
Suffix

Overwrite existing synonyms

Create synonym

Position option is not there.


WebFocus 7.6.10
 
Posts: 10 | Registered: July 27, 2011Reply With QuoteReport This Post
Guru
posted Hide Post
Looks like you are using an older release. Please use the current production Release 7.7.03M. Thank you.
 
Posts: 380 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Data Migrator - XML Schema

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.