Initializing Additional Fields On Import

[Jaymer]

I WOULD THINK you always have to check 'create if not found' - because its trying to find a record to update.

and have you tried an import WITHOUT template - just using 1st line to identify the fields?

[Stetson]

For the most part, I've never used 'create if not found'. It never made a difference for me when importing to SQL Server. I was using 'create if not found' yesterday when troubleshooting, but it didn't behave any differently than when not using it, so I dropped it.

Can you send me an example of what you mean by doing the export without a template? Is this documented in any of the manuals? I'm not exactly sure what you mean. Do you mean use the Import action in a process without all of the parameters?

Thanks.

[Jaymer]

these are 3 diff import files I import.
Order Header
Order Line
Order Section

No template it used because of the 1st line in the file.




*O.Order_Num,"O.Date_Ordered","O.Status","O.Date_Status","O.ob_Customer.ID","O.JobName","O.ControlNum","O.EmailNum","O.CustOrderNum","O.Amt_Order","O.XrefOrder","O.ServiceYN","O.KeyedBy","O.CommentsYN",O.OrderPlus
788731,"04/07/2020","I","04/21/2020",Mast_Cust#200034,"PETERSON"," 18131","281624",""," 2456.02","","","","",788731

*L.PriKey,L.ob_Order.Order_Num,L.Order_Num,L.Line,L.Status,L.Qty,L.UM,L.Product,L.QCode,L.ps_Product.ID,L.Inventory_Id,L.Description,L.Factory_Line,L.Cust_ID,L.Cost_Line_Item,L.Cost_Ext,L.CommentsYN,L.Dimensions,L.Dim_Width,L.Dim_W_Fract,L.Dim_Height,L.Dim_H_Fract,L.Dim_W_Points,L.Dim_H_Points,L.Option_1,L.Option_2,L.Option_3,L.Option_4,L.Option_5,L.Option_6,L.Option_7,L.Option_8,L.Option_9,L.Correlated_Order,L.Correlated_Line,L.MU_Num_Children,L.MU_Parent_Line,L.MU_Group,L.Feat1_Abrv,L.Feat2_Abrv,L.Feat3_Abrv,L.Feat4_Abrv,L.Feat5_Abrv,L.Feat6_Abrv,L.Feat7_Abrv,L.Feat8_Abrv,L.Feat9_Abrv,L.Category1,L.Category2,L.Category3,L.Category4,L.Category5,L.Category6,L.Category7,L.Category8,L.Category9,L.Section1,L.Section2,L.Section3,L.Section4,L.Section5,L.Section6,L.Section7,L.Section8,L.Section9,L.FtrTable1,L.FtrTable2,L.FtrTable3,L.FtrTable4,L.FtrTable5,L.FtrTable6,L.FtrTable7,L.FtrTable8,L.FtrTable9,L.Repair_Remake,L.Oriel_Offset,L.OrielYN,L.Extreme_SizeYN,L.OO_YN,L.OO_ProductYN,L.OO_DenverYN,L.Date_Completed,L.Date_Data_Entry,L.Data_Entry_ID,L.Install_Loc1,L.Install_Loc2,L.Breakdown,L.Template,L.ps_Template.ID,L.Pos2,L.Pos3,L.Pos4,L.Pos5,L.Pos6,L.Pos7,L.Pos8,L.Pos9
78873101,788731,788731,01,F, 1,000,8202,822P,Mast_Product#4510,,"8200 2-PANEL",82,A00005, 235.00, 235.00,N,35 1/2 x 35 1/4, 35,1/2, 35,1/4, 8, 4,WH,LE,NG,LE,NG,HS,HD,,,,,,,,WHITE,LE ARGON,NO GRIDS,LE ARGON,NO GRIDS,HALF SCR,HDRAIL,,,Color,Glass,Grids,Glass,Grids,Screens,SCRNSTYL,,,,G7-GLAS-LT,GR-GRID-LT,G7-GLAS-RT,GR-GRID-RT,SC-SCRN-RT,,,,073,002,003,002,003,004,099,,,, 0.000000,,N,N,,,04/16/2020,00/00/0000,,"","",,,Mast_Template#0000,LEFT,LEFT,RIGHT,RIGHT,,,,

Imp_SE.PriKey,Imp_SE.Ord,Imp_SE.Lin,Imp_SE.SectID_Display,Imp_SE.Width,Imp_SE.Height,Imp_SE.FromSect,Imp_SE.ToSect,Imp_SE.MastSE_ID.ID
78873101F8-FRS20,788731,01,F8-FRS2, 35.50000, 35.25000,,,Mast_SE#2269

[Stetson]

What's the mechanism to import? Where/how do you execute the import? For example, are you issuing the same import command I would issue but you omit the template parameter in the command?

[Jaymer]

Not at desk, but pretty sure in this case it’s

Import O from filename
Import L from filename