{"id":23565,"date":"2022-04-29T12:56:11","date_gmt":"2022-04-29T16:56:11","guid":{"rendered":"https:\/\/phpreaction.com\/uncategorized\/support-for-importing-data-with-phpreaction\/"},"modified":"2022-04-29T12:56:12","modified_gmt":"2022-04-29T16:56:12","slug":"support-for-importing-data-with-phpreaction","status":"publish","type":"post","link":"https:\/\/phpreaction.com\/en\/features\/support-for-importing-data-with-phpreaction\/","title":{"rendered":"Support for importing data with PHPReaction"},"content":{"rendered":"<p>[vc_row mo_row_type=&#8221;in_container&#8221;][vc_column][vc_custom_heading text=&#8221;Why import data?&#8221; font_container=&#8221;tag:h2|text_align:center|color:%2300afef&#8221; use_theme_fonts=&#8221;yes&#8221;][vc_column_text]<span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Importing is a very efficient method of adding and updating your information.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Here are some examples:<\/span><\/p>\n<ul>\n<li><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">When setting up a new PHPReaction system<\/span><\/li>\n<li><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Mass registration or correction of data<\/span><\/li>\n<li><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Sequencing \/ Interrelation \/ Linkage with external systems<\/span>\n<ul>\n<li><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">&#8220;Stocktaking&#8221; data grid<\/span><\/li>\n<li><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Exporting prices from another computer system<\/span><\/li>\n<li><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Update your product prices<\/span><\/li>\n<\/ul>\n<\/li>\n<li><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Sequencing \/ Interrelation \/ Linkage with out-of-control systems<\/span>\n<ul>\n<li><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Receive a new pricing schedule for your products<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">It is possible to confirm or compare imported information with the API export and interaction system.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Our import system is able to make relationships.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Normally these relations are in the form of a numerical reference called &#8220;Id&#8221;<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Ex: ID: 1<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Moreover, it is even possible by specific functionalities to make references by other information.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">For example, one reference per SKU makes it easier to update your suppliers&#8217; prices when you receive a new price list for your products.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Example of a product reference by SKU:<\/span><br \/>\n<span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">product|getProductIdBySKU =&gt; 12345SKU<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">There are even specific features that avoid external data processing since it is done directly at the import level.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">For example, simplifying the updating of inventory quantities when taking inventory \/ counting.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Normally, this would require knowing the current inventory count and making the necessary adjustment.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Ex: 10 in inventory \/ count: 15 so an inventory entry of +5<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">With the &#8220;ImportInventoryAdjust&#8221; functionality, simply transfer 15 and the system will do the calculation for you.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Example Update Quantity in inventory:<\/span><br \/>\n<span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">number|importInventoryAdjust =&gt; 15<\/span><br \/>\n[\/vc_column_text][\/vc_column][\/vc_row][vc_row mo_row_type=&#8221;in_container&#8221;][vc_column][vc_custom_heading text=&#8221;Caution&#8221; font_container=&#8221;tag:h2|text_align:center|color:%2300afef&#8221; use_theme_fonts=&#8221;yes&#8221;][vc_column_text]<span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Importing is a tool that has many advantages (above). On the other hand, it involves high risks (dangers). Several checks do not occur during import, since they are performed at a very high level that exceeds security and business rules. This is unavoidable, since imports often use logic that is not standard or expected by the system.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">So you won&#8217;t get any error message or it won&#8217;t be as clear as in the app. In case of error due to its mode of operation, you will have corrupted data&#8230;<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">It is the responsibility of the person importing the file to validate and cross-check the content of the file.<\/span>[\/vc_column_text][\/vc_column][\/vc_row][vc_row mo_row_type=&#8221;in_container&#8221;][vc_column][vc_custom_heading text=&#8221;How to access the import system&#8221; font_container=&#8221;tag:h2|text_align:center|color:%2300afef&#8221; use_theme_fonts=&#8221;yes&#8221;][vc_column_text]<span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">To gain access, users must have import training. The duration varies according to the objectives and the level of access. You will be given an example of the &#8220;Template&#8221; format, to simplify your life.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">To perform your work, you must also have the rights to the requested elements. There are two possible levels.<\/span><\/p>\n<p><span style=\"text-decoration: underline;\"><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Limited Import<\/span><\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Allows the update of specific elements, these take the form of buttons at the desired places in the application.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">For example:<\/span><\/p>\n<ul>\n<li><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Importing information from a sale<\/span><\/li>\n<li><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Importing purchase information<\/span><\/li>\n<li><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Import of products<\/span><\/li>\n<\/ul>\n<p><span style=\"text-decoration: underline;\"><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Admin import<\/span><\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Allows you to import all system information.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Thanks to the metadata, it is possible to know the reference and the exact nature of each piece of information in the system (available through the parameters).<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">However, this requires a good understanding of the data structure.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">It is possible to deepen the knowledge of this structure by exploring our API export and interaction system.<\/span>[\/vc_column_text][\/vc_column][\/vc_row][vc_row mo_row_type=&#8221;in_container&#8221;][vc_column][vc_custom_heading text=&#8221;What is a CSV?&#8221; font_container=&#8221;tag:h2|text_align:center|color:%2300afef&#8221; use_theme_fonts=&#8221;yes&#8221;][vc_column_text]<span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\"><img decoding=\"async\" class=\"alignright\" src=\"https:\/\/phpreaction.com\/wp-content\/uploads\/2017\/03\/csvicone.png\" alt=\"\" width=\"200\" \/><\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">These are tabular data as comma separated values \u200b\u200b(&#8216;,&#8217;)<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">This is the translation of the English &#8220;Comma Separated Values \u200b\u200b=&gt; CSV&#8221;<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Reference and detailed definition according to Wikipedia:<\/span><\/p>\n<p><a href=\"https:\/\/en.wikipedia.org\/wiki\/Comma-separated_values\"><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">https:\/\/en.wikipedia.org\/wiki\/Comma-separated_values<\/span><\/a><\/p>\n<p><a href=\"https:\/\/en.wikipedia.org\/wiki\/Comma-separated_values\"><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">https:\/\/en.wikipedia.org\/wiki\/Comma-separated_values<\/span><\/a><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">simple example<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">&#8220;id&#8221;,&#8221;name&#8221;<\/span><br \/>\n<span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">1,&#8221;PHPCreation Inc&#8221;<\/span><br \/>\n<span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">2,&#8221;PHPReaction&#8221;<\/span><br \/>\n<span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">3,&#8221;Simon Tremblay&#8221;<\/span><\/p>\n<h2><\/h2>\n<p>[\/vc_column_text][\/vc_column][\/vc_row][vc_row mo_row_type=&#8221;in_container&#8221;][vc_column][vc_custom_heading text=&#8221;Why a CSV?&#8221; font_container=&#8221;tag:h2|text_align:center|color:%2300afef&#8221; use_theme_fonts=&#8221;yes&#8221;][vc_column_text]<span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Its structure is simple. That is why:<\/span><\/p>\n<ul>\n<li><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">It has no formatting elements<\/span><\/li>\n<li><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">It is very efficient and compact<\/span><\/li>\n<li><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">This is a standard and recognized format<\/span><\/li>\n<li><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">It is widespread (used by many systems)<\/span><\/li>\n<\/ul>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">It is possible to open CSV documents in a text editor like Notepad.<\/span><br \/>\n<span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">But it is much more convenient to open them with a <a href=\"https:\/\/en.wikipedia.org\/wiki\/Spreadsheet\">spreadsheet<\/a> system<\/span><br \/>\n<span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Ex: Open Office (<a href=\"https:\/\/www.openoffice.org\/download\/\">Free download<\/a>)<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">e.g. Libre Office (<a href=\"https:\/\/www.libreoffice.org\/download\/download\/\">free download<\/a>)<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">E.g.: Microsoft Excel or MS Excel<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Ex: Google Doc &#8220;Calc&#8221; or &#8220;GCalc&#8221;<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">It is possible to easily convert a spreadsheet document to CSV.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Ex: Excel extension .XLS or .XLSX to CSV (simply with a &#8220;Save as&#8221;)<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Ex: <a href=\"https:\/\/en.wikipedia.org\/wiki\/OpenDocument\">Open Document Spreadsheet extension .ODS<\/a> to CSV<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">In addition, several systems offer direct CSV export.<\/span><br \/>\n[\/vc_column_text][\/vc_column][\/vc_row][vc_row mo_row_type=&#8221;in_container&#8221;][vc_column][vc_custom_heading text=&#8221;Target the data to import&#8221; font_container=&#8221;tag:h2|text_align:center|color:%2300afef&#8221; use_theme_fonts=&#8221;yes&#8221;][vc_column_text]<span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">You need to know the general structure of the data to help you target the right items to import.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">It is possible to deepen the knowledge of this structure by exploring our API export and interaction system (available in the settings).<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Often we have to separate our information into several imports to target the right elements.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">For example:<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Inventory product grid separated in two (Products and Inventory).<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Of course, the inventory will include a reference to the Products.<\/span><br \/>\n[\/vc_column_text][\/vc_column][\/vc_row][vc_row mo_row_type=&#8221;in_container&#8221;][vc_column][vc_custom_heading text=&#8221;Preparing an import file \/ Using CSV file&#8221; font_container=&#8221;tag:h2|text_align:center|color:%2300afef&#8221; use_theme_fonts=&#8221;yes&#8221;][vc_column_text]<span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">You need to know the reference of the data used by the import system.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Thanks to the metadata, it is possible to know the reference and the exact nature of each information in the system (available in the parameters) (<a href=\"https:\/\/en.wikipedia.org\/wiki\/Metadata\">https:\/\/en.wikipedia.org\/wiki\/Metadata<\/a>)<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">We suggest you first compare your information with the form for this item.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Often the selected elements include references \/ mandatory fields, sheet to be completed and conditions, in order to avoid any subsequent problem.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Required fields are marked with a red &#8220;*&#8221; asterisk.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">You can use the software of your choice to generate a CSV.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Suggested settings:<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Separation: &#8220;,&#8221; by commas (Attention on MS Excel, it uses the &#8220;;&#8221;)<\/span><br \/>\n<span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Text fields: &#8220;&#8221;&#8221; Use of double quotes to repair fields (pay attention to special characters)<\/span><br \/>\n<span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Encoding: UTF-8 (pay attention to special characters)<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Please refer to the following link for more details and more explanatory steps related to creating a custom CSV import file for your data to PHPReaction: <a href=\"https:\/\/phpreaction.com\/quoi-de-neuf\/import-massif-de-donnees-dans-votre-erp\/\">https:\/\/phpreaction.com\/quoi-de-neuf\/import-massif-de-donnees-dans-votre-erp\/<\/a><\/span>[\/vc_column_text][\/vc_column][\/vc_row][vc_row mo_row_type=&#8221;in_container&#8221;][vc_column][vc_custom_heading text=&#8221;Start import request&#8221; font_container=&#8221;tag:h2|text_align:center|color:%2300afef&#8221; use_theme_fonts=&#8221;yes&#8221;][vc_column_text]<span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Use targeted item link (available in settings)<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Follow the steps:<\/span><\/p>\n<ol>\n<li><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Select file<\/span><\/li>\n<li><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Confirm the settings used (if possible, keep the default ones)<\/span><\/li>\n<li><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Launch the request called &#8220;Job&#8221;<\/span><\/li>\n<\/ol>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">The system will inform you of the new request and will send you its reference number.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">The request is pending and used by another system so its sole responsibility is to import the requests.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Normally the delay is less than 5min, often practically instantaneous (15 seconds).<\/span>[\/vc_column_text][\/vc_column][\/vc_row][vc_row mo_row_type=&#8221;in_container&#8221;][vc_column][vc_custom_heading text=&#8221;Confirmation of request&#8221; font_container=&#8221;tag:h2|text_align:center|color:%2300afef&#8221; use_theme_fonts=&#8221;yes&#8221;][vc_column_text]<span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">You can return to see the requests (available in the parameters which include all the information of the request.)<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">In addition, these are associated with the results of the request. You will be able to consult.<\/span>[\/vc_column_text][\/vc_column][\/vc_row][vc_row mo_row_type=&#8221;in_container&#8221;][vc_column][vc_custom_heading text=&#8221;Validate information&#8221; font_container=&#8221;tag:h2|text_align:center|color:%2300afef&#8221; use_theme_fonts=&#8221;yes&#8221;][vc_column_text]<span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Of course, following the import, you will be able to consult what you have just done.<\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">If you get unexpected behaviors or results from your import, there is probably some information you left out that is required by the system.<\/span>[\/vc_column_text][\/vc_column][\/vc_row][vc_row mo_row_type=&#8221;in_container&#8221;][vc_column][vc_custom_heading text=&#8221;To know more&#8221; font_container=&#8221;tag:h2|text_align:center|color:%2300afef&#8221; use_theme_fonts=&#8221;yes&#8221;][vc_column_text]<span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\"><a href=\"https:\/\/phpreaction.com\/quoi-de-neuf\/import-massif-de-donnees-dans-votre-erp\/\">How to do massive data import<\/a><\/span><\/p>\n<p><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\"><a href=\"https:\/\/phpreaction.com\/quoi-de-neuf\/import-massif-de-donnees-dans-votre-erp\/#exemples\">See examples of import grids here!<\/a><\/span>[\/vc_column_text][\/vc_column][\/vc_row][vc_row mo_row_type=&#8221;fullwidth&#8221; mo_text_scheme=&#8221;darker-overlay&#8221; mo_padding=&#8221;custom&#8221; mo_bg_color=&#8221;#1a9fd9&#8243; mo_padding_top=&#8221;30&#8243; mo_padding_bottom=&#8221;30&#8243;][vc_column width=&#8221;2\/3&#8243;][vc_column_text]<\/p>\n<p style=\"text-align: center;\"><strong><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">Do you want efficient management?<\/span><\/strong><br \/>\n<strong><span style=\"font-size: 18pt; font-family: 'trebuchet ms', geneva, sans-serif;\">We are happy to participate in your project!<\/span><\/strong><\/p>\n<p>[\/vc_column_text][\/vc_column][vc_column width=&#8221;1\/3&#8243;][vc_btn title=&#8221;Ask for a consultation&#8221; style=&#8221;outline-custom&#8221; outline_custom_color=&#8221;#ffffff&#8221; outline_custom_hover_background=&#8221;#ffffff&#8221; outline_custom_hover_text=&#8221;#1a9fd9&#8243; shape=&#8221;square&#8221; size=&#8221;lg&#8221; align=&#8221;center&#8221; link=&#8221;url:https%3A%2F%2Fphpreaction.com%2Fen%2Fconsulting%2F|&#8221;][\/vc_column][\/vc_row]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[vc_row mo_row_type=&#8221;in_container&#8221;][vc_column][vc_custom_heading text=&#8221;Why import data?&#8221; font_container=&#8221;tag:h2|text_align:center|color:%2300afef&#8221; use_theme_fonts=&#8221;yes&#8221;][vc_column_text]Importing is a very efficient method of adding and updating your information. Here are some examples: When setting up a new PHPReaction system Mass registration or correction of data Sequencing \/ Interrelation \/ Linkage with external systems &#8220;Stocktaking&#8221; data grid Exporting prices from another computer system Update your product [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":11086,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"single-fullwidth.php","format":"standard","meta":{"footnotes":""},"categories":[198],"tags":[],"class_list":["post-23565","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-features"],"_links":{"self":[{"href":"https:\/\/phpreaction.com\/en\/wp-json\/wp\/v2\/posts\/23565","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phpreaction.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phpreaction.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phpreaction.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phpreaction.com\/en\/wp-json\/wp\/v2\/comments?post=23565"}],"version-history":[{"count":0,"href":"https:\/\/phpreaction.com\/en\/wp-json\/wp\/v2\/posts\/23565\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/phpreaction.com\/en\/wp-json\/wp\/v2\/media\/11086"}],"wp:attachment":[{"href":"https:\/\/phpreaction.com\/en\/wp-json\/wp\/v2\/media?parent=23565"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpreaction.com\/en\/wp-json\/wp\/v2\/categories?post=23565"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpreaction.com\/en\/wp-json\/wp\/v2\/tags?post=23565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}