Cloud Notes

[david caliano]

I'm trying to get data from another program into Bookmap through Cloud Notes.
I loaded the URL and it just says "loading" .  
Could someone tell me what I am doing wrong?

[Andry API support]

Hi David,
we need details to figure it out. Your log would be very helpful.
Also:

• data from another program - what kind of program?
  
• does it produce data compatible with Bookmap?
  

[david caliano]

I figured it out.  Had to put the excel file in the Bookmap format then upload the 
file to Google Sheets then publish from there.

[david caliano]

The file I have from IRT is updating every ten seconds with new price levels.
For example, the daily high and low.  When the market makes a new low the 
price changes automatically in that excel file.  When I go to upload this file
to my google drive and open it in google sheets in order to publish it so 
it can be read in Bookmap, the price levels show up when I create with it
a cloud column.  But the levels don't update along with the excel file from IRT.
How do I get the levels to automatically update in Bookmap?

[Svyatoslav]

First of all, all those uploads to google drive, one drive, etc., are not really an official way to use the CloudNotes functionality. It's just a trick to get a direct link to a file without spending much effort. What bookmap app itself does - it just expects a link to a file in certain format, as described in https://bookmap.com/knowledgebase/docs/ ... escription
It does not really care where that link comes from. Bookmap can not read the excel file (xls) - it only reads CSV (btw, important to keep in mind that it actually has to be a CSV, not SCSV or any other variation - say Excel does not always respect the CSV format specification).
So, regardless of how you get the data, what you need to do is either:
- (better) have some URL where the relevant version of a file is available. That can be your own server (including the one running locally on your computer) or any other source, as long as it follows the specification
- (worse, and that will probably fail from time to time) write changes to a CSV file on your computer and specify this file as a URL using file:/// format. I'm saying it's worse cause in certain cases bookmap might not fully close such file and this will prevent your scripts from writing into it. You can however use any primitive http server to make it available via HTTP locally, that will solve the issue.

[Andry API support]

david caliano
If you need a server example in Java please check this thread

[david caliano]

I have no idea how to go about using java.  
Will it work going the OneDrive route like it says
in that link ?

[Svyatoslav]

You will have to manually convert the data from whichever format you have into bookmap format in order to do that. If you go that route - you don't even really need to upload it to the server. If the file is on your computer - you can specify the file location using file:/// protocol (e.g. file:///c:\my-folder\my-notes.csv )

[david caliano]

That would be the URL I would put into Bookmap under under the Settings for the Cloud Notes column?

C:\users\dcali\documents\ED_Output.csv

That's the location on my computer.  

[Svyatoslav]

Yes. It would be file:///C:\users\dcali\documents\ED_Output.csv