Importing Data

Discussion in 'Optigold ISP' started by DELREY, Sep 22, 2004.

0
  1. #1
    I'm importing close to three hundred clients into a new install from another accounting program (peachtree, ugh....!) I have been able to somewhat massage the csv file to closely match the first few field described in Appendix A however for me to make the most of this transfer and to accurately match fields, I need to import with the power user option when importing. My question is can I predefine a custom import order for filemaker to recognize? Is there a master list that provides more details I can use as a reference to build a CSV to easily import data? (Appendix A only illustrates the first few fields)

    Thanks for your help?
    DELREY
     
    DELREY, Sep 22, 2004 IP
  2. spectrum

    spectrum Guest

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Hey Delrey,

    I have some of the same questions you have. Made any head way?

    Best Regards,

    Spectrum
     
    spectrum, Sep 25, 2004 IP
  3. DELREY

    DELREY Peon

    Messages:
    23
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Nope, still waiting for support to respond. I don't think they disclose their table structure from the database which really hurts trying to import. They offer a paid service for a flat fee of a $1000 or $250 an hour which is a little discouraging considering I just recently purchased. Hopefully I'll hear something soon.......

    If I hear something I'll certainly post the response.

    DELREY
     
    DELREY, Sep 25, 2004 IP
  4. spectrum

    spectrum Guest

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    :confused:
     
    spectrum, Sep 28, 2004 IP
  5. spectrum

    spectrum Guest

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    :confused: Delrey,
    I have not been able to get anybody to answer the phone at Digitalpoint for 10 days.
    When I made my last call on Friday or Saturday, the mail box said it was full. I called both the sales and support numbers and got the same results. I noticed your comment, that you didn't think they disclosed their table structure from the database. I was told the product came with the ability to import to all data fields and there was nothing said about additional services needed, fee flat or hourly. Maybe a good thing they have 30 day money back program. Please post a response if you hear anything. Like you I need this information soon.

    Spectrum
     
    spectrum, Sep 28, 2004 IP
  6. l0cke

    l0cke Active Member

    Messages:
    178
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    73
    #6
    Yes, you can create a custom import order and basically import anything. For reference the Optigold data model is available here: ftp://ftp.digitalpoint.com/support/datamodel.zip

    If you are still having trouble finding fields you can post here and I'll try to help you out.

    * I am not affiliated with Digital Point.
     
    l0cke, Sep 28, 2004 IP
  7. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #7
    You can import as a power user, but unless you are importing from a FileMaker database (with the field names being the same), it's not possible to "remember" the power user import order.
     
    digitalpoint, Sep 28, 2004 IP