Help needed to display icon flag in column

KAMIZAKI,

It looks like you are mostly there. In the data set, what does your code look like for calling the image file? Are the images stored in the media library?

Update: If you are trying to use images from the media library, that is not supported yet (CMS 1.7.3). Please see here , and here. So the images must be external and called with a correct html image tag or via css. Since you are using data sets I would think it easiest to use css. Something like “background-image: url([bgImagePath|1]);” should work if the column name is “bgImagePath”. And in the dataset the column bgImagePath was set to something like “http://www.server.com/path_here/image.jpg”.

cslaughter,
i’v try but nothing ,if only somebody who have experience with this things (programing ) can help
thanks.

KAMIZAKI,

I have experience with programming. It would be very helpful if you could post the css code you have tried specific to the image and also post what you have entered into the dataset for the image file location. Without those two things it is very hard to help because we can’t see what you are doing or trying. So far in the css code you have posted you are not even calling an image to display.

I currently am successfully using datasets to show images with both a dataset and dataset with a ticker.

KAMIZAKI,

Also can you please turn on Auditing on the screen in which you are trying to see images on. Then see if you see anything like this error in the log:

“SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to…”

cslaughter,
thanks for replay actualy im trying many things without succes ,im just new in all this even i dont know where i have to put the ligne , i give you befor the css code and the picture ( if you creat new layout and column and you past the code i give i thing it will be easy for you because me without any knowledge i manage to give the table this aspect so i’m sure you will do better than me

KAMAIZAKI,

The flag image files you want to use must be in a publicly accessible location, or location at least accessible to the screen you want to use them on. Can you please post the url of one of the flags you want to use? Then I can give you the code to use to display the flag.

Also have you read: Creating Ticker Templates using “Override Template”

the falgs are in my computer in folder what i understand till now is that xampp is install for this reason i thing right?

xampp is a package of software containing the Apache server, MySQL for running a sql database, PHP to allow use of PHP files, and PERL which allows you to run PERL programming scripts.

When you say the flags are on your computer in a folder, can you please share with me the path to the flags? Is it something like “c:\www\images\flag1.jpg”?

cslaughter,
yes sure this is the path D:\XIBO LAYOUT\drapeaux

KAMIZAKI,

Thank you for the screen shots.

I see that you have flag files at “d:\XIBO LAYOUT\drapeaux”. I would suggest changing the folder “XIBO LAYOUT” to “xibo_layout” as spaces and uppercase may cause some issues.

Is the screen that is displaying the layout on the same network at the Xibo CMS?

cslaughter,
no XIBO CMS is in partition C and this folder jusi give it this name i can also change the path and the location

KAMIZAKI,

Is the Xibo Client being run on the same machine as the Xibo CMS?

cslaughter,
yes the XIBO client run on the same machine as XIBO CMS

KAMIZAKI,

Please change the folder “XIBO LAYOUT” to “xibo_layout” and make sure the web server (Apache) has permission to use the folder.

In the dataset do you have a column for the image path?? Please post a screen shot of the dataset data.

cslaughter,
i just change the name of the folder

KAMIZAKI,

It does not look like you have a column in the dataset for the flag image file. Please go to “dataset” then click the down arrow next to the dataset you are working on. Then click on “View Columns”, and “Add Column”. Please fill in the form as follows and click save:

Next go back to the dataset click on the down arrow and then click on View Data. Next we want fill out bgImagePath for each flag image. So the flag for USD would read “file:///d:/xibo_layout/drapeaux/USD.jpg”, if those images files are jpg’s.

cslaughter,
the column i chose for image is the first one( Pays)


is it ok like this or i have to change it like yours ?

KAMIZAKI,

How you have it will work fine.

Now you just need to fill out “Pays” data to go to the image file path such as, “file:///d:/xibo_layout/drapeaux/USD.jpg” for USD.

Edit: You did check to make sure the webserver has access to “d:/xibo_layout/drapeaux”, correct??

cslaughter,
sorry i dont know how to check it