Patrickc

MrPLC Member
  • Content count

    37
  • Joined

  • Last visited

Everything posted by Patrickc

  1. I would like to open an existing excel sheet from FT View SE. I know it could be possible using Macro commands, but I have no idea how to code in Visual Basic. Could anyone help me out and maybe provide the code necessary for me to just paste in the macro so I can just run it? Thank you Patrick
  2. Any one know how i can get FT view Client to work on a dual screen? I have FT view Client V6.00.00 Thank you!
  3. I really need help to try get Factory talk View 6.0 to run on windows 7 x64 (not a virtual machine like vm ware or something please) I need to do this because the PC i'm using has 8GB RAM, and as you know x32 (x86) bit system can only use about 4GB and sometimes FT view Client crashes due to lack of memory. Any help will be much appreciated! Patrick
  4. how can i make the alarm banner popup automatically when there is a new alarm? thank you
  5. Doesn't apply anymore - that was for my original question of "could not use '|'; file already in use". Now about the code: Sub_Button1_Released() is a button on FT view, the code I pasted below it was VBA code that was assigned to the button so as to open the excel sheet. I guess if i make 2 different buttons - one to make it visible and one to actually open it, the user would have both options just in case the excel sheet is closed (even though I'm sure i can protect it - but ill get to that later :) ) Another remark about the sheet attached: Delete the backround and unhide a couple of rows so you can have a look at the working :) It was a bitch to figure out and implement on excel since I'm not an expert in excel, or any other software! I just know how to use a lot of different software :) Also, if anyone would like to use the excel sheet attached, just ask for permission and I would be more than happy to let you :) Thank you, Patrick Edit: Hmm, I tried doing this: Private Sub Button3_Released() Excel.Application.Visible = True End Sub But apparently that didn't work - I'm quite sure I'm doing something wrong =/ Thanks
  6. I get the error: "could not use '|'; file already in use" when I refresh the table in excel. The only solution i found was to turn off data logging, refresh and then turn it on again, but the problem with this is that it creates another data point when you start the datalogging again, and that is a problem since I need a report (on excel ) that shows the daily consumption. So I only want one data point per day, because otherwise, it will mess up the calculations on excel. Any idea how i could access the data log file without having to stop data logging - or, if that isn't possible, how I could prevent data logging from creating a new data point when I re-start the data logging? Thank you very much Patrick
  7. dang it...any other option?
  8. I attached the file, you might need to change some settings around because i tried to make it look like a webpage when in fullscreen. Thank you Also if you're good at VBA; I am using this code: Private Sub Button1_Released() Excel.Application.Workbooks.Open "C:\Users\BMS\Desktop\Schedule with button.xlsm" Excel.Application.Visible = True End Sub To open an excel file. Now, the Excel file is supposed to be always open and constantly running, since its updating from it. Is there a way that I could change the code so that it will maximize it (if minimized) or open (if closed). I am running with a dual monitor setup and I need it to popup on the right hand side monitor (monitor 2) - if this makes any difference. I have no idea on how VBA works, never studied it, so I'm depending on help :) Thank you Patrick Schedule with button.rar
  9. I am building a client software on factory talk and i have a display which contains a panel with a lot of images (buttons and lights) with their respective tags. When a section of the panel is pressed, a popup is opened showing a more detailed version of the panel. First of all, the panel takes a while to load, secondly, if more than two popups are opened the computer goes into a frenzy. The screens start flickering and changing what is displayed, the start bar shoots to the top of the screen, resolution is lost etc etc...The only solution is to hard-restart. I have noticed an error message in the flickering: "Insufficient memory" or something of the sort. The computer I am working and running the software on is: Intel Core i5 760 2.8 Ghz 8GB ram DDR3 Nvidia GeForce GT 430 with 1024Mb Memory With Windows 7 professional x64 freshly installed Could it be the Graphics card memory? Any ideas would be highly appreciated! Thank you
  10. I think i figured out what the problem was - I think i reached the limit of the amount of tags that could be visible at one time. Thing is that on the main panel i had a lot of lights, all with their respective tags. I took a chance and started deleting some of the less useful ones, after reducing the number by half or more i tried loading up popups again. This time it went up to 7 popups! I am glad with that, and so is the User, so it will have to stay that way :) Do you think it really is because i reached the tag limit? Thank you
  11. I am working in Factory Talk View SE 6.10 I can't seem to find this "Advanced" tab, in my "Alarm and Event setup" the 3rd tab is called "Level" and there isn't advanced to be seen anywhere! Thank you Patrick
  12. Wow ok, thanks lol, Lots of hatred for FT view I see! Thank you, at least i know im not alone!
  13. Hehe ok sorry you're right, didn't realise i didnt give any details. So, I'm using Factory talk View 6.10 to do datalogging on some tags (which are already in FT view). This datalog is saved in OBDC format. I am using excel 07 to access this datalog file and draw a table with it, showing me Tag name, Date & Time, and Tag Value. Problem is, to refresh excel to get the new data, I need to stop the datalogging on Factory talk (otherwise I would get the error i mentioned above). Everytime I do this, I get a new datapoint created (i.e. a value for the tags for that current time). Now by time, things start getting messed up, the datalog points available are jumbled up and "seem" random - since there are multiple datapoints at times where a 'snapshot' of the tags should not have been taken. I would like to find a way to bypass this error to avoid having to stop the datalogging on factory talk to refresh excel (basically avoiding creating extra datapoints) Any idea? Thank you
  14. I upgraded the Graphics card to a more decent ATI radeon 6950 club edition, but the problem still persists. I consulted my IT technician and he had no idea what could be happening. Sometimes an error pops up saying: "Insufficient memory to complete operation" (or something similar). The technician suggested against downgrading to XP since I would lose the capability to get 8GB RAM and even the i5 processor. Thank you Patrick
  15. Hi Julio, Thank you for your reply. The software I am currently running, the 6.10 is stated to be compatible with windows 7 professional x64 in the description, so I wonder howcome they told you it was not officially compatible. Also, thing is I used to run this software on Windows 7 Professional x86 (32 bit) and I had the same problems with it. I am going to try the new graphics card since if I just end up downgrading the OS, I will essentially lose half the RAM. I will try to remember to post what happens here :) Thank you Patrick
  16. I keep on getting errors on FT view SE 6.10 whilst doing data logging. I started data logging for a number of tags and when left overnight i came back in the morning to find that data logging stopped for a couple of hours, started again, had invalid or no readings for certain tags and other things. I made sure the power options for the PC were not power saver - the PC doesnt sleep automatically and the hard-drives are never turned off, the only thing it does is turn off the display automatically after about 10 minutes. Any ideas what might be going on? I have plenty of space on my hard drive for it to save. I haven't pasted an error FT view gave me because at the moment there aren't any in the Diagnostics list, I will edit the post when i get an error again. Thank you Patrick
  17. The problem has been solved - apparently even leaving the option to turn off the display after a certain amount of time cause the data logging to malfunction!
  18. I'm doing trending on FT view SE 6.10 Does anyone know if I could download some new trend templates to change the default one as it doesn't really have many options... I would like the user to have the option to tick which objects he would like to see on the graph etc etc Thank you
  19. Thank you ill try it out, even though i don't know how to use vba hehe Thankyou
  20. Yes i found that out, but i wanted something that the user could toggle without having to mess around with the settings of graph - preferabbly radio buttons (or similar) on the graph itself. I thought there would be some different trends on ab.com but i couldn't find anything =/ Thanks
  21. The problem is that only this specific display has caused the computer to crash...I also think its weird that the graphics card can't cope with the software =/ Thank you
  22. I am trying to do some data logging on FT view SE. I managed to start a new data log and saved in OBDC in the .mdf format. I started the data log without any errors, and stopped it, also without any errors. Now i need to be able to access this data outside of factorytalk, ie: Not in FT trends! Any help will be appreciated
  23. Thank you very much for that reply, you were very helpful Patrick
  24. I am using Crystal reports 2010 and i would like to report a number of "tags" I managed to connect it to Factory talk using data logging, but I wanted to know if there is some way of connecting it directly to RS linx so the tags update in real-time Thank you Patrick
  25. Thank you, Would you suggest using the "File Set" data logging instead of the OBDC? Are there any major differences or advantages to using either one? Thank you Patrick