Need help with XML Import

[cfunn]

I am importing sales data into my FM6 Invoices DB

I have a .XSL stylesheet and I have one small problem

I need to import "C12345" into each record

Something like C12345

I need this line imported into each record but it is not present in my xml that I am importing.

Here is my current .XSL

<?xml version='1.0' encoding='UTF-8' ?>

0

Where or how can I add the info I need?

Thanks,

Craig

[Fenton]

Say what? If it's not in the xml you're importing, then how could you "import" it? There is an "Internet Cust#". There is a "Username." If those can be matched with a field in your database, then you could run a scripted post-import Replace (or Loop) operation to populate the CustomerID, from a relational match.

It is fairly common to have to do this when you receive data from an external source. What you'd really want to know however is whether any records did NOT match; likely if you have to use only the name.

[comment]

I am not quite following this either. To take the request literally, all it would take is:

...

C12345

...

and a corresponding field declared in the section.

[cfunn]

I will try an simplify my question.

I am importing into FM6 via XML. I have a XSL sheet working. I want to set all these orders imported to a specific name, C12345.

This info is not in my xml data. I want all the records I import to have this data. Can I put some instructions in my XSL so every order will have C12345. This is not coming from the source.

If I can how do I write it in my XSL?

Thanks for any imput.

Craig

[Fenton]

OK, to create a "fixed" data in the xsl do as comment says. Duplicate one of your existing Field rows, in the METADATA section, to create the field. Put it in the order you want to import (which you'll then match in FileMaker's Import dialog later).

Then, in the same order down below (between fields), put exactly what comment put in his code. That is, do not put an "xsl:value-of" element, just put your data, just type it in. You are just putting your own data instead of having the xsl select it.

Or just put it at the end of your Metadata and

's; easier.

[cfunn]

That was exactly what I needed.

Thank You

Craig