Infrastructure Map Server Forum
Welcome to Autodesk’s Infrastructure Map Server Forums. Share your knowledge, ask questions, and explore popular Infrastructure Map Server topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Updating Excel file after making a data source in MGE 2011

6 REPLIES 6
Reply
Message 1 of 7
DEVR1361
758 Views, 6 Replies

Updating Excel file after making a data source in MGE 2011

I'm a bit embarassed to admit that Excel is the data source, but it is not a matter of choice.  We keep the status of work at lat/long points in an Excel 2007/2010 sheet.  Once the sheet is connected as a data source, it is locked for editing.  Even after a bit of convoluted logic that got the data updated, the changes did not flow up to the layers and maps.

 

Is there a way to update existing data in an Excel file and have the changes reflected in MGE 2011 without recreating everything from scratch or restarting the server?

 

In the Studio help file (search for "upload", select "About ODBC Data Source" I found this line:

"If your data is in Microsoft Access or Excel format, you can upload the source files to the site server from any location in your file system. You can also download the files from the server to your file system for update and replacement."

 

Can anyone explain how this is done?

 

Thanks,

Dan

6 REPLIES 6
Message 2 of 7
pg002a
in reply to: DEVR1361

You must use FDO Excel ODBC dataconnection instead uploading  it to MGE server,  then all changes made in excel are reflected  in MGE and you dont need to do more.

Message 3 of 7
DEVR1361
in reply to: pg002a

When I make that connection and then try to open the Excel file I get the message "This file is in use."

 

What I did:

>Selected OSGeo FDO Provider for ODBC

>Connect to an external file

>Select the file

>This connection string is created:

Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};Dbq=%MG_DATA_PATH_ALIAS[MGEData]%WarwickRI_Data/Warwick_RI_ODAS.xlsx;

>Define te Geometry and the data points preview nicely.

 

However, I cannot edit the excel file - Excel responds: "Enter a new name or close the file that's open in another program."

 

If I make a DSN connection or connect to a database (using the above connection string), the file is still locked...

 

Should I be connecting to the Excel file differently? Am I using the wrong FDO?

 

 

Message 4 of 7
pg002a
in reply to: DEVR1361

I found same problem after I configured connection over ODBC, but I did restart to PC and then it was able to edit excel table and if you have Studio opened then it was no possible to edit excel but after closing it was  possible to edit excel again. But I think smarter way to convert Excel data  to mdb, with it you dont have data editing problem.

 

Kajar

 

 

 

Message 5 of 7
DEVR1361
in reply to: pg002a

I will give that a try - closing studio while viewing the web page and editing the Excel file.  I agree that mdb (or any other database) would be better, but that is not an option.  I appreciate you "reading between the lines" understanding what I was doing (wrong) and making an excellent observation and suggestion.  Many thanks.

 

Dan

Message 6 of 7
DEVR1361
in reply to: DEVR1361

If the MGE server is running, the Excel file cannot be accessed. 

My MGE server is a virtual machine (2008 r2) on my 64 bit Win7 Pro machine.  The Excel file is on the server, accessed by the Win7 host machine via a mapped drive letter. I have installed AccessDatabaseEngine_X64.exe on the server, although the Excel 2010 file is 32 bit. 

Any other suggestions?

 

Dan

Message 7 of 7
gluckett
in reply to: DEVR1361

A mapped drive might be an issue.

In the Services, log into MapGuide Service as a user who is local admin on the server and has network access to the xls file.

Connect to the xls file with ODBC with UNC path and not mapped drive.

make sure you restart the mapguide service after logging in with that user.

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report