Jump to content
Sign in to follow this  
Gismo12

Copy and paste data

Recommended Posts

Hi All,

I need to copy one field only from one layout (+- 200 records) and past all those records from that field into another layout.

I have tried a few commands but does not produce the required result.

Please could you advise on a script?

Edited by Lee Smith
Change title spelling error

Share this post


Link to post
Share on other sites

I don't understand your question. You have 200+ records in one table (?) and you want to duplicate their values in another table (?) ? Where you also have the same amount of records? Or do you mean copy all 200+ values into  a field of a single record in the other table? Why would you ever need to do such things? Please provide some more background, as this looks like an XY problem.

Share this post


Link to post
Share on other sites

I need to copy all records in the first table (Product) , but only a specific field (Part Number) to a second table (Catalog) to field Product Number)

if table 1 has 200 records, table 2 should have 200 records

Share this post


Link to post
Share on other sites

Technically, you could import them - but I would still ask why you think it's necessary. As a rule, we try to eliminate duplicate data.

Share this post


Link to post
Share on other sites

The First table is my products table with pricing, which is imported from an excel file, pricing is always changing

in my catalog table i need to link a picture of the product

thus the reason why i need to duplicate.

i dont have pictures in the excel format to import every time there is a price change

Share this post


Link to post
Share on other sites
8 minutes ago, Gismo12 said:

pricing is always changing

Does the list of products also change (significantly) every time? If not, you should look into importing the prices using the update matching records method. That way you could have a single table with all your Product info, including images and current prices.

  • Like 1

Share this post


Link to post
Share on other sites

no the product list does not change that often

i will look into that, thank you

Share this post


Link to post
Share on other sites

Note also that even with two tables, the Catalog table can access the current prices via a relationship based on matching a known identifier, such as SKU - so there is no need to move data from one location to another.

Share this post


Link to post
Share on other sites

Yes, as you explained in the last comment, that was my reasoning behind copying the data to the second table to add a picture to the second table.

Share this post


Link to post
Share on other sites

If the second table (Catalog?) has no records yet, and you want to populate it with the products you currently have, then importing them is the simplest way. Filemaker allows importing records from one table to another in the same file (make sure the source table has a found set of all records you wish to import). 

But this would be a one-time operation and there would be no need to script it.

 

Share this post


Link to post
Share on other sites

how would i import from one table to another, one field only, without a script?

Share this post


Link to post
Share on other sites

 

22 minutes ago, Gismo12 said:

how would i import from one table to another, one field only, without a script?

  1. Go to a layout of the source table and select Show All Records from the Records menu (or do a find to locate only the records you want to import);
  2. Go to a layout of the target table and select Import Records > File… from the File menu. Choose the current file as the source file.
  3. In the Import File Mapping window, select the source table from the drop down menu on the left pane and map the source field to the target field on the right.

For more detailed instructions, see the help at: https://fmhelp.filemaker.com/help/17/fmp/en/#page/FMP_Help%2Fimport-action-field-mapping.html%23ww1061356

--
Make sure to have a backup in case you make a mistake.

 

Edited by comment
  • Like 1

Share this post


Link to post
Share on other sites

Hi,

I have managed to import the data successfully by I noticed that when you create a new record, the auto index key is updated but then you import, the auto primary key is not updated. which means when I click to add the photo of the product after the data has been imported, I get a primary key is defined to require a value, how would I go about this?

Share this post


Link to post
Share on other sites
10 hours ago, Gismo12 said:

the auto index key is updated but then you import, the auto primary key is not updated

I am not sure what the difference between the two is. If you select Perform auto-enter options while importing in the Import Options dialog box, then all auto-enter fields will be populated.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Similar Content

    • By Calvin Tomm
      In list view I want to be able to "grab" an object so I can move the record up or down in the found set. Is there a way to do this? It would be just like how an item on an list in an iPhone gets moved up or down. For example, on a play list in Music, I can change the order of songs to be played.
      Also, I would like to have this capability when I move my solution over to FileMaker Go
      Thanks!
    • By amerioca
      Hi everybody,
       
      I recently amended a db from an old Lynda course, controlling shore excursions for river cruise ships. For my limited expertise (I am still a rookie at the very best) the construction is somewhat complex as there is many vessels, different routes, different charterers and consequently different shore excursion programs and prices. In some cases the shore excursion program of different vessels and operators is similar but not the same and so on.
      I have 7 different tables partly related (pls see graph attached):
       
      For every journey ::customers and ::trip are assigned a tour code and date (“tour code” is not unique as journeys repeat themselves during the season, “Tour Code” in conjunction with “Date” is unique)
      Every tour operator/vessel has many trips on every journey. All table occurences and fields are uniquely defined by unique id.
      Now I want to create an opening layout reflecting all relevant cruise information such as passenger list from ::customer and ::trip (shore excursions) for the specific journey, as well as other information in text fields.
      But I seem to be unable to get the right relationship and layout setups together. I tried all possible relations and layout setup combination but nothing worked so far.  
      On the same layout I was able to either retrieve the passenger list from ::customer for each journey or the offered shore excursion (trip) list from ::trip  but not both together on one layout.
       
      What is it, I am doing wrong? Any ideas are appreciated

    • By V!ncent
      Hi there,
      I have a topic that can take the chosen value in a vertical radio buttons list.
      But some values in this list have a description so long that it can not be displayed on one line. So I need a "return to line" in the list of radio buttons. (see attached photo)
      How to do ?
      Thank you for your wise advice.
      V!ncent

    • By Arno
      Hi There,
       I’m pretty new with using Filemaker, but still I built a solution that fits pretty all my needs (for now…)
      I’m still experiencing one big problem with my solution for which I would need help.
      Here’s the context : I run a little company. We receive financial reports every quarter.
      All quarterly reports ( Excel file or csv file) have the exact same form.
      I then created a layout based on the table created when importing the csv that works properly.
      My need: as I’m to receive a new financial report on next quarters (Q12018, Q22018, Q32018 etc.), I would like to pull the new data from my Main layout.
      Is there a way of having a layout pull the data from the new table (actually whatever table) to be created each time I’ll be importing a new Financial Report without getting rid of the original data (which I would like to keep in place, for obvious reasons)? Let’s say from a pull down?
      Thank you very much for your help and don’t hesitate to get back to me if my explanations aren’t clear enough.
    • By kolvorok
      I'd get some problems with date formats after installing FMS 15, and I'm trying to solve it by importing to a clone of the original database. But two tables has no layouts and I can't find a way to import these tables without making a layout in the clone or adding a table when importing. The last seems to be the simplest, but how will the relationships behave?
  • Who Viewed the Topic

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.