Page 1 of 2 12 LastLast
Results 1 to 13 of 14
  1. #1
    Join Date
    Mar 2009
    Location
    Moncton, NB
    Posts
    157
    Post Likes

    Extract data from Microsoft Excel spreadsheet into Niagara Ax?

    I have a potential customer who has an online software scheduling system that does the scheduling of office, rooms, gym, etc and is managed online. They want to conect this online scheduling system to the Jace so they don't need to double the entry of scheding rooms to control the HVAC. I contacted the vendor and they also host the database. With the permission of the customer the Jace can have access to the spreadsheet through an IP. Has anyone parsed a spreadsheet before? I can't find any documentation on the possible process. I'd like to extract time and occupancy status of a room.

  2. #2
    Join Date
    Jul 2009
    Location
    Charlotte, NC
    Posts
    423
    Post Likes
    Quote Originally Posted by XRRIDER View Post
    I have a potential customer who has an online software scheduling system that does the scheduling of office, rooms, gym, etc and is managed online. They want to conect this online scheduling system to the Jace so they don't need to double the entry of scheding rooms to control the HVAC. I contacted the vendor and they also host the database. With the permission of the customer the Jace can have access to the spreadsheet through an IP. Has anyone parsed a spreadsheet before? I can't find any documentation on the possible process. I'd like to extract time and occupancy status of a room.
    That's gonna be a tough one. It's possible though. I know that you can parse a modbus registry and automatically create points and it's the same process with an excel spreadsheet and all.

  3. #3
    Join Date
    Mar 2009
    Location
    Moncton, NB
    Posts
    157
    Post Likes
    Thread Starter
    Quote Originally Posted by ControlY0urMind View Post
    That's gonna be a tough one. It's possible though. I know that you can parse a modbus registry and automatically create points and it's the same process with an excel spreadsheet and all.
    Would you have a direction on that? I need to start somewhere. Competitor said it can't be done so if I can it means a large install for me.

  4. Likes NateClark liked this post
  5. #4
    Join Date
    Feb 2013
    Location
    Phoenix, AZ
    Posts
    184
    Post Likes
    I found several examples of Excel to OPC server software by doing a Google search. Perhaps you could get the vendor or custy to run one, and import the data into the Jace via OPC?

  6. #5
    Join Date
    Jul 2006
    Location
    Southern California
    Posts
    277
    Post Likes
    Are you familiar with soap and xml pipe feeds?

    Seems like you could aim a custom excel based soap / xml data pipe feed at the clients web based schedule xml objects,
    (if they can be, or are already xml tagged) then your custom soap excel file could retransmit the client's
    schedules over into the jace using bacnet xml writes.
    Not sure Jace supports this technique fully, but could be worth a try.
    Just do one simple schedule object first, and if that works, you are good to go on all of them.

    Kinda of sorta like bringing in weather data from noaa.

    Anyway, good luck as this request from clients has been growing in popularity.
    "We are what we repeatedly do. Excellence, then, is not an act, but a habit" Aristotle

    Remember to "Pay it Forward"; help out the newer generation of techs, remember someone during our career helped us! ("Pay it Forward" was by someone smarter than me!!)

  7. Likes NateClark liked this post
  8. #6
    Join Date
    Jul 2008
    Location
    Melbourne
    Posts
    1,611
    Post Likes
    Quote Originally Posted by XRRIDER View Post
    ... Has anyone parsed a spreadsheet before? I can't find any documentation on the possible process. I'd like to extract time and occupancy status of a room.
    1 The Excel file probably queries a backend database of some sort ... so quite likely that one the AX database drivers will work.
    2 If not, have the Excel file save a copy itself as CSV file every time it changes ... then open the csv file and Parse for info.
    3 write an agent on the supervisor side to get the excel file and have it save as csv at your end ...then open and parse for info
    4 yes AX will also open an XML file and comes complete with everything needed to get XML data.
    1 + 1 = 3 ( *** for very large values of 1)

    ...everybody wants a box of chocolates and long stemmed rose

    Be brave. You cannot get eaten by an imaginary tiger.

  9. Likes NateClark liked this post
  10. #7
    Join Date
    Apr 2013
    Posts
    1
    Post Likes

  11. #8
    Join Date
    Mar 2009
    Location
    Moncton, NB
    Posts
    157
    Post Likes
    Thread Starter
    Thanks, I download the Test Module. I update as I progress.

  12. #9
    Join Date
    Jan 2016
    Location
    Louisville KY
    Posts
    26
    Post Likes
    This link is a 404 now B-(

  13. #10
    Join Date
    Feb 2005
    Posts
    1,488
    Post Likes
    who is the scheduling software vendor?

  14. #11
    Join Date
    Jan 2016
    Location
    Louisville KY
    Posts
    26
    Post Likes
    EMS software (www.emssoftware.com)

  15. #12
    Join Date
    Dec 2004
    Location
    San Francisco Bay Area
    Posts
    537
    Post Likes
    Quote Originally Posted by NateClark View Post
    This link is a 404 now B-(
    The new link can be found on this page:
    http://www.kodaro.com/products/driver-software.html

  16. #13
    Join Date
    Mar 2009
    Location
    Moncton, NB
    Posts
    157
    Post Likes
    Thread Starter
    Thanks for the update.

Page 1 of 2 12 LastLast

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Related Forums

Plumbing Talks | Contractor MagazineThe place where Electrical professionals meet.