Graphics

 View Only
  • 1.  Datalinq Server and Excel

    Posted 09-23-2016 21:53
    Hello,

    I have a crawl set up through an Excel sheet that shows scores and tweets. It works fine most of the time but after it loops a few times some of the columns stop linking... If I check the Datalinq Server and click Browse complete columns are empty. Most of the times, I have to completely restart the computer to make this work and other times restarting doesn't even help.
    Any ideas what the problem could be?

    Best,
    Mildred


  • 2.  RE: Datalinq Server and Excel

    Posted 09-24-2016 07:03
    How do you configure your datalinq ? With Excel Datalinq Source, ADODB ?
    #XPression


  • 3.  RE: Datalinq Server and Excel

    Posted 09-26-2016 21:18
    Correct!
    ADODB pulling from an EXCEL template!


    #XPression


  • 4.  RE: Datalinq Server and Excel

    Posted 09-27-2016 02:37
    This is not something I've ever heard reported before. Check the excel sheet and make sure that "Sharing" is enabled on the sheet. I believe the sharing option is found on the Review tab of the excel ribbon bar (off the top of my head).

    #XPression


  • 5.  RE: Datalinq Server and Excel

    Posted 09-27-2016 03:40
    It is shared. I wonder if having multiple people using the excel sheet affects it?
    I had to create a whole new excel file because the file kept disappearing too.


    #XPression


  • 6.  RE: Datalinq Server and Excel

    Posted 09-27-2016 15:25
    If the file is disappearing, something really funny (and probably not related to XPression) is happening. XPression would never remove the file.
    #XPression


  • 7.  RE: Datalinq Server and Excel

    Posted 09-27-2016 15:29
    Searching google about Microsoft office files being lost when shared to multiple users returns a lot of unresolved issues. Including many from Microsoft Answers itself. Don't seem to be a lot of concrete solutions either..
    #XPression