Real time file sharing
Quote from Dimitris72 on September 20, 2019, 2:14 pmHello there,
I need to create a publication for office use that when installed in 2 pc's (office in City A and another office in City B) will be able to access in real time (via internet) the same database files for the filewrite and fileread actions. I have tried it with a Cloud folder but its taking too long to update the files... sometimes takes up to 5 minutes for a minor update causing problems. so i guess the cloud folder is not an option.
I currently use the Neobook 5.7.0 Professional version but I'm whiling to buy the VisualNEO Win if I have to in order to create the publication. Can someone (experienced) please guide me as where to look for information on what to do to achieve that?
Thanking you in advance,
Dimitri.
Hello there,
I need to create a publication for office use that when installed in 2 pc's (office in City A and another office in City B) will be able to access in real time (via internet) the same database files for the filewrite and fileread actions. I have tried it with a Cloud folder but its taking too long to update the files... sometimes takes up to 5 minutes for a minor update causing problems. so i guess the cloud folder is not an option.
I currently use the Neobook 5.7.0 Professional version but I'm whiling to buy the VisualNEO Win if I have to in order to create the publication. Can someone (experienced) please guide me as where to look for information on what to do to achieve that?
Thanking you in advance,
Dimitri.
Quote from Gaev on September 20, 2019, 3:50 pm@dimitris72
access in real time (via internet) the same database files for the filewrite and fileread actions.
I don't understand ... FileRead/FileWrite commands work on simple text files (not Databases) ... can you provide examples of code you are using ?
I have tried it with a Cloud folder but its taking too long to update the files ... sometimes takes up to 5 minutes for a minor update causing problems. so i guess the cloud folder is not an option.
What cloud ? ... AWS, Azure, Microsoft One Drive, Google Drive, other ?
Define update ... one line of data or entire file ? ... if entire file, how large are the files ?Does it take just as long if attempted with something other than your Application ?
access in real time (via internet) the same database files for the filewrite and fileread actions.
I don't understand ... FileRead/FileWrite commands work on simple text files (not Databases) ... can you provide examples of code you are using ?
I have tried it with a Cloud folder but its taking too long to update the files ... sometimes takes up to 5 minutes for a minor update causing problems. so i guess the cloud folder is not an option.
What cloud ? ... AWS, Azure, Microsoft One Drive, Google Drive, other ?
Define update ... one line of data or entire file ? ... if entire file, how large are the files ?
Does it take just as long if attempted with something other than your Application ?
Quote from Dimitris72 on September 20, 2019, 11:30 pmQuote from Gaev on September 20, 2019, 3:50 pm@dimitris72
I don't understand ... FileRead/FileWrite commands work on simple text files (not Databases) ... can you provide examples of code you are using ?
sorry my bad, simple txt files would be fine so to be able to read/write variable values.
What cloud ? ... AWS, Azure, Microsoft One Drive, Google Drive, other ?
Define update ... one line of data or entire file ? ... if entire file, how large are the files ?Does it take just as long if attempted with something other than your Application ?
Three entire txt files of about 10kb in size each. So far I have tried the One Drive, Google Drive & the Megasync... they all take too long to transfer the newly created/modified files after a while.
I'd really like to avoid the cloud option if I can. Is there another way i could do it like using the FM/TP plugin by any chance? Thank you.
Quote from Gaev on September 20, 2019, 3:50 pmI don't understand ... FileRead/FileWrite commands work on simple text files (not Databases) ... can you provide examples of code you are using ?
sorry my bad, simple txt files would be fine so to be able to read/write variable values.
What cloud ? ... AWS, Azure, Microsoft One Drive, Google Drive, other ?
Define update ... one line of data or entire file ? ... if entire file, how large are the files ?Does it take just as long if attempted with something other than your Application ?
Three entire txt files of about 10kb in size each. So far I have tried the One Drive, Google Drive & the Megasync... they all take too long to transfer the newly created/modified files after a while.
I'd really like to avoid the cloud option if I can. Is there another way i could do it like using the FM/TP plugin by any chance? Thank you.
Quote from Gaev on September 21, 2019, 12:32 am@dimitris72
Is there another way i could do it
If there is one, I am not aware of it.
Currently, is there any method (outside your application) that your users in the two cities are able to deploy in able to send/receive files ?
Are these stand alone machines ... or are they in some sort of LAN/WAN configuration ?
like using the FM/TP plugin by any chance?
The FM/FTP plugin provides the client side in an FTP (File Transfer Protocol) transaction; to the best of my knowledge, you can not make it act like a server side program.
Note that ...
a) Text files can not be updated in 'real time' ... no matter what protocol you use ... that is why database technology was invented ... and even then, the datatabase software has to make sure that records in the process of being updated by one user are not over written by another.
b) Your best bet is to explore why it takes so long to update the files in the Cloud ... are these files huge ? ... and how many lines are you updating at one time ?
Is there another way i could do it
If there is one, I am not aware of it.
Currently, is there any method (outside your application) that your users in the two cities are able to deploy in able to send/receive files ?
Are these stand alone machines ... or are they in some sort of LAN/WAN configuration ?
like using the FM/TP plugin by any chance?
The FM/FTP plugin provides the client side in an FTP (File Transfer Protocol) transaction; to the best of my knowledge, you can not make it act like a server side program.
Note that ...
a) Text files can not be updated in 'real time' ... no matter what protocol you use ... that is why database technology was invented ... and even then, the datatabase software has to make sure that records in the process of being updated by one user are not over written by another.
b) Your best bet is to explore why it takes so long to update the files in the Cloud ... are these files huge ? ... and how many lines are you updating at one time ?
Quote from Dimitris72 on September 21, 2019, 1:37 amCurrently, is there any method (outside your application) that your users in the two cities are able to deploy in able to send/receive files ?
Are these stand alone machines ... or are they in some sort of LAN/WAN configuration ?
yes, they are stand alone machines. we have a (small) medical center located on an island and the head office is in the city of Athens. i'm trying to make the publication that will allow our 2 secretaries (one on each location) to manage doctors and patience files, book/cancel appointments, info on given prescriptions etc from both locations. currently we exchange pdf xlsx etc files through One Drive cloud folders with no problem. but is necessary to somehow make this publication access the altered variable files in near real time speed so we dont get to have double-booked times for apointments.
a) Text files can not be updated in 'real time' ... no matter what protocol you use ... that is why database technology was invented ... and even then, the datatabase software has to make sure that records in the process of being updated by one user are not over written by another.
the txt files are being created by the publication for storing variable values... would it make any difference if where saved as .dat instead?
b) Your best bet is to explore why it takes so long to update the files in the Cloud ... are these files huge ? ... and how many lines are you updating at one time ?
10-15 files of not more than 10kb each... updating 1-3 lines at a time, but sometimes it takes too long to "see" the changes on the other end. besides that, if the publication try to read a file at the very same time is being updated by the One Drive, it returns a [could not read the file] error message. that is the main reason i want to avoid the cloud option if possible. Thanking you in advance.
Currently, is there any method (outside your application) that your users in the two cities are able to deploy in able to send/receive files ?
Are these stand alone machines ... or are they in some sort of LAN/WAN configuration ?
yes, they are stand alone machines. we have a (small) medical center located on an island and the head office is in the city of Athens. i'm trying to make the publication that will allow our 2 secretaries (one on each location) to manage doctors and patience files, book/cancel appointments, info on given prescriptions etc from both locations. currently we exchange pdf xlsx etc files through One Drive cloud folders with no problem. but is necessary to somehow make this publication access the altered variable files in near real time speed so we dont get to have double-booked times for apointments.
a) Text files can not be updated in 'real time' ... no matter what protocol you use ... that is why database technology was invented ... and even then, the datatabase software has to make sure that records in the process of being updated by one user are not over written by another.
the txt files are being created by the publication for storing variable values... would it make any difference if where saved as .dat instead?
b) Your best bet is to explore why it takes so long to update the files in the Cloud ... are these files huge ? ... and how many lines are you updating at one time ?
10-15 files of not more than 10kb each... updating 1-3 lines at a time, but sometimes it takes too long to "see" the changes on the other end. besides that, if the publication try to read a file at the very same time is being updated by the One Drive, it returns a [could not read the file] error message. that is the main reason i want to avoid the cloud option if possible. Thanking you in advance.
