(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › [Solved] Export/Import discrepancy
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 [2] 3  Send Topic Send Topic Print Print
Very Hot Topic (More than 25 Replies) [Solved] Export/Import discrepancy (Read 3199 times)
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: [Solved] Export/Import discrepancy
Reply #15 - Aug 31st, 2007 at 7:39pm
Print Post Print Post  
OK.  Yikes.

How do I use @REPLACE to replace a quote, when quotes are used to enclose the text to be replaced?
  
**
Captain Infinity
Back to top
WWW WWW  
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: [Solved] Export/Import discrepancy
Reply #16 - Aug 31st, 2007 at 8:16pm
Print Post Print Post  
@Chr(34)

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: [Solved] Export/Import discrepancy
Reply #17 - Aug 31st, 2007 at 8:21pm
Print Post Print Post  
Remember don't forget to fix those two fields that just have a \ in them.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: [Solved] Export/Import discrepancy
Reply #18 - Aug 31st, 2007 at 8:33pm
Print Post Print Post  
Thank you, that's working well.  Any other characters I need to check for?
  
**
Captain Infinity
Back to top
WWW WWW  
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: [Solved] Export/Import discrepancy
Reply #19 - Aug 31st, 2007 at 8:33pm
Print Post Print Post  
Quote:
Remember don't forget to fix those two fields that just have a \ in them.

Yep. got 'em, first thing.  Thanks!
  
**
Captain Infinity
Back to top
WWW WWW  
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: [Solved] Export/Import discrepancy
Reply #20 - Aug 31st, 2007 at 8:36pm
Print Post Print Post  
I notice that the search syntax ]..".. is retrieving records where the field contains a set of double angles, something like >> but a single character.  I have no idea where my users got these things.  Do you know the @CHR() code for this?
  
**
Captain Infinity
Back to top
WWW WWW  
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: [Solved] Export/Import discrepancy
Reply #21 - Aug 31st, 2007 at 8:56pm
Print Post Print Post  
I used F11 & F12 to get the double braces out of there, and now a search for quotes returns no results.  The escape slashes are gone as well.  So unless there are other characters I need to look for, I think I'm good to give the export/import another try.  Please let me know if there are other bugaboos I should search for.

Tomorrow I'm going to have to clean up my invoices and workorders.  Not looking forward to that.

Thanks for your help with this Ray, it is much appreciated.
  
**
Captain Infinity
Back to top
WWW WWW  
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: [Solved] Export/Import discrepancy
Reply #22 - Aug 31st, 2007 at 9:01pm
Print Post Print Post  
Quotes and Backslashes are the main ones that you have to look out for. Only other thing I can think of is text data trying to go into a a non-text field. This will simply leave the field blank or Zero but you may want to check your fields to be sure that they do not have text data in a non-text field.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: [Solved] Export/Import discrepancy
Reply #23 - Aug 31st, 2007 at 9:12pm
Print Post Print Post  
Thanks again for your help, Ray.  I appear to have successfully imported 10318 records into Sesame (one of my users snuck a new record in there when I wasn't looking) and a quick scan shows no data errors.

Thanks for the info on text in non-text fields (I posted the question earlier in the Weeds forum), as it will be an issue when I do my Workorder imports.  I think what I'll just do is if they've put text in a non-text field in Q&A, I'll just make the target in Sesame into text, rather than try to clean it all up.  After all, I do want to get some sleep this weekend at some point.
  
**
Captain Infinity
Back to top
WWW WWW  
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: [Solved] Export/Import discrepancy
Reply #24 - Aug 31st, 2007 at 9:19pm
Print Post Print Post  
This is interesting, sort of a cherry to top off my day:

I changed all the quote marks in Q&A into double-single quotes: ' '
Imported the records into Sesame.
Now, they're all double quotes.

Earlier it was the other way around.

I'm happy with the result, but heck if I know why it happened.
  
**
Captain Infinity
Back to top
WWW WWW  
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: [Solved] Export/Import discrepancy
Reply #25 - Aug 31st, 2007 at 9:43pm
Print Post Print Post  
Infinity wrote on Aug 31st, 2007 at 9:19pm:
I changed all the quote marks in Q&A into double-single quotes: ' '
Imported the records into Sesame.
Now, they're all double quotes.

Are you sure that they are not two single quotes right next to each other? You probably have a variable width font now. Try backspacing over one of the quote marks and see if the other remains.
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: [Solved] Export/Import discrepancy
Reply #26 - Aug 31st, 2007 at 10:03pm
Print Post Print Post  
Yep, that's exactly what it is.  Heh.  Thanks.
  
**
Captain Infinity
Back to top
WWW WWW  
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: [Solved] Export/Import discrepancy
Reply #27 - Sep 2nd, 2007 at 4:51pm
Print Post Print Post  
Now that I've changed all my quotes into double apostrophes in Q&A, exported the clean data, and imported it into Sesame, is there any reason why I shouldn't perform Mass Updates in Sesame to turn the double apostrophes back into quotes?
  
**
Captain Infinity
Back to top
WWW WWW  
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: [Solved] Export/Import discrepancy
Reply #28 - Sep 2nd, 2007 at 5:34pm
Print Post Print Post  
I would feel OK doing that, but make a backup copy first.
  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: [Solved] Export/Import discrepancy
Reply #29 - Sep 3rd, 2007 at 1:14pm
Print Post Print Post  
Bob_Hansen wrote on Sep 2nd, 2007 at 5:34pm:
I would feel OK doing that, but make a backup copy first.

Ditto.

Sesame is smart enough to add a backslash before any double quotes that appear within your data, so it won't be a problem if you need to export/import again with Sesame.
  

Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1 [2] 3 
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-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge