Graphics

Hi all !

Do you know if it's possible to do some query with a XML feed ?

I looked all the videos on Xpression website, and each time the field "Table" is already filled, but when I do the same, I have nothing in it...

Can someone help me ?
Thank you !

It is not possible to query the XML source the same way an ADODB source can be queried. You will need to use Datalinq keys and Data Pages to extract data from XML sources.

#XPression

So I convert my data to an excel with adodb connection in datalinq server, I do this : [I]SELECT * FROM Class$ ORDER BY RANK [/I]but no data is shown...
Any idea ?
#XPression

If you open the Datalinq Server, select the ADODB source and hit browse do you see and data?
http://i.imgur.com/NPfOOjs.png
#XPression

Yes, but in the browse form, I don't have the field "Table" on top... Only row and column...
#XPression

What version and build of XPression are you using?
Ex. XPression Studio 6.5 3575.
#XPression

Xpression Studio SCE 5.9 3155
#XPression

My source is [I]Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\GraphOp\Desktop\TeamClass\Misc\Cla ss_Group.xlsx;Extended Properties="Excel 12.0;HDR=Yes;IMEX=1";

(No space in my filename, but the forum add it alone...)[/I]

#XPression

Check to make sure you don't have the Fixed Tables option turned on in the datalinq config.. It might help if you posted screenshots of your config.
#XPression

Option turned off...
But If thing I'm on the way...

See :
For the moment, I receive a CSV, I save as *.xlsx and then add it to datalinq server. -> No Table Field
I tried to create a new blank *.xlsx and then copy/paste only text from CSV to this sheet, save and add on datalinq server. -> Table is here !

#XPression

I read you carefully, after some test on my side, here is the reason...
If your Excel file as only one tab, Table Field disappear instead of having only one choice in it.
#XPression

It's true... But my query still not working :(
#XPression

Any more idea ? I really need this to work...
#XPression

Uploading your xls file and screenshots of what you are trying would allow us to try it for you.
#XPression

File can be upload here : http://s000.tinyupload.com/?file_id=68603490657160485739

I want to get the data of a specific group ("A", "B"...), ordered by rank column, that's all.
In my scene, 4 groups within 1 txtobject for the name, 1 for the rank, 1 for point, etc...
#XPression

This SQL query worked for me..
SELECT * FROM [Class_Group$] where [Group Name]=' B' ORDER BY RANK DESC

When a table name contains spaces or special characters (like a dollar sign) you need to wrap it in Square Brackets.. Also note that your Group Name values in the excel sheet have a space before the letter A,B, etc.

#XPression

Thank you ! I don't know the "square brackets" trick !
#XPression