Normal Topic exporting image feild gives wrong data (Read 794 times)
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
exporting image feild gives wrong data
Mar 24th, 2004 at 9:39pm
Print Post Print Post  
Regardless of the export options I choose, my exported data is coming out a bit garbled for my image fields. Example:

I'm getting this:

//images//products//item1.jpg

It should be this:

/images/products/item1.jpg

The images show up correctly in sesame, but I would imagine my exported data is useless with the extra backslashes.

Is this a bug?

Steve in Texas
  
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: exporting image feild gives wrong data
Reply #1 - Mar 26th, 2004 at 2:45pm
Print Post Print Post  
Steve,

It's not a bug. Special characters, such as quotes and backslashes, are escaped on export. The escape character is a backslash. Many programs require these characters to be escaped in order to, for example, import quote delimited values that include quote marks.

If the escaped characters are a problem, you'll need to run your export file through a routine that strips the extra slashes, or use the SBasic file i/o commands in a mass update instead of Export.

We do intend to increase the number of formatting options available for export in future versions.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: exporting image feild gives wrong data
Reply #2 - Mar 26th, 2004 at 3:41pm
Print Post Print Post  
Thanks for the tip. I'm having problems with exporting test such as:     This item has a unique, "warm" feel to it.

the quotes within the text, in addition to the comma are throwing the fields out of order.

Ive had best results with exporting to .txt and using excel to "find/replace" the extra characters.

I'll look into your suggestions.

Thanks for the help, as always!

Steve
  
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: exporting image feild gives wrong data
Reply #3 - Mar 26th, 2004 at 3:48pm
Print Post Print Post  
If quotes are your problem, Sesame export will already allow you to specify a custom character as the delimiter. Specify something other than a " mark. You may find that % or | works better for you.

Same goes for the comma separator. You may be better off with a Tab separator.

The issue of delimiting and separating values that may contain the delimiter and/or separator is one which has plagued export/import since the dawn of time.  Grin
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: exporting image feild gives wrong data
Reply #4 - Mar 26th, 2004 at 3:50pm
Print Post Print Post  
Sounds good. I'll do it!

Ps. Thanks for the Manual Supplement. It solved numerous problems for my "invoice application".

Steve
  
Back to top
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: exporting image feild gives wrong data
Reply #5 - Apr 14th, 2004 at 10:45pm
Print Post Print Post  
I'm still having problems importing from a .csv. Sesame is throwing out "/" and splitting up text at every comma. I replaced the comma with a + sign and replace "/" with "//" but there must be a better way.

Where can I find out which characters are "escaped" on import/export?

Using Notepad to add quotes around text doesnt seem to help.

Thanks for any advice.

Steve in Texas

  
Back to top
IP Logged