Welcome Guest   | Login   
  Search  
  Index |  Recent Threads |  Register | 


Quick Go »
Thread Status: Normal
Total posts in this thread: 6
[Change thread status] [Delete this Thread] [Move this Thread]
[Add To My Favorites] [Watch this Thread] [Post new Thread]
Author
Previous Thread This topic has been viewed 61 times and has 5 replies Next Thread
OPwebmaster
localendar Expert



Joined: Jan 24, 2015
Posts: 282
Status: Offline

Edit this Post   Import/Export from CSV Reply to this Post
Reply with Quote
[Delete this Thread]

I find it is much quicker to add information for multiple events using an Excel spreadsheet than typing in the Localendar entry forms. I think I have read all the posts on CSV in this forum, as well as the tutorial.

For Importing to Localendar, would it be possible to add the other fields that can be set when entered directly on the Localendar screen? They are: Background color, Street Address & Category [Your sample EXPORT CSV shows street address entries under Location, but when I export data from My Calendar, all entries under "Location' are blank, even though some of the entries have valid Street Addresses].

Thanks,

Harry
[Jan 26, 2015, 12:48:51 AM] [72.241.195.138] Show Post Printable Version [Link] Report threatening post: please login first  Go to top 
support
localendar Expert
Member's Avatar


Joined: Sep 15, 2004
Posts: 6016
Status: Offline
Edit this Post   Re: Import/Export from CSV Reply to this Post
Reply with Quote
[Delete this Post]

I've tested both import and export for location, and found both to be working normally.

Please note that with CSV files, the field on the localendar Event Editor that is used for location is the location "Information" field, not the street address.

On Import, it is impossible to verify any location inaccuracies (or ask the member to select from a list of possible choices) so the location is importation in the Information section.

CSV Export uses this same field to be consistent with the way CSV Imports are handled
----------------------------------------
Marc Higgins
Support Associate, localendar.com
Follow us on Twitter! http://www.twitter.com/localendar_news
[Jan 27, 2015, 1:14:06 AM] [24.189.166.198] Show Post Printable Version [Link] Report threatening post: please login first  Go to top 
OPwebmaster
localendar Expert



Joined: Jan 24, 2015
Posts: 282
Status: Offline

Edit this Post   Re: Import/Export from CSV Reply to this Post
Reply with Quote
[Delete this Post]

Marc:

I understand your point about Localendar not being able to verify the accuracy of the street address.

For Importing CSV to Localendar, would it be possible to add the two other fields that can be set when entered directly on the Localendar screen? They are: Background color & Category ?


Harry
[Jan 27, 2015, 5:21:58 AM] [72.241.195.138] Show Post Printable Version [Link] Report threatening post: please login first  Go to top 
esthouston01
New Member



Joined: Nov 24, 2009
Posts: 7
Status: Offline

Edit this Post   Re: Import/Export from CSV Reply to this Post
Reply with Quote
[Delete this Post]

 
Marc:

I understand your point about Localendar not being able to verify the accuracy of the street address.

For Importing CSV to Localendar, would it be possible to add the two other fields that can be set when entered directly on the Localendar screen? They are: Background color & Category ?


Harry


Good suggestion, I too was wanting to use the csv import, but the lack of color was a deal killer. I just had my team update it manually through the website. Wish it were included. And Category should be as well.
[Feb 3, 2015, 9:08:27 PM] [50.197.205.81] Show Post Printable Version [Link] Report threatening post: please login first  Go to top 
support
localendar Expert
Member's Avatar


Joined: Sep 15, 2004
Posts: 6016
Status: Offline
Edit this Post   Re: Import/Export from CSV Reply to this Post
Reply with Quote
[Delete this Post]

Unfortunately, I don't think we'll be able to reliably add Category. The issue is that all categories have an underlying unique # (you can catch a glimpse of this if you publish a calendar with only particular categories)

In your CSV file, you would have no way of knowing all the unique category IDs.. you'd want to use a name. And we can assume people will make mistakes entering that name. I suppose we could push any mistakes to the General category, but we just don't like building something that we know will be error prone in the end.

Colors is a similar problem.. Are people going to enter valid HTML hex codes int he CSV? We have no way to tell. And if we default bad input to a certain color, the member may never know b/c if may be on a date in the future.

We'll think about it.. we could probably create an error report for the user, but it all feels a little un-user friendly.
----------------------------------------
Marc Higgins
Support Associate, localendar.com
Follow us on Twitter! http://www.twitter.com/localendar_news
[Feb 9, 2015, 1:52:33 AM] [24.189.166.198] Show Post Printable Version [Link] Report threatening post: please login first  Go to top 
OPwebmaster
localendar Expert



Joined: Jan 24, 2015
Posts: 282
Status: Offline

Edit this Post   Re: Import/Export from CSV Reply to this Post
Reply with Quote
[Delete this Post]

Marc:

I understand your concerns. It must be very hard to design something that no user can mess up.

But if a user was willing to go to the effort to manually modify the .CSV file, then I would think it would be worth the risk. The option is to enter all the color and category information manually again, which I would think is a bigger risk to the user. I have made hard copy pages of all this info so I don't make mistakes.

I really am trying to export out of one Localendar, and then import into ANOTHER Localendar. In this case, there would be no manual miscoding. See the thread 'Re: Basic questions-potential user' and my reply dated Feb 6, 2015 6:00:08 PM.

Harry
[Feb 9, 2015, 4:52:43 AM] [72.241.195.138] Show Post Printable Version [Link] Report threatening post: please login first  Go to top 
[Show Thread Printable Version] [Post new Thread]

Help! | Cobranding | Legal | Privacy Policy | About localendar.com | Contact Us