(UTC)
  Lantica User Forum › Archived Topics › Archived Topics › Re: Hierarchical RoadApple
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Re: Hierarchical RoadApple (Read 939 times)
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Hierarchical RoadApple
Apr 16th, 2004 at 9:45pm
Print Post Print Post  
I think don't hold your breath. 

That is not a NO, it is just not going to be quick.  There will be no shortcuts, but perhaps some automation can be applied.

Anyway, I will try to pick away at something over the next few weeks in any spare moments I can squeeze together.
  


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
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Hierarchical RoadApple
Reply #1 - Apr 17th, 2004 at 3:31am
Print Post Print Post  
Hello walt.   How does this look? Grin   Grin

These are the test sample conditions.
Record count = 10 Invoices.
Each invoice has three line items.
Each line item has 6 fields of data.
The Invoice itself has 11 fields of information including the Invoice # as the key field.

Sample file exported from Q&A.  The common header fields are all together with the Invoice Number in the middle.  All of the line item information is together, grouped by the same line.  This can be set up in Q&A and only requires the one export.  Used comma delimiter, but could use semicolon with quotes.


Quote:
HdrFld1,HdrFld2,HdrFld3,Invoice #1,HdrFld4,HdrFld5,HdrFld6,HdrFld7,HdrFld8, HdrFld9,HdrFld10,Line1Fld1,Line1Fld2,Line1Fld3,Line1Fld4,Line1Fld5, Line1Fld6,Line2Fld1,Line2Fld2,Line2Fld3,Line2Fld4,Line2Fld5,Line2Fld6, Line3Fld1,Line3Fld2,Line3Fld3,Line3Fld4,Line3Fld5,Line3Fld6

HdrFld1,HdrFld2,HdrFld3,Invoice #2,HdrFld4,HdrFld5,HdrFld6,HdrFld7,HdrFld8, HdrFld9,HdrFld10,Line1Fld1,Line1Fld2,Line1Fld3,Line1Fld4,Line1Fld5, Line1Fld6,Line2Fld1,Line2Fld2,Line2Fld3,Line2Fld4,Line2Fld5,Line2Fld6, Line3Fld1,Line3Fld2,Line3Fld3,Line3Fld4,Line3Fld5,Line3Fld6

HdrFld1,HdrFld2,HdrFld3,Invoice #3,HdrFld4,HdrFld5,HdrFld6,HdrFld7,HdrFld8, HdrFld9,HdrFld10,Line1Fld1,Line1Fld2,Line1Fld3,Line1Fld4,Line1Fld5, Line1Fld6,Line2Fld1,Line2Fld2,Line2Fld3,Line2Fld4,Line2Fld5,Line2Fld6, Line3Fld1,Line3Fld2,Line3Fld3,Line3Fld4,Line3Fld5,Line3Fld6

HdrFld1,HdrFld2,HdrFld3,Invoice #4,HdrFld4,HdrFld5,HdrFld6,HdrFld7,HdrFld8, HdrFld9,HdrFld10,Line1Fld1,Line1Fld2,Line1Fld3,Line1Fld4,Line1Fld5, Line1Fld6,Line2Fld1,Line2Fld2,Line2Fld3,Line2Fld4,Line2Fld5,Line2Fld6, Line3Fld1,Line3Fld2,Line3Fld3,Line3Fld4,Line3Fld5,Line3Fld6

HdrFld1,HdrFld2,HdrFld3,Invoice #5,HdrFld4,HdrFld5,HdrFld6,HdrFld7,HdrFld8, HdrFld9,HdrFld10,Line1Fld1,Line1Fld2,Line1Fld3,Line1Fld4,Line1Fld5, Line1Fld6,Line2Fld1,Line2Fld2,Line2Fld3,Line2Fld4,Line2Fld5,Line2Fld6, Line3Fld1,Line3Fld2,Line3Fld3,Line3Fld4,Line3Fld5,Line3Fld6

HdrFld1,HdrFld2,HdrFld3,Invoice #6,HdrFld4,HdrFld5,HdrFld6,HdrFld7,HdrFld8, HdrFld9,HdrFld10,Line1Fld1,Line1Fld2,Line1Fld3,Line1Fld4,Line1Fld5, Line1Fld6,Line2Fld1,Line2Fld2,Line2Fld3,Line2Fld4,Line2Fld5,Line2Fld6, Line3Fld1,Line3Fld2,Line3Fld3,Line3Fld4,Line3Fld5,Line3Fld6

HdrFld1,HdrFld2,HdrFld3,Invoice #7,HdrFld4,HdrFld5,HdrFld6,HdrFld7,HdrFld8, HdrFld9,HdrFld10,Line1Fld1,Line1Fld2,Line1Fld3,Line1Fld4,Line1Fld5, Line1Fld6,Line2Fld1,Line2Fld2,Line2Fld3,Line2Fld4,Line2Fld5,Line2Fld6, Line3Fld1,Line3Fld2,Line3Fld3,Line3Fld4,Line3Fld5,Line3Fld6

HdrFld1,HdrFld2,HdrFld3,Invoice #8,HdrFld4,HdrFld5,HdrFld6,HdrFld7,HdrFld8, HdrFld9,HdrFld10,Line1Fld1,Line1Fld2,Line1Fld3,Line1Fld4,Line1Fld5, Line1Fld6,Line2Fld1,Line2Fld2,Line2Fld3,Line2Fld4,Line2Fld5,Line2Fld6, Line3Fld1,Line3Fld2,Line3Fld3,Line3Fld4,Line3Fld5,Line3Fld6

HdrFld1,HdrFld2,HdrFld3,Invoice #9,HdrFld4,HdrFld5,HdrFld6,HdrFld7,HdrFld8, HdrFld9,HdrFld10,Line1Fld1,Line1Fld2,Line1Fld3,Line1Fld4,Line1Fld5, Line1Fld6,Line2Fld1,Line2Fld2,Line2Fld3,Line2Fld4,Line2Fld5,Line2Fld6, Line3Fld1,Line3Fld2,Line3Fld3,Line3Fld4,Line3Fld5,Line3Fld6

HdrFld1,HdrFld2,HdrFld3,Invoice #10,HdrFld4,HdrFld5,HdrFld6,HdrFld7,HdrFld8, HdrFld9,HdrFld10,Line1Fld1,Line1Fld2,Line1Fld3,Line1Fld4,Line1Fld5, Line1Fld6,Line2Fld1,Line2Fld2,Line2Fld3,Line2Fld4,Line2Fld5,Line2Fld6, Line3Fld1,Line3Fld2,Line3Fld3,Line3Fld4,Line3Fld5,Line3Fld6


I have created some tools in my office to convert the export file into the following results to be imported by Sesame:   Grin  Quote:
Invoice #1,HdrFld1,HdrFld2,HdrFld3,HdrFld4,HdrFld5,HdrFld6,HdrFld7,HdrFld8, HdrFld9,HdrFld10,
Invoice #10,HdrFld1,HdrFld2,HdrFld3,HdrFld4,HdrFld5,HdrFld6,HdrFld7,HdrFld8, HdrFld9,HdrFld10,
Invoice #2,HdrFld1,HdrFld2,HdrFld3,HdrFld4,HdrFld5,HdrFld6,HdrFld7,HdrFld8, HdrFld9,HdrFld10,
Invoice #3,HdrFld1,HdrFld2,HdrFld3,HdrFld4,HdrFld5,HdrFld6,HdrFld7,HdrFld8, HdrFld9,HdrFld10,
Invoice #4,HdrFld1,HdrFld2,HdrFld3,HdrFld4,HdrFld5,HdrFld6,HdrFld7,HdrFld8, HdrFld9,HdrFld10,
Invoice #5,HdrFld1,HdrFld2,HdrFld3,HdrFld4,HdrFld5,HdrFld6,HdrFld7,HdrFld8, HdrFld9,HdrFld10,
Invoice #6,HdrFld1,HdrFld2,HdrFld3,HdrFld4,HdrFld5,HdrFld6,HdrFld7,HdrFld8, HdrFld9,HdrFld10,
Invoice #7,HdrFld1,HdrFld2,HdrFld3,HdrFld4,HdrFld5,HdrFld6,HdrFld7,HdrFld8, HdrFld9,HdrFld10,
Invoice #8,HdrFld1,HdrFld2,HdrFld3,HdrFld4,HdrFld5,HdrFld6,HdrFld7,HdrFld8, HdrFld9,HdrFld10,
Invoice #9,HdrFld1,HdrFld2,HdrFld3,HdrFld4,HdrFld5,HdrFld6,HdrFld7,HdrFld8, HdrFld9,HdrFld10,
Invoice #1,Line1Fld1,Line1Fld2,Line1Fld3,Line1Fld4,Line1Fld5,Line1Fld6,
Invoice #1,Line2Fld1,Line2Fld2,Line2Fld3,Line2Fld4,Line2Fld5,Line2Fld6,
Invoice #1,Line3Fld1,Line3Fld2,Line3Fld3,Line3Fld4,Line3Fld5,Line3Fld6
Invoice #10,Line1Fld1,Line1Fld2,Line1Fld3,Line1Fld4,Line1Fld5,Line1Fld6,
Invoice #10,Line2Fld1,Line2Fld2,Line2Fld3,Line2Fld4,Line2Fld5,Line2Fld6,
Invoice #10,Line3Fld1,Line3Fld2,Line3Fld3,Line3Fld4,Line3Fld5,Line3Fld6
Invoice #2,Line1Fld1,Line1Fld2,Line1Fld3,Line1Fld4,Line1Fld5,Line1Fld6,
Invoice #2,Line2Fld1,Line2Fld2,Line2Fld3,Line2Fld4,Line2Fld5,Line2Fld6,
Invoice #2,Line3Fld1,Line3Fld2,Line3Fld3,Line3Fld4,Line3Fld5,Line3Fld6
Invoice #3,Line1Fld1,Line1Fld2,Line1Fld3,Line1Fld4,Line1Fld5,Line1Fld6,
Invoice #3,Line2Fld1,Line2Fld2,Line2Fld3,Line2Fld4,Line2Fld5,Line2Fld6,
Invoice #3,Line3Fld1,Line3Fld2,Line3Fld3,Line3Fld4,Line3Fld5,Line3Fld6
Invoice #4,Line1Fld1,Line1Fld2,Line1Fld3,Line1Fld4,Line1Fld5,Line1Fld6,
Invoice #4,Line2Fld1,Line2Fld2,Line2Fld3,Line2Fld4,Line2Fld5,Line2Fld6,
Invoice #4,Line3Fld1,Line3Fld2,Line3Fld3,Line3Fld4,Line3Fld5,Line3Fld6
Invoice #5,Line1Fld1,Line1Fld2,Line1Fld3,Line1Fld4,Line1Fld5,Line1Fld6,
Invoice #5,Line2Fld1,Line2Fld2,Line2Fld3,Line2Fld4,Line2Fld5,Line2Fld6,
Invoice #5,Line3Fld1,Line3Fld2,Line3Fld3,Line3Fld4,Line3Fld5,Line3Fld6
Invoice #6,Line1Fld1,Line1Fld2,Line1Fld3,Line1Fld4,Line1Fld5,Line1Fld6,
Invoice #6,Line2Fld1,Line2Fld2,Line2Fld3,Line2Fld4,Line2Fld5,Line2Fld6,
Invoice #6,Line3Fld1,Line3Fld2,Line3Fld3,Line3Fld4,Line3Fld5,Line3Fld6
Invoice #7,Line1Fld1,Line1Fld2,Line1Fld3,Line1Fld4,Line1Fld5,Line1Fld6,
Invoice #7,Line2Fld1,Line2Fld2,Line2Fld3,Line2Fld4,Line2Fld5,Line2Fld6,
Invoice #7,Line3Fld1,Line3Fld2,Line3Fld3,Line3Fld4,Line3Fld5,Line3Fld6
Invoice #8,Line1Fld1,Line1Fld2,Line1Fld3,Line1Fld4,Line1Fld5,Line1Fld6,
Invoice #8,Line2Fld1,Line2Fld2,Line2Fld3,Line2Fld4,Line2Fld5,Line2Fld6,
Invoice #8,Line3Fld1,Line3Fld2,Line3Fld3,Line3Fld4,Line3Fld5,Line3Fld6
Invoice #9,Line1Fld1,Line1Fld2,Line1Fld3,Line1Fld4,Line1Fld5,Line1Fld6,
Invoice #9,Line2Fld1,Line2Fld2,Line2Fld3,Line2Fld4,Line2Fld5,Line2Fld6,
Invoice #9,Line3Fld1,Line3Fld2,Line3Fld3,Line3Fld4,Line3Fld5,Line3Fld6
  The result is 40 records, 10 Records for Invoice Headers, and 30 records for the Invoice Details, all using a common Invoice Number for a Key.

This single file can now be broken into two files for two databases, Invoice Header and Invoice Details. No need to go through Notepad or other tools to individually pick out individual lines like Carl had to do.  No need to do the multiple exports that I had first suggested.  And there is essentially no limitation to the number of line items.Grin

This is just a quick (6 hours?) and dirty (for example, trailing commas to be deleted) sample, but I now know that I can do this with quite a bit of flexibility on layouts, empty fields, etc.  The actual time to convert from Q&A export to Sesame import format will be much less than the  6 hours it took to develop Roll Eyes

So, does this look like what you asked for?  I may actually have a conversion product available with some more refinement.

You can probably cancel those tickets to Mumbai
  


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
 
BOBSCOTT
Senior Member
Members
*****
Offline


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
Re: Hierarchical RoadApple
Reply #2 - Apr 18th, 2004 at 4:02am
Print Post Print Post  
Quote:
You've proven you're not just another pretty face with the boyish good looks of a Warren Christopher or Janet Reno.


Hey, Be nice to  Janet Reno she is one smart Lady.  Smiley
  
Team – Together Everyone Achieves More
Back to top
 
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: Hierarchical RoadApple
Reply #3 - Apr 19th, 2004 at 2:51am
Print Post Print Post  
Hi walt, you had a couple of questions:
Quote:
1.  Can/will you take it to the next level resulting in one file (like the hierarchical one shown on p. 322 of the User's Guide) so we can skip the relational stuff and import it directly into the natural link form/subform?
How about this?
Quote:
"Invoice #1","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8"," HdrFld9","HdrFld10"
"Invoice #1","Line1Fld1","Line1Fld2","Line1Fld3","Line1Fld4","Line1Fld5","Line1Fld6"
"Invoice #1","Line2Fld1","Line2Fld2","Line2Fld3","Line2Fld4","Line2Fld5","Line2Fld6"
"Invoice #1","Line3Fld1","Line3Fld2","Line3Fld3","Line3Fld4","Line3Fld5","Line3Fld6"
"Invoice #10","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8"," HdrFld9","HdrFld10"
"Invoice #10","Line1Fld1","Line1Fld2","Line1Fld3","Line1Fld4","Line1Fld5","Line1Fld6"
"Invoice #10","Line2Fld1","Line2Fld2","Line2Fld3","Line2Fld4","Line2Fld5","Line2Fld6"
"Invoice #10","Line3Fld1","Line3Fld2","Line3Fld3","Line3Fld4","Line3Fld5","Line3Fld6"
"Invoice #2","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8"," HdrFld9","HdrFld10"
"Invoice #2","Line1Fld1","Line1Fld2","Line1Fld3","Line1Fld4","Line1Fld5","Line1Fld6"
"Invoice #2","Line2Fld1","Line2Fld2","Line2Fld3","Line2Fld4","Line2Fld5","Line2Fld6"
"Invoice #2","Line3Fld1","Line3Fld2","Line3Fld3","Line3Fld4","Line3Fld5","Line3Fld6"
"Invoice #3","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8"," HdrFld9","HdrFld10"
"Invoice #3","Line1Fld1","Line1Fld2","Line1Fld3","Line1Fld4","Line1Fld5","Line1Fld6"
"Invoice #3","Line2Fld1","Line2Fld2","Line2Fld3","Line2Fld4","Line2Fld5","Line2Fld6"
"Invoice #3","Line3Fld1","Line3Fld2","Line3Fld3","Line3Fld4","Line3Fld5","Line3Fld6"
"Invoice #4","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8"," HdrFld9","HdrFld10"
"Invoice #4","Line1Fld1","Line1Fld2","Line1Fld3","Line1Fld4","Line1Fld5","Line1Fld6"
"Invoice #4","Line2Fld1","Line2Fld2","Line2Fld3","Line2Fld4","Line2Fld5","Line2Fld6"
"Invoice #4","Line3Fld1","Line3Fld2","Line3Fld3","Line3Fld4","Line3Fld5","Line3Fld6"
"Invoice #5","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8"," HdrFld9","HdrFld10"
"Invoice #5","Line1Fld1","Line1Fld2","Line1Fld3","Line1Fld4","Line1Fld5","Line1Fld6"
"Invoice #5","Line2Fld1","Line2Fld2","Line2Fld3","Line2Fld4","Line2Fld5","Line2Fld6"
"Invoice #5","Line3Fld1","Line3Fld2","Line3Fld3","Line3Fld4","Line3Fld5","Line3Fld6"
"Invoice #6","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8"," HdrFld9","HdrFld10"
"Invoice #6","Line1Fld1","Line1Fld2","Line1Fld3","Line1Fld4","Line1Fld5","Line1Fld6"
"Invoice #6","Line2Fld1","Line2Fld2","Line2Fld3","Line2Fld4","Line2Fld5","Line2Fld6"
"Invoice #6","Line3Fld1","Line3Fld2","Line3Fld3","Line3Fld4","Line3Fld5","Line3Fld6"
"Invoice #7","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8"," HdrFld9","HdrFld10"
"Invoice #7","Line1Fld1","Line1Fld2","Line1Fld3","Line1Fld4","Line1Fld5","Line1Fld6"
"Invoice #7","Line2Fld1","Line2Fld2","Line2Fld3","Line2Fld4","Line2Fld5","Line2Fld6"
"Invoice #7","Line3Fld1","Line3Fld2","Line3Fld3","Line3Fld4","Line3Fld5","Line3Fld6"
"Invoice #8","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8"," HdrFld9","HdrFld10"
"Invoice #8","Line1Fld1","Line1Fld2","Line1Fld3","Line1Fld4","Line1Fld5","Line1Fld6"
"Invoice #8","Line2Fld1","Line2Fld2","Line2Fld3","Line2Fld4","Line2Fld5","Line2Fld6"
"Invoice #8","Line3Fld1","Line3Fld2","Line3Fld3","Line3Fld4","Line3Fld5","Line3Fld6"
"Invoice #9","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8"," HdrFld9","HdrFld10"
"Invoice #9","Line1Fld1","Line1Fld2","Line1Fld3","Line1Fld4","Line1Fld5","Line1Fld6"
"Invoice #9","Line2Fld1","Line2Fld2","Line2Fld3","Line2Fld4","Line2Fld5","Line2Fld6"
"Invoice #9","Line3Fld1","Line3Fld2","Line3Fld3","Line3Fld4","Line3Fld5","Line3Fld6"
Note: Spaces near ends of lines are in forum display only, not in actual file.

Quote:
2.  Can you include more fields below the subform for financial summary which are currently below the line item rows on the Q&A design (per #4 above)?
Those lines are all considered as part of the Header, I have just moved them all together.  They will appear according to the layout of the elements on the form.

Quote:
3.  Can the fields also be comma quote delimited?
DONE

Quote:
4.  What if someone needs more than one subform?
See no problem, that could also be addressed.  I think that is more a process of how you do the import in Sesame. 
 
Quote:
5.  Can you bill your time to Sesame Marketing?
I doubt it, but I can be contacted and bill you directly instead Grin

Quote:
6.  Can you loan me any money?
Loan is negotiable at usual usury rates.  Gift is out of the question, unless from you to me. Grin
  


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
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Hierarchical RoadApple
Reply #4 - Apr 19th, 2004 at 5:40pm
Print Post Print Post  
Not too fast Walt.  Send that check by normal ground delivery, not overnight express!  Got some more work to do.

I had not actually done an hierarchal import, just made a theoretical file.  When I tried to do an import with the hierarchal test file, I had some problems. Embarrassed

I have just received an email from Erika that indicates the problems in the file I have created.  Just in time to probably save me many hours of troubleshooting.Roll Eyes

But I am sure I will be able to overcome the structure issues that she points out .    Please stay tuned.  Grin
  


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
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Hierarchical RoadApple
Reply #5 - Apr 20th, 2004 at 4:33am
Print Post Print Post  
Success Grin  Finally got back to this tonight.
Quote:
"KeyFld1","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8","HdrFld9","HdrFld10","Line1Fld1","Line1Fld2","Line1Fld3","Line1Fld4","
Line1Fld5","Line1Fld6","Line2Fld1","Line2Fld2","Line2Fld3","Line2Fld4","Line2Fld
5","Line2Fld6","Line3Fld1","Line3Fld2","Line3Fld3","Line3Fld4","Line3Fld5","Line
3Fld6"

"KeyFld2","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8","HdrFld9","HdrFld10","Line1Fld1","Line1Fld2","Line1Fld3","Line1Fld4","
Line1Fld5","Line1Fld6","Line2Fld1","Line2Fld2","Line2Fld3","Line2Fld4","Line2Fld
5","Line2Fld6","Line3Fld1","Line3Fld2","Line3Fld3","Line3Fld4","Line3Fld5","Line
3Fld6"

"KeyFld3","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8","HdrFld9","HdrFld10","Line1Fld1","Line1Fld2","Line1Fld3","Line1Fld4","
Line1Fld5","Line1Fld6","Line2Fld1","Line2Fld2","Line2Fld3","Line2Fld4","Line2Fld
5","Line2Fld6","Line3Fld1","Line3Fld2","Line3Fld3","Line3Fld4","Line3Fld5","Line
3Fld6"

"KeyFld4","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8","HdrFld9","HdrFld10","Line1Fld1","Line1Fld2","Line1Fld3","Line1Fld4","
Line1Fld5","Line1Fld6","Line2Fld1","Line2Fld2","Line2Fld3","Line2Fld4","Line2Fld
5","Line2Fld6","Line3Fld1","Line3Fld2","Line3Fld3","Line3Fld4","Line3Fld5","Line
3Fld6"

"KeyFld5","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8","HdrFld9","HdrFld10","Line1Fld1","Line1Fld2","Line1Fld3","Line1Fld4","
Line1Fld5","Line1Fld6","Line2Fld1","Line2Fld2","Line2Fld3","Line2Fld4","Line2Fld
5","Line2Fld6","Line3Fld1","Line3Fld2","Line3Fld3","Line3Fld4","Line3Fld5","Line
3Fld6"
================================================
Q&A Export above is converted to hierarchal file below.  Sesame import tested OK. Sample for 5 Invoice type structures. Ten common fields on Invoice Header.  Three lines per Invoice, six fields per line item. (Forum display causes unreal spaces).
================================================
"KeyFld1","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8","HdrFld9","HdrFld10","Line1Fld1","Line1Fld2","Line1Fld3","Line1Fld4","
Line1Fld5","Line1Fld6"
"KeyFld1","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8","HdrFld9","HdrFld10","Line2Fld1","Line2Fld2","Line2Fld3","Line2Fld4","
Line2Fld5","Line2Fld6"
"KeyFld1","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8","HdrFld9","HdrFld10","Line3Fld1","Line3Fld2","Line3Fld3","Line3Fld4","
Line3Fld5","Line3Fld6"
"KeyFld2","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8","HdrFld9","HdrFld10","Line1Fld1","Line1Fld2","Line1Fld3","Line1Fld4","
Line1Fld5","Line1Fld6"
"KeyFld2","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8","HdrFld9","HdrFld10","Line2Fld1","Line2Fld2","Line2Fld3","Line2Fld4","
Line2Fld5","Line2Fld6"
"KeyFld2","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8","HdrFld9","HdrFld10","Line3Fld1","Line3Fld2","Line3Fld3","Line3Fld4","
Line3Fld5","Line3Fld6"
"KeyFld3","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8","HdrFld9","HdrFld10","Line1Fld1","Line1Fld2","Line1Fld3","Line1Fld4","
Line1Fld5","Line1Fld6"
"KeyFld3","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8","HdrFld9","HdrFld10","Line2Fld1","Line2Fld2","Line2Fld3","Line2Fld4","
Line2Fld5","Line2Fld6"
"KeyFld3","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8","HdrFld9","HdrFld10","Line3Fld1","Line3Fld2","Line3Fld3","Line3Fld4","
Line3Fld5","Line3Fld6"
"KeyFld4","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8","HdrFld9","HdrFld10","Line1Fld1","Line1Fld2","Line1Fld3","Line1Fld4","
Line1Fld5","Line1Fld6"
"KeyFld4","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8","HdrFld9","HdrFld10","Line2Fld1","Line2Fld2","Line2Fld3","Line2Fld4","
Line2Fld5","Line2Fld6"
"KeyFld4","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8","HdrFld9","HdrFld10","Line3Fld1","Line3Fld2","Line3Fld3","Line3Fld4","
Line3Fld5","Line3Fld6"
"KeyFld5","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8","HdrFld9","HdrFld10","Line1Fld1","Line1Fld2","Line1Fld3","Line1Fld4","
Line1Fld5","Line1Fld6"
"KeyFld5","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8","HdrFld9","HdrFld10","Line2Fld1","Line2Fld2","Line2Fld3","Line2Fld4","
Line2Fld5","Line2Fld6"
"KeyFld5","HdrFld1","HdrFld2","HdrFld3","HdrFld4","HdrFld5","HdrFld6","HdrFld7",
"HdrFld8","HdrFld9","HdrFld10","Line3Fld1","Line3Fld2","Line3Fld3","Line3Fld4","
Line3Fld5","Line3Fld6"

Using this does require addition of some fields with Mass Updated values added to Q&A and a predefined export layout that is easily defined.  It uses "quote-comma" delimited export format.  I can then take that exported file and quickly convert into the format above to be imported by Sesame for a hierarchal structure.

Not available for public use at this time, but I can be contacted if you need to do this.  I can also create the files necessary for a relational structure if that is what is needed.

I am not sure that it is worth the effort to come up with a stand alone generic utility for Q&A to Sesame conversions that has enough flexibility.  It will take some time to come up with a standalone product that can be delivered to end users, and I think that this is a service that only has a one-time usage value for anyone.  Each database requires some customization at my end.

If interested in having this done for you, please go to www.sensiblesolutions.org/Q&AToSesame.htm. ; I can probably turn around an export file for you in one work day.  Prep work to be done in Q&A can be done by me or by you.  I have provided some instructions on the web page if you are interested.

Thanks to waltfor the inspiration and kick in the butt.  And thanks to Erika for pointing out an earlier problem.
« Last Edit: Apr 20th, 2004 at 1:09pm by Bob_Hansen »  


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
 
Page Index Toggle Pages: 1
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