Author Topic: Open Office  (Read 264 times)

  • All members
  • Posts: 95
  • Karma: +0/-1
Open Office
« on: Fri, 04 May, 2018, 17:26 »
For the last year I haven't paid up to use MS Office and have instead been using Open Office.

Is there any way to import your results into Open Office via either the BF main site or thro MF pro so that I can edit and examine my results.

I've tried everything but have failed 😭

  • Trigger developers
  • Posts: 2787
  • Karma: +229/-0
*
Re: Open Office
« Reply #1 on: Fri, 04 May, 2018, 20:08 »
Hi
By results are you meaning your statement? In MFP when you are viewing your statement, towards the top right are a row of buttons. One of them saves the statement as a CSV file. I believe you can import CSV files into Open Office. 
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 95
  • Karma: +0/-1
Re: Open Office
« Reply #2 on: Sat, 05 May, 2018, 07:37 »
Hi By results are you meaning your statement? In MFP when you are viewing your statement, towards the top right are a row of buttons. One of them saves the statement as a CSV file. I believe you can import CSV files into Open Office.

Hi Mark.
Yes I do mean the statement
I can import the data but Open Office doesn't recognise the characters as numbers. Every number is imported with a prefix which I can't remove

  • All members
  • Posts: 95
  • Karma: +0/-1
Re: Open Office
« Reply #3 on: Sat, 05 May, 2018, 07:41 »
Like this 

  • Trigger developers
  • Posts: 2787
  • Karma: +229/-0
*
Re: Open Office
« Reply #4 on: Sat, 05 May, 2018, 08:20 »
Hi
I don't have Open Office so I can't test, but give this a try:

open csv file with notepad, word wrap off
edit > replace
find what: "
replace with: leave blank
save csv
try import to Open Office

and if you've not done so already, can you try formatting a column in Open office to "number"
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • Administrator
  • Posts: 6098
  • Karma: +208/-2
  • Gender: Female
*
Re: Open Office
« Reply #5 on: Sat, 05 May, 2018, 20:37 »
There is no way to connect MF Pro to an Open Office document directly, but you can use the advice the other users kindly gave above.
Always try your triggers in Test Mode before switching to real money!

You can get a faster response from us if you contact us via FaceBook Messenger.

Присоединяйтесь к нашей официальной группе ВКонтакте!

  • All members
  • Posts: 367
  • Karma: +15/-0
Re: Open Office
« Reply #6 on: Sat, 05 May, 2018, 21:01 »
These settings work for opening mfp csv files in libre office calc....I believe libre office and open office are pretty much identical.

Hope that helps


  • All members
  • Posts: 95
  • Karma: +0/-1
Re: Open Office
« Reply #7 on: Mon, 07 May, 2018, 09:41 »
Hi I don't have Open Office so I can't test, but give this a try: open csv file with notepad, word wrap off edit > replace find what: " replace with: leave blank save csv try import to Open Office and if you've not done so already, can you try formatting a column in Open office to "number"

Thanks for the replys guys.
This does seem to work. Opening first in notepad and removing the "
Its a shame we can only download one day at a time :(

I just need to figure it out for when downloading from the Betfair site now.
Its a totally different format from Beftaif