Import file does not work

[John Chamberlain]

I have a FMP file with 37 fields. I have tried to import new records from a file created from an Excel file. When I issue the Import command the right side of the import page only shows 19 field names.

 

Also when I decided to import what matching fields there were, it appeared that the import took place and the message box shows that 10 records were added, but no records were actually imported to my destination file.

 

Any ideas?

[Wim Decorte]

Not enough info I think.  Imports are usually very straightforward.  Wrong file?   Wrong target table in the correct file?  Can you post a screenshot?

[John Chamberlain]

Both input and target files have only one table _ I have attached .tiff pictures of target table, and of import window - also attached a both files

2.tiff

1.tiff

PETER ZIPPI FILE copy.zip

2013n adoptions Converted.fp7.zip

[Brooks]

What is the login for Peter Zippi?

[Lee Smith]

He posted this file in another thread, here is the link to the PW and ID

 

John, please do not post protected files as example to the Forums.

[John Chamberlain]

Sorry, Name is John P/W is 16163

[John Chamberlain]

Just like the previous thread, everyone seems to have passed on to other threads and no one is interested anymore. Should I repost my problem (with the P/W removed)?

[Lee Smith]

Hi John,

 

Why did you posted your file twice?

 

Unless you have made changes to your file that is pertinent to your new question, then a link to your previous question is all that is needed, even though you included some additional information with it here.

 

Is the other file posted somewhere else too?

 

 

 

everyone seems to have passed on to other threads and no one is interested anymore

 

As far as this statement, it is your responsibility to keep your thread active until you reach a satisfactory conclusion to your problem. 

 

BTW, the members usually stop replying to a thread when it appears that the Original Poster has received  a solution to there need.. If we stop replying review your thread and let us know what questions still remain.

 

HTH, 

 

Lee

[John Chamberlain]

Hi Lee

 

I posted the file twice because there were two separate problems (one relating to a Find, and one relating to Import of records). There were changes to the file in the interim.

 

How do I keep a thread active? In both cases, I posted replies to both your comment (on this thread), and the thread regarding the Find problem. In both cases there was no further contact from anyone with a suggestion for a solution.

 

PS Is there a way to delete all my previous posts and start over?

[Brooks]

The reason your import fails is due to your field validations. They will not allow records to be added. Turn off your field validation or add an auto enter to them. Also, most of us have jobs. This is not a chat room and it may take a few hours to respond. After disabling your field validation the import works just fine. The right side shows all the fields if you scroll down. 

[Lee Smith]

You simply need to restate what your problem continues to be. 

 

Some have just use the word Bump, others have added information to help clarify, others have just asked, "is there anything I need to clarify", etc, Your option.

 

Do NOT delete a post or a thread, once it has been replied to. If you do this, it messes us up becuase it leave holes in our forum, especially with the attachments. i.e. we will still have the attachments, but no thread to go with them.

[John Chamberlain]

Thanks for you response - all imports are working now.