(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › IMPORTING CURRENT DATA
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 [2]  Send Topic Send Topic Print Print
Hot Topic (More than 10 Replies) IMPORTING CURRENT DATA (Read 3612 times)
mytime0127
Member
*
Offline


Q&A user since 1994

Posts: 17
Location: Boerne, Texas
Joined: Feb 25th, 2011
Re: IMPORTING CURRENT DATA
Reply #15 - Mar 11th, 2011 at 6:01pm
Print Post Print Post  
Using the Mass Update saved a lot of time scrolling through each record.

Since I do not know how to write the codes, I found this programming code in the Lantica User Forum and altered it to my field names.

Telephone Number fields.  I ditched the template and used the mass update for the telephone numbers as you suggested.  using the following line in the Program Editor for each field:
HomePhone = "(" + @Left(HomePhone, 3) + ") " + @Mid(HomePhone, 4, 3) + "-" + @Right(HomePhone, 4)
Mobile = "(" + @Left(Mobile, 3) + ") " + @Mid(Mobile, 4, 3) + "-" + @Right(Mobile, 4)
WorkPhone = "(" + @Left(WorkPhone, 3) + ") " + @Mid(WorkPhone, 4, 3) + "-" + @Right(WorkPhone, 4)

Now if I can just find the code for formatting the date field I could save more time. Grin

Thanks for your help!
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: IMPORTING CURRENT DATA
Reply #16 - Mar 11th, 2011 at 6:15pm
Print Post Print Post  
If you want someone to help you with code to reformat the date fields, you should post examples of the format in which they are currently so we know what you're trying to parse.
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
mytime0127
Member
*
Offline


Q&A user since 1994

Posts: 17
Location: Boerne, Texas
Joined: Feb 25th, 2011
Re: IMPORTING CURRENT DATA
Reply #17 - Mar 11th, 2011 at 7:21pm
Print Post Print Post  
Ok, thanks.
imported data from q&a as text (w/o - or /) it is actually date information and is formated as yyyy/mm/dd.
the imported data appears as yyyymmdd.
When the end user inserts the required dates they want ti to automatically format so they do not hve to actually input the /.
Embarrassed
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: IMPORTING CURRENT DATA
Reply #18 - Mar 11th, 2011 at 8:36pm
Print Post Print Post  
mytime0127 wrote on Mar 11th, 2011 at 7:21pm:
Ok, thanks.
imported data from q&a as text (w/o - or /) it is actually date information and is formated as yyyy/mm/dd.
the imported data appears as yyyymmdd.
When the end user inserts the required dates they want ti to automatically format so they do not hve to actually input the /.

Are you sure you don't just want to make this a Date field, instead of a Text field, Becky?
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
mytime0127
Member
*
Offline


Q&A user since 1994

Posts: 17
Location: Boerne, Texas
Joined: Feb 25th, 2011
Re: IMPORTING CURRENT DATA
Reply #19 - Mar 11th, 2011 at 8:47pm
Print Post Print Post  
If that would work better, then absolutely.
  
Back to top
 
IP Logged
 
mytime0127
Member
*
Offline


Q&A user since 1994

Posts: 17
Location: Boerne, Texas
Joined: Feb 25th, 2011
Re: IMPORTING CURRENT DATA
Reply #20 - Mar 11th, 2011 at 9:51pm
Print Post Print Post  
Designer> Manage a database> Database Name (Notify)> Manage Fields>. List fields & action.
Changed fields Date, Date Recorded and Completed from text fields to date fields, Run BatcH.
Reconciled to database.
In Designer preview application, the fields populated properly as dates YYYY/MM/DD.

Thank you so much.  I consider this database Ready For Launch!

Monday will be the startup design for the BIG ONE! Cool
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1 [2] 
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2025. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge