This extension is disponible in 2 versions one for Dreamweaver CS3/CS4/CS5 and one for others Dreamweaver minus versions. When you buy this extension you will be able to download the 2 versions at the same time.
To see how work in minor versions of Dreamweaver like Dw 2004/Mx/8/8.01 click here
Import on:
On Page Load
on the OnLoad event of the page
Post variable
when the request.form variable exists
Get variable
when the request.querystring variable exists
Request variable
when the generic request variable exists
Session variable
when the session variable exists
Application variable
when the Application variable exists
Cookie variable
when the request.Cookie variable exists
Redirect page:
The page you want redirect after the import process is end
Display errors:
If checked after the import process is end and if there are errors, display a table with the list of errors, the SqlQuery and the line number.
Import from:
You have 2 method to define the source Xml file, with a Path or with a Url.
Use the path when the file is inside your site or when the user upload a file and use the Url when you get the file Xml from another site.
File path:
The file path of the Xml file you want import from. The path must be relative to a file inside the site root or ina folder. Normally the user must upload the file Xml so you must create an upload page with your standard upload method where the user can upload a Xml file in a folder inside your site. The upload file must have the same name you setup in this field and all the time the user want import from Xml file must upload a file with this name or you can setup the upload page to change the name of the uploaded file and give all the times the same name.
File url:
The file url in case you setup the Import Method to Url.
Must be a full Url like: http://www.yoursite.com/yourfolder/yourfile.xml
Is not required the extension is xml but the page must return a valid xml content.
Row elements:
Display the nodes elements will be available in the Xml.
This is an example:
DataBase panel
Connection:
In the Connection pop-up menu, select a connection to the database. Click the Define button if you need to define a connection
Data base table:
In the Data Base Table pop-up menu, select the database table into which the record should be inserted
Unique column key:
(for the database table)
In the Unique Key Column pop-up menus, select a key column (usually the record ID column) to identify the record in the database table. Select the Numeric option if the value is a number. A key column usually accepts only numeric values, but sometimes it accepts text values.
On duplicate entry:
The available value are:
Don't verify
In this case the extension don't verify if there are duplicated record, but insert all the records
Skip
The record is not inserted and the extension skip the record.
Update
The extension update the record with the value from the import Xml file.
Throw error
Generate an error and the record is not inserted and not updated. This error will be displayed after the end of the import process and only if the Display errors is checked.
Unique column key:
(for the Xml file)
In this combo you must select the Xml field that is the unique column key value of the record and is used to determine if the record exist in the table.
To determine if a record exist the extension search in the table if there is a record where the Unique Column Key for the Database and the Unique Column Key for the Xml file are equal.
This field cannot be imported into the database because normally this value is assegned from the database each time you add a new record and also cannot be updated.
Db format date:
This is the format of the date field your database required. When you import a date field The extension get the string value from the Xml file and transform in a date variable, after with the Db format date create a new date string with the exact format your database need.
Db format boolean:
This is the format of the boolean field your database required. When you import a boolean field The extension get the string value from the Xml file and transform in a boolean variable, after with the Db format boolean create a new boolean string with the exact format your database need.
Date delim char:
When you import a date value into the database the SqlQuery must have a field delimiter and this delimiter depend on the DataBase you use.
For. example with MsAccess the delimiter must be # and the date syntax must be like #01/01/2006#, but with SqlServer the delimiter must be a ' and the date syntax must be like '01/01/2006'
Date null:
The value you must use into the SqlQuery to insert a date with a null value, when the date value is void.
Normally is used the Null but in some case you must use the ''
This value depend on the database setup
String null:
The value you must use into the SqlQuery to insert a string with a null value, when the string value is void.
Normally is used the Null but in some case you must use the ''
This value depend on the database setup
Number null:
The value you must use into the SqlQuery to insert a number with a null value, when the number value is void.
Normally is used the 0 (zero) but in some case you must use the Null
This value depend on what you prefer have in your database if a null field or a field with 0 (zero) value.
Fields panel
Xml repeated element:
The nodes name of the xml file that must be inserted in the database. The extension will insert a record each node with this name. In this field you will see only the elements node at the first level in your xml file.
Xml unique column key:
The node/attribute that contain the unique identifier for the xml element. Only if you setup a behavior in the On duplicate entry combo
Fields:
The list of DataBase fields you want import fropm the xml and the reference you setup for each fields. Use the Add/Edit button to poputale this list. When you click on the Add or on the Edit butto a PopUp open with all the parameters you can setup for each DataBase fields.
Db field:
The DataBase field name
Get value from:
This combo define where get the value for each database fields.
Normally you get the value from the Xml file but may be for some fields you need get the value from other source like session variable, application variable, cookie variable, parameter send with querystring or with a form or also entered value.
Xml node:
Define from which node/attribute of the Xml you need get the db field value. In this list you will find only the childnodes of the xml node you select in the Xml repeated element combo
Reference name:
The name of the asp-object where get the value like session variable, application variable, cookie variable, parameter send with querystring or with a form or also entered value. This is enabled on ly when you select a Get value from that is not xml file
Format:
The format of the data you have in your xml.
The available format are:
Text
Numeric (Integer)
Numeric (.)
Numeric (,)
Data DD/MM/YYYY
Data DD/MM/YY
Data MM/DD/YYYY
Data MM/DD/YY
Data YYYYMMDD
Data YYMMDD
Data DD/MM/YYYY hh:mm:ss
Data DD/MM/YY hh:mm:ss
Data MM/DD/YYYY hh:mm:ss
Data MM/DD/YY hh:mm:ss
Data Extended format
Boolean (true,false)
Boolean (1,0)
Boolean (-1,0)
Boolean (Y,N)
Boolean (Yes,No)
The data format has a new value "Data Extended format", with this option the extension can parse xlm date format like: "Sun, 12 Nov 2009 10:05:03 GMT+" There are 2 format need more info: Numeric (.) and Numeric (,), the first is a number with the . (comma) decimal separator like 12345.67 and the second is a number with a , (virgola) decimal separator like 12345,67
In the SqlQuery all the number with decimal value must be inserted with the point decimal separator and without the GroupDigit separator, and you must choose the format for the number valur you receive from the Xml file so the extension will format the value in the exact format the SqlQuery need.
