Filemaker Pro question...

[aeroswat]

Not sure if this site hosts a forum that supports anything like this so i'm sorry if this is bad for me to post it here but I have just gotten good advice from this site and figured i might give it a shot. I'm trying to export a Filemaker Pro database to an excel CSV file and last time I did this I noticed that some of the text fields were exported incorrectly. I noticed for the most part it had to do with replacing any groups of ad with a capital A. I'm not sure why it does this and it took a very long time to fix the data when I imported it into the MySQL database so I was hoping to not have to go through this again in my 2nd database export. Any information would be appreciated. I've looked for resources on this and could not find anything.

[ChemicalBliss]

Hate finding 0 replies so i'll try lol (Bear in mind i didnt know what filemaker was before i read this post.);

 

There are two possible reasons;

a) It's on purpose (A Setting, and Algorithm Given for that specific Export Feature)

b) It's a bug in the code that will need to be fixed by the devlopers.

 

You have a few options at your disposal though;

If (a):

  1. Go through any settings or Preferences and look for any exporting options, or replacement options etc.

  2. Try Reinstalling the application (Make sure to backup your data)

  3. Try a different (Older or Newer) Version of the software.

if (b):

  1. Try a different Version of the Software (Either the bug is new or old).

  2. Tell the developers about the bug and anything you think of that can cause it ie;

  Try exporting much smaller database from the software with that "ad" pattern and see if it's a size thing etc.

 

Hope this Helps,

Good Luck.

[gevensen]

i just exported about 75k files from fmp successfully to mysql

 

1) create a separate table in fmp pro with one text field

2) write a routine to cycle through all your files

3) this is an actual set field command to create a sql line suitable fro export, notice the format & "' , '" &

you can adapt the code to make it straight csv easily

using SetVariable set up your variables such as $bank_account  ( adapt for your use )

 

"INSERT INTO `sc_bank_statements` ( `id`, `account` , `start_date` , `end_date`, `start_balance` , `end_balance`, `income`, `expenses`, `reconciled` ) VALUES  ( 'NULL' , '" & $bank_account & "' , '" & $start_date & "' , '" & $end_date & "' , '" & $starting_balance & "' , '" & $ending_balance & "' , '" & $income & "' , '" & $expense & "' , '" & $reconciled &"');"

 

4) then export files to csv when done

 

it works

 

i did it

 

i could find zero help anywhere on the issue

 

try playing with it from that aspect good luck