Encore Forums Knowledgebase  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums  Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

Printable Version

All Forums >> [Product Forums] >> [Productivity Software] >> [Calendar Creator] >> CC General Functionality >> Importing from CMS Logos Facility Manager

Page: [1]

Login Message << Older Topic   Newer Topic >>

Importing from CMS Logos Facility Manager - 10/22/2013 8:11:27 AM    office2800   Posts: 3 Joined: 10/22/2013 Status: offline I exported the calendar file successfully from Facilities Manager (the data is listed when opened in notepad or excel) but it is not importing into Calendar Creator 12.1. I have followed all your instructions with no success. What more do I need to do? Post #: 1

RE: Importing from CMS Logos Facility Manager - 10/22/2013 11:01:47 AM    DEJenc3 Posts: 533 Joined: 6/22/2005 Status: offline First, let's be clear on what format was used to export the data. Normally you would export to .csv from an external program. If you have done that, what error, if any, do you get when trying to import? It's possible that the exported data will have to be tweaked so that the column headings exactly match the field names in Calendar Creator, and also that there are no empty fields. If you want to check the formats and headings used by Calendar Creator, you can export a sample calendar from CC. _____________________________ David (in reply to office2800) Post #: 2

RE: Importing from CMS Logos Facility Manager - 10/22/2013 11:01:52 AM    ellengard Posts: 3253 Joined: 10/2/2006 Status: offline quote: ORIGINAL: office2800 ... I have followed all your instructions with no success. Whose instructions are you referring to? (This is a user-to-user forum. No one here works for Encore.) If you can point to those instructions, someone may be able to help. --------- Oops, Hi, David... I see we hit the OK button within seconds of each other. < Message edited by ellengard -- 10/22/2013 11:03:46 AM > (in reply to office2800) Post #: 3

RE: Importing from CMS Logos Facility Manager - 10/22/2013 11:54:14 AM    DEJenc3 Posts: 533 Joined: 6/22/2005 Status: offline Hi, ellengard, The simultaneous posts can happen often, and I've done that enough times. I assume that the instructions followed were based on the CC Help file, but maybe not, so I'll be interested to know as well. I'll add this link to a message where external file importing was discussed: http://forums.encoreusa.com/fb.asp?m=43569 _____________________________ David (in reply to ellengard) Post #: 4

RE: Importing from CMS Logos Facility Manager - 10/22/2013 1:25:33 PM    office2800   Posts: 3 Joined: 10/22/2013 Status: offline where in calendar creator do I find proper headings to compare with the exported file I have. (in reply to DEJenc3) Post #: 5

RE: Importing from CMS Logos Facility Manager - 10/22/2013 1:57:21 PM    DEJenc3 Posts: 533 Joined: 6/22/2005 Status: offline It seems that Calendar Creator doesn't export field names with an exported .csv file, so try these as column headings for your exported data: Start Date Start Time End Time Event Description Priority Category Unassigned Note These appear to be the mapping field assignment options on Import. _____________________________ David (in reply to office2800) Post #: 6

RE: Importing from CMS Logos Facility Manager - 11/26/2013 2:44:05 PM    office2800   Posts: 3 Joined: 10/22/2013 Status: offline I can get the events to import thanks to you but it will not import the times. Any suggestion? (in reply to DEJenc3) Post #: 7

RE: Importing from CMS Logos Facility Manager - 11/26/2013 9:17:34 PM    DEJenc3 Posts: 533 Joined: 6/22/2005 Status: offline Time and date fields can be troublesome for data exchange. I've exported a .csv file from Calendar Creator, and successfully imported it back into Calendar Creator. It has a time field format example, using 5pm, as follows: With the .csv file opened in notepad, it is: 17:00 With the .csv file opened in Excel, the field contents in the formula field show as: 5:00:00 PM Are you mapping the fields during the import process? Do you have options for exporting your data from CMS Logos Facility Manager in a compatible format? It may take some trial and error testing with different time formats. It appears to me that it should be possible to import time from .csv files, though it may require saving the exported file with a spreadsheet program using differently-formatted time fields. You will likely find one that works. Let us know how it goes. _____________________________ David (in reply to office2800) Post #: 8

All Forums >> [Product Forums] >> [Productivity Software] >> [Calendar Creator] >> CC General Functionality >> Importing from CMS Logos Facility Manager

Page: [1]

New Messages No New Messages Hot Topic w/ New Messages Hot Topic w/o New Messages Locked w/ New Messages Locked w/o New Messages

Post New Thread  Reply to Message  Post New Poll  Submit Vote  Delete My Own Post  Delete My Own Thread  Rate Posts

Please Note: In order to post a message on the forums, you will need to become an Encore Forum Member. Click on the Register link on the top of this page and follow the instructions to become an Encore Forum Member.

If you are a new member and need help using these forums, please click on the FAQ link at the top of this page.