[web2py] Matching iterations of a for loop to field names in a table

2013-04-04 Thread David S
I'm very new to web2py and python in general but have a bit of knowledge 
when it comes to C/C++. 

I've got a db setup which needs to pull data from a row in a .csv file and 
put each column in the .csv into the corresponding column in the db. Rather 
than doing this explicitly (there's ~40 columns), I'd like to have each 
iteration of the for loop correspond to one of the columns. Here's what 
I've got so far:

for lines in import_data:
info = lines.split(',')
field_name = 'field1'
db[csv_data].insert(**{field_name:info})

The above puts all the data in 'field1' and not into separate columns, 
close but not quite. I'm thinking some sort of select from the db might 
work. Any ideas or links which might help?

Thanks,
David

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.




[web2py] Re: Matching iterations of a for loop to field names in a table

2013-04-04 Thread David S
I initially tried using that function however import_from_csv_file() 
doesn't work with this file. I also tried using a few lines of code to 
manipulate the data into something import_from_csv_file would like and 
write that to a .csv then try importing it, but had no luck. Below are the 
contents of the file:

A,2,000282,15,r,1:08:34 
PM,2/2/2014,BCC,,BCC,,BCC,,BCC,,BCC,,BCC,,BCC,,,
A,2,000282,15,r,1:08:46 
PM,2/2/2014,BCC,,BCC,,BCC,,BCC,,BCC,,BCC,,BCC,,,
A,3,000282,15,R,1:20:05 
PM,2/2/2014,BCC,,BCC,,BCC,,BCC,,BCC,,BCC,,BCC,,,
A,00012,000282,15,R,1:20:37 
PM,2/2/2014,BCC,,BCC,,BCC,,BCC,,BCC,,BCC,,BCC,,,
A,00056,000282,15,R,1:29:09 
PM,2/2/2014,BCC,,BCC,,BCC,,BCC,,BCC,,BCC,,BCC,,,

And, as a note I cannot change the formatting of this .csv file as it is 
being generated by a computer running Windows NT using proprietary 
software. Changing the format would require the that company to rewrite 
part of their software.

On Wednesday, April 3, 2013 5:40:01 PM UTC-4, David S wrote:
>
> I'm very new to web2py and python in general but have a bit of knowledge 
> when it comes to C/C++. 
>
> I've got a db setup which needs to pull data from a row in a .csv file and 
> put each column in the .csv into the corresponding column in the db. Rather 
> than doing this explicitly (there's ~40 columns), I'd like to have each 
> iteration of the for loop correspond to one of the columns. Here's what 
> I've got so far:
>
> for lines in import_data:
> info = lines.split(',')
> field_name = 'field1'
> db[csv_data].insert(**{field_name:info})
>
> The above puts all the data in 'field1' and not into separate columns, 
> close but not quite. I'm thinking some sort of select from the db might 
> work. Any ideas or links which might help?
>
> Thanks,
> David
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.




[web2py] Re: Matching iterations of a for loop to field names in a table

2013-04-04 Thread David S
The data isn't formatted quite right. It's looking like I'll have to format 
the file a little.

As a test, I tried adding the column names to the top of the .csv file and 
import_from_csv_file works. I'm going to make a function to add the column 
names to the first line of the file. 

Thanks for your help!

On Thursday, April 4, 2013 2:05:54 PM UTC-4, Massimo Di Pierro wrote:
>
> Ok you can do:
>
> colnames = ['field1','field2',etc.]
> for lines in import_data:
> items = lines.split(',')
> db[csv_data].insert(**dict((colnames[i],v) for i,v in 
> enumerate(items)))
>
> It may still fail of the data is not in the right format but you can find 
> out why.
>
> On Wednesday, 3 April 2013 16:40:01 UTC-5, David S wrote:
>>
>> I'm very new to web2py and python in general but have a bit of knowledge 
>> when it comes to C/C++. 
>>
>> I've got a db setup which needs to pull data from a row in a .csv file 
>> and put each column in the .csv into the corresponding column in the db. 
>> Rather than doing this explicitly (there's ~40 columns), I'd like to have 
>> each iteration of the for loop correspond to one of the columns. Here's 
>> what I've got so far:
>>
>> for lines in import_data:
>> info = lines.split(',')
>> field_name = 'field1'
>> db[csv_data].insert(**{field_name:info})
>>
>> The above puts all the data in 'field1' and not into separate columns, 
>> close but not quite. I'm thinking some sort of select from the db might 
>> work. Any ideas or links which might help?
>>
>> Thanks,
>> David
>>
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.




[web2py] How to merge two tables

2013-04-08 Thread David S
I have three tables, db.table1 db.table2 and db.table3. They are identical 
except for the information stored in each. table3 is blank and after 
running some code should contain the combination of the values in table1 
and table2. 

An example ( is generated by web2py_uuid()):

db.table1:
col1 col2 col3 col4 col5 col6 col7 col8
1AZxx  
2BYxx  
3CXxx  
4DWxx  

db.table2:
col1 col2 col3 col4 col5 col6 col7 col8
1AZ  yy
2BY  yy
3CX  yy
4DW  yy

After merging, db.table3 should look like this:

db.table3:
col1 col2 col3 col4 col5 col6 col7 col8
1AZxxyy
2BYxxyy
3CXxxyy
4DWxxyy

After some research, I found that exporting table1 and table2 to separate 
.csv files and then importing them into table3 should be an easy way to do 
this, however it does not seem to be working for me. Below is the code I've 
tried to use:

rows = db(db.table1).select()
rows.export_to_csv_file(open('table1.csv','wb'))
db.table3.import_from_csv_file(open('table1.csv','rb'),unique='col1')

rows = db(db.table2).select()
rows.export_to_csv_file(open('table2.csv','wb'))
db.table3.import_from_csv_file(open('table2.csv','rb'),unique='col1')

The problem I'm having is only the values from table2 are showing in table3.

I've also tried using a join like this:

db(db.table1.col1 == db.table2.col1).select()

But it creates something which looks like this:

col1 col2 col3 col4 col5 col6 col7 col8   col1 col2 col3 col4 col5 col6 
col7 col8
1AZxx   1AZ  y
y
2BYxx   2BY  y
y
3CXxx   3CX  y
y
4DWxx   4DW  y
y

Is there another way of doing the join which would produce table3 how I'd 
like it formatted?

Anyone have a suggestion or better way to do this?

Thanks,
David

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.




[web2py] Re: How to merge two tables

2013-04-09 Thread David S
You're right about the uuid... I can't remember why it's even there and it 
doesn't make sense for what I'm looking to do.

And your solution worked! Thank you. I don't know why I didn't see that.

David

On Monday, April 8, 2013 4:59:24 PM UTC-4, Cliff Kachinske wrote:
>
> db(db.table1.col1 == db.table2.col1).select(
>   db.table1.col2, 
>   db.table1.col3, 
>   db.table1.col4,
>   db.table1.col5,
>   db.table2.col6,
>   db.table2.col7
>   )
>
> What's the purpose of the uuid?  If they are identical between 
> corresponding rows of the two tables, it defeats the purpose of uuid.
>
> uuid = Universally Unique IDentifier.  Each instance should be unique.
>
> If you want to guarantee that each record in a table a primary key is 
> sufficient for that.
>
> Answers to these questions and many more can be found in the Web2py Manual 
> here: http://web2py.com/books/default/chapter/29/06.
>
> On Monday, April 8, 2013 4:29:35 PM UTC-4, David S wrote:
>>
>> I have three tables, db.table1 db.table2 and db.table3. They are 
>> identical except for the information stored in each. table3 is blank and 
>> after running some code should contain the combination of the values in 
>> table1 and table2. 
>>
>> An example ( is generated by web2py_uuid()):
>>
>> db.table1:
>> col1 col2 col3 col4 col5 col6 col7 col8
>> 1AZxx  
>> 2BYxx  
>> 3CXxx  
>> 4DWxx  
>>
>> db.table2:
>> col1 col2 col3 col4 col5 col6 col7 col8
>> 1AZ  yy
>> 2BY  yy
>> 3CX  yy
>> 4DW  yy
>>
>> After merging, db.table3 should look like this:
>>
>> db.table3:
>> col1 col2 col3 col4 col5 col6 col7 col8
>> 1AZxxyy
>> 2BYxxyy
>> 3CXxxyy
>> 4DWxxyy
>>
>> After some research, I found that exporting table1 and table2 to separate 
>> .csv files and then importing them into table3 should be an easy way to do 
>> this, however it does not seem to be working for me. Below is the code I've 
>> tried to use:
>>
>> rows = db(db.table1).select()
>> rows.export_to_csv_file(open('table1.csv','wb'))
>> db.table3.import_from_csv_file(open('table1.csv','rb'),unique='col1')
>> 
>> rows = db(db.table2).select()
>> rows.export_to_csv_file(open('table2.csv','wb'))
>> db.table3.import_from_csv_file(open('table2.csv','rb'),unique='col1')
>>
>> The problem I'm having is only the values from table2 are showing in 
>> table3.
>>
>> I've also tried using a join like this:
>>
>> db(db.table1.col1 == db.table2.col1).select()
>>
>> But it creates something which looks like this:
>>
>> col1 col2 col3 col4 col5 col6 col7 col8   col1 col2 col3 col4 col5 col6 
>> col7 col8
>> 1AZxx   1AZ  y
>> y
>> 2BYxx   2BY  y
>> y
>> 3CXxx   3CX  y
>> y
>> 4DWxx   4DW  y
>> y
>>
>> Is there another way of doing the join which would produce table3 how I'd 
>> like it formatted?
>>
>> Anyone have a suggestion or better way to do this?
>>
>> Thanks,
>> David
>>
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.




[web2py] Re: How to merge two tables

2013-04-09 Thread David S
This works as well! Thank you.

I ended up adding a .export_to_csv_file() to the end of Cliff's code and 
re-importing the data to table3. The final version of this application 
might see tens of thousands of lines, each with ~40 columns in each table. 
Which way do you think would work better?

David

On Tuesday, April 9, 2013 10:12:08 AM UTC-4, Massimo Di Pierro wrote:
>
> If they fit in ram and have the same column names:
>
> rows = db(db.table1).select()
> rows = rows + db(db.table2).select()
> rows = rows + db(db.table3).select()
> rows = rows.sort(lambda row: row.col8) # optional
>
> On Monday, 8 April 2013 15:29:35 UTC-5, David S wrote:
>>
>> I have three tables, db.table1 db.table2 and db.table3. They are 
>> identical except for the information stored in each. table3 is blank and 
>> after running some code should contain the combination of the values in 
>> table1 and table2. 
>>
>> An example ( is generated by web2py_uuid()):
>>
>> db.table1:
>> col1 col2 col3 col4 col5 col6 col7 col8
>> 1AZxx  
>> 2BYxx  
>> 3CXxx  
>> 4DWxx  
>>
>> db.table2:
>> col1 col2 col3 col4 col5 col6 col7 col8
>> 1AZ  yy
>> 2BY  yy
>> 3CX  yy
>> 4DW  yy
>>
>> After merging, db.table3 should look like this:
>>
>> db.table3:
>> col1 col2 col3 col4 col5 col6 col7 col8
>> 1AZxxyy
>> 2BYxxyy
>> 3CXxxyy
>> 4DWxxyy
>>
>> After some research, I found that exporting table1 and table2 to separate 
>> .csv files and then importing them into table3 should be an easy way to do 
>> this, however it does not seem to be working for me. Below is the code I've 
>> tried to use:
>>
>> rows = db(db.table1).select()
>> rows.export_to_csv_file(open('table1.csv','wb'))
>> db.table3.import_from_csv_file(open('table1.csv','rb'),unique='col1')
>> 
>> rows = db(db.table2).select()
>> rows.export_to_csv_file(open('table2.csv','wb'))
>> db.table3.import_from_csv_file(open('table2.csv','rb'),unique='col1')
>>
>> The problem I'm having is only the values from table2 are showing in 
>> table3.
>>
>> I've also tried using a join like this:
>>
>> db(db.table1.col1 == db.table2.col1).select()
>>
>> But it creates something which looks like this:
>>
>> col1 col2 col3 col4 col5 col6 col7 col8   col1 col2 col3 col4 col5 col6 
>> col7 col8
>> 1AZxx   1AZ  y
>> y
>> 2BYxx   2BY  y
>> y
>> 3CXxx   3CX  y
>> y
>> 4DWxx   4DW  y
>> y
>>
>> Is there another way of doing the join which would produce table3 how I'd 
>> like it formatted?
>>
>> Anyone have a suggestion or better way to do this?
>>
>> Thanks,
>> David
>>
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.




[web2py] web2py and paradox databases

2013-04-11 Thread David S
Today I discovered I'll need to read from a paradox database (
http://en.wikipedia.org/wiki/Paradox_%28database%29) and pull some 
information from it into my application. I cannot change the data source to 
SQL or another format as doing that would require a complete hardware 
overhaul to replace some ancient scanning equipment from the mid 90s. From 
doing a little research, I've found the general suggestion is to try pyodbc 
and hope it works. There's also a few tools which seem to be able to 
convert from paradox to another database format. However these are all 
linux-based and compiling for Windows is untested and undocumented.

Is it possible DAL might be able to work with this setup, and if so what 
would the connections string look like?
Does anyone have experience with using web2py and paradox databases? Any 
suggestions?

David

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.




[web2py] Re: web2py and paradox databases

2013-04-19 Thread David S
Update:
I decided to keep the solution as easy as possible. I found a command line 
paradox db converter from here: 
http://www.dbf2002.com/paradox-converter/index.html and used 
subprocess.call() to it which converts the paradox db into a .csv. Then I 
used import_from_csv_file() to get the data. 

The code is all of two lines:
subprocess.call('pxcnv.exe paradox.db paradox.csv')
db.table.import_from_csv_file(open('paradox.csv','rb'))

David

On Thursday, April 11, 2013 6:25:03 PM UTC-4, Niphlod wrote:
>
> this site comes to the rescue very often
>
> http://www.connectionstrings.com/paradox#intersolv-3-11-odbc
>
> you can use the connection string just after mssql:// (e.g. 
> mssql://{theconnectionstringhere}) if it has the same t-sql support .
>
> As for seeking "official" support within web2py, I fear that no-one could 
> actually test it if not you 
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.




[web2py] Query doesn't select the proper range

2013-04-25 Thread David S
I've got a query which looks like this:

(db.tracking.number >= 0) & (db.tracking.number <= 22000)

where number is an integer. And this should select everything with  
numberbetween 0 and 22000 but it doesn't. For example, if I set the query to 
just

(db.tracking.number >= 0)

as expected it grabs anything with a number greater than or equal to 0 and 
I can see all the data. However, if I set it to

(db.tracking.number >= 250)

it grabs everything greater than 250, less than 1000, and will also pick up 
numbers where if a trailing zero was added, it would be within the range 
(ex: 26->260, 27->270, 28->280, 29->290, 30->300, ... ).

I have some strings formatted like this: X# which I use re.sub to 
remove characters and then use int() to convert the remaining number to a 
int before ever being put into the table. I've checked to make sure 
everything really is an integer before going into the table and it all 
seems to be OK. I'm not sure if this is a python quirk, SQL quirk, or a 
web2py quirk. Any suggestions?

Thanks,
David

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.




[web2py] Re: Query doesn't select the proper range

2013-04-25 Thread David S
I am using SQLite and had changed from string->int so I deleted all of the 
database files in /myapp/databases and then reloaded all of the data. The 
issue persisted :( 

The select generated is correct. I think you're right in saying it's 
something wrong with the backend.

Thanks!
David

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.




[web2py] how to dynamically select fields for SQLFORM.grid

2013-04-29 Thread David S
I've got a very nice looking grid from SQLFORM.grid based on my db.items, 
however it has ~30 columns which can be too much information for the user. 
I'd like to make it so the fields shown are selectable by the user. So far 
I've created db.search which stores the user's search history and added 
some Boolean fields to function as check boxes to hide/show the fields on 
the SQLFORM used to search the db. The basic logic I'd like to use looks 
like this:

selected_fields = ? #empty field type?

if(field_1_box_checked)
selected_fields += field_1
if(field_2_box_checked)
selected_fields += field_2
...
if(field_n_box_checked)
selected_fields += field_n

return dict(items=SQLFORM.grid(query,selected_fields))

Should field objects be combined using '+','&', or 'and'? I also read 
hereit's
 easy to generate a list of fields and use .remove("") to 
remove an item from the list, but that's a list and not a field type. What 
is the best way to do this?

Thanks,
David

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.




[web2py] Re: how to dynamically select fields for SQLFORM.grid

2013-04-29 Thread David S
Never mind. I figured it out. Here's what I've got as a proof of concept:

selected_fields=()
fields = db.items.fields()
for field in fields:
selected_fields += db.items[field],

This gives the same output as if I manually entered 
selected_fields=(field_1,field_2,..field_n)

On Monday, April 29, 2013 9:42:14 AM UTC-4, David S wrote:
>
> I've got a very nice looking grid from SQLFORM.grid based on my db.items, 
> however it has ~30 columns which can be too much information for the user. 
> I'd like to make it so the fields shown are selectable by the user. So far 
> I've created db.search which stores the user's search history and added 
> some Boolean fields to function as check boxes to hide/show the fields on 
> the SQLFORM used to search the db. The basic logic I'd like to use looks 
> like this:
>
> selected_fields = ? #empty field type?
>
> if(field_1_box_checked)
> selected_fields += field_1
> if(field_2_box_checked)
> selected_fields += field_2
> ...
> if(field_n_box_checked)
> selected_fields += field_n
>
> return dict(items=SQLFORM.grid(query,selected_fields))
>
> Should field objects be combined using '+','&', or 'and'? I also read 
> here<https://groups.google.com/forum/?fromgroups=#!searchin/web2py/add$20fields/web2py/Wxor15Jwo2g/bqaRNNCceLIJ>it's
>  easy to generate a list of fields and use .remove("") to 
> remove an item from the list, but that's a list and not a field type. What 
> is the best way to do this?
>
> Thanks,
> David
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.




[web2py] A more concise way to update or insert?

2013-05-20 Thread David S
I've got some csv files which need to be imported to a table. However the 
import_from_csv_file function doesn't seem to work because the files can 
(and almost always do) contain errors and to the best of my knowledge that 
function cannot fix errors on the fly. Anyway, I decided to write my own 
csv reading function which puts each line into a list and then uses 
update_or_insert to get each line into the db.

The problem I'm having is there are two csv files for each entry in the 
table (think product_inspection_1.csv and product_inspection_2.csv, matched 
by serial #), and when using update_or_insert the inspection 2 results can 
overwrite the inspection 1 results and vice versa. 

Is there a way using update_or_insert to conditionally update a column in a 
row? Something like:

if col_1:
only update col_2
if col_2:
only update col_1

I've been able to get something working by using an insert, catching an 
exception when the serial #s conflict, and then selectively updating the 
columns which need updating. But it's kind of like a moped: it gets the job 
done but you wouldn't your friends to see you using it.

Does update_or_insert have this capability? Is there another function which 
might do this in a more concise manner?

David

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.




[web2py] Re: A more concise way to update or insert?

2013-05-20 Thread David S
The issue with doing it that way is the files are not separated (in the 
same folder) and there's not really a good way to tell them apart as the 
file names are just numbers. I've also no control over where the files are 
stored, or the folder structure. I suppose I could do something that checks 
for which columns are empty and determines what to update from that... 
Regardless there still would have to be some sort of check before 
updating/inserting.

On Monday, May 20, 2013 12:19:00 PM UTC-4, Niphlod wrote:
>
> given that you wrote your own parser, why are you having problems with 
> updates ?
> just pass only the columns you need to update to the update_or_insert 
> statement
>
> On Monday, May 20, 2013 5:41:11 PM UTC+2, David S wrote:
>>
>> I've got some csv files which need to be imported to a table. However the 
>> import_from_csv_file function doesn't seem to work because the files can 
>> (and almost always do) contain errors and to the best of my knowledge that 
>> function cannot fix errors on the fly. Anyway, I decided to write my own 
>> csv reading function which puts each line into a list and then uses 
>> update_or_insert to get each line into the db.
>>
>> The problem I'm having is there are two csv files for each entry in the 
>> table (think product_inspection_1.csv and product_inspection_2.csv, matched 
>> by serial #), and when using update_or_insert the inspection 2 results can 
>> overwrite the inspection 1 results and vice versa. 
>>
>> Is there a way using update_or_insert to conditionally update a column in 
>> a row? Something like:
>>
>> if col_1:
>> only update col_2
>> if col_2:
>> only update col_1
>>
>> I've been able to get something working by using an insert, catching an 
>> exception when the serial #s conflict, and then selectively updating the 
>> columns which need updating. But it's kind of like a moped: it gets the job 
>> done but you wouldn't your friends to see you using it.
>>
>> Does update_or_insert have this capability? Is there another function 
>> which might do this in a more concise manner?
>>
>> David
>>
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.




[web2py] web2py as service can't access locally mounted network folder

2013-07-08 Thread David S
I'm running web2py 2.4.5 (yes I know I need to upgrade) on a network 
server. For ease of installation I've chosen to deploy my application as a 
service. It's been working great until now. Some of the data my app needs 
is located on a network folder, so I mapped the folder to the U:\ drive. I 
should be able to access it just like the C:\ drive. But that isn't 
happening. 

When I run web2py from the command line (see picture) I can do import os 
and do os.listdir('U:\\') and it works. I can launch web2py from the 
command line, then open the shell via appadmin and again it works fine. 
When I start the web2py service it simply doesn't find the U:\ drive. It 
works for C:\, D:\, and E:\ (all local, physical drives).

I've checked the service's permissions and tried running it under usernames 
which definitely have access to the network folder. It seems the issue is 
running web2py as a service.

Any ideas how to fix this, or what could be causing the issue?

David

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


<>

[web2py] online web2py book inaccessible

2013-07-23 Thread David S
It seems the online web2py book (http://web2py.com/book) isn't working for 
me and is giving an unknown error.

Is anyone seeing this issue?

David

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.




Re: [web2py] online web2py book inaccessible

2013-07-24 Thread David S
Everything seems to work. Thanks!

On Wednesday, July 24, 2013 4:28:38 AM UTC-4, Massimo Di Pierro wrote:
>
> I was doing an upgrade. Can you confirm everything is ok now?
>
> On Tuesday, 23 July 2013 12:15:42 UTC-5, Jonathan Lundell wrote:
>>
>> On 23 Jul 2013, at 9:59 AM, David S  wrote:
>>
>> It seems the online web2py book (http://web2py.com/book) isn't working 
>> for me and is giving an unknown error.
>>
>> Is anyone seeing this issue?
>>
>>
>> Yeah, it's broken.
>>
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.