otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
 Follow New Posts:Twitter
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTM Wiki

OTM SIG
OTM Wiki
MavenWire


Data Loading Loading data into OTM / G-Log through CSVs, XML, and the UI.

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old June 2nd, 2009, 18:53
Member
 
Join Date: Jan 2007
Posts: 30
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 1
Thanked 0 Times in 0 Posts
Rep Power: 0
slimjim30215 is on a distinguished road
X_Lane Renaming Maintenance

Hi, I have a challenge I hope someone can provide a recommendation for.

We negotiate and update our rates in OTM once per year.

Over the course of the year individual lane rates may be added on an intermittent basis.

If we add rates via the UI, the X_Lane that is created is a system-assigned number. If we upload rates via CSV we can obviously name the X_Lanes with our preferred naming conventions.

If we do an extract at the end of the year some of the x_Lanes will be displayed with our preferred naming conventions while those that were uploaded via the UI over the course of the year will be displayed as the system-assigned number.

How can we change this system-assigned number to our preferred naming convention? We can change the content in the CSVs but when we go to upload these changes, and make the choice of 'iu' for Insert/Update, that still leaves us with system-assigned numbered x_lanes. Bottom line, we want to get rid of those "orphaned" system-assigned numbered x_lanes.

What is the easiest/cleanest way to do this? Basically, what is the best practice?

Thanks in advance!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old June 3rd, 2009, 04:42
Senior Member
 
Join Date: Sep 2007
Location: india
Posts: 182
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 7
Thanked 13 Times in 13 Posts
Rep Power: 3
nipunlakhotia is on a distinguished road
Send a message via Yahoo to nipunlakhotia
Re: X_Lane Renaming Maintenance

Hi,

As per my understanding, naming convention of auto-generated X_LANE cannot be changed from system assigned number.

You can delete the "orphaned" system-assigned numbered x_lanes either from front end or via CSV upload with '-d' option.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Forum Maintenance: Site Down Nov 27-30 chrisplough News and Events 2 December 9th, 2008 12:00
Error in inserting record into X_LANE JayVal Data Loading 2 September 26th, 2008 15:48
Forum Maintenance: Patching 12/09/2007 chrisplough News and Events 0 December 9th, 2007 22:02
Forum Maintenance: 8/07 - 8/08 chrisplough News and Events 1 September 8th, 2007 17:29
[SOLVED] renaming the tabs neelimachenta Branding, Screen Sets, XSL/CSS and Translations 1 June 25th, 2007 10:01



All times are GMT. The time now is 21:45.
Copyright © 2006-2009, Open Book Solutions LLC. All rights reserved.


Inactive Reminders By Icora Web Design

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40