Normal Topic Simple single csv file import (Read 758 times)
jondolar
Junior Member
**
Offline


Keep Trying

Posts: 57
Location: Montreal Canada
Joined: Dec 25th, 2003
Simple single csv file import
May 30th, 2004 at 7:54pm
Print Post Print Post  
Hi

I'm trying do to a simple data import. The csv file has only 2 fields Client_Id and Order_Id. The Sesame empty Orders.db has the very same 2 fields on one form. In sesame I select the Orders.db, Add Data Menu then the Order form. I then cycle the left bottom pane to select Import Order. I have [IGNORE COLUMN]in first position and my 2 fields, Client_Id and Order_Id. When I select Client_Id to make it the first field to import, the first line, Client.Id disappear completely while [IGNORE COLUMN] goes to the second line and the third line Order.Id remains there and the two elements remaining in the pane are frozen i.e. cannot be selected, moved etc. If I do an import at that point, only Client.Id gets imported from the csv file. I deleted everything a couple of times and started fresh to be sure that everything, field defenitions, form etc. were done properly. I checked the field's properties. Everything looks OK.  I closed the application and reopened it several times. Niet, it won't work. I'm at lost. ??? Any idea?

TIA

Serge
  

When all you have is a hammer, everything starts to look like nail!
Back to top
 
IP Logged
 
jondolar
Junior Member
**
Offline


Keep Trying

Posts: 57
Location: Montreal Canada
Joined: Dec 25th, 2003
Re: Simple single csv file import
Reply #1 - May 31st, 2004 at 10:10pm
Print Post Print Post  
Any help at all on this one Roll Eyes

Thanks In Advance

Serge
  

When all you have is a hammer, everything starts to look like nail!
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Simple single csv file import
Reply #2 - Jun 1st, 2004 at 10:45am
Print Post Print Post  
I just built a two LE form. On selecting the import spec handler and selecting the first of the two LEs - it moved to the first position. I did have to click outside the spec handler (on its scrollbar) once to get it to recognize further clicks, but no LEs disappeared or were mishandled on import.

What version are you running?
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
jondolar
Junior Member
**
Offline


Keep Trying

Posts: 57
Location: Montreal Canada
Joined: Dec 25th, 2003
Re: Simple single csv file import
Reply #3 - Jun 1st, 2004 at 11:31am
Print Post Print Post  
Hi
I'm using 1.0.3 I can send you the files if you want

Serge
  

When all you have is a hammer, everything starts to look like nail!
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Simple single csv file import
Reply #4 - Jun 1st, 2004 at 12:18pm
Print Post Print Post  
Naw - I did find a minor bug in the import spec handler that caused the reactive area of each line to shrink to only the top six pixels of each line after the first toggle. The fix will be in 1.0.4. Try that when its available. We just got the "go ahead" from the testers - so it won't be long.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
jondolar
Junior Member
**
Offline


Keep Trying

Posts: 57
Location: Montreal Canada
Joined: Dec 25th, 2003
Re: Simple single csv file import
Reply #5 - Jun 1st, 2004 at 12:40pm
Print Post Print Post  
Thanks Mark

That's a relief Cheesy

Serge
  

When all you have is a hammer, everything starts to look like nail!
Back to top
 
IP Logged