Sheju Sathyanesan Posted February 4, 2016 Share Posted February 4, 2016 I am looking for, a script or method, so I can import records from CSV to another related table fields ! How is that possible Link to comment Share on other sites More sharing options...
comment Posted February 4, 2016 Share Posted February 4, 2016 Your question is not clear. Please provide more details. In general, you can only import into one table at a time. Link to comment Share on other sites More sharing options...
Sheju Sathyanesan Posted February 5, 2016 Author Share Posted February 5, 2016 Yes... I have Excel file, want to import into FM file but some fields are connected to other tables. like in Invoice, there is account field, Account is a field with lookup value.. even if I import it will not connect to the Account table... How can I solve this.. thank you for your feedback... Link to comment Share on other sites More sharing options...
comment Posted February 5, 2016 Share Posted February 5, 2016 I am afraid I cannot help you, because your description is too vague. Link to comment Share on other sites More sharing options...
David Zakary Posted February 5, 2016 Share Posted February 5, 2016 Actually it isn't that vague. Sheju wants to import into multiple tables at the same time to build the related records. You can't do that in one step. Likely the easiest way to do this type of process is to create a table that is used just for importing. Bring the Excel file into that table. You then have to work your way through each record in this temporary table. You'll start with all of the "parent" data, go to the parent table, create a new record, record the primary key value and then set the fields as needed. The next step is to go to the child table(s) and create all of the records required there. As you've got the primary key value in a variable you set that into the foreign key field to build the relationship between parent and child tables. When you do the set fields your lookups should trigger. It's a lot of jumping around and looping but pretty straight forward. There are other methods too but you may find this the easiest. Link to comment Share on other sites More sharing options...
Sheju Sathyanesan Posted February 5, 2016 Author Share Posted February 5, 2016 Yes... I got it now... I will be working on this exactly, how you explained.... Appreciated for your help... Link to comment Share on other sites More sharing options...
LaRetta Posted February 5, 2016 Share Posted February 5, 2016 Hi Sheju, Here is an article which helps you through that process. It includes an example file as well. And if you can, please go to your profile and update your information so we know your platform and FM version. It will help us help you in the future. :-) Migration Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2993 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now