Facility Control

 View Only
  • 1.  dashboard combo box

    Posted 12-10-2018 11:37
    hello experts, how can i setup dashboard so i can control expression user input control .https://www.youtube.com/watch?v=pkACfzHp4rE 12:30. i follow the same thing and make some name with headshot in excel and linw in expression and its working. whenever i change name in sequencer take item ,headshot also changing. now i want to control that name through xpression.

    any expert here to help me please . iam new :)


  • 2.  RE: dashboard combo box

    Posted 12-11-2018 20:39

    I'm a little lost as to what you want to do in DashBoard, your initial question does not include DashBoard.

    Are you wanting to create an excel spreadsheet that XPression uses as user input control, but that also feeds DashBoard to define the constraints of a combobox in a DashBoard panel?

    If that's what you want, I've attached a panel that reads a CSV (also attached) and creates a combobox constraint based on the first row of the CSV file.

    You can turn on streaming on the DashBoard panel so that this information is available as a datasource to XP as well. There are also other ways to stream that information from DashBoard to XP.



    NOTE that I had to change the file extension of the csv file to .txt so I could post it on this board. Change it back to .csv before running the panel.


    #DashBoard


  • 3.  RE: dashboard combo box

    Posted 01-06-2019 11:40
    I'm a little lost as to what you want to do in DashBoard, your initial question does not include DashBoard.

    Are you wanting to create an excel spreadsheet that XPression uses as user input control, but that also feeds DashBoard to define the constraints of a combobox in a DashBoard panel?

    If that's what you want, I've attached a panel that reads a CSV (also attached) and creates a combobox constraint based on the first row of the CSV file.

    You can turn on streaming on the DashBoard panel so that this information is available as a datasource to XP as well. There are also other ways to stream that information from DashBoard to XP.

    NOTE that I had to change the file extension of the csv file to .txt so I could post it on this board. Change it back to .csv before running the panel.


    sorry for late reply . i want to control xpression text field and image field from dashboard user input control. my all data is in excel.


    #DashBoard


  • 4.  RE: dashboard combo box

    Posted 01-06-2019 12:34

    sorry for late reply . i want to control xpression text field and image field from dashboard user input control. my all data is in excel.



    Ahhh... Well, you're gonna have some issues with this one...

    1: There is no way to directly import excel into dashboard. I'm still waiting on a DataLinq connection IN to DashBoard.

    2: What you can do, is to export the excel to an XML or CSV (as above) containing the data you define in the excel document.

    3: This can be imported and arranged into a table in DashBoard, reflecting the data you have in excel again.

    4: This data can then be used as a source for updating several parameters that is linked to Xpression (ie. text and image url).
    #DashBoard


  • 5.  RE: dashboard combo box

    Posted 01-07-2019 05:46



    Ahhh... Well, you're gonna have some issues with this one...

    1: There is no way to directly import excel into dashboard. I'm still waiting on a DataLinq connection IN to DashBoard.

    2: What you can do, is to export the excel to an XML or CSV (as above) containing the data you define in the excel document.

    3: This can be imported and arranged into a table in DashBoard, reflecting the data you have in excel again.

    4: This data can then be used as a source for updating several parameters that is linked to Xpression (ie. text and image url).



    thank you ... will give try and get back again
    #DashBoard


  • 6.  RE: dashboard combo box

    Posted 01-29-2019 07:02



    thank you ... will give try and get back again

    can you send me some idea to importing xml or csv in dashboard... iam still new in this work

    thank you
    #DashBoard


  • 7.  RE: dashboard combo box

    Posted 03-08-2019 09:06



    Ahhh... Well, you're gonna have some issues with this one...

    1: There is no way to directly import excel into dashboard. I'm still waiting on a DataLinq connection IN to DashBoard.

    2: What you can do, is to export the excel to an XML or CSV (as above) containing the data you define in the excel document.

    3: This can be imported and arranged into a table in DashBoard, reflecting the data you have in excel again.

    4: This data can then be used as a source for updating several parameters that is linked to Xpression (ie. text and image url).




    hello and thank you i got it know. now i have reporter name with image in csv sheet i want to change image as i choose name in dashboard dropdown sheet. i mean i want to change name and image in xpression as i change name in dashboard dropdown. i have name and image format in csv file. and this format just read front row only i want to make it read specific row which i want also . thank you
    #DashBoard


  • 8.  RE: dashboard combo box

    Posted 03-08-2019 17:27
    Hi @sunil thapa
    There are 2 ways of doing this depending on whether or not you are using the XPression plug-in for DashBoard.
    If you are using the XPression plug-in, you should be able to set your image path as a published field on the XPression side and, when combo box selection is changed, set the value of the published field for your Take Item in XPression to the new image path.

    Otherwise, you can use DataLinq to feed your current combo box selection to XPression and execute a script on the XPression side to update to the appropriate image. If you are going this route, I would strongly-recommend posting in the XPression forum for further assistance.

    Cheers.

    James
    #DashBoard


  • 9.  RE: dashboard combo box

    Posted 03-10-2019 09:29
    Hi @sunil thapa
    There are 2 ways of doing this depending on whether or not you are using the XPression plug-in for DashBoard.
    If you are using the XPression plug-in, you should be able to set your image path as a published field on the XPression side and, when combo box selection is changed, set the value of the published field for your Take Item in XPression to the new image path.

    Otherwise, you can use DataLinq to feed your current combo box selection to XPression and execute a script on the XPression side to update to the appropriate image. If you are going this route, I would strongly-recommend posting in the XPression forum for further assistance.

    Cheers.

    James

    hi, bit confuse about xpression plug-in. is this MOS plugin or what. i can do it on xpresssion using dalinq and combo box. if i change name image will change automaticall. but i want to do it through dashboard. do i need scripting or is there any other way through dashboard. and how can i read specific column of csv file in dashboard. i tried to read specif column but i cnat get it it alwasy read first column only in dashboard. i mean of csv file .
    #DashBoard